PREVIEW / futures_1hour / 2009-02-12
file: by_date/futures_1hour/2009/2009-02-12.parquet size: 43 KB rows: 1,262
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-12 00:00:00 | ES | Futures | 787.22 | 787.46 | 785.08 | 785.32 | 2249.0 |
| 2009-02-12 01:00:00 | ES | Futures | 785.32 | 787.69 | 785.08 | 786.98 | 2357.0 |
| 2009-02-12 02:00:00 | ES | Futures | 786.98 | 787.69 | 785.8 | 786.03 | 2463.0 |
| 2009-02-12 03:00:00 | ES | Futures | 786.03 | 786.74 | 779.87 | 781.76 | 24583.0 |
| 2009-02-12 04:00:00 | ES | Futures | 781.76 | 782.47 | 779.87 | 781.76 | 11133.0 |
| 2009-02-12 05:00:00 | ES | Futures | 781.76 | 782.0 | 778.44 | 779.15 | 18587.0 |
| 2009-02-12 06:00:00 | ES | Futures | 779.15 | 782.71 | 778.44 | 780.81 | 13494.0 |
| 2009-02-12 07:00:00 | ES | Futures | 780.81 | 782.47 | 778.92 | 779.39 | 13613.0 |
| 2009-02-12 08:00:00 | ES | Futures | 779.63 | 783.66 | 777.97 | 781.29 | 71381.0 |
| 2009-02-12 09:00:00 | ES | Futures | 781.29 | 781.29 | 768.72 | 770.14 | 381736.0 |
| 2009-02-12 10:00:00 | ES | Futures | 770.14 | 777.02 | 766.82 | 775.36 | 444547.0 |
| 2009-02-12 11:00:00 | ES | Futures | 775.6 | 780.1 | 770.38 | 776.54 | 349503.0 |
| 2009-02-12 12:00:00 | ES | Futures | 776.54 | 782.71 | 776.07 | 778.44 | 232275.0 |
| 2009-02-12 13:00:00 | ES | Futures | 778.68 | 779.39 | 771.33 | 775.36 | 315228.0 |
| 2009-02-12 14:00:00 | ES | Futures | 775.36 | 777.26 | 765.63 | 767.06 | 345700.0 |
| 2009-02-12 15:00:00 | ES | Futures | 767.29 | 791.01 | 764.21 | 789.59 | 810985.0 |
| 2009-02-12 16:00:00 | ES | Futures | 789.83 | 793.86 | 788.4 | 792.2 | 133869.0 |
| 2009-02-12 17:00:00 | ES | Futures | 792.44 | 793.15 | 792.2 | 792.2 | 1386.0 |
| 2009-02-12 18:00:00 | ES | Futures | 791.72 | 793.62 | 790.54 | 790.54 | 5891.0 |
| 2009-02-12 19:00:00 | ES | Futures | 790.54 | 791.01 | 789.59 | 790.06 | 3024.0 |
| 2009-02-12 20:00:00 | ES | Futures | 790.3 | 790.78 | 789.59 | 790.06 | 2128.0 |
| 2009-02-12 21:00:00 | ES | Futures | 790.06 | 792.91 | 789.59 | 791.96 | 2334.0 |
| 2009-02-12 22:00:00 | ES | Futures | 791.96 | 795.76 | 791.96 | 795.05 | 3451.0 |
| 2009-02-12 23:00:00 | ES | Futures | 795.05 | 795.52 | 793.86 | 795.28 | 1607.0 |
| 2009-02-12 00:00:00 | NQ | Futures | 1378.58 | 1380.56 | 1376.32 | 1377.45 | 48.0 |
| 2009-02-12 01:00:00 | NQ | Futures | 1377.45 | 1382.54 | 1376.61 | 1381.12 | 300.0 |
| 2009-02-12 02:00:00 | NQ | Futures | 1381.12 | 1381.97 | 1379.15 | 1379.43 | 137.0 |
| 2009-02-12 03:00:00 | NQ | Futures | 1379.43 | 1380.56 | 1368.42 | 1372.37 | 1885.0 |
| 2009-02-12 04:00:00 | NQ | Futures | 1371.81 | 1372.65 | 1368.42 | 1371.52 | 832.0 |
| 2009-02-12 05:00:00 | NQ | Futures | 1371.52 | 1371.52 | 1365.88 | 1365.88 | 836.0 |
| 2009-02-12 06:00:00 | NQ | Futures | 1365.88 | 1374.35 | 1364.75 | 1370.68 | 1016.0 |
| 2009-02-12 07:00:00 | NQ | Futures | 1370.39 | 1376.61 | 1370.11 | 1370.96 | 2198.0 |
| 2009-02-12 08:00:00 | NQ | Futures | 1371.24 | 1380.28 | 1369.26 | 1377.45 | 6556.0 |
| 2009-02-12 09:00:00 | NQ | Futures | 1377.17 | 1377.74 | 1361.07 | 1366.72 | 45831.0 |
| 2009-02-12 10:00:00 | NQ | Futures | 1366.44 | 1382.82 | 1358.25 | 1378.3 | 57085.0 |
| 2009-02-12 11:00:00 | NQ | Futures | 1377.74 | 1392.7 | 1371.24 | 1385.36 | 56240.0 |
| 2009-02-12 12:00:00 | NQ | Futures | 1385.64 | 1398.91 | 1384.51 | 1388.18 | 39413.0 |
| 2009-02-12 13:00:00 | NQ | Futures | 1388.47 | 1389.31 | 1373.78 | 1382.25 | 45308.0 |
| 2009-02-12 14:00:00 | NQ | Futures | 1382.25 | 1385.92 | 1362.2 | 1366.16 | 49541.0 |
| 2009-02-12 15:00:00 | NQ | Futures | 1366.16 | 1403.43 | 1359.1 | 1402.3 | 91506.0 |
| 2009-02-12 16:00:00 | NQ | Futures | 1402.3 | 1408.51 | 1401.17 | 1406.26 | 12295.0 |
| 2009-02-12 17:00:00 | NQ | Futures | 1405.13 | 1406.54 | 1404.56 | 1404.56 | 72.0 |
| 2009-02-12 18:00:00 | NQ | Futures | 1404.84 | 1407.1 | 1403.43 | 1403.43 | 362.0 |
| 2009-02-12 19:00:00 | NQ | Futures | 1403.43 | 1404.28 | 1402.58 | 1403.43 | 90.0 |
| 2009-02-12 20:00:00 | NQ | Futures | 1403.43 | 1404.84 | 1403.15 | 1403.15 | 86.0 |
| 2009-02-12 21:00:00 | NQ | Futures | 1403.15 | 1408.23 | 1403.15 | 1407.39 | 131.0 |
| 2009-02-12 22:00:00 | NQ | Futures | 1407.39 | 1413.6 | 1407.1 | 1412.19 | 310.0 |
| 2009-02-12 23:00:00 | NQ | Futures | 1412.75 | 1413.6 | 1410.21 | 1413.6 | 64.0 |
| 2009-02-12 00:00:00 | YM | Futures | 7182.7 | 7184.5 | 7166.3 | 7168.1 | 102.0 |
| 2009-02-12 01:00:00 | YM | Futures | 7167.2 | 7189.0 | 7167.2 | 7182.7 | 186.0 |
> showing 50 of 1,262 rows — these rows as CSV