PREVIEW / futures_1hour / 2009-02-15
file: by_date/futures_1hour/2009/2009-02-15.parquet size: 11 KB rows: 161
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-02-15 18:00:00 | ES | Futures | 772.28 | 774.17 | 768.48 | 772.04 | 8842.0 |
| 2009-02-15 19:00:00 | ES | Futures | 772.04 | 774.41 | 771.56 | 773.7 | 3796.0 |
| 2009-02-15 20:00:00 | ES | Futures | 773.7 | 775.36 | 772.75 | 773.46 | 3089.0 |
| 2009-02-15 21:00:00 | ES | Futures | 773.46 | 773.94 | 772.28 | 772.51 | 1924.0 |
| 2009-02-15 22:00:00 | ES | Futures | 772.51 | 773.22 | 772.04 | 772.04 | 1371.0 |
| 2009-02-15 23:00:00 | ES | Futures | 772.04 | 772.51 | 770.38 | 770.62 | 2759.0 |
| 2009-02-15 18:00:00 | NQ | Futures | 1382.82 | 1382.82 | 1370.11 | 1377.74 | 558.0 |
| 2009-02-15 19:00:00 | NQ | Futures | 1378.02 | 1381.69 | 1376.89 | 1380.56 | 106.0 |
| 2009-02-15 20:00:00 | NQ | Futures | 1380.84 | 1383.67 | 1379.15 | 1379.99 | 134.0 |
| 2009-02-15 21:00:00 | NQ | Futures | 1379.99 | 1380.28 | 1378.02 | 1378.02 | 70.0 |
| 2009-02-15 22:00:00 | NQ | Futures | 1378.3 | 1380.84 | 1378.3 | 1378.3 | 57.0 |
| 2009-02-15 23:00:00 | NQ | Futures | 1378.58 | 1378.86 | 1375.76 | 1375.76 | 217.0 |
| 2009-02-15 18:00:00 | YM | Futures | 7063.3 | 7066.9 | 7021.4 | 7047.8 | 468.0 |
| 2009-02-15 19:00:00 | YM | Futures | 7046.9 | 7063.3 | 7042.3 | 7059.6 | 259.0 |
| 2009-02-15 20:00:00 | YM | Futures | 7060.5 | 7078.8 | 7051.4 | 7059.6 | 290.0 |
| 2009-02-15 21:00:00 | YM | Futures | 7062.4 | 7066.0 | 7054.2 | 7055.1 | 120.0 |
| 2009-02-15 22:00:00 | YM | Futures | 7055.1 | 7059.6 | 7052.3 | 7055.1 | 86.0 |
| 2009-02-15 23:00:00 | YM | Futures | 7055.1 | 7056.0 | 7041.4 | 7042.3 | 166.0 |
| 2009-02-15 18:00:00 | CL | Futures | 108.88 | 108.88 | 107.64 | 107.66 | 345.0 |
| 2009-02-15 19:00:00 | CL | Futures | 107.66 | 108.26 | 107.64 | 108.05 | 116.0 |
| 2009-02-15 20:00:00 | CL | Futures | 108.05 | 108.41 | 107.97 | 107.97 | 92.0 |
| 2009-02-15 21:00:00 | CL | Futures | 108.03 | 108.1 | 107.64 | 107.79 | 40.0 |
| 2009-02-15 22:00:00 | CL | Futures | 107.82 | 107.92 | 107.77 | 107.79 | 36.0 |
| 2009-02-15 23:00:00 | CL | Futures | 107.79 | 108.41 | 107.79 | 108.41 | 92.0 |
| 2009-02-15 18:00:00 | GC | Futures | 1338.4 | 1342.1 | 1336.7 | 1340.7 | 671.0 |
| 2009-02-15 19:00:00 | GC | Futures | 1340.8 | 1341.5 | 1333.4 | 1334.3 | 812.0 |
| 2009-02-15 20:00:00 | GC | Futures | 1334.1 | 1336.6 | 1333.7 | 1336.3 | 415.0 |
| 2009-02-15 21:00:00 | GC | Futures | 1336.4 | 1337.1 | 1334.8 | 1335.1 | 387.0 |
| 2009-02-15 22:00:00 | GC | Futures | 1335.3 | 1335.4 | 1334.4 | 1335.1 | 341.0 |
| 2009-02-15 23:00:00 | GC | Futures | 1335.0 | 1336.0 | 1334.6 | 1335.0 | 262.0 |
| 2009-02-15 18:00:00 | ZN | Futures | 94.919468 | 94.97975 | 94.883299 | 94.955637 | 1388.0 |
| 2009-02-15 19:00:00 | ZN | Futures | 94.955637 | 94.967693 | 94.823017 | 94.84713 | 1471.0 |
| 2009-02-15 20:00:00 | ZN | Futures | 94.823017 | 94.871243 | 94.798905 | 94.798905 | 613.0 |
| 2009-02-15 21:00:00 | ZN | Futures | 94.798905 | 94.823017 | 94.750679 | 94.750679 | 500.0 |
| 2009-02-15 22:00:00 | ZN | Futures | 94.750679 | 94.762736 | 94.654229 | 94.678341 | 1706.0 |
| 2009-02-15 23:00:00 | ZN | Futures | 94.666285 | 94.666285 | 94.61806 | 94.630116 | 1298.0 |
> showing 36 of 161 rows — these rows as CSV