PREVIEW / futures_1hour / 2009-02-16
file: by_date/futures_1hour/2009/2009-02-16.parquet size: 30 KB rows: 848
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-16 00:00:00 | ES | Futures | 770.85 | 772.99 | 770.38 | 772.51 | 1445.0 |
| 2009-02-16 01:00:00 | ES | Futures | 772.51 | 773.22 | 771.8 | 772.99 | 1136.0 |
| 2009-02-16 02:00:00 | ES | Futures | 773.22 | 775.6 | 772.75 | 774.65 | 6247.0 |
| 2009-02-16 03:00:00 | ES | Futures | 774.88 | 776.54 | 773.7 | 775.36 | 18157.0 |
| 2009-02-16 04:00:00 | ES | Futures | 775.6 | 776.78 | 774.17 | 774.41 | 5356.0 |
| 2009-02-16 05:00:00 | ES | Futures | 774.17 | 774.88 | 772.28 | 774.17 | 6333.0 |
| 2009-02-16 06:00:00 | ES | Futures | 774.41 | 775.83 | 773.94 | 775.36 | 4780.0 |
| 2009-02-16 07:00:00 | ES | Futures | 775.12 | 775.36 | 773.7 | 774.17 | 2110.0 |
| 2009-02-16 08:00:00 | ES | Futures | 774.17 | 776.07 | 773.46 | 774.41 | 14133.0 |
| 2009-02-16 09:00:00 | ES | Futures | 774.65 | 775.6 | 772.28 | 772.75 | 9196.0 |
| 2009-02-16 10:00:00 | ES | Futures | 772.99 | 772.99 | 769.43 | 770.14 | 14271.0 |
| 2009-02-16 11:00:00 | ES | Futures | 769.9 | 770.38 | 766.82 | 767.29 | 10801.0 |
| 2009-02-16 18:00:00 | ES | Futures | 767.77 | 769.43 | 767.77 | 768.95 | 4832.0 |
| 2009-02-16 19:00:00 | ES | Futures | 769.19 | 770.38 | 768.24 | 770.14 | 2756.0 |
| 2009-02-16 20:00:00 | ES | Futures | 770.14 | 770.62 | 764.69 | 765.16 | 6999.0 |
| 2009-02-16 21:00:00 | ES | Futures | 765.16 | 766.11 | 764.69 | 765.4 | 2030.0 |
| 2009-02-16 22:00:00 | ES | Futures | 765.4 | 766.11 | 764.21 | 765.16 | 3005.0 |
| 2009-02-16 23:00:00 | ES | Futures | 764.92 | 766.11 | 764.69 | 765.4 | 1591.0 |
| 2009-02-16 00:00:00 | NQ | Futures | 1376.04 | 1379.43 | 1376.04 | 1379.43 | 219.0 |
| 2009-02-16 01:00:00 | NQ | Futures | 1378.86 | 1380.84 | 1378.58 | 1380.28 | 99.0 |
| 2009-02-16 02:00:00 | NQ | Futures | 1380.84 | 1383.67 | 1380.56 | 1382.54 | 178.0 |
| 2009-02-16 03:00:00 | NQ | Futures | 1382.54 | 1384.79 | 1378.58 | 1380.84 | 1438.0 |
| 2009-02-16 04:00:00 | NQ | Futures | 1381.12 | 1382.54 | 1378.86 | 1381.97 | 485.0 |
| 2009-02-16 05:00:00 | NQ | Futures | 1382.25 | 1383.1 | 1379.99 | 1382.54 | 679.0 |
| 2009-02-16 06:00:00 | NQ | Futures | 1382.54 | 1384.51 | 1381.69 | 1383.38 | 348.0 |
| 2009-02-16 07:00:00 | NQ | Futures | 1383.1 | 1383.67 | 1380.84 | 1382.54 | 270.0 |
| 2009-02-16 08:00:00 | NQ | Futures | 1382.54 | 1385.92 | 1382.25 | 1383.95 | 1182.0 |
| 2009-02-16 09:00:00 | NQ | Futures | 1383.67 | 1385.36 | 1378.58 | 1378.86 | 1718.0 |
| 2009-02-16 10:00:00 | NQ | Futures | 1378.58 | 1378.58 | 1368.98 | 1369.83 | 2653.0 |
| 2009-02-16 11:00:00 | NQ | Futures | 1369.83 | 1371.52 | 1362.77 | 1364.18 | 2391.0 |
| 2009-02-16 18:00:00 | NQ | Futures | 1364.75 | 1368.7 | 1364.75 | 1368.13 | 439.0 |
| 2009-02-16 19:00:00 | NQ | Futures | 1368.42 | 1370.11 | 1367.0 | 1370.11 | 127.0 |
| 2009-02-16 20:00:00 | NQ | Futures | 1370.11 | 1370.39 | 1361.07 | 1362.77 | 330.0 |
| 2009-02-16 21:00:00 | NQ | Futures | 1362.2 | 1364.46 | 1362.2 | 1363.33 | 377.0 |
| 2009-02-16 22:00:00 | NQ | Futures | 1363.05 | 1364.46 | 1360.79 | 1363.62 | 272.0 |
| 2009-02-16 23:00:00 | NQ | Futures | 1363.05 | 1363.62 | 1361.64 | 1362.2 | 185.0 |
| 2009-02-16 00:00:00 | YM | Futures | 7043.2 | 7059.6 | 7042.3 | 7057.8 | 78.0 |
| 2009-02-16 01:00:00 | YM | Futures | 7056.9 | 7059.6 | 7050.5 | 7058.7 | 135.0 |
| 2009-02-16 02:00:00 | YM | Futures | 7059.6 | 7076.0 | 7058.7 | 7066.0 | 327.0 |
| 2009-02-16 03:00:00 | YM | Futures | 7066.9 | 7081.5 | 7064.2 | 7074.2 | 1231.0 |
| 2009-02-16 04:00:00 | YM | Futures | 7076.0 | 7082.4 | 7066.0 | 7067.8 | 564.0 |
| 2009-02-16 05:00:00 | YM | Futures | 7067.8 | 7069.7 | 7049.6 | 7065.1 | 486.0 |
| 2009-02-16 06:00:00 | YM | Futures | 7067.8 | 7077.0 | 7062.4 | 7071.5 | 272.0 |
| 2009-02-16 07:00:00 | YM | Futures | 7069.7 | 7071.5 | 7062.4 | 7063.3 | 121.0 |
| 2009-02-16 08:00:00 | YM | Futures | 7063.3 | 7080.6 | 7059.6 | 7066.9 | 638.0 |
| 2009-02-16 09:00:00 | YM | Futures | 7066.9 | 7072.4 | 7042.3 | 7052.3 | 448.0 |
| 2009-02-16 10:00:00 | YM | Futures | 7052.3 | 7055.1 | 7026.8 | 7031.4 | 868.0 |
| 2009-02-16 11:00:00 | YM | Futures | 7029.6 | 7035.0 | 7008.6 | 7014.1 | 735.0 |
| 2009-02-16 18:00:00 | YM | Futures | 7015.9 | 7030.5 | 7015.9 | 7026.8 | 191.0 |
| 2009-02-16 19:00:00 | YM | Futures | 7027.7 | 7036.9 | 7022.3 | 7035.9 | 216.0 |
> showing 50 of 848 rows — these rows as CSV