PREVIEW / futures_1hour / 2010-11-21
file: by_date/futures_1hour/2010/2010-11-21.parquet size: 14 KB rows: 261
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-21 18:00:00 | ES | Futures | 1185.81 | 1187.78 | 1184.58 | 1187.29 | 25423.0 |
| 2010-11-21 19:00:00 | ES | Futures | 1187.54 | 1188.03 | 1186.8 | 1187.78 | 9416.0 |
| 2010-11-21 20:00:00 | ES | Futures | 1188.03 | 1189.01 | 1187.29 | 1187.78 | 11730.0 |
| 2010-11-21 21:00:00 | ES | Futures | 1188.03 | 1188.77 | 1187.29 | 1188.52 | 8391.0 |
| 2010-11-21 22:00:00 | ES | Futures | 1188.52 | 1188.77 | 1187.29 | 1188.03 | 8061.0 |
| 2010-11-21 23:00:00 | ES | Futures | 1187.78 | 1188.03 | 1187.04 | 1187.54 | 2154.0 |
| 2010-11-21 18:00:00 | NQ | Futures | 2454.74 | 2463.34 | 2454.16 | 2462.77 | 557.0 |
| 2010-11-21 19:00:00 | NQ | Futures | 2461.91 | 2463.06 | 2460.76 | 2462.77 | 356.0 |
| 2010-11-21 20:00:00 | NQ | Futures | 2462.48 | 2465.93 | 2461.62 | 2462.77 | 512.0 |
| 2010-11-21 21:00:00 | NQ | Futures | 2463.06 | 2465.35 | 2462.48 | 2463.92 | 434.0 |
| 2010-11-21 22:00:00 | NQ | Futures | 2463.63 | 2463.92 | 2461.62 | 2463.06 | 290.0 |
| 2010-11-21 23:00:00 | NQ | Futures | 2462.77 | 2463.63 | 2461.91 | 2462.48 | 48.0 |
| 2010-11-21 18:00:00 | YM | Futures | 10696.3 | 10706.8 | 10676.3 | 10696.3 | 686.0 |
| 2010-11-21 19:00:00 | YM | Futures | 10697.3 | 10703.0 | 10695.4 | 10701.1 | 282.0 |
| 2010-11-21 20:00:00 | YM | Futures | 10700.2 | 10710.6 | 10697.3 | 10704.0 | 359.0 |
| 2010-11-21 21:00:00 | YM | Futures | 10703.0 | 10708.7 | 10696.3 | 10704.9 | 393.0 |
| 2010-11-21 22:00:00 | YM | Futures | 10704.9 | 10705.9 | 10696.3 | 10700.2 | 401.0 |
| 2010-11-21 23:00:00 | YM | Futures | 10700.2 | 10701.1 | 10692.5 | 10693.5 | 92.0 |
| 2010-11-21 18:00:00 | CL | Futures | 153.31 | 153.7 | 153.09 | 153.7 | 2717.0 |
| 2010-11-21 19:00:00 | CL | Futures | 153.68 | 153.78 | 153.5 | 153.76 | 1124.0 |
| 2010-11-21 20:00:00 | CL | Futures | 153.76 | 154.0 | 153.68 | 153.94 | 1399.0 |
| 2010-11-21 21:00:00 | CL | Futures | 153.96 | 154.02 | 153.85 | 153.98 | 793.0 |
| 2010-11-21 22:00:00 | CL | Futures | 153.98 | 154.19 | 153.87 | 154.13 | 876.0 |
| 2010-11-21 23:00:00 | CL | Futures | 154.15 | 154.17 | 153.76 | 154.15 | 841.0 |
| 2010-11-21 18:00:00 | GC | Futures | 1898.5 | 1902.1 | 1898.5 | 1901.0 | 2044.0 |
| 2010-11-21 19:00:00 | GC | Futures | 1901.2 | 1902.0 | 1895.0 | 1897.4 | 2000.0 |
| 2010-11-21 20:00:00 | GC | Futures | 1897.1 | 1904.1 | 1896.0 | 1903.4 | 2760.0 |
| 2010-11-21 21:00:00 | GC | Futures | 1903.8 | 1904.5 | 1901.3 | 1901.7 | 1242.0 |
| 2010-11-21 22:00:00 | GC | Futures | 1901.9 | 1902.7 | 1900.2 | 1902.7 | 1176.0 |
| 2010-11-21 23:00:00 | GC | Futures | 1902.7 | 1904.9 | 1901.2 | 1904.5 | 1674.0 |
| 2010-11-21 18:00:00 | ZN | Futures | 103.674486 | 103.687512 | 103.583303 | 103.622381 | 6321.0 |
| 2010-11-21 19:00:00 | ZN | Futures | 103.635407 | 103.674486 | 103.609355 | 103.622381 | 3637.0 |
| 2010-11-21 20:00:00 | ZN | Futures | 103.609355 | 103.622381 | 103.583303 | 103.609355 | 4484.0 |
| 2010-11-21 21:00:00 | ZN | Futures | 103.609355 | 103.622381 | 103.570277 | 103.596329 | 2827.0 |
| 2010-11-21 22:00:00 | ZN | Futures | 103.596329 | 103.622381 | 103.596329 | 103.609355 | 972.0 |
| 2010-11-21 23:00:00 | ZN | Futures | 103.596329 | 103.648433 | 103.596329 | 103.635407 | 1737.0 |
> showing 36 of 261 rows — these rows as CSV