Expert SQL Database Management Needed

Job ID: 37957641

Budget: $8 – $15 USD

Task list

1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable is added with data
2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection
3) We need to write ports to the SQL data table to allow internet connection
4) We need instrument to add historical 1 min data to the database created on stage 1
5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database

Conditions:
We do have a budget limit which is set to 150 USD, after reaching this limit we ask worker to reach out and submit the work. After we will either increase budget or stop working
Related categories: Python SQL MySQL Database Administration SQLite