PREVIEW / futures_1hour / 2009-01-18
file: by_date/futures_1hour/2009/2009-01-18.parquet size: 12 KB rows: 194
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-01-18 18:00:00 | ES | Futures | 808.09 | 821.37 | 807.85 | 817.58 | 18324.0 |
| 2009-01-18 19:00:00 | ES | Futures | 817.82 | 818.05 | 815.92 | 816.39 | 2724.0 |
| 2009-01-18 20:00:00 | ES | Futures | 816.15 | 817.1 | 815.21 | 816.87 | 2439.0 |
| 2009-01-18 21:00:00 | ES | Futures | 816.87 | 817.34 | 814.02 | 815.44 | 3509.0 |
| 2009-01-18 22:00:00 | ES | Futures | 815.44 | 816.39 | 811.65 | 811.65 | 3195.0 |
| 2009-01-18 23:00:00 | ES | Futures | 811.89 | 814.73 | 811.65 | 814.49 | 1637.0 |
| 2009-01-18 18:00:00 | NQ | Futures | 1354.3 | 1380.56 | 1354.3 | 1376.61 | 873.0 |
| 2009-01-18 19:00:00 | NQ | Futures | 1374.63 | 1374.63 | 1370.68 | 1371.52 | 185.0 |
| 2009-01-18 20:00:00 | NQ | Futures | 1371.24 | 1372.37 | 1369.26 | 1372.09 | 117.0 |
| 2009-01-18 21:00:00 | NQ | Futures | 1372.09 | 1372.65 | 1367.85 | 1369.26 | 158.0 |
| 2009-01-18 22:00:00 | NQ | Futures | 1370.39 | 1370.39 | 1363.9 | 1364.75 | 169.0 |
| 2009-01-18 23:00:00 | NQ | Futures | 1365.88 | 1368.98 | 1365.31 | 1367.85 | 41.0 |
| 2009-01-18 18:00:00 | YM | Futures | 7535.3 | 7647.4 | 7535.3 | 7622.8 | 753.0 |
| 2009-01-18 19:00:00 | YM | Futures | 7621.0 | 7621.0 | 7600.9 | 7603.7 | 313.0 |
| 2009-01-18 20:00:00 | YM | Futures | 7603.7 | 7608.2 | 7597.3 | 7606.4 | 110.0 |
| 2009-01-18 21:00:00 | YM | Futures | 7609.1 | 7612.8 | 7582.7 | 7594.6 | 256.0 |
| 2009-01-18 22:00:00 | YM | Futures | 7596.4 | 7600.0 | 7567.2 | 7568.1 | 180.0 |
| 2009-01-18 23:00:00 | YM | Futures | 7567.2 | 7590.0 | 7566.3 | 7584.5 | 116.0 |
| 2009-01-18 18:00:00 | CL | Futures | 127.16 | 127.58 | 126.98 | 127.07 | 212.0 |
| 2009-01-18 19:00:00 | CL | Futures | 127.1 | 127.31 | 125.99 | 126.56 | 158.0 |
| 2009-01-18 20:00:00 | CL | Futures | 126.77 | 127.07 | 126.23 | 126.56 | 149.0 |
| 2009-01-18 21:00:00 | CL | Futures | 126.62 | 126.77 | 126.47 | 126.77 | 110.0 |
| 2009-01-18 22:00:00 | CL | Futures | 126.77 | 126.77 | 126.17 | 126.77 | 129.0 |
| 2009-01-18 23:00:00 | CL | Futures | 126.77 | 126.77 | 126.5 | 126.71 | 139.0 |
| 2009-01-18 18:00:00 | GC | Futures | 1203.5 | 1206.7 | 1200.0 | 1200.5 | 1618.0 |
| 2009-01-18 19:00:00 | GC | Futures | 1201.3 | 1201.7 | 1196.1 | 1197.0 | 889.0 |
| 2009-01-18 20:00:00 | GC | Futures | 1197.0 | 1198.1 | 1193.8 | 1194.1 | 998.0 |
| 2009-01-18 21:00:00 | GC | Futures | 1194.3 | 1196.4 | 1193.7 | 1194.0 | 441.0 |
| 2009-01-18 22:00:00 | GC | Futures | 1194.0 | 1196.1 | 1193.6 | 1194.1 | 404.0 |
| 2009-01-18 23:00:00 | GC | Futures | 1194.0 | 1195.8 | 1192.8 | 1195.1 | 626.0 |
| 2009-01-18 18:00:00 | ZN | Futures | 97.089607 | 97.137832 | 97.005213 | 97.11372 | 1648.0 |
| 2009-01-18 19:00:00 | ZN | Futures | 97.101663 | 97.149889 | 96.920818 | 97.005213 | 2250.0 |
| 2009-01-18 20:00:00 | ZN | Futures | 96.993156 | 97.029325 | 96.956987 | 96.9811 | 915.0 |
| 2009-01-18 21:00:00 | ZN | Futures | 96.9811 | 96.993156 | 96.9811 | 96.993156 | 166.0 |
| 2009-01-18 22:00:00 | ZN | Futures | 96.993156 | 97.005213 | 96.969044 | 96.993156 | 447.0 |
| 2009-01-18 23:00:00 | ZN | Futures | 96.993156 | 97.125776 | 96.993156 | 97.041382 | 1319.0 |
> showing 36 of 194 rows — these rows as CSV