PREVIEW / futures_1hour / 2015-11-05
file: by_date/futures_1hour/2015/2015-11-05.parquet size: 52 KB rows: 1,608
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-05 00:00:00 | ES | Futures | 2243.63 | 2244.7 | 2242.83 | 2243.63 | 3137.0 |
| 2015-11-05 01:00:00 | ES | Futures | 2243.63 | 2245.5 | 2243.63 | 2244.17 | 2963.0 |
| 2015-11-05 02:00:00 | ES | Futures | 2244.17 | 2245.77 | 2242.83 | 2244.7 | 5636.0 |
| 2015-11-05 03:00:00 | ES | Futures | 2244.43 | 2245.5 | 2239.35 | 2240.95 | 21988.0 |
| 2015-11-05 04:00:00 | ES | Futures | 2240.95 | 2244.97 | 2240.42 | 2242.83 | 15916.0 |
| 2015-11-05 05:00:00 | ES | Futures | 2243.09 | 2248.18 | 2242.56 | 2246.57 | 20213.0 |
| 2015-11-05 06:00:00 | ES | Futures | 2246.57 | 2250.32 | 2245.5 | 2248.18 | 16149.0 |
| 2015-11-05 07:00:00 | ES | Futures | 2248.18 | 2252.73 | 2247.91 | 2251.66 | 24380.0 |
| 2015-11-05 08:00:00 | ES | Futures | 2251.66 | 2251.66 | 2246.84 | 2247.64 | 24526.0 |
| 2015-11-05 09:00:00 | ES | Futures | 2247.64 | 2250.05 | 2242.56 | 2249.78 | 213069.0 |
| 2015-11-05 10:00:00 | ES | Futures | 2249.78 | 2251.12 | 2230.52 | 2234.0 | 360859.0 |
| 2015-11-05 11:00:00 | ES | Futures | 2234.26 | 2241.76 | 2232.12 | 2241.22 | 188058.0 |
| 2015-11-05 12:00:00 | ES | Futures | 2241.22 | 2244.7 | 2238.55 | 2244.43 | 146004.0 |
| 2015-11-05 13:00:00 | ES | Futures | 2244.43 | 2245.5 | 2239.62 | 2242.56 | 115621.0 |
| 2015-11-05 14:00:00 | ES | Futures | 2242.56 | 2243.9 | 2236.41 | 2239.35 | 111755.0 |
| 2015-11-05 15:00:00 | ES | Futures | 2239.62 | 2244.7 | 2236.67 | 2241.49 | 185001.0 |
| 2015-11-05 16:00:00 | ES | Futures | 2241.49 | 2242.83 | 2239.62 | 2242.56 | 53410.0 |
| 2015-11-05 18:00:00 | ES | Futures | 2242.02 | 2242.29 | 2238.81 | 2239.08 | 4973.0 |
| 2015-11-05 19:00:00 | ES | Futures | 2239.35 | 2240.15 | 2237.74 | 2239.62 | 3828.0 |
| 2015-11-05 20:00:00 | ES | Futures | 2239.88 | 2240.15 | 2238.55 | 2239.88 | 2976.0 |
| 2015-11-05 21:00:00 | ES | Futures | 2239.88 | 2239.88 | 2238.55 | 2239.08 | 2250.0 |
| 2015-11-05 22:00:00 | ES | Futures | 2239.08 | 2239.62 | 2238.55 | 2238.81 | 1102.0 |
| 2015-11-05 23:00:00 | ES | Futures | 2238.81 | 2240.15 | 2238.28 | 2239.88 | 1998.0 |
| 2015-11-05 00:00:00 | NQ | Futures | 5588.26 | 5589.45 | 5585.3 | 5586.19 | 718.0 |
| 2015-11-05 01:00:00 | NQ | Futures | 5586.48 | 5590.63 | 5586.19 | 5587.37 | 388.0 |
| 2015-11-05 02:00:00 | NQ | Futures | 5587.37 | 5591.52 | 5584.7 | 5588.86 | 787.0 |
| 2015-11-05 03:00:00 | NQ | Futures | 5588.56 | 5590.63 | 5575.22 | 5579.07 | 3326.0 |
| 2015-11-05 04:00:00 | NQ | Futures | 5578.78 | 5589.75 | 5577.89 | 5584.41 | 1648.0 |
| 2015-11-05 05:00:00 | NQ | Futures | 5583.82 | 5596.56 | 5583.52 | 5595.38 | 2705.0 |
| 2015-11-05 06:00:00 | NQ | Futures | 5595.68 | 5603.68 | 5591.82 | 5599.83 | 2940.0 |
| 2015-11-05 07:00:00 | NQ | Futures | 5600.12 | 5606.65 | 5598.64 | 5601.9 | 3754.0 |
| 2015-11-05 08:00:00 | NQ | Futures | 5601.6 | 5601.6 | 5595.97 | 5597.45 | 4030.0 |
| 2015-11-05 09:00:00 | NQ | Futures | 5597.45 | 5602.79 | 5584.7 | 5601.6 | 34547.0 |
| 2015-11-05 10:00:00 | NQ | Futures | 5601.6 | 5605.46 | 5542.9 | 5551.2 | 58101.0 |
| 2015-11-05 11:00:00 | NQ | Futures | 5550.9 | 5571.96 | 5548.24 | 5570.77 | 30870.0 |
| 2015-11-05 12:00:00 | NQ | Futures | 5570.77 | 5577.29 | 5559.21 | 5575.81 | 25189.0 |
| 2015-11-05 13:00:00 | NQ | Futures | 5575.81 | 5578.78 | 5567.51 | 5570.77 | 18637.0 |
| 2015-11-05 14:00:00 | NQ | Futures | 5570.47 | 5575.22 | 5555.65 | 5564.54 | 16424.0 |
| 2015-11-05 15:00:00 | NQ | Futures | 5564.84 | 5577.89 | 5560.39 | 5570.77 | 26080.0 |
| 2015-11-05 16:00:00 | NQ | Futures | 5571.07 | 5574.92 | 5566.92 | 5573.44 | 5531.0 |
| 2015-11-05 18:00:00 | NQ | Futures | 5574.92 | 5575.22 | 5567.8 | 5568.99 | 746.0 |
| 2015-11-05 19:00:00 | NQ | Futures | 5568.1 | 5571.07 | 5565.14 | 5568.69 | 760.0 |
| 2015-11-05 20:00:00 | NQ | Futures | 5568.99 | 5568.99 | 5565.14 | 5568.1 | 442.0 |
| 2015-11-05 21:00:00 | NQ | Futures | 5567.8 | 5567.8 | 5565.14 | 5566.03 | 263.0 |
| 2015-11-05 22:00:00 | NQ | Futures | 5566.03 | 5566.62 | 5564.25 | 5564.25 | 293.0 |
| 2015-11-05 23:00:00 | NQ | Futures | 5564.54 | 5567.21 | 5563.36 | 5566.92 | 332.0 |
| 2015-11-05 00:00:00 | YM | Futures | 18858.9 | 18868.5 | 18855.8 | 18860.0 | 777.0 |
| 2015-11-05 01:00:00 | YM | Futures | 18858.9 | 18873.8 | 18857.9 | 18862.1 | 376.0 |
| 2015-11-05 02:00:00 | YM | Futures | 18862.1 | 18873.8 | 18855.8 | 18867.4 | 684.0 |
| 2015-11-05 03:00:00 | YM | Futures | 18866.4 | 18872.7 | 18825.1 | 18838.8 | 3006.0 |
> showing 50 of 1,608 rows — these rows as CSV