PREVIEW / futures_30min / 2011-06-30
file: by_date/futures_30min/2011/2011-06-30.parquet size: 76 KB rows: 2,755
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-30 00:00:00 | ES | Futures | 1303.64 | 1303.89 | 1302.89 | 1303.14 | 652.0 |
| 2011-06-30 00:30:00 | ES | Futures | 1303.14 | 1304.14 | 1303.14 | 1303.89 | 1515.0 |
| 2011-06-30 01:00:00 | ES | Futures | 1304.14 | 1304.39 | 1303.14 | 1303.64 | 2620.0 |
| 2011-06-30 01:30:00 | ES | Futures | 1303.64 | 1303.89 | 1303.14 | 1303.64 | 1614.0 |
| 2011-06-30 02:00:00 | ES | Futures | 1303.64 | 1304.14 | 1302.4 | 1302.89 | 4168.0 |
| 2011-06-30 02:30:00 | ES | Futures | 1302.65 | 1303.64 | 1302.4 | 1303.14 | 5719.0 |
| 2011-06-30 03:00:00 | ES | Futures | 1303.39 | 1305.39 | 1302.65 | 1304.64 | 19573.0 |
| 2011-06-30 03:30:00 | ES | Futures | 1304.64 | 1304.89 | 1302.65 | 1303.14 | 10963.0 |
| 2011-06-30 04:00:00 | ES | Futures | 1303.39 | 1304.14 | 1302.4 | 1303.39 | 9556.0 |
| 2011-06-30 04:30:00 | ES | Futures | 1303.39 | 1304.64 | 1302.89 | 1304.14 | 7291.0 |
| 2011-06-30 05:00:00 | ES | Futures | 1303.89 | 1304.64 | 1302.89 | 1303.64 | 4600.0 |
| 2011-06-30 05:30:00 | ES | Futures | 1303.64 | 1304.89 | 1302.65 | 1303.14 | 8029.0 |
| 2011-06-30 06:00:00 | ES | Futures | 1303.14 | 1303.64 | 1302.65 | 1302.89 | 5703.0 |
| 2011-06-30 06:30:00 | ES | Futures | 1302.89 | 1303.14 | 1302.15 | 1302.4 | 5758.0 |
| 2011-06-30 07:00:00 | ES | Futures | 1302.15 | 1304.39 | 1301.4 | 1304.14 | 13374.0 |
| 2011-06-30 07:30:00 | ES | Futures | 1304.14 | 1304.64 | 1302.89 | 1303.89 | 11140.0 |
| 2011-06-30 08:00:00 | ES | Futures | 1303.89 | 1304.39 | 1303.39 | 1303.89 | 12443.0 |
| 2011-06-30 08:30:00 | ES | Futures | 1303.64 | 1304.89 | 1302.65 | 1304.64 | 28295.0 |
| 2011-06-30 09:00:00 | ES | Futures | 1304.89 | 1305.39 | 1303.39 | 1303.64 | 28964.0 |
| 2011-06-30 09:30:00 | ES | Futures | 1303.89 | 1310.63 | 1302.4 | 1307.88 | 330048.0 |
| 2011-06-30 10:00:00 | ES | Futures | 1307.88 | 1312.37 | 1307.63 | 1311.12 | 200045.0 |
| 2011-06-30 10:30:00 | ES | Futures | 1311.12 | 1311.37 | 1308.63 | 1309.88 | 97888.0 |
| 2011-06-30 11:00:00 | ES | Futures | 1310.13 | 1312.87 | 1309.88 | 1311.87 | 105312.0 |
| 2011-06-30 11:30:00 | ES | Futures | 1311.62 | 1313.12 | 1311.37 | 1312.62 | 91576.0 |
| 2011-06-30 12:00:00 | ES | Futures | 1312.37 | 1313.62 | 1311.87 | 1312.37 | 62434.0 |
| 2011-06-30 12:30:00 | ES | Futures | 1312.37 | 1312.37 | 1310.88 | 1311.37 | 62710.0 |
| 2011-06-30 13:00:00 | ES | Futures | 1311.37 | 1312.37 | 1309.38 | 1310.38 | 61695.0 |
| 2011-06-30 13:30:00 | ES | Futures | 1310.13 | 1311.12 | 1309.38 | 1311.12 | 42287.0 |
| 2011-06-30 14:00:00 | ES | Futures | 1311.12 | 1311.62 | 1309.88 | 1310.38 | 31526.0 |
| 2011-06-30 14:30:00 | ES | Futures | 1310.13 | 1312.12 | 1309.63 | 1310.63 | 56099.0 |
| 2011-06-30 15:00:00 | ES | Futures | 1310.38 | 1311.62 | 1309.13 | 1311.37 | 77144.0 |
| 2011-06-30 15:30:00 | ES | Futures | 1311.37 | 1314.37 | 1311.12 | 1312.12 | 282281.0 |
| 2011-06-30 16:00:00 | ES | Futures | 1312.12 | 1312.87 | 1311.12 | 1311.62 | 140207.0 |
| 2011-06-30 16:30:00 | ES | Futures | 1311.62 | 1312.12 | 1310.38 | 1310.63 | 7563.0 |
| 2011-06-30 17:00:00 | ES | Futures | 1310.63 | 1313.12 | 1310.38 | 1312.12 | 7904.0 |
| 2011-06-30 18:00:00 | ES | Futures | 1312.12 | 1312.87 | 1311.87 | 1312.37 | 2182.0 |
| 2011-06-30 18:30:00 | ES | Futures | 1312.37 | 1312.87 | 1311.37 | 1312.62 | 1746.0 |
| 2011-06-30 19:00:00 | ES | Futures | 1312.37 | 1313.12 | 1312.12 | 1312.37 | 1517.0 |
| 2011-06-30 19:30:00 | ES | Futures | 1312.37 | 1312.37 | 1310.63 | 1310.63 | 2244.0 |
| 2011-06-30 20:00:00 | ES | Futures | 1310.63 | 1312.12 | 1310.63 | 1311.62 | 3295.0 |
| 2011-06-30 20:30:00 | ES | Futures | 1311.62 | 1311.87 | 1310.13 | 1310.38 | 3025.0 |
| 2011-06-30 21:00:00 | ES | Futures | 1310.38 | 1310.38 | 1309.38 | 1309.88 | 4296.0 |
| 2011-06-30 21:30:00 | ES | Futures | 1309.88 | 1310.13 | 1309.38 | 1309.38 | 1436.0 |
| 2011-06-30 22:00:00 | ES | Futures | 1309.38 | 1310.38 | 1309.38 | 1310.13 | 2079.0 |
| 2011-06-30 22:30:00 | ES | Futures | 1309.88 | 1310.38 | 1309.38 | 1310.38 | 1661.0 |
| 2011-06-30 23:00:00 | ES | Futures | 1310.38 | 1310.88 | 1310.13 | 1310.13 | 1323.0 |
| 2011-06-30 23:30:00 | ES | Futures | 1310.38 | 1310.63 | 1310.13 | 1310.63 | 390.0 |
| 2011-06-30 00:00:00 | NQ | Futures | 2643.7 | 2643.99 | 2641.4 | 2642.26 | 163.0 |
| 2011-06-30 00:30:00 | NQ | Futures | 2642.55 | 2644.56 | 2642.55 | 2643.12 | 271.0 |
| 2011-06-30 01:00:00 | NQ | Futures | 2643.41 | 2644.28 | 2642.55 | 2643.41 | 131.0 |
> showing 50 of 2,755 rows — these rows as CSV