PREVIEW / futures_1hour / 2015-11-24
file: by_date/futures_1hour/2015/2015-11-24.parquet size: 51 KB rows: 1,578
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-24 00:00:00 | ES | Futures | 2230.52 | 2231.05 | 2228.91 | 2228.91 | 2493.0 |
| 2015-11-24 01:00:00 | ES | Futures | 2228.91 | 2231.86 | 2228.91 | 2231.05 | 3543.0 |
| 2015-11-24 02:00:00 | ES | Futures | 2231.05 | 2234.0 | 2231.05 | 2231.86 | 7213.0 |
| 2015-11-24 03:00:00 | ES | Futures | 2231.86 | 2232.39 | 2212.59 | 2213.93 | 63072.0 |
| 2015-11-24 04:00:00 | ES | Futures | 2214.2 | 2224.1 | 2210.72 | 2222.76 | 36513.0 |
| 2015-11-24 05:00:00 | ES | Futures | 2222.76 | 2225.17 | 2219.01 | 2220.08 | 16657.0 |
| 2015-11-24 06:00:00 | ES | Futures | 2220.35 | 2223.56 | 2218.48 | 2220.08 | 21123.0 |
| 2015-11-24 07:00:00 | ES | Futures | 2220.08 | 2222.49 | 2213.66 | 2215.53 | 38951.0 |
| 2015-11-24 08:00:00 | ES | Futures | 2215.8 | 2217.94 | 2212.59 | 2215.8 | 46630.0 |
| 2015-11-24 09:00:00 | ES | Futures | 2216.07 | 2224.63 | 2215.8 | 2222.76 | 197301.0 |
| 2015-11-24 10:00:00 | ES | Futures | 2222.76 | 2224.36 | 2212.32 | 2215.0 | 229202.0 |
| 2015-11-24 11:00:00 | ES | Futures | 2215.0 | 2229.18 | 2213.66 | 2227.58 | 239425.0 |
| 2015-11-24 12:00:00 | ES | Futures | 2227.84 | 2231.05 | 2226.51 | 2228.11 | 130370.0 |
| 2015-11-24 13:00:00 | ES | Futures | 2228.38 | 2235.87 | 2228.38 | 2234.0 | 144093.0 |
| 2015-11-24 14:00:00 | ES | Futures | 2234.26 | 2238.01 | 2230.52 | 2235.6 | 108735.0 |
| 2015-11-24 15:00:00 | ES | Futures | 2235.6 | 2238.55 | 2231.59 | 2233.73 | 161944.0 |
| 2015-11-24 16:00:00 | ES | Futures | 2233.73 | 2234.0 | 2230.25 | 2230.52 | 44166.0 |
| 2015-11-24 18:00:00 | ES | Futures | 2230.52 | 2233.46 | 2230.52 | 2232.66 | 3475.0 |
| 2015-11-24 19:00:00 | ES | Futures | 2232.66 | 2233.19 | 2231.05 | 2231.05 | 3186.0 |
| 2015-11-24 20:00:00 | ES | Futures | 2231.05 | 2231.32 | 2228.65 | 2229.98 | 4702.0 |
| 2015-11-24 21:00:00 | ES | Futures | 2229.72 | 2230.52 | 2229.45 | 2229.72 | 1793.0 |
| 2015-11-24 22:00:00 | ES | Futures | 2229.72 | 2231.86 | 2229.18 | 2231.86 | 2272.0 |
| 2015-11-24 23:00:00 | ES | Futures | 2232.12 | 2233.19 | 2231.32 | 2232.39 | 2002.0 |
| 2015-11-24 00:00:00 | NQ | Futures | 5544.68 | 5547.05 | 5541.12 | 5541.71 | 421.0 |
| 2015-11-24 01:00:00 | NQ | Futures | 5541.71 | 5547.64 | 5541.71 | 5545.57 | 206.0 |
| 2015-11-24 02:00:00 | NQ | Futures | 5546.75 | 5555.65 | 5546.46 | 5550.61 | 1369.0 |
| 2015-11-24 03:00:00 | NQ | Futures | 5550.61 | 5551.2 | 5498.43 | 5501.98 | 8248.0 |
| 2015-11-24 04:00:00 | NQ | Futures | 5501.39 | 5526.89 | 5496.05 | 5521.85 | 5162.0 |
| 2015-11-24 05:00:00 | NQ | Futures | 5521.55 | 5527.78 | 5511.77 | 5513.84 | 2485.0 |
| 2015-11-24 06:00:00 | NQ | Futures | 5514.14 | 5526.3 | 5509.69 | 5517.99 | 3479.0 |
| 2015-11-24 07:00:00 | NQ | Futures | 5517.99 | 5522.44 | 5499.91 | 5505.54 | 5231.0 |
| 2015-11-24 08:00:00 | NQ | Futures | 5505.84 | 5511.47 | 5498.13 | 5505.25 | 8113.0 |
| 2015-11-24 09:00:00 | NQ | Futures | 5505.25 | 5525.7 | 5504.36 | 5522.44 | 31459.0 |
| 2015-11-24 10:00:00 | NQ | Futures | 5523.33 | 5527.19 | 5479.15 | 5490.72 | 42310.0 |
| 2015-11-24 11:00:00 | NQ | Futures | 5490.42 | 5529.56 | 5482.12 | 5526.0 | 36997.0 |
| 2015-11-24 12:00:00 | NQ | Futures | 5526.0 | 5536.67 | 5515.03 | 5522.74 | 20349.0 |
| 2015-11-24 13:00:00 | NQ | Futures | 5522.74 | 5544.68 | 5522.74 | 5540.23 | 18158.0 |
| 2015-11-24 14:00:00 | NQ | Futures | 5539.93 | 5551.5 | 5526.3 | 5540.82 | 15685.0 |
| 2015-11-24 15:00:00 | NQ | Futures | 5540.82 | 5547.05 | 5528.67 | 5539.05 | 22684.0 |
| 2015-11-24 16:00:00 | NQ | Futures | 5539.05 | 5539.05 | 5532.23 | 5532.52 | 3356.0 |
| 2015-11-24 18:00:00 | NQ | Futures | 5532.52 | 5539.05 | 5531.63 | 5538.16 | 482.0 |
| 2015-11-24 19:00:00 | NQ | Futures | 5537.86 | 5538.16 | 5532.23 | 5532.23 | 569.0 |
| 2015-11-24 20:00:00 | NQ | Futures | 5532.23 | 5532.23 | 5526.0 | 5530.15 | 760.0 |
| 2015-11-24 21:00:00 | NQ | Futures | 5530.15 | 5531.63 | 5529.26 | 5529.85 | 355.0 |
| 2015-11-24 22:00:00 | NQ | Futures | 5530.15 | 5534.89 | 5527.48 | 5534.6 | 647.0 |
| 2015-11-24 23:00:00 | NQ | Futures | 5535.19 | 5540.23 | 5533.41 | 5535.78 | 614.0 |
| 2015-11-24 00:00:00 | YM | Futures | 18815.5 | 18821.9 | 18807.0 | 18807.0 | 329.0 |
| 2015-11-24 01:00:00 | YM | Futures | 18807.0 | 18828.2 | 18807.0 | 18822.9 | 510.0 |
| 2015-11-24 02:00:00 | YM | Futures | 18824.0 | 18848.4 | 18821.9 | 18831.4 | 972.0 |
| 2015-11-24 03:00:00 | YM | Futures | 18830.3 | 18832.5 | 18677.8 | 18684.2 | 8268.0 |
> showing 50 of 1,578 rows — these rows as CSV