PREVIEW / futures_1hour / 2009-06-07
file: by_date/futures_1hour/2009/2009-06-07.parquet size: 12 KB rows: 216
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-06-07 18:00:00 | ES | Futures | 900.54 | 900.54 | 895.75 | 896.71 | 7750.0 |
| 2009-06-07 19:00:00 | ES | Futures | 896.95 | 898.63 | 896.71 | 897.19 | 2725.0 |
| 2009-06-07 20:00:00 | ES | Futures | 897.19 | 900.3 | 897.19 | 898.63 | 4838.0 |
| 2009-06-07 21:00:00 | ES | Futures | 898.63 | 898.87 | 895.99 | 896.23 | 4059.0 |
| 2009-06-07 22:00:00 | ES | Futures | 896.23 | 899.11 | 895.99 | 898.87 | 3584.0 |
| 2009-06-07 23:00:00 | ES | Futures | 899.11 | 900.06 | 898.63 | 898.63 | 2322.0 |
| 2009-06-07 18:00:00 | NQ | Futures | 1695.46 | 1697.45 | 1687.79 | 1689.21 | 576.0 |
| 2009-06-07 19:00:00 | NQ | Futures | 1689.21 | 1692.34 | 1689.21 | 1690.63 | 117.0 |
| 2009-06-07 20:00:00 | NQ | Futures | 1689.5 | 1695.75 | 1689.5 | 1692.91 | 213.0 |
| 2009-06-07 21:00:00 | NQ | Futures | 1692.91 | 1693.76 | 1687.79 | 1688.93 | 235.0 |
| 2009-06-07 22:00:00 | NQ | Futures | 1689.5 | 1694.33 | 1688.07 | 1694.33 | 141.0 |
| 2009-06-07 23:00:00 | NQ | Futures | 1694.61 | 1696.31 | 1692.91 | 1695.18 | 103.0 |
| 2009-06-07 18:00:00 | YM | Futures | 8040.8 | 8040.8 | 8006.8 | 8014.2 | 293.0 |
| 2009-06-07 19:00:00 | YM | Futures | 8016.9 | 8030.7 | 8015.1 | 8026.1 | 138.0 |
| 2009-06-07 20:00:00 | YM | Futures | 8025.2 | 8044.5 | 8020.6 | 8031.6 | 336.0 |
| 2009-06-07 21:00:00 | YM | Futures | 8030.7 | 8031.6 | 8011.4 | 8013.2 | 259.0 |
| 2009-06-07 22:00:00 | YM | Futures | 8013.2 | 8031.6 | 8007.7 | 8031.6 | 294.0 |
| 2009-06-07 23:00:00 | YM | Futures | 8032.5 | 8040.8 | 8028.9 | 8029.8 | 245.0 |
| 2009-06-07 18:00:00 | CL | Futures | 163.215 | 163.215 | 161.925 | 162.093 | 610.0 |
| 2009-06-07 19:00:00 | CL | Futures | 162.093 | 162.809 | 161.997 | 162.547 | 331.0 |
| 2009-06-07 20:00:00 | CL | Futures | 162.547 | 162.594 | 162.093 | 162.451 | 386.0 |
| 2009-06-07 21:00:00 | CL | Futures | 162.499 | 162.929 | 162.451 | 162.594 | 397.0 |
| 2009-06-07 22:00:00 | CL | Futures | 162.57 | 162.57 | 162.188 | 162.451 | 444.0 |
| 2009-06-07 23:00:00 | CL | Futures | 162.403 | 162.451 | 162.355 | 162.355 | 181.0 |
| 2009-06-07 18:00:00 | GC | Futures | 1354.8 | 1361.6 | 1350.5 | 1352.4 | 1535.0 |
| 2009-06-07 19:00:00 | GC | Futures | 1352.4 | 1358.5 | 1352.4 | 1357.3 | 439.0 |
| 2009-06-07 20:00:00 | GC | Futures | 1356.8 | 1357.4 | 1353.4 | 1356.8 | 724.0 |
| 2009-06-07 21:00:00 | GC | Futures | 1356.8 | 1360.2 | 1356.5 | 1359.8 | 1157.0 |
| 2009-06-07 22:00:00 | GC | Futures | 1359.7 | 1360.8 | 1358.5 | 1360.5 | 591.0 |
| 2009-06-07 23:00:00 | GC | Futures | 1360.8 | 1361.1 | 1360.5 | 1360.9 | 320.0 |
| 2009-06-07 18:00:00 | ZN | Futures | 89.97346 | 89.97346 | 89.97346 | 89.97346 | 1.0 |
| 2009-06-07 19:00:00 | ZN | Futures | 89.99788 | 89.99788 | 89.936831 | 89.98567 | 4.0 |
| 2009-06-07 20:00:00 | ZN | Futures | 90.01009 | 90.022299 | 89.97346 | 89.97346 | 7.0 |
| 2009-06-07 22:00:00 | ZN | Futures | 89.949041 | 89.949041 | 89.887992 | 89.887992 | 3.0 |
| 2009-06-07 23:00:00 | ZN | Futures | 89.765895 | 89.765895 | 89.765895 | 89.765895 | 10.0 |
> showing 35 of 216 rows — these rows as CSV