PREVIEW / futures_30min / 2012-10-07
file: by_date/futures_30min/2012/2012-10-07.parquet size: 19 KB rows: 482
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-10-07 18:00:00 | ES | Futures | 1489.1 | 1489.1 | 1486.03 | 1486.8 | 7545.0 |
| 2012-10-07 18:30:00 | ES | Futures | 1486.8 | 1487.31 | 1484.76 | 1485.52 | 2467.0 |
| 2012-10-07 19:00:00 | ES | Futures | 1485.52 | 1485.78 | 1484.76 | 1485.27 | 1613.0 |
| 2012-10-07 19:30:00 | ES | Futures | 1485.01 | 1486.8 | 1483.99 | 1486.03 | 2704.0 |
| 2012-10-07 20:00:00 | ES | Futures | 1486.03 | 1486.8 | 1485.78 | 1486.29 | 2268.0 |
| 2012-10-07 20:30:00 | ES | Futures | 1486.03 | 1486.54 | 1485.78 | 1486.54 | 788.0 |
| 2012-10-07 21:00:00 | ES | Futures | 1486.29 | 1486.54 | 1484.5 | 1484.76 | 2575.0 |
| 2012-10-07 21:30:00 | ES | Futures | 1484.76 | 1485.78 | 1484.5 | 1485.01 | 1567.0 |
| 2012-10-07 22:00:00 | ES | Futures | 1485.01 | 1485.27 | 1484.24 | 1484.76 | 1405.0 |
| 2012-10-07 22:30:00 | ES | Futures | 1484.76 | 1485.78 | 1484.24 | 1484.5 | 2422.0 |
| 2012-10-07 23:00:00 | ES | Futures | 1484.5 | 1485.01 | 1484.24 | 1484.5 | 1181.0 |
| 2012-10-07 23:30:00 | ES | Futures | 1484.76 | 1485.01 | 1484.24 | 1484.5 | 1095.0 |
| 2012-10-07 18:00:00 | NQ | Futures | 3261.72 | 3263.75 | 3258.23 | 3260.27 | 606.0 |
| 2012-10-07 18:30:00 | NQ | Futures | 3260.27 | 3261.14 | 3255.91 | 3258.23 | 409.0 |
| 2012-10-07 19:00:00 | NQ | Futures | 3258.23 | 3258.23 | 3255.62 | 3255.62 | 124.0 |
| 2012-10-07 19:30:00 | NQ | Futures | 3255.91 | 3257.65 | 3254.46 | 3256.49 | 307.0 |
| 2012-10-07 20:00:00 | NQ | Futures | 3256.49 | 3257.94 | 3255.91 | 3256.2 | 204.0 |
| 2012-10-07 20:30:00 | NQ | Futures | 3255.91 | 3257.07 | 3255.62 | 3257.07 | 205.0 |
| 2012-10-07 21:00:00 | NQ | Futures | 3256.78 | 3256.78 | 3252.13 | 3252.13 | 411.0 |
| 2012-10-07 21:30:00 | NQ | Futures | 3253.0 | 3255.33 | 3252.71 | 3253.29 | 308.0 |
| 2012-10-07 22:00:00 | NQ | Futures | 3253.58 | 3254.16 | 3252.13 | 3252.71 | 208.0 |
| 2012-10-07 22:30:00 | NQ | Futures | 3253.0 | 3254.75 | 3252.42 | 3253.29 | 188.0 |
| 2012-10-07 23:00:00 | NQ | Futures | 3253.29 | 3253.87 | 3252.42 | 3253.29 | 82.0 |
| 2012-10-07 23:30:00 | NQ | Futures | 3253.58 | 3254.16 | 3252.42 | 3252.42 | 143.0 |
| 2012-10-07 18:00:00 | YM | Futures | 13557.0 | 13557.0 | 13534.0 | 13541.0 | 873.0 |
| 2012-10-07 18:30:00 | YM | Futures | 13539.0 | 13543.0 | 13524.0 | 13533.0 | 279.0 |
| 2012-10-07 19:00:00 | YM | Futures | 13533.0 | 13533.0 | 13525.0 | 13528.0 | 116.0 |
| 2012-10-07 19:30:00 | YM | Futures | 13528.0 | 13537.0 | 13519.0 | 13534.0 | 275.0 |
| 2012-10-07 20:00:00 | YM | Futures | 13533.0 | 13539.0 | 13531.0 | 13535.0 | 209.0 |
| 2012-10-07 20:30:00 | YM | Futures | 13534.0 | 13538.0 | 13533.0 | 13538.0 | 75.0 |
| 2012-10-07 21:00:00 | YM | Futures | 13537.0 | 13537.0 | 13522.0 | 13522.0 | 178.0 |
| 2012-10-07 21:30:00 | YM | Futures | 13523.0 | 13532.0 | 13523.0 | 13526.0 | 166.0 |
| 2012-10-07 22:00:00 | YM | Futures | 13526.0 | 13528.0 | 13520.0 | 13521.0 | 185.0 |
| 2012-10-07 22:30:00 | YM | Futures | 13522.0 | 13528.0 | 13520.0 | 13520.0 | 342.0 |
| 2012-10-07 23:00:00 | YM | Futures | 13521.0 | 13523.0 | 13517.0 | 13521.0 | 149.0 |
| 2012-10-07 23:30:00 | YM | Futures | 13522.0 | 13522.0 | 13517.0 | 13519.0 | 98.0 |
| 2012-10-07 18:00:00 | CL | Futures | 146.56 | 146.61 | 146.18 | 146.22 | 499.0 |
| 2012-10-07 18:30:00 | CL | Futures | 146.2 | 146.36 | 146.15 | 146.35 | 229.0 |
| 2012-10-07 19:00:00 | CL | Futures | 146.28 | 146.32 | 146.17 | 146.25 | 135.0 |
| 2012-10-07 19:30:00 | CL | Futures | 146.27 | 146.33 | 146.18 | 146.27 | 205.0 |
| 2012-10-07 20:00:00 | CL | Futures | 146.3 | 146.32 | 146.01 | 146.04 | 530.0 |
| 2012-10-07 20:30:00 | CL | Futures | 146.02 | 146.32 | 146.01 | 146.14 | 345.0 |
| 2012-10-07 21:00:00 | CL | Futures | 146.14 | 146.14 | 145.66 | 145.81 | 615.0 |
| 2012-10-07 21:30:00 | CL | Futures | 145.81 | 146.1 | 145.79 | 145.86 | 718.0 |
| 2012-10-07 22:00:00 | CL | Futures | 145.83 | 145.89 | 145.58 | 145.79 | 605.0 |
| 2012-10-07 22:30:00 | CL | Futures | 145.81 | 146.05 | 145.79 | 145.94 | 526.0 |
| 2012-10-07 23:00:00 | CL | Futures | 145.92 | 146.01 | 145.84 | 145.91 | 241.0 |
| 2012-10-07 23:30:00 | CL | Futures | 145.89 | 145.96 | 145.83 | 145.92 | 202.0 |
| 2012-10-07 18:00:00 | GC | Futures | 2458.3 | 2459.0 | 2454.6 | 2455.3 | 1175.0 |
| 2012-10-07 18:30:00 | GC | Futures | 2455.3 | 2455.7 | 2454.5 | 2455.7 | 279.0 |
> showing 50 of 482 rows — these rows as CSV