PREVIEW / futures_1hour / 2009-03-13
file: by_date/futures_1hour/2009/2009-03-13.parquet size: 35 KB rows: 995
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-03-13 00:00:00 | ES | Futures | 712.5 | 712.98 | 711.79 | 712.74 | 1003.0 |
| 2009-03-13 01:00:00 | ES | Futures | 712.74 | 713.45 | 711.56 | 711.56 | 1386.0 |
| 2009-03-13 02:00:00 | ES | Futures | 711.56 | 712.5 | 711.32 | 712.03 | 1388.0 |
| 2009-03-13 03:00:00 | ES | Futures | 712.27 | 713.93 | 712.03 | 713.69 | 6522.0 |
| 2009-03-13 04:00:00 | ES | Futures | 713.69 | 719.38 | 713.69 | 718.91 | 25970.0 |
| 2009-03-13 05:00:00 | ES | Futures | 718.91 | 719.62 | 716.3 | 717.25 | 10495.0 |
| 2009-03-13 06:00:00 | ES | Futures | 717.25 | 720.33 | 716.77 | 720.33 | 8150.0 |
| 2009-03-13 07:00:00 | ES | Futures | 720.09 | 722.23 | 717.96 | 719.15 | 18292.0 |
| 2009-03-13 08:00:00 | ES | Futures | 719.15 | 721.28 | 715.35 | 715.59 | 17419.0 |
| 2009-03-13 09:00:00 | ES | Futures | 715.59 | 717.01 | 710.61 | 716.06 | 82062.0 |
| 2009-03-13 10:00:00 | ES | Futures | 716.3 | 719.86 | 711.32 | 712.27 | 115506.0 |
| 2009-03-13 11:00:00 | ES | Futures | 712.27 | 714.4 | 705.86 | 707.76 | 82894.0 |
| 2009-03-13 12:00:00 | ES | Futures | 708.0 | 711.08 | 704.2 | 710.37 | 77128.0 |
| 2009-03-13 13:00:00 | ES | Futures | 710.61 | 714.88 | 709.66 | 713.69 | 43983.0 |
| 2009-03-13 14:00:00 | ES | Futures | 713.69 | 717.96 | 711.32 | 714.4 | 50024.0 |
| 2009-03-13 15:00:00 | ES | Futures | 714.17 | 719.38 | 713.69 | 717.01 | 59720.0 |
| 2009-03-13 16:00:00 | ES | Futures | 717.01 | 720.09 | 716.54 | 719.62 | 21138.0 |
| 2009-03-13 00:00:00 | NQ | Futures | 1315.33 | 1315.89 | 1313.92 | 1315.33 | 21.0 |
| 2009-03-13 01:00:00 | NQ | Futures | 1316.18 | 1316.18 | 1312.79 | 1312.79 | 23.0 |
| 2009-03-13 02:00:00 | NQ | Futures | 1313.63 | 1313.63 | 1312.22 | 1313.07 | 33.0 |
| 2009-03-13 03:00:00 | NQ | Futures | 1313.07 | 1316.18 | 1312.79 | 1315.61 | 133.0 |
| 2009-03-13 04:00:00 | NQ | Futures | 1315.89 | 1324.37 | 1315.89 | 1322.95 | 1195.0 |
| 2009-03-13 05:00:00 | NQ | Futures | 1323.52 | 1323.8 | 1318.72 | 1319.0 | 447.0 |
| 2009-03-13 06:00:00 | NQ | Futures | 1319.0 | 1325.78 | 1318.15 | 1325.49 | 315.0 |
| 2009-03-13 07:00:00 | NQ | Futures | 1325.49 | 1328.32 | 1320.41 | 1322.39 | 715.0 |
| 2009-03-13 08:00:00 | NQ | Futures | 1322.39 | 1324.65 | 1309.96 | 1310.53 | 2120.0 |
| 2009-03-13 09:00:00 | NQ | Futures | 1310.53 | 1318.15 | 1304.6 | 1317.31 | 10915.0 |
| 2009-03-13 10:00:00 | NQ | Futures | 1317.31 | 1322.39 | 1306.86 | 1309.4 | 14496.0 |
| 2009-03-13 11:00:00 | NQ | Futures | 1309.12 | 1313.07 | 1298.95 | 1301.77 | 8440.0 |
| 2009-03-13 12:00:00 | NQ | Futures | 1301.49 | 1307.7 | 1298.1 | 1306.86 | 7593.0 |
| 2009-03-13 13:00:00 | NQ | Futures | 1306.58 | 1314.2 | 1306.01 | 1310.53 | 5525.0 |
| 2009-03-13 14:00:00 | NQ | Futures | 1310.25 | 1317.59 | 1305.45 | 1313.07 | 5851.0 |
| 2009-03-13 15:00:00 | NQ | Futures | 1313.07 | 1320.13 | 1312.51 | 1317.87 | 7641.0 |
| 2009-03-13 16:00:00 | NQ | Futures | 1317.87 | 1323.24 | 1316.74 | 1322.67 | 2699.0 |
| 2009-03-13 00:00:00 | YM | Futures | 6535.6 | 6537.4 | 6529.1 | 6537.4 | 151.0 |
| 2009-03-13 01:00:00 | YM | Futures | 6537.4 | 6539.2 | 6524.5 | 6524.5 | 53.0 |
| 2009-03-13 02:00:00 | YM | Futures | 6525.5 | 6532.8 | 6524.5 | 6527.3 | 137.0 |
| 2009-03-13 03:00:00 | YM | Futures | 6531.0 | 6545.7 | 6531.0 | 6545.7 | 305.0 |
| 2009-03-13 04:00:00 | YM | Futures | 6544.8 | 6587.9 | 6542.0 | 6584.3 | 2137.0 |
| 2009-03-13 05:00:00 | YM | Futures | 6587.0 | 6589.8 | 6562.2 | 6571.4 | 735.0 |
| 2009-03-13 06:00:00 | YM | Futures | 6569.6 | 6599.0 | 6565.0 | 6595.3 | 991.0 |
| 2009-03-13 07:00:00 | YM | Futures | 6597.1 | 6613.7 | 6583.4 | 6593.5 | 1792.0 |
| 2009-03-13 08:00:00 | YM | Futures | 6592.5 | 6600.8 | 6555.8 | 6558.5 | 3075.0 |
| 2009-03-13 09:00:00 | YM | Futures | 6558.5 | 6583.4 | 6528.2 | 6583.4 | 20998.0 |
| 2009-03-13 10:00:00 | YM | Futures | 6583.4 | 6607.2 | 6532.8 | 6552.1 | 37417.0 |
| 2009-03-13 11:00:00 | YM | Futures | 6552.1 | 6573.2 | 6495.1 | 6511.7 | 27295.0 |
| 2009-03-13 12:00:00 | YM | Futures | 6512.6 | 6534.6 | 6481.3 | 6531.9 | 20805.0 |
| 2009-03-13 13:00:00 | YM | Futures | 6531.9 | 6567.7 | 6524.5 | 6556.7 | 16502.0 |
| 2009-03-13 14:00:00 | YM | Futures | 6555.8 | 6593.5 | 6542.0 | 6565.0 | 21684.0 |
| 2009-03-13 15:00:00 | YM | Futures | 6565.0 | 6605.4 | 6559.5 | 6584.3 | 18025.0 |
> showing 50 of 995 rows — these rows as CSV