PREVIEW / futures_1hour / 2012-10-07
file: by_date/futures_1hour/2012/2012-10-07.parquet size: 14 KB rows: 259
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 | 1484.76 | 1485.52 | 10012.0 |
| 2012-10-07 19:00:00 | ES | Futures | 1485.52 | 1486.8 | 1483.99 | 1486.03 | 4317.0 |
| 2012-10-07 20:00:00 | ES | Futures | 1486.03 | 1486.8 | 1485.78 | 1486.54 | 3056.0 |
| 2012-10-07 21:00:00 | ES | Futures | 1486.29 | 1486.54 | 1484.5 | 1485.01 | 4142.0 |
| 2012-10-07 22:00:00 | ES | Futures | 1485.01 | 1485.78 | 1484.24 | 1484.5 | 3827.0 |
| 2012-10-07 23:00:00 | ES | Futures | 1484.5 | 1485.01 | 1484.24 | 1484.5 | 2276.0 |
| 2012-10-07 18:00:00 | NQ | Futures | 3261.72 | 3263.75 | 3255.91 | 3258.23 | 1015.0 |
| 2012-10-07 19:00:00 | NQ | Futures | 3258.23 | 3258.23 | 3254.46 | 3256.49 | 431.0 |
| 2012-10-07 20:00:00 | NQ | Futures | 3256.49 | 3257.94 | 3255.62 | 3257.07 | 409.0 |
| 2012-10-07 21:00:00 | NQ | Futures | 3256.78 | 3256.78 | 3252.13 | 3253.29 | 719.0 |
| 2012-10-07 22:00:00 | NQ | Futures | 3253.58 | 3254.75 | 3252.13 | 3253.29 | 396.0 |
| 2012-10-07 23:00:00 | NQ | Futures | 3253.29 | 3254.16 | 3252.42 | 3252.42 | 225.0 |
| 2012-10-07 18:00:00 | YM | Futures | 13557.0 | 13557.0 | 13524.0 | 13533.0 | 1152.0 |
| 2012-10-07 19:00:00 | YM | Futures | 13533.0 | 13537.0 | 13519.0 | 13534.0 | 391.0 |
| 2012-10-07 20:00:00 | YM | Futures | 13533.0 | 13539.0 | 13531.0 | 13538.0 | 284.0 |
| 2012-10-07 21:00:00 | YM | Futures | 13537.0 | 13537.0 | 13522.0 | 13526.0 | 344.0 |
| 2012-10-07 22:00:00 | YM | Futures | 13526.0 | 13528.0 | 13520.0 | 13520.0 | 527.0 |
| 2012-10-07 23:00:00 | YM | Futures | 13521.0 | 13523.0 | 13517.0 | 13519.0 | 247.0 |
| 2012-10-07 18:00:00 | CL | Futures | 146.56 | 146.61 | 146.15 | 146.35 | 728.0 |
| 2012-10-07 19:00:00 | CL | Futures | 146.28 | 146.33 | 146.17 | 146.27 | 340.0 |
| 2012-10-07 20:00:00 | CL | Futures | 146.3 | 146.32 | 146.01 | 146.14 | 875.0 |
| 2012-10-07 21:00:00 | CL | Futures | 146.14 | 146.14 | 145.66 | 145.86 | 1333.0 |
| 2012-10-07 22:00:00 | CL | Futures | 145.83 | 146.05 | 145.58 | 145.94 | 1131.0 |
| 2012-10-07 23:00:00 | CL | Futures | 145.92 | 146.01 | 145.83 | 145.92 | 443.0 |
| 2012-10-07 18:00:00 | GC | Futures | 2458.3 | 2459.0 | 2454.5 | 2455.7 | 1454.0 |
| 2012-10-07 19:00:00 | GC | Futures | 2455.3 | 2457.4 | 2453.6 | 2457.2 | 677.0 |
| 2012-10-07 20:00:00 | GC | Futures | 2456.7 | 2457.8 | 2454.5 | 2455.2 | 1223.0 |
| 2012-10-07 21:00:00 | GC | Futures | 2455.2 | 2455.3 | 2444.9 | 2445.2 | 6661.0 |
| 2012-10-07 22:00:00 | GC | Futures | 2445.2 | 2446.9 | 2439.3 | 2446.2 | 7088.0 |
| 2012-10-07 23:00:00 | GC | Futures | 2446.2 | 2447.6 | 2445.2 | 2447.0 | 1645.0 |
| 2012-10-07 18:00:00 | ZN | Futures | 117.910063 | 118.020972 | 117.910063 | 118.007109 | 3610.0 |
| 2012-10-07 19:00:00 | ZN | Futures | 118.007109 | 118.020972 | 117.993245 | 118.020972 | 1038.0 |
| 2012-10-07 20:00:00 | ZN | Futures | 118.007109 | 118.020972 | 117.993245 | 118.007109 | 1904.0 |
| 2012-10-07 21:00:00 | ZN | Futures | 118.007109 | 118.048699 | 118.007109 | 118.020972 | 3216.0 |
| 2012-10-07 22:00:00 | ZN | Futures | 118.034836 | 118.062563 | 118.020972 | 118.034836 | 3975.0 |
| 2012-10-07 23:00:00 | ZN | Futures | 118.034836 | 118.076427 | 118.034836 | 118.062563 | 1818.0 |
> showing 36 of 259 rows — these rows as CSV