PREVIEW / futures_1hour / 2018-04-15
file: by_date/futures_1hour/2018/2018-04-15.parquet size: 15 KB rows: 302
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2018-04-15 18:00:00 | ES | Futures | 2918.21 | 2922.85 | 2916.57 | 2919.84 | 20026.0 |
| 2018-04-15 19:00:00 | ES | Futures | 2919.84 | 2920.93 | 2917.93 | 2918.75 | 5623.0 |
| 2018-04-15 20:00:00 | ES | Futures | 2918.75 | 2919.02 | 2914.66 | 2917.11 | 10441.0 |
| 2018-04-15 21:00:00 | ES | Futures | 2917.11 | 2917.39 | 2910.84 | 2911.93 | 9856.0 |
| 2018-04-15 22:00:00 | ES | Futures | 2911.93 | 2913.84 | 2908.38 | 2908.65 | 6782.0 |
| 2018-04-15 23:00:00 | ES | Futures | 2908.65 | 2910.29 | 2906.74 | 2908.65 | 6517.0 |
| 2018-04-15 18:00:00 | NQ | Futures | 7889.82 | 7917.9 | 7887.75 | 7910.51 | 5655.0 |
| 2018-04-15 19:00:00 | NQ | Futures | 7911.1 | 7913.17 | 7903.42 | 7906.96 | 1355.0 |
| 2018-04-15 20:00:00 | NQ | Futures | 7906.67 | 7907.55 | 7894.25 | 7903.71 | 2635.0 |
| 2018-04-15 21:00:00 | NQ | Futures | 7904.01 | 7905.78 | 7882.43 | 7887.16 | 2740.0 |
| 2018-04-15 22:00:00 | NQ | Futures | 7886.87 | 7891.89 | 7870.61 | 7871.5 | 2177.0 |
| 2018-04-15 23:00:00 | NQ | Futures | 7871.79 | 7873.57 | 7862.93 | 7869.43 | 2518.0 |
| 2018-04-15 18:00:00 | YM | Futures | 26546.8 | 26666.2 | 26546.8 | 26623.9 | 3402.0 |
| 2018-04-15 19:00:00 | YM | Futures | 26623.9 | 26629.3 | 26597.8 | 26602.1 | 986.0 |
| 2018-04-15 20:00:00 | YM | Futures | 26602.1 | 26608.7 | 26567.4 | 26593.5 | 2309.0 |
| 2018-04-15 21:00:00 | YM | Futures | 26594.5 | 26595.6 | 26527.2 | 26540.2 | 2843.0 |
| 2018-04-15 22:00:00 | YM | Futures | 26539.1 | 26557.6 | 26504.4 | 26508.7 | 2021.0 |
| 2018-04-15 23:00:00 | YM | Futures | 26508.7 | 26519.6 | 26490.3 | 26505.5 | 2067.0 |
| 2018-04-15 18:00:00 | CL | Futures | 60.14 | 60.49 | 59.85 | 59.98 | 5360.0 |
| 2018-04-15 19:00:00 | CL | Futures | 59.98 | 60.01 | 59.9 | 59.97 | 2137.0 |
| 2018-04-15 20:00:00 | CL | Futures | 59.97 | 59.99 | 59.66 | 59.71 | 3285.0 |
| 2018-04-15 21:00:00 | CL | Futures | 59.7 | 59.72 | 59.51 | 59.7 | 2935.0 |
| 2018-04-15 22:00:00 | CL | Futures | 59.7 | 59.71 | 59.6 | 59.61 | 1649.0 |
| 2018-04-15 23:00:00 | CL | Futures | 59.6 | 59.67 | 59.6 | 59.65 | 1126.0 |
| 2018-04-15 18:00:00 | GC | Futures | 1778.4 | 1780.7 | 1769.2 | 1772.1 | 10909.0 |
| 2018-04-15 19:00:00 | GC | Futures | 1772.0 | 1776.6 | 1771.8 | 1774.1 | 6175.0 |
| 2018-04-15 20:00:00 | GC | Futures | 1774.2 | 1776.1 | 1773.3 | 1774.2 | 5738.0 |
| 2018-04-15 21:00:00 | GC | Futures | 1774.2 | 1780.5 | 1774.2 | 1778.6 | 15146.0 |
| 2018-04-15 22:00:00 | GC | Futures | 1778.6 | 1780.4 | 1776.5 | 1780.1 | 12128.0 |
| 2018-04-15 23:00:00 | GC | Futures | 1780.1 | 1780.1 | 1777.9 | 1778.8 | 4002.0 |
| 2018-04-15 18:00:00 | ZN | Futures | 120.839493 | 120.839493 | 120.714108 | 120.745454 | 21982.0 |
| 2018-04-15 19:00:00 | ZN | Futures | 120.745454 | 120.761128 | 120.729781 | 120.761128 | 8292.0 |
| 2018-04-15 20:00:00 | ZN | Futures | 120.761128 | 120.792474 | 120.745454 | 120.745454 | 9183.0 |
| 2018-04-15 21:00:00 | ZN | Futures | 120.745454 | 120.792474 | 120.745454 | 120.792474 | 9128.0 |
| 2018-04-15 22:00:00 | ZN | Futures | 120.792474 | 120.82382 | 120.776801 | 120.82382 | 10629.0 |
| 2018-04-15 23:00:00 | ZN | Futures | 120.82382 | 120.82382 | 120.792474 | 120.808147 | 4570.0 |
> showing 36 of 302 rows — these rows as CSV