PREVIEW / futures_30min / 2013-01-03
file: by_date/futures_30min/2013/2013-01-03.parquet size: 79 KB rows: 2,908
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-03 00:00:00 | ES | Futures | 1491.31 | 1491.31 | 1491.05 | 1491.31 | 1134.0 |
| 2013-01-03 00:30:00 | ES | Futures | 1491.05 | 1491.31 | 1490.54 | 1490.54 | 1101.0 |
| 2013-01-03 01:00:00 | ES | Futures | 1490.54 | 1491.31 | 1490.54 | 1491.05 | 1144.0 |
| 2013-01-03 01:30:00 | ES | Futures | 1491.05 | 1491.82 | 1490.79 | 1491.31 | 2016.0 |
| 2013-01-03 02:00:00 | ES | Futures | 1491.31 | 1491.56 | 1490.79 | 1490.79 | 2764.0 |
| 2013-01-03 02:30:00 | ES | Futures | 1491.05 | 1491.31 | 1490.54 | 1491.05 | 3569.0 |
| 2013-01-03 03:00:00 | ES | Futures | 1491.05 | 1493.1 | 1490.79 | 1491.56 | 13550.0 |
| 2013-01-03 03:30:00 | ES | Futures | 1491.31 | 1492.85 | 1491.31 | 1492.33 | 4100.0 |
| 2013-01-03 04:00:00 | ES | Futures | 1492.59 | 1493.1 | 1491.56 | 1491.56 | 5986.0 |
| 2013-01-03 04:30:00 | ES | Futures | 1491.56 | 1492.59 | 1491.05 | 1492.08 | 5610.0 |
| 2013-01-03 05:00:00 | ES | Futures | 1492.08 | 1492.59 | 1491.05 | 1492.08 | 7375.0 |
| 2013-01-03 05:30:00 | ES | Futures | 1492.08 | 1492.59 | 1491.56 | 1491.56 | 6342.0 |
| 2013-01-03 06:00:00 | ES | Futures | 1491.56 | 1492.08 | 1491.31 | 1491.82 | 5388.0 |
| 2013-01-03 06:30:00 | ES | Futures | 1491.82 | 1492.08 | 1490.79 | 1490.79 | 5171.0 |
| 2013-01-03 07:00:00 | ES | Futures | 1491.05 | 1491.56 | 1490.54 | 1491.31 | 8834.0 |
| 2013-01-03 07:30:00 | ES | Futures | 1491.31 | 1491.56 | 1490.79 | 1491.31 | 6291.0 |
| 2013-01-03 08:00:00 | ES | Futures | 1491.31 | 1495.41 | 1490.54 | 1495.16 | 38530.0 |
| 2013-01-03 08:30:00 | ES | Futures | 1495.16 | 1495.41 | 1492.59 | 1494.39 | 30434.0 |
| 2013-01-03 09:00:00 | ES | Futures | 1494.13 | 1495.16 | 1493.62 | 1495.16 | 16875.0 |
| 2013-01-03 09:30:00 | ES | Futures | 1494.9 | 1495.16 | 1491.05 | 1492.85 | 153052.0 |
| 2013-01-03 10:00:00 | ES | Futures | 1493.1 | 1495.16 | 1492.85 | 1494.39 | 94920.0 |
| 2013-01-03 10:30:00 | ES | Futures | 1494.39 | 1495.93 | 1493.36 | 1494.39 | 97011.0 |
| 2013-01-03 11:00:00 | ES | Futures | 1494.13 | 1497.47 | 1493.87 | 1496.44 | 117004.0 |
| 2013-01-03 11:30:00 | ES | Futures | 1496.7 | 1498.24 | 1496.44 | 1496.95 | 61495.0 |
| 2013-01-03 12:00:00 | ES | Futures | 1496.95 | 1498.49 | 1496.7 | 1497.72 | 47378.0 |
| 2013-01-03 12:30:00 | ES | Futures | 1497.72 | 1497.98 | 1495.93 | 1497.47 | 50102.0 |
| 2013-01-03 13:00:00 | ES | Futures | 1497.21 | 1498.24 | 1496.18 | 1498.24 | 34241.0 |
| 2013-01-03 13:30:00 | ES | Futures | 1497.98 | 1499.01 | 1497.72 | 1498.49 | 40378.0 |
| 2013-01-03 14:00:00 | ES | Futures | 1498.49 | 1498.49 | 1492.33 | 1493.36 | 163181.0 |
| 2013-01-03 14:30:00 | ES | Futures | 1493.36 | 1494.64 | 1491.31 | 1493.87 | 93629.0 |
| 2013-01-03 15:00:00 | ES | Futures | 1493.62 | 1494.39 | 1489.51 | 1490.79 | 111823.0 |
| 2013-01-03 15:30:00 | ES | Futures | 1490.54 | 1493.1 | 1488.23 | 1492.85 | 234746.0 |
| 2013-01-03 16:00:00 | ES | Futures | 1492.59 | 1492.85 | 1490.02 | 1491.56 | 94221.0 |
| 2013-01-03 16:30:00 | ES | Futures | 1491.56 | 1493.1 | 1491.56 | 1492.59 | 7102.0 |
| 2013-01-03 17:00:00 | ES | Futures | 1492.59 | 1493.36 | 1492.33 | 1492.59 | 1596.0 |
| 2013-01-03 18:00:00 | ES | Futures | 1492.33 | 1492.85 | 1492.08 | 1492.33 | 2545.0 |
| 2013-01-03 18:30:00 | ES | Futures | 1492.33 | 1492.33 | 1491.05 | 1491.31 | 2439.0 |
| 2013-01-03 19:00:00 | ES | Futures | 1491.31 | 1491.82 | 1491.05 | 1491.56 | 4237.0 |
| 2013-01-03 19:30:00 | ES | Futures | 1491.56 | 1493.87 | 1491.56 | 1492.59 | 6056.0 |
| 2013-01-03 20:00:00 | ES | Futures | 1492.59 | 1493.1 | 1491.56 | 1492.08 | 4049.0 |
| 2013-01-03 20:30:00 | ES | Futures | 1492.08 | 1493.1 | 1491.56 | 1492.59 | 4327.0 |
| 2013-01-03 21:00:00 | ES | Futures | 1492.59 | 1492.85 | 1491.31 | 1491.56 | 3279.0 |
| 2013-01-03 21:30:00 | ES | Futures | 1491.82 | 1491.82 | 1491.31 | 1491.31 | 1041.0 |
| 2013-01-03 22:00:00 | ES | Futures | 1491.31 | 1491.56 | 1490.28 | 1490.79 | 3192.0 |
| 2013-01-03 22:30:00 | ES | Futures | 1491.05 | 1491.05 | 1490.28 | 1490.79 | 1694.0 |
| 2013-01-03 23:00:00 | ES | Futures | 1490.54 | 1490.79 | 1490.02 | 1490.28 | 1741.0 |
| 2013-01-03 23:30:00 | ES | Futures | 1490.54 | 1490.54 | 1489.77 | 1490.02 | 2036.0 |
| 2013-01-03 00:00:00 | NQ | Futures | 3183.42 | 3183.42 | 3182.55 | 3183.13 | 148.0 |
| 2013-01-03 00:30:00 | NQ | Futures | 3183.13 | 3183.42 | 3181.39 | 3181.39 | 155.0 |
| 2013-01-03 01:00:00 | NQ | Futures | 3181.39 | 3182.26 | 3180.51 | 3181.39 | 323.0 |
> showing 50 of 2,908 rows — these rows as CSV