PREVIEW / futures_1hour / 2009-08-02
file: by_date/futures_1hour/2009/2009-08-02.parquet size: 13 KB rows: 228
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-08-02 18:00:00 | ES | Futures | 948.02 | 951.64 | 947.78 | 948.99 | 9324.0 |
| 2009-08-02 19:00:00 | ES | Futures | 949.23 | 950.92 | 949.23 | 949.95 | 2651.0 |
| 2009-08-02 20:00:00 | ES | Futures | 950.19 | 950.68 | 947.3 | 948.75 | 6891.0 |
| 2009-08-02 21:00:00 | ES | Futures | 948.51 | 949.71 | 948.26 | 948.51 | 2363.0 |
| 2009-08-02 22:00:00 | ES | Futures | 948.51 | 951.64 | 948.02 | 951.4 | 3147.0 |
| 2009-08-02 23:00:00 | ES | Futures | 951.64 | 952.61 | 950.92 | 951.88 | 3091.0 |
| 2009-08-02 18:00:00 | NQ | Futures | 1824.21 | 1830.48 | 1823.36 | 1825.92 | 829.0 |
| 2009-08-02 19:00:00 | NQ | Futures | 1826.2 | 1830.48 | 1825.92 | 1829.05 | 250.0 |
| 2009-08-02 20:00:00 | NQ | Futures | 1829.05 | 1829.05 | 1823.93 | 1826.49 | 649.0 |
| 2009-08-02 21:00:00 | NQ | Futures | 1826.77 | 1828.2 | 1825.92 | 1826.49 | 156.0 |
| 2009-08-02 22:00:00 | NQ | Futures | 1826.49 | 1831.62 | 1825.07 | 1831.33 | 342.0 |
| 2009-08-02 23:00:00 | NQ | Futures | 1831.33 | 1833.32 | 1830.19 | 1832.19 | 277.0 |
| 2009-08-02 18:00:00 | YM | Futures | 8414.2 | 8449.3 | 8413.3 | 8430.9 | 349.0 |
| 2009-08-02 19:00:00 | YM | Futures | 8429.0 | 8446.6 | 8429.0 | 8440.1 | 119.0 |
| 2009-08-02 20:00:00 | YM | Futures | 8439.2 | 8442.0 | 8420.7 | 8429.9 | 322.0 |
| 2009-08-02 21:00:00 | YM | Futures | 8429.9 | 8436.4 | 8426.2 | 8426.2 | 88.0 |
| 2009-08-02 22:00:00 | YM | Futures | 8428.1 | 8454.0 | 8424.4 | 8452.1 | 305.0 |
| 2009-08-02 23:00:00 | YM | Futures | 8454.0 | 8462.3 | 8448.4 | 8455.8 | 233.0 |
| 2009-08-02 18:00:00 | CL | Futures | 161.8 | 162.26 | 161.31 | 162.1 | 1029.0 |
| 2009-08-02 19:00:00 | CL | Futures | 162.08 | 162.8 | 161.94 | 162.4 | 959.0 |
| 2009-08-02 20:00:00 | CL | Futures | 162.43 | 162.85 | 162.1 | 162.45 | 2025.0 |
| 2009-08-02 21:00:00 | CL | Futures | 162.47 | 162.71 | 162.45 | 162.47 | 1026.0 |
| 2009-08-02 22:00:00 | CL | Futures | 162.45 | 163.41 | 162.33 | 163.03 | 1780.0 |
| 2009-08-02 23:00:00 | CL | Futures | 163.06 | 163.8 | 163.01 | 163.52 | 1645.0 |
| 2009-08-02 18:00:00 | GC | Futures | 1347.3 | 1350.0 | 1347.1 | 1348.6 | 442.0 |
| 2009-08-02 19:00:00 | GC | Futures | 1348.5 | 1354.4 | 1348.3 | 1353.5 | 961.0 |
| 2009-08-02 20:00:00 | GC | Futures | 1353.5 | 1353.7 | 1350.0 | 1350.4 | 1169.0 |
| 2009-08-02 21:00:00 | GC | Futures | 1350.6 | 1351.3 | 1348.6 | 1349.2 | 754.0 |
| 2009-08-02 22:00:00 | GC | Futures | 1349.2 | 1350.2 | 1348.7 | 1350.2 | 382.0 |
| 2009-08-02 23:00:00 | GC | Futures | 1349.9 | 1351.6 | 1349.5 | 1351.0 | 631.0 |
| 2009-08-02 18:00:00 | ZN | Futures | 93.126384 | 93.126384 | 93.039582 | 93.064382 | 999.0 |
| 2009-08-02 19:00:00 | ZN | Futures | 93.051982 | 93.051982 | 92.96518 | 92.96518 | 2088.0 |
| 2009-08-02 20:00:00 | ZN | Futures | 92.96518 | 92.96518 | 92.915579 | 92.927979 | 4431.0 |
| 2009-08-02 21:00:00 | ZN | Futures | 92.927979 | 92.95278 | 92.927979 | 92.940379 | 2612.0 |
| 2009-08-02 22:00:00 | ZN | Futures | 92.940379 | 92.96518 | 92.927979 | 92.96518 | 1760.0 |
| 2009-08-02 23:00:00 | ZN | Futures | 92.96518 | 92.96518 | 92.915579 | 92.915579 | 1216.0 |
> showing 36 of 228 rows — these rows as CSV