PREVIEW / futures_30min / 2012-08-28
file: by_date/futures_30min/2012/2012-08-28.parquet size: 68 KB rows: 2,662
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-28 00:00:00 | ES | Futures | 1429.07 | 1429.84 | 1428.82 | 1429.58 | 839.0 |
| 2012-08-28 00:30:00 | ES | Futures | 1429.58 | 1429.84 | 1429.07 | 1429.33 | 1084.0 |
| 2012-08-28 01:00:00 | ES | Futures | 1429.33 | 1430.09 | 1429.33 | 1429.84 | 1223.0 |
| 2012-08-28 01:30:00 | ES | Futures | 1429.58 | 1432.63 | 1429.58 | 1432.38 | 5668.0 |
| 2012-08-28 02:00:00 | ES | Futures | 1432.63 | 1432.63 | 1431.11 | 1431.87 | 3625.0 |
| 2012-08-28 02:30:00 | ES | Futures | 1431.87 | 1432.63 | 1431.62 | 1432.12 | 1946.0 |
| 2012-08-28 03:00:00 | ES | Futures | 1432.38 | 1432.38 | 1430.09 | 1430.6 | 13739.0 |
| 2012-08-28 03:30:00 | ES | Futures | 1430.6 | 1434.16 | 1429.84 | 1433.9 | 13529.0 |
| 2012-08-28 04:00:00 | ES | Futures | 1433.65 | 1434.16 | 1431.36 | 1432.12 | 8229.0 |
| 2012-08-28 04:30:00 | ES | Futures | 1432.38 | 1433.65 | 1432.12 | 1433.14 | 9105.0 |
| 2012-08-28 05:00:00 | ES | Futures | 1433.14 | 1435.18 | 1433.14 | 1435.18 | 11461.0 |
| 2012-08-28 05:30:00 | ES | Futures | 1435.18 | 1435.18 | 1433.4 | 1433.4 | 8904.0 |
| 2012-08-28 06:00:00 | ES | Futures | 1433.4 | 1434.67 | 1433.4 | 1434.16 | 4713.0 |
| 2012-08-28 06:30:00 | ES | Futures | 1434.16 | 1434.16 | 1432.89 | 1433.14 | 3523.0 |
| 2012-08-28 07:00:00 | ES | Futures | 1433.14 | 1433.14 | 1431.87 | 1432.63 | 10208.0 |
| 2012-08-28 07:30:00 | ES | Futures | 1432.63 | 1432.89 | 1431.62 | 1431.62 | 9471.0 |
| 2012-08-28 08:00:00 | ES | Futures | 1431.87 | 1432.63 | 1430.09 | 1430.34 | 16956.0 |
| 2012-08-28 08:30:00 | ES | Futures | 1430.6 | 1430.6 | 1428.31 | 1428.82 | 22545.0 |
| 2012-08-28 09:00:00 | ES | Futures | 1429.07 | 1431.36 | 1428.31 | 1429.58 | 43335.0 |
| 2012-08-28 09:30:00 | ES | Futures | 1429.33 | 1433.4 | 1428.06 | 1428.56 | 157540.0 |
| 2012-08-28 10:00:00 | ES | Futures | 1428.31 | 1435.43 | 1427.29 | 1434.67 | 178461.0 |
| 2012-08-28 10:30:00 | ES | Futures | 1434.67 | 1436.19 | 1431.62 | 1432.38 | 118250.0 |
| 2012-08-28 11:00:00 | ES | Futures | 1432.12 | 1432.89 | 1430.6 | 1432.38 | 86696.0 |
| 2012-08-28 11:30:00 | ES | Futures | 1432.38 | 1433.9 | 1431.11 | 1433.9 | 70325.0 |
| 2012-08-28 12:00:00 | ES | Futures | 1433.65 | 1435.43 | 1433.65 | 1434.41 | 64973.0 |
| 2012-08-28 12:30:00 | ES | Futures | 1434.41 | 1435.18 | 1433.4 | 1434.92 | 24204.0 |
| 2012-08-28 13:00:00 | ES | Futures | 1434.92 | 1435.18 | 1432.38 | 1432.63 | 25558.0 |
| 2012-08-28 13:30:00 | ES | Futures | 1432.63 | 1433.65 | 1431.62 | 1432.12 | 18585.0 |
| 2012-08-28 14:00:00 | ES | Futures | 1432.12 | 1434.92 | 1432.12 | 1434.41 | 27540.0 |
| 2012-08-28 14:30:00 | ES | Futures | 1434.41 | 1435.18 | 1432.63 | 1433.4 | 25392.0 |
| 2012-08-28 15:00:00 | ES | Futures | 1433.4 | 1435.94 | 1432.38 | 1432.63 | 60297.0 |
| 2012-08-28 15:30:00 | ES | Futures | 1432.89 | 1433.65 | 1430.85 | 1431.87 | 83798.0 |
| 2012-08-28 16:00:00 | ES | Futures | 1431.87 | 1432.12 | 1431.11 | 1431.87 | 51215.0 |
| 2012-08-28 16:30:00 | ES | Futures | 1431.36 | 1431.87 | 1431.11 | 1431.36 | 4800.0 |
| 2012-08-28 17:00:00 | ES | Futures | 1431.62 | 1433.14 | 1431.36 | 1432.89 | 2735.0 |
| 2012-08-28 18:00:00 | ES | Futures | 1432.12 | 1433.65 | 1431.87 | 1433.4 | 2470.0 |
| 2012-08-28 18:30:00 | ES | Futures | 1433.4 | 1433.65 | 1433.14 | 1433.14 | 450.0 |
| 2012-08-28 19:00:00 | ES | Futures | 1433.4 | 1433.65 | 1432.89 | 1433.14 | 326.0 |
| 2012-08-28 19:30:00 | ES | Futures | 1433.14 | 1433.14 | 1432.89 | 1433.14 | 217.0 |
| 2012-08-28 20:00:00 | ES | Futures | 1433.14 | 1433.14 | 1432.38 | 1432.63 | 1287.0 |
| 2012-08-28 20:30:00 | ES | Futures | 1432.63 | 1433.4 | 1432.63 | 1432.63 | 1069.0 |
| 2012-08-28 21:00:00 | ES | Futures | 1432.89 | 1433.4 | 1432.38 | 1433.14 | 999.0 |
| 2012-08-28 21:30:00 | ES | Futures | 1433.14 | 1433.14 | 1431.62 | 1432.63 | 1297.0 |
| 2012-08-28 22:00:00 | ES | Futures | 1432.63 | 1433.4 | 1432.38 | 1433.14 | 833.0 |
| 2012-08-28 22:30:00 | ES | Futures | 1433.4 | 1433.4 | 1432.63 | 1433.14 | 748.0 |
| 2012-08-28 23:00:00 | ES | Futures | 1433.14 | 1433.14 | 1432.38 | 1432.38 | 728.0 |
| 2012-08-28 23:30:00 | ES | Futures | 1432.63 | 1433.14 | 1432.12 | 1433.14 | 897.0 |
| 2012-08-28 00:00:00 | NQ | Futures | 3220.04 | 3222.36 | 3220.04 | 3221.78 | 220.0 |
| 2012-08-28 00:30:00 | NQ | Futures | 3222.07 | 3222.07 | 3220.62 | 3220.91 | 250.0 |
| 2012-08-28 01:00:00 | NQ | Futures | 3221.2 | 3222.36 | 3220.62 | 3222.36 | 137.0 |
> showing 50 of 2,662 rows — these rows as CSV