PREVIEW / futures_1hour / 2015-07-17
file: by_date/futures_1hour/2015/2015-07-17.parquet size: 41 KB rows: 1,255
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-07-17 00:00:00 | ES | Futures | 2253.26 | 2253.53 | 2252.46 | 2253.26 | 2297.0 |
| 2015-07-17 01:00:00 | ES | Futures | 2253.53 | 2254.32 | 2252.99 | 2254.32 | 2153.0 |
| 2015-07-17 02:00:00 | ES | Futures | 2254.32 | 2255.66 | 2253.79 | 2255.12 | 3728.0 |
| 2015-07-17 03:00:00 | ES | Futures | 2255.39 | 2255.66 | 2252.99 | 2253.79 | 12016.0 |
| 2015-07-17 04:00:00 | ES | Futures | 2253.53 | 2254.06 | 2252.46 | 2253.26 | 8359.0 |
| 2015-07-17 05:00:00 | ES | Futures | 2252.99 | 2254.06 | 2252.46 | 2253.53 | 8607.0 |
| 2015-07-17 06:00:00 | ES | Futures | 2253.79 | 2254.86 | 2253.26 | 2254.06 | 7807.0 |
| 2015-07-17 07:00:00 | ES | Futures | 2254.32 | 2255.66 | 2253.79 | 2255.39 | 16105.0 |
| 2015-07-17 08:00:00 | ES | Futures | 2255.39 | 2256.99 | 2255.12 | 2255.39 | 20703.0 |
| 2015-07-17 09:00:00 | ES | Futures | 2255.39 | 2256.99 | 2250.86 | 2252.99 | 166747.0 |
| 2015-07-17 10:00:00 | ES | Futures | 2252.73 | 2254.32 | 2250.06 | 2252.73 | 153212.0 |
| 2015-07-17 11:00:00 | ES | Futures | 2252.99 | 2254.32 | 2251.93 | 2252.46 | 81744.0 |
| 2015-07-17 12:00:00 | ES | Futures | 2252.46 | 2253.26 | 2250.6 | 2252.73 | 66811.0 |
| 2015-07-17 13:00:00 | ES | Futures | 2252.73 | 2253.26 | 2251.4 | 2252.19 | 47178.0 |
| 2015-07-17 14:00:00 | ES | Futures | 2251.93 | 2255.66 | 2251.93 | 2254.86 | 89954.0 |
| 2015-07-17 15:00:00 | ES | Futures | 2254.86 | 2257.79 | 2253.79 | 2256.72 | 127340.0 |
| 2015-07-17 16:00:00 | ES | Futures | 2256.72 | 2257.52 | 2255.92 | 2256.72 | 58656.0 |
| 2015-07-17 17:00:00 | ES | Futures | 2256.99 | 2257.52 | 2256.45 | 2257.52 | 1023.0 |
| 2015-07-17 00:00:00 | NQ | Futures | 5453.17 | 5454.95 | 5451.69 | 5454.36 | 322.0 |
| 2015-07-17 01:00:00 | NQ | Futures | 5454.36 | 5455.84 | 5451.99 | 5455.54 | 588.0 |
| 2015-07-17 02:00:00 | NQ | Futures | 5455.84 | 5460.86 | 5453.17 | 5458.5 | 920.0 |
| 2015-07-17 03:00:00 | NQ | Futures | 5458.79 | 5459.09 | 5451.4 | 5454.06 | 1731.0 |
| 2015-07-17 04:00:00 | NQ | Futures | 5454.06 | 5455.24 | 5451.1 | 5454.36 | 1415.0 |
| 2015-07-17 05:00:00 | NQ | Futures | 5453.77 | 5458.79 | 5453.77 | 5455.24 | 1942.0 |
| 2015-07-17 06:00:00 | NQ | Futures | 5454.95 | 5456.72 | 5453.77 | 5454.95 | 1074.0 |
| 2015-07-17 07:00:00 | NQ | Futures | 5454.65 | 5460.86 | 5454.65 | 5459.39 | 4310.0 |
| 2015-07-17 08:00:00 | NQ | Futures | 5459.39 | 5467.37 | 5459.09 | 5465.01 | 5196.0 |
| 2015-07-17 09:00:00 | NQ | Futures | 5465.01 | 5475.06 | 5460.86 | 5473.58 | 40693.0 |
| 2015-07-17 10:00:00 | NQ | Futures | 5473.58 | 5483.34 | 5468.55 | 5481.57 | 34136.0 |
| 2015-07-17 11:00:00 | NQ | Futures | 5480.98 | 5489.26 | 5478.61 | 5482.16 | 17806.0 |
| 2015-07-17 12:00:00 | NQ | Futures | 5482.16 | 5484.82 | 5476.25 | 5482.46 | 12199.0 |
| 2015-07-17 13:00:00 | NQ | Futures | 5482.75 | 5486.01 | 5478.91 | 5483.94 | 9083.0 |
| 2015-07-17 14:00:00 | NQ | Futures | 5483.94 | 5498.43 | 5482.46 | 5494.88 | 16693.0 |
| 2015-07-17 15:00:00 | NQ | Futures | 5495.18 | 5505.53 | 5490.74 | 5504.64 | 24435.0 |
| 2015-07-17 16:00:00 | NQ | Futures | 5504.64 | 5505.82 | 5499.32 | 5503.16 | 6302.0 |
| 2015-07-17 17:00:00 | NQ | Futures | 5502.87 | 5506.42 | 5502.87 | 5505.82 | 212.0 |
| 2015-07-17 00:00:00 | YM | Futures | 18960.2 | 18964.4 | 18953.9 | 18962.3 | 228.0 |
| 2015-07-17 01:00:00 | YM | Futures | 18963.3 | 18969.7 | 18961.2 | 18967.5 | 372.0 |
| 2015-07-17 02:00:00 | YM | Futures | 18969.7 | 18983.4 | 18964.4 | 18978.1 | 566.0 |
| 2015-07-17 03:00:00 | YM | Futures | 18979.1 | 18980.2 | 18957.0 | 18962.3 | 1674.0 |
| 2015-07-17 04:00:00 | YM | Futures | 18963.3 | 18966.5 | 18951.7 | 18959.1 | 1468.0 |
| 2015-07-17 05:00:00 | YM | Futures | 18958.1 | 18964.4 | 18949.6 | 18960.2 | 819.0 |
| 2015-07-17 06:00:00 | YM | Futures | 18959.1 | 18970.7 | 18959.1 | 18966.5 | 549.0 |
| 2015-07-17 07:00:00 | YM | Futures | 18966.5 | 18974.9 | 18959.1 | 18973.9 | 3656.0 |
| 2015-07-17 08:00:00 | YM | Futures | 18972.8 | 18987.6 | 18969.7 | 18971.8 | 2130.0 |
| 2015-07-17 09:00:00 | YM | Futures | 18970.7 | 18981.2 | 18925.4 | 18935.9 | 16570.0 |
| 2015-07-17 10:00:00 | YM | Futures | 18938.1 | 18948.6 | 18911.7 | 18928.6 | 13007.0 |
| 2015-07-17 11:00:00 | YM | Futures | 18929.6 | 18941.2 | 18920.1 | 18926.5 | 6823.0 |
| 2015-07-17 12:00:00 | YM | Futures | 18926.5 | 18938.1 | 18919.1 | 18934.9 | 4473.0 |
| 2015-07-17 13:00:00 | YM | Futures | 18935.9 | 18940.2 | 18922.3 | 18926.5 | 3120.0 |
> showing 50 of 1,255 rows — these rows as CSV