PREVIEW / futures_30min / 2012-09-11
file: by_date/futures_30min/2012/2012-09-11.parquet size: 67 KB rows: 2,519
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-09-11 00:00:00 | ES | Futures | 1446.87 | 1447.64 | 1446.62 | 1446.62 | 2713.0 |
| 2012-09-11 00:30:00 | ES | Futures | 1446.87 | 1446.87 | 1446.11 | 1446.36 | 1331.0 |
| 2012-09-11 01:00:00 | ES | Futures | 1446.62 | 1446.87 | 1446.11 | 1446.87 | 2388.0 |
| 2012-09-11 01:30:00 | ES | Futures | 1446.87 | 1448.4 | 1446.62 | 1448.14 | 3553.0 |
| 2012-09-11 02:00:00 | ES | Futures | 1448.4 | 1449.16 | 1448.14 | 1448.65 | 6648.0 |
| 2012-09-11 02:30:00 | ES | Futures | 1448.91 | 1453.74 | 1448.65 | 1453.23 | 19537.0 |
| 2012-09-11 03:00:00 | ES | Futures | 1453.23 | 1455.77 | 1452.98 | 1455.26 | 30828.0 |
| 2012-09-11 03:30:00 | ES | Futures | 1455.26 | 1455.77 | 1452.98 | 1453.99 | 15938.0 |
| 2012-09-11 04:00:00 | ES | Futures | 1453.99 | 1454.5 | 1452.47 | 1453.48 | 9712.0 |
| 2012-09-11 04:30:00 | ES | Futures | 1453.48 | 1455.01 | 1452.47 | 1453.99 | 11057.0 |
| 2012-09-11 05:00:00 | ES | Futures | 1453.99 | 1455.26 | 1452.72 | 1454.5 | 9520.0 |
| 2012-09-11 05:30:00 | ES | Futures | 1454.76 | 1454.76 | 1453.23 | 1454.5 | 10390.0 |
| 2012-09-11 06:00:00 | ES | Futures | 1454.25 | 1454.5 | 1452.72 | 1452.72 | 6895.0 |
| 2012-09-11 06:30:00 | ES | Futures | 1452.72 | 1454.76 | 1452.47 | 1454.25 | 11416.0 |
| 2012-09-11 07:00:00 | ES | Futures | 1454.5 | 1456.79 | 1454.25 | 1456.54 | 19154.0 |
| 2012-09-11 07:30:00 | ES | Futures | 1456.28 | 1456.79 | 1455.26 | 1455.26 | 15171.0 |
| 2012-09-11 08:00:00 | ES | Futures | 1455.26 | 1457.04 | 1455.01 | 1455.52 | 18234.0 |
| 2012-09-11 08:30:00 | ES | Futures | 1455.52 | 1456.28 | 1453.74 | 1455.01 | 35452.0 |
| 2012-09-11 09:00:00 | ES | Futures | 1455.01 | 1457.04 | 1453.99 | 1453.99 | 36053.0 |
| 2012-09-11 09:30:00 | ES | Futures | 1453.99 | 1459.08 | 1453.48 | 1458.06 | 163622.0 |
| 2012-09-11 10:00:00 | ES | Futures | 1458.32 | 1458.82 | 1457.04 | 1457.55 | 81711.0 |
| 2012-09-11 10:30:00 | ES | Futures | 1457.81 | 1459.84 | 1457.3 | 1459.33 | 97630.0 |
| 2012-09-11 11:00:00 | ES | Futures | 1459.33 | 1462.13 | 1459.08 | 1461.88 | 94830.0 |
| 2012-09-11 11:30:00 | ES | Futures | 1461.62 | 1462.13 | 1459.08 | 1459.59 | 58819.0 |
| 2012-09-11 12:00:00 | ES | Futures | 1459.84 | 1460.1 | 1458.06 | 1459.59 | 43526.0 |
| 2012-09-11 12:30:00 | ES | Futures | 1459.33 | 1459.84 | 1458.06 | 1459.33 | 31911.0 |
| 2012-09-11 13:00:00 | ES | Futures | 1459.33 | 1460.35 | 1458.32 | 1459.59 | 47414.0 |
| 2012-09-11 13:30:00 | ES | Futures | 1459.84 | 1461.11 | 1459.33 | 1459.84 | 37737.0 |
| 2012-09-11 14:00:00 | ES | Futures | 1459.84 | 1460.35 | 1458.57 | 1459.84 | 36112.0 |
| 2012-09-11 14:30:00 | ES | Futures | 1459.84 | 1460.35 | 1456.79 | 1457.81 | 47594.0 |
| 2012-09-11 15:00:00 | ES | Futures | 1457.55 | 1458.32 | 1456.03 | 1456.54 | 53167.0 |
| 2012-09-11 15:30:00 | ES | Futures | 1456.54 | 1458.57 | 1456.03 | 1456.79 | 82922.0 |
| 2012-09-11 16:00:00 | ES | Futures | 1456.79 | 1457.3 | 1454.76 | 1455.01 | 60993.0 |
| 2012-09-11 16:30:00 | ES | Futures | 1455.01 | 1455.26 | 1454.25 | 1454.76 | 4832.0 |
| 2012-09-11 17:00:00 | ES | Futures | 1454.5 | 1454.76 | 1453.99 | 1454.25 | 2626.0 |
| 2012-09-11 18:00:00 | ES | Futures | 1454.5 | 1454.76 | 1452.98 | 1453.23 | 3680.0 |
| 2012-09-11 18:30:00 | ES | Futures | 1453.48 | 1453.48 | 1453.23 | 1453.48 | 540.0 |
| 2012-09-11 19:00:00 | ES | Futures | 1453.48 | 1453.99 | 1452.98 | 1453.74 | 1103.0 |
| 2012-09-11 19:30:00 | ES | Futures | 1453.74 | 1454.5 | 1453.48 | 1454.25 | 1251.0 |
| 2012-09-11 20:00:00 | ES | Futures | 1454.25 | 1454.5 | 1453.48 | 1454.5 | 2000.0 |
| 2012-09-11 20:30:00 | ES | Futures | 1454.5 | 1457.04 | 1454.25 | 1455.77 | 5141.0 |
| 2012-09-11 21:00:00 | ES | Futures | 1455.77 | 1457.55 | 1455.52 | 1456.79 | 4083.0 |
| 2012-09-11 21:30:00 | ES | Futures | 1457.04 | 1457.55 | 1456.54 | 1456.54 | 2384.0 |
| 2012-09-11 22:00:00 | ES | Futures | 1456.79 | 1458.32 | 1456.54 | 1458.06 | 2495.0 |
| 2012-09-11 22:30:00 | ES | Futures | 1458.06 | 1458.32 | 1457.3 | 1457.55 | 1424.0 |
| 2012-09-11 23:00:00 | ES | Futures | 1457.55 | 1457.81 | 1456.54 | 1456.54 | 1442.0 |
| 2012-09-11 23:30:00 | ES | Futures | 1456.79 | 1457.55 | 1456.54 | 1456.79 | 1826.0 |
| 2012-09-11 00:00:00 | NQ | Futures | 3222.94 | 3223.81 | 3222.36 | 3222.36 | 302.0 |
| 2012-09-11 00:30:00 | NQ | Futures | 3222.36 | 3222.65 | 3221.2 | 3222.07 | 84.0 |
| 2012-09-11 01:00:00 | NQ | Futures | 3222.07 | 3223.52 | 3221.78 | 3223.23 | 173.0 |
> showing 50 of 2,519 rows — these rows as CSV