PREVIEW / futures_1hour / 2009-03-15
file: by_date/futures_1hour/2009/2009-03-15.parquet size: 13 KB rows: 218
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-15 18:00:00 | ES | Futures | 719.62 | 720.82 | 715.31 | 716.51 | 8264.0 |
| 2009-03-15 19:00:00 | ES | Futures | 716.51 | 718.42 | 716.27 | 716.51 | 3206.0 |
| 2009-03-15 20:00:00 | ES | Futures | 716.51 | 720.58 | 716.27 | 720.58 | 4023.0 |
| 2009-03-15 21:00:00 | ES | Futures | 720.58 | 720.58 | 718.66 | 719.38 | 2204.0 |
| 2009-03-15 22:00:00 | ES | Futures | 719.38 | 720.58 | 719.14 | 719.86 | 2134.0 |
| 2009-03-15 23:00:00 | ES | Futures | 719.86 | 720.82 | 718.66 | 719.14 | 1669.0 |
| 2009-03-15 18:00:00 | NQ | Futures | 1322.67 | 1324.94 | 1315.28 | 1315.85 | 510.0 |
| 2009-03-15 19:00:00 | NQ | Futures | 1315.85 | 1318.98 | 1315.85 | 1315.85 | 120.0 |
| 2009-03-15 20:00:00 | NQ | Futures | 1315.57 | 1322.39 | 1315.57 | 1322.39 | 236.0 |
| 2009-03-15 21:00:00 | NQ | Futures | 1322.1 | 1322.1 | 1318.41 | 1319.83 | 130.0 |
| 2009-03-15 22:00:00 | NQ | Futures | 1320.11 | 1322.1 | 1319.26 | 1320.4 | 115.0 |
| 2009-03-15 23:00:00 | NQ | Futures | 1320.4 | 1321.25 | 1317.56 | 1317.84 | 184.0 |
| 2009-03-15 18:00:00 | YM | Futures | 6575.1 | 6580.6 | 6538.3 | 6542.9 | 374.0 |
| 2009-03-15 19:00:00 | YM | Futures | 6547.5 | 6565.0 | 6543.8 | 6545.7 | 187.0 |
| 2009-03-15 20:00:00 | YM | Futures | 6545.7 | 6578.8 | 6544.8 | 6578.8 | 284.0 |
| 2009-03-15 21:00:00 | YM | Futures | 6578.8 | 6578.8 | 6560.4 | 6568.6 | 157.0 |
| 2009-03-15 22:00:00 | YM | Futures | 6566.8 | 6577.8 | 6566.8 | 6571.4 | 118.0 |
| 2009-03-15 23:00:00 | YM | Futures | 6572.3 | 6577.8 | 6560.4 | 6567.7 | 168.0 |
| 2009-03-15 18:00:00 | CL | Futures | 118.32 | 118.32 | 114.55 | 115.8 | 625.0 |
| 2009-03-15 19:00:00 | CL | Futures | 115.67 | 116.05 | 115.57 | 115.72 | 178.0 |
| 2009-03-15 20:00:00 | CL | Futures | 115.67 | 116.08 | 115.11 | 116.08 | 220.0 |
| 2009-03-15 21:00:00 | CL | Futures | 116.08 | 116.18 | 115.42 | 116.08 | 90.0 |
| 2009-03-15 22:00:00 | CL | Futures | 116.26 | 116.79 | 116.26 | 116.59 | 137.0 |
| 2009-03-15 23:00:00 | CL | Futures | 116.59 | 116.59 | 115.67 | 115.98 | 151.0 |
| 2009-03-15 18:00:00 | GC | Futures | 1320.6 | 1321.6 | 1316.2 | 1316.9 | 876.0 |
| 2009-03-15 19:00:00 | GC | Futures | 1317.4 | 1318.9 | 1314.8 | 1317.8 | 406.0 |
| 2009-03-15 20:00:00 | GC | Futures | 1317.9 | 1321.2 | 1313.5 | 1320.9 | 984.0 |
| 2009-03-15 21:00:00 | GC | Futures | 1320.9 | 1321.6 | 1317.6 | 1317.9 | 419.0 |
| 2009-03-15 22:00:00 | GC | Futures | 1317.9 | 1318.8 | 1317.5 | 1318.8 | 129.0 |
| 2009-03-15 23:00:00 | GC | Futures | 1318.5 | 1318.9 | 1316.9 | 1318.6 | 179.0 |
| 2009-03-15 18:00:00 | ZN | Futures | 95.418998 | 95.541095 | 95.394578 | 95.516675 | 1620.0 |
| 2009-03-15 19:00:00 | ZN | Futures | 95.528885 | 95.528885 | 95.431207 | 95.467836 | 2132.0 |
| 2009-03-15 20:00:00 | ZN | Futures | 95.467836 | 95.480046 | 95.2969 | 95.32132 | 2288.0 |
| 2009-03-15 21:00:00 | ZN | Futures | 95.30911 | 95.357949 | 95.30911 | 95.30911 | 1261.0 |
| 2009-03-15 22:00:00 | ZN | Futures | 95.32132 | 95.32132 | 95.162593 | 95.174803 | 1907.0 |
| 2009-03-15 23:00:00 | ZN | Futures | 95.174803 | 95.211432 | 95.162593 | 95.211432 | 1760.0 |
> showing 36 of 218 rows — these rows as CSV