PREVIEW / futures_30min / 2012-08-22
file: by_date/futures_30min/2012/2012-08-22.parquet size: 74 KB rows: 2,706
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-22 00:00:00 | ES | Futures | 1432.38 | 1432.89 | 1432.12 | 1432.38 | 1607.0 |
| 2012-08-22 00:30:00 | ES | Futures | 1432.38 | 1433.4 | 1432.38 | 1433.14 | 1122.0 |
| 2012-08-22 01:00:00 | ES | Futures | 1433.4 | 1433.4 | 1432.38 | 1432.63 | 1278.0 |
| 2012-08-22 01:30:00 | ES | Futures | 1432.89 | 1433.4 | 1432.38 | 1432.89 | 1427.0 |
| 2012-08-22 02:00:00 | ES | Futures | 1433.14 | 1433.9 | 1432.38 | 1432.89 | 3755.0 |
| 2012-08-22 02:30:00 | ES | Futures | 1433.14 | 1434.16 | 1432.63 | 1434.16 | 3084.0 |
| 2012-08-22 03:00:00 | ES | Futures | 1434.16 | 1434.16 | 1431.62 | 1432.89 | 17967.0 |
| 2012-08-22 03:30:00 | ES | Futures | 1432.63 | 1433.14 | 1431.62 | 1432.63 | 13763.0 |
| 2012-08-22 04:00:00 | ES | Futures | 1432.63 | 1434.16 | 1431.87 | 1433.65 | 12795.0 |
| 2012-08-22 04:30:00 | ES | Futures | 1433.4 | 1435.68 | 1433.4 | 1434.67 | 9946.0 |
| 2012-08-22 05:00:00 | ES | Futures | 1434.67 | 1434.92 | 1433.14 | 1433.9 | 7847.0 |
| 2012-08-22 05:30:00 | ES | Futures | 1433.9 | 1434.16 | 1432.89 | 1433.9 | 4881.0 |
| 2012-08-22 06:00:00 | ES | Futures | 1433.9 | 1434.67 | 1432.89 | 1434.67 | 5598.0 |
| 2012-08-22 06:30:00 | ES | Futures | 1434.41 | 1435.18 | 1432.12 | 1432.63 | 9888.0 |
| 2012-08-22 07:00:00 | ES | Futures | 1432.38 | 1432.63 | 1431.87 | 1432.12 | 11328.0 |
| 2012-08-22 07:30:00 | ES | Futures | 1431.87 | 1433.14 | 1431.87 | 1432.89 | 10450.0 |
| 2012-08-22 08:00:00 | ES | Futures | 1432.89 | 1433.9 | 1432.89 | 1433.65 | 10526.0 |
| 2012-08-22 08:30:00 | ES | Futures | 1433.65 | 1434.67 | 1431.11 | 1432.63 | 30016.0 |
| 2012-08-22 09:00:00 | ES | Futures | 1432.63 | 1433.4 | 1431.11 | 1431.87 | 24865.0 |
| 2012-08-22 09:30:00 | ES | Futures | 1431.87 | 1435.18 | 1430.09 | 1433.9 | 189648.0 |
| 2012-08-22 10:00:00 | ES | Futures | 1433.9 | 1434.92 | 1432.38 | 1434.67 | 115044.0 |
| 2012-08-22 10:30:00 | ES | Futures | 1434.67 | 1435.43 | 1430.85 | 1431.11 | 156414.0 |
| 2012-08-22 11:00:00 | ES | Futures | 1430.85 | 1432.89 | 1429.58 | 1430.6 | 143686.0 |
| 2012-08-22 11:30:00 | ES | Futures | 1430.85 | 1432.12 | 1429.58 | 1432.12 | 66421.0 |
| 2012-08-22 12:00:00 | ES | Futures | 1431.87 | 1432.38 | 1430.09 | 1431.11 | 37570.0 |
| 2012-08-22 12:30:00 | ES | Futures | 1430.85 | 1431.11 | 1428.31 | 1428.82 | 62839.0 |
| 2012-08-22 13:00:00 | ES | Futures | 1428.82 | 1431.11 | 1428.56 | 1430.6 | 28912.0 |
| 2012-08-22 13:30:00 | ES | Futures | 1430.85 | 1431.87 | 1429.58 | 1430.34 | 30637.0 |
| 2012-08-22 14:00:00 | ES | Futures | 1430.09 | 1435.68 | 1430.09 | 1432.63 | 193766.0 |
| 2012-08-22 14:30:00 | ES | Futures | 1432.63 | 1437.97 | 1431.87 | 1437.46 | 116449.0 |
| 2012-08-22 15:00:00 | ES | Futures | 1437.46 | 1438.48 | 1434.92 | 1435.94 | 88761.0 |
| 2012-08-22 15:30:00 | ES | Futures | 1435.94 | 1437.46 | 1434.92 | 1435.94 | 138208.0 |
| 2012-08-22 16:00:00 | ES | Futures | 1435.94 | 1437.21 | 1435.68 | 1436.7 | 61298.0 |
| 2012-08-22 16:30:00 | ES | Futures | 1436.45 | 1436.7 | 1435.43 | 1436.45 | 6024.0 |
| 2012-08-22 17:00:00 | ES | Futures | 1436.45 | 1436.96 | 1435.94 | 1436.19 | 2435.0 |
| 2012-08-22 18:00:00 | ES | Futures | 1436.19 | 1436.7 | 1435.43 | 1436.7 | 1622.0 |
| 2012-08-22 18:30:00 | ES | Futures | 1436.7 | 1436.7 | 1435.68 | 1436.45 | 1860.0 |
| 2012-08-22 19:00:00 | ES | Futures | 1436.45 | 1436.96 | 1435.68 | 1436.19 | 941.0 |
| 2012-08-22 19:30:00 | ES | Futures | 1435.94 | 1437.46 | 1435.94 | 1437.21 | 1280.0 |
| 2012-08-22 20:00:00 | ES | Futures | 1437.21 | 1437.46 | 1435.94 | 1436.45 | 2542.0 |
| 2012-08-22 20:30:00 | ES | Futures | 1436.45 | 1438.74 | 1436.45 | 1438.48 | 5132.0 |
| 2012-08-22 21:00:00 | ES | Futures | 1438.48 | 1441.02 | 1438.23 | 1440.77 | 7858.0 |
| 2012-08-22 21:30:00 | ES | Futures | 1440.77 | 1441.53 | 1440.52 | 1441.28 | 5710.0 |
| 2012-08-22 22:00:00 | ES | Futures | 1441.28 | 1441.53 | 1440.26 | 1440.26 | 3538.0 |
| 2012-08-22 22:30:00 | ES | Futures | 1440.26 | 1440.26 | 1438.74 | 1440.01 | 9518.0 |
| 2012-08-22 23:00:00 | ES | Futures | 1440.01 | 1441.79 | 1439.75 | 1441.28 | 2565.0 |
| 2012-08-22 23:30:00 | ES | Futures | 1441.28 | 1441.79 | 1440.77 | 1441.53 | 2923.0 |
| 2012-08-22 00:00:00 | NQ | Futures | 3209.32 | 3210.77 | 3209.32 | 3209.9 | 271.0 |
| 2012-08-22 00:30:00 | NQ | Futures | 3210.19 | 3211.93 | 3209.9 | 3211.93 | 138.0 |
| 2012-08-22 01:00:00 | NQ | Futures | 3211.64 | 3211.64 | 3209.9 | 3210.77 | 126.0 |
> showing 50 of 2,706 rows — these rows as CSV