PREVIEW / futures_30min / 2013-01-30
file: by_date/futures_30min/2013/2013-01-30.parquet size: 80 KB rows: 2,973
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-30 00:00:00 | ES | Futures | 1543.65 | 1543.91 | 1543.14 | 1543.14 | 1504.0 |
| 2013-01-30 00:30:00 | ES | Futures | 1543.14 | 1543.65 | 1543.14 | 1543.65 | 875.0 |
| 2013-01-30 01:00:00 | ES | Futures | 1543.65 | 1543.91 | 1543.14 | 1543.65 | 1083.0 |
| 2013-01-30 01:30:00 | ES | Futures | 1543.65 | 1543.91 | 1542.37 | 1542.37 | 2110.0 |
| 2013-01-30 02:00:00 | ES | Futures | 1542.37 | 1544.93 | 1542.37 | 1544.68 | 7111.0 |
| 2013-01-30 02:30:00 | ES | Futures | 1544.93 | 1545.45 | 1544.17 | 1544.93 | 6135.0 |
| 2013-01-30 03:00:00 | ES | Futures | 1544.93 | 1545.19 | 1543.91 | 1544.68 | 14213.0 |
| 2013-01-30 03:30:00 | ES | Futures | 1544.93 | 1545.7 | 1544.42 | 1545.19 | 10718.0 |
| 2013-01-30 04:00:00 | ES | Futures | 1545.19 | 1545.7 | 1544.17 | 1545.7 | 9128.0 |
| 2013-01-30 04:30:00 | ES | Futures | 1545.7 | 1545.7 | 1544.93 | 1545.19 | 5806.0 |
| 2013-01-30 05:00:00 | ES | Futures | 1545.19 | 1545.45 | 1543.91 | 1544.68 | 11350.0 |
| 2013-01-30 05:30:00 | ES | Futures | 1544.93 | 1545.45 | 1544.17 | 1545.45 | 8268.0 |
| 2013-01-30 06:00:00 | ES | Futures | 1545.19 | 1545.7 | 1543.91 | 1544.42 | 7191.0 |
| 2013-01-30 06:30:00 | ES | Futures | 1544.17 | 1545.19 | 1544.17 | 1545.19 | 7900.0 |
| 2013-01-30 07:00:00 | ES | Futures | 1545.19 | 1545.19 | 1543.91 | 1544.17 | 13501.0 |
| 2013-01-30 07:30:00 | ES | Futures | 1544.17 | 1544.68 | 1542.88 | 1543.14 | 17900.0 |
| 2013-01-30 08:00:00 | ES | Futures | 1542.88 | 1544.68 | 1541.09 | 1541.6 | 45541.0 |
| 2013-01-30 08:30:00 | ES | Futures | 1541.6 | 1542.63 | 1538.01 | 1541.09 | 90392.0 |
| 2013-01-30 09:00:00 | ES | Futures | 1541.09 | 1542.37 | 1540.83 | 1542.37 | 31219.0 |
| 2013-01-30 09:30:00 | ES | Futures | 1542.37 | 1545.19 | 1540.57 | 1542.37 | 176111.0 |
| 2013-01-30 10:00:00 | ES | Futures | 1542.37 | 1542.63 | 1538.78 | 1539.8 | 158970.0 |
| 2013-01-30 10:30:00 | ES | Futures | 1539.8 | 1540.57 | 1538.26 | 1540.06 | 122014.0 |
| 2013-01-30 11:00:00 | ES | Futures | 1540.32 | 1542.11 | 1540.06 | 1541.09 | 76829.0 |
| 2013-01-30 11:30:00 | ES | Futures | 1540.83 | 1542.63 | 1540.83 | 1541.6 | 79336.0 |
| 2013-01-30 12:00:00 | ES | Futures | 1541.86 | 1542.37 | 1539.55 | 1540.06 | 91671.0 |
| 2013-01-30 12:30:00 | ES | Futures | 1540.06 | 1543.14 | 1539.29 | 1542.88 | 58177.0 |
| 2013-01-30 13:00:00 | ES | Futures | 1542.88 | 1543.14 | 1541.6 | 1542.88 | 31076.0 |
| 2013-01-30 13:30:00 | ES | Futures | 1542.88 | 1543.14 | 1541.09 | 1541.6 | 31110.0 |
| 2013-01-30 14:00:00 | ES | Futures | 1541.6 | 1542.88 | 1538.78 | 1540.57 | 92592.0 |
| 2013-01-30 14:30:00 | ES | Futures | 1540.83 | 1541.6 | 1537.49 | 1539.55 | 99019.0 |
| 2013-01-30 15:00:00 | ES | Futures | 1539.8 | 1540.32 | 1536.21 | 1537.24 | 149272.0 |
| 2013-01-30 15:30:00 | ES | Futures | 1536.98 | 1537.49 | 1534.67 | 1536.72 | 216173.0 |
| 2013-01-30 16:00:00 | ES | Futures | 1536.72 | 1536.98 | 1534.41 | 1535.18 | 89377.0 |
| 2013-01-30 16:30:00 | ES | Futures | 1534.93 | 1535.44 | 1533.64 | 1533.9 | 10613.0 |
| 2013-01-30 17:00:00 | ES | Futures | 1533.64 | 1534.16 | 1532.88 | 1533.13 | 3337.0 |
| 2013-01-30 18:00:00 | ES | Futures | 1533.64 | 1535.18 | 1533.64 | 1534.41 | 5486.0 |
| 2013-01-30 18:30:00 | ES | Futures | 1534.67 | 1534.93 | 1533.9 | 1533.9 | 2289.0 |
| 2013-01-30 19:00:00 | ES | Futures | 1534.16 | 1535.7 | 1533.9 | 1535.44 | 3664.0 |
| 2013-01-30 19:30:00 | ES | Futures | 1535.44 | 1535.44 | 1534.41 | 1534.93 | 1536.0 |
| 2013-01-30 20:00:00 | ES | Futures | 1534.93 | 1535.7 | 1534.41 | 1534.67 | 2300.0 |
| 2013-01-30 20:30:00 | ES | Futures | 1534.67 | 1535.18 | 1533.39 | 1533.64 | 3302.0 |
| 2013-01-30 21:00:00 | ES | Futures | 1533.9 | 1534.16 | 1533.39 | 1533.64 | 1166.0 |
| 2013-01-30 21:30:00 | ES | Futures | 1533.64 | 1533.9 | 1532.88 | 1532.88 | 2028.0 |
| 2013-01-30 22:00:00 | ES | Futures | 1532.88 | 1534.16 | 1532.88 | 1534.16 | 1487.0 |
| 2013-01-30 22:30:00 | ES | Futures | 1534.16 | 1534.41 | 1533.39 | 1533.64 | 2379.0 |
| 2013-01-30 23:00:00 | ES | Futures | 1533.64 | 1533.9 | 1533.39 | 1533.64 | 432.0 |
| 2013-01-30 23:30:00 | ES | Futures | 1533.64 | 1533.64 | 1533.13 | 1533.39 | 1990.0 |
| 2013-01-30 00:00:00 | NQ | Futures | 3194.77 | 3195.36 | 3193.9 | 3194.48 | 100.0 |
| 2013-01-30 00:30:00 | NQ | Futures | 3194.19 | 3195.65 | 3193.9 | 3195.65 | 206.0 |
| 2013-01-30 01:00:00 | NQ | Futures | 3195.36 | 3195.36 | 3193.32 | 3193.32 | 395.0 |
> showing 50 of 2,973 rows — these rows as CSV