PREVIEW / futures_30min / 2013-01-14
file: by_date/futures_30min/2013/2013-01-14.parquet size: 74 KB rows: 2,845
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-14 00:00:00 | ES | Futures | 1508.76 | 1509.01 | 1508.24 | 1508.5 | 896.0 |
| 2013-01-14 00:30:00 | ES | Futures | 1508.5 | 1508.76 | 1507.22 | 1507.47 | 2820.0 |
| 2013-01-14 01:00:00 | ES | Futures | 1507.47 | 1507.99 | 1506.45 | 1507.22 | 2115.0 |
| 2013-01-14 01:30:00 | ES | Futures | 1507.22 | 1507.99 | 1506.7 | 1507.47 | 838.0 |
| 2013-01-14 02:00:00 | ES | Futures | 1507.47 | 1508.76 | 1507.22 | 1508.5 | 2784.0 |
| 2013-01-14 02:30:00 | ES | Futures | 1508.76 | 1509.27 | 1507.22 | 1507.47 | 5986.0 |
| 2013-01-14 03:00:00 | ES | Futures | 1507.73 | 1508.24 | 1506.45 | 1506.96 | 9864.0 |
| 2013-01-14 03:30:00 | ES | Futures | 1506.96 | 1508.76 | 1506.7 | 1508.24 | 6839.0 |
| 2013-01-14 04:00:00 | ES | Futures | 1508.24 | 1508.76 | 1507.47 | 1508.5 | 6637.0 |
| 2013-01-14 04:30:00 | ES | Futures | 1508.5 | 1509.53 | 1508.24 | 1508.76 | 6776.0 |
| 2013-01-14 05:00:00 | ES | Futures | 1509.01 | 1509.53 | 1508.5 | 1508.76 | 4926.0 |
| 2013-01-14 05:30:00 | ES | Futures | 1508.76 | 1509.01 | 1506.7 | 1506.96 | 6901.0 |
| 2013-01-14 06:00:00 | ES | Futures | 1506.96 | 1507.73 | 1506.19 | 1506.19 | 19093.0 |
| 2013-01-14 06:30:00 | ES | Futures | 1506.19 | 1507.22 | 1506.19 | 1506.96 | 12423.0 |
| 2013-01-14 07:00:00 | ES | Futures | 1506.7 | 1507.22 | 1504.91 | 1505.16 | 10640.0 |
| 2013-01-14 07:30:00 | ES | Futures | 1504.91 | 1505.16 | 1503.62 | 1503.88 | 20979.0 |
| 2013-01-14 08:00:00 | ES | Futures | 1503.88 | 1505.16 | 1502.85 | 1504.91 | 20881.0 |
| 2013-01-14 08:30:00 | ES | Futures | 1504.65 | 1505.42 | 1504.65 | 1504.65 | 12120.0 |
| 2013-01-14 09:00:00 | ES | Futures | 1504.91 | 1504.91 | 1503.11 | 1503.88 | 21478.0 |
| 2013-01-14 09:30:00 | ES | Futures | 1503.88 | 1505.68 | 1500.29 | 1501.31 | 198247.0 |
| 2013-01-14 10:00:00 | ES | Futures | 1501.57 | 1501.83 | 1498.75 | 1500.03 | 125725.0 |
| 2013-01-14 10:30:00 | ES | Futures | 1500.03 | 1502.6 | 1499.77 | 1502.08 | 74664.0 |
| 2013-01-14 11:00:00 | ES | Futures | 1502.34 | 1503.37 | 1501.83 | 1502.6 | 56059.0 |
| 2013-01-14 11:30:00 | ES | Futures | 1502.34 | 1503.11 | 1500.8 | 1502.85 | 67376.0 |
| 2013-01-14 12:00:00 | ES | Futures | 1502.85 | 1503.37 | 1500.8 | 1501.06 | 56862.0 |
| 2013-01-14 12:30:00 | ES | Futures | 1501.06 | 1502.6 | 1501.06 | 1501.57 | 27021.0 |
| 2013-01-14 13:00:00 | ES | Futures | 1501.57 | 1503.37 | 1500.54 | 1502.6 | 36034.0 |
| 2013-01-14 13:30:00 | ES | Futures | 1502.85 | 1503.11 | 1501.31 | 1501.83 | 28001.0 |
| 2013-01-14 14:00:00 | ES | Futures | 1501.83 | 1504.39 | 1501.31 | 1503.88 | 55915.0 |
| 2013-01-14 14:30:00 | ES | Futures | 1503.88 | 1505.16 | 1503.11 | 1503.88 | 39130.0 |
| 2013-01-14 15:00:00 | ES | Futures | 1504.14 | 1505.68 | 1503.88 | 1503.88 | 38423.0 |
| 2013-01-14 15:30:00 | ES | Futures | 1504.14 | 1504.65 | 1501.57 | 1504.65 | 95588.0 |
| 2013-01-14 16:00:00 | ES | Futures | 1504.65 | 1505.42 | 1502.08 | 1502.34 | 58119.0 |
| 2013-01-14 16:30:00 | ES | Futures | 1502.6 | 1504.65 | 1502.34 | 1503.37 | 8772.0 |
| 2013-01-14 17:00:00 | ES | Futures | 1503.37 | 1503.62 | 1503.37 | 1503.62 | 884.0 |
| 2013-01-14 18:00:00 | ES | Futures | 1503.62 | 1504.14 | 1502.85 | 1503.88 | 2325.0 |
| 2013-01-14 18:30:00 | ES | Futures | 1503.88 | 1503.88 | 1503.11 | 1503.11 | 735.0 |
| 2013-01-14 19:00:00 | ES | Futures | 1503.11 | 1504.14 | 1502.6 | 1503.88 | 2402.0 |
| 2013-01-14 19:30:00 | ES | Futures | 1503.88 | 1503.88 | 1502.34 | 1502.6 | 1727.0 |
| 2013-01-14 20:00:00 | ES | Futures | 1502.85 | 1503.11 | 1501.57 | 1502.08 | 2801.0 |
| 2013-01-14 20:30:00 | ES | Futures | 1501.83 | 1503.88 | 1501.83 | 1502.85 | 3957.0 |
| 2013-01-14 21:00:00 | ES | Futures | 1503.11 | 1503.37 | 1502.34 | 1502.6 | 1548.0 |
| 2013-01-14 21:30:00 | ES | Futures | 1502.6 | 1502.85 | 1502.08 | 1502.34 | 2228.0 |
| 2013-01-14 22:00:00 | ES | Futures | 1502.34 | 1502.34 | 1501.06 | 1501.06 | 3727.0 |
| 2013-01-14 22:30:00 | ES | Futures | 1501.06 | 1501.31 | 1499.52 | 1499.77 | 5020.0 |
| 2013-01-14 23:00:00 | ES | Futures | 1499.52 | 1500.54 | 1499.52 | 1500.03 | 1411.0 |
| 2013-01-14 23:30:00 | ES | Futures | 1499.77 | 1500.54 | 1499.52 | 1500.54 | 1870.0 |
| 2013-01-14 00:00:00 | NQ | Futures | 3196.81 | 3197.39 | 3196.52 | 3197.39 | 156.0 |
| 2013-01-14 00:30:00 | NQ | Futures | 3197.1 | 3197.39 | 3194.48 | 3194.77 | 199.0 |
| 2013-01-14 01:00:00 | NQ | Futures | 3194.77 | 3195.65 | 3193.03 | 3195.07 | 181.0 |
> showing 50 of 2,845 rows — these rows as CSV