PREVIEW / futures_1hour / 2015-11-06
file: by_date/futures_1hour/2015/2015-11-06.parquet size: 45 KB rows: 1,320
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-06 00:00:00 | ES | Futures | 2239.88 | 2242.29 | 2239.62 | 2242.02 | 3706.0 |
| 2015-11-06 01:00:00 | ES | Futures | 2242.02 | 2242.29 | 2240.42 | 2242.02 | 1850.0 |
| 2015-11-06 02:00:00 | ES | Futures | 2242.29 | 2243.09 | 2240.42 | 2241.49 | 5808.0 |
| 2015-11-06 03:00:00 | ES | Futures | 2241.22 | 2241.76 | 2238.55 | 2240.15 | 18650.0 |
| 2015-11-06 04:00:00 | ES | Futures | 2240.15 | 2241.49 | 2239.35 | 2240.15 | 12653.0 |
| 2015-11-06 05:00:00 | ES | Futures | 2240.42 | 2241.22 | 2239.35 | 2240.69 | 7467.0 |
| 2015-11-06 06:00:00 | ES | Futures | 2240.69 | 2240.69 | 2238.81 | 2239.88 | 7621.0 |
| 2015-11-06 07:00:00 | ES | Futures | 2239.62 | 2243.9 | 2239.35 | 2242.83 | 18492.0 |
| 2015-11-06 08:00:00 | ES | Futures | 2243.09 | 2246.57 | 2228.38 | 2232.39 | 227343.0 |
| 2015-11-06 09:00:00 | ES | Futures | 2232.39 | 2243.63 | 2229.72 | 2231.05 | 339288.0 |
| 2015-11-06 10:00:00 | ES | Futures | 2230.79 | 2238.55 | 2223.56 | 2234.0 | 372007.0 |
| 2015-11-06 11:00:00 | ES | Futures | 2234.0 | 2235.34 | 2227.31 | 2231.32 | 187290.0 |
| 2015-11-06 12:00:00 | ES | Futures | 2231.59 | 2234.26 | 2226.51 | 2230.79 | 123339.0 |
| 2015-11-06 13:00:00 | ES | Futures | 2230.52 | 2237.74 | 2229.72 | 2236.67 | 110760.0 |
| 2015-11-06 14:00:00 | ES | Futures | 2236.67 | 2240.95 | 2231.05 | 2234.8 | 151886.0 |
| 2015-11-06 15:00:00 | ES | Futures | 2235.07 | 2241.22 | 2234.26 | 2240.42 | 175871.0 |
| 2015-11-06 16:00:00 | ES | Futures | 2240.42 | 2241.49 | 2239.35 | 2240.69 | 61514.0 |
| 2015-11-06 00:00:00 | NQ | Futures | 5566.62 | 5573.14 | 5566.62 | 5571.96 | 559.0 |
| 2015-11-06 01:00:00 | NQ | Futures | 5572.55 | 5573.14 | 5569.58 | 5572.25 | 234.0 |
| 2015-11-06 02:00:00 | NQ | Futures | 5573.14 | 5575.22 | 5568.69 | 5570.77 | 1137.0 |
| 2015-11-06 03:00:00 | NQ | Futures | 5570.47 | 5571.07 | 5563.06 | 5569.29 | 3621.0 |
| 2015-11-06 04:00:00 | NQ | Futures | 5568.99 | 5571.96 | 5566.32 | 5569.29 | 1647.0 |
| 2015-11-06 05:00:00 | NQ | Futures | 5569.29 | 5572.55 | 5568.69 | 5571.66 | 904.0 |
| 2015-11-06 06:00:00 | NQ | Futures | 5571.66 | 5572.25 | 5567.51 | 5568.99 | 1301.0 |
| 2015-11-06 07:00:00 | NQ | Futures | 5568.69 | 5578.48 | 5568.4 | 5577.59 | 2939.0 |
| 2015-11-06 08:00:00 | NQ | Futures | 5577.59 | 5584.41 | 5541.42 | 5550.31 | 28849.0 |
| 2015-11-06 09:00:00 | NQ | Futures | 5550.9 | 5579.07 | 5544.68 | 5549.13 | 55656.0 |
| 2015-11-06 10:00:00 | NQ | Futures | 5548.83 | 5582.33 | 5525.11 | 5571.96 | 59030.0 |
| 2015-11-06 11:00:00 | NQ | Futures | 5571.66 | 5574.03 | 5554.17 | 5566.03 | 31909.0 |
| 2015-11-06 12:00:00 | NQ | Futures | 5566.62 | 5570.77 | 5547.05 | 5558.32 | 20815.0 |
| 2015-11-06 13:00:00 | NQ | Futures | 5558.32 | 5570.47 | 5551.5 | 5568.4 | 16971.0 |
| 2015-11-06 14:00:00 | NQ | Futures | 5568.99 | 5576.4 | 5552.09 | 5562.47 | 23131.0 |
| 2015-11-06 15:00:00 | NQ | Futures | 5562.47 | 5576.7 | 5560.69 | 5575.81 | 20247.0 |
| 2015-11-06 16:00:00 | NQ | Futures | 5575.81 | 5578.78 | 5572.55 | 5577.59 | 4168.0 |
| 2015-11-06 00:00:00 | YM | Futures | 18839.9 | 18857.9 | 18838.8 | 18853.7 | 532.0 |
| 2015-11-06 01:00:00 | YM | Futures | 18852.6 | 18860.0 | 18845.2 | 18858.9 | 378.0 |
| 2015-11-06 02:00:00 | YM | Futures | 18858.9 | 18867.4 | 18840.9 | 18848.4 | 720.0 |
| 2015-11-06 03:00:00 | YM | Futures | 18847.3 | 18855.8 | 18831.4 | 18838.8 | 2268.0 |
| 2015-11-06 04:00:00 | YM | Futures | 18837.8 | 18843.1 | 18829.3 | 18835.6 | 733.0 |
| 2015-11-06 05:00:00 | YM | Futures | 18836.7 | 18847.3 | 18832.5 | 18846.2 | 885.0 |
| 2015-11-06 06:00:00 | YM | Futures | 18847.3 | 18848.4 | 18834.6 | 18840.9 | 773.0 |
| 2015-11-06 07:00:00 | YM | Futures | 18839.9 | 18857.9 | 18833.5 | 18853.7 | 2275.0 |
| 2015-11-06 08:00:00 | YM | Futures | 18853.7 | 18890.7 | 18753.0 | 18795.4 | 22500.0 |
| 2015-11-06 09:00:00 | YM | Futures | 18796.5 | 18913.0 | 18777.4 | 18815.5 | 34962.0 |
| 2015-11-06 10:00:00 | YM | Futures | 18814.5 | 18884.4 | 18757.3 | 18846.2 | 34350.0 |
| 2015-11-06 11:00:00 | YM | Futures | 18845.2 | 18852.6 | 18783.7 | 18821.9 | 17823.0 |
| 2015-11-06 12:00:00 | YM | Futures | 18822.9 | 18844.1 | 18784.8 | 18815.5 | 10126.0 |
| 2015-11-06 13:00:00 | YM | Futures | 18815.5 | 18879.1 | 18811.3 | 18875.9 | 9190.0 |
| 2015-11-06 14:00:00 | YM | Futures | 18875.9 | 18906.6 | 18830.3 | 18858.9 | 15745.0 |
| 2015-11-06 15:00:00 | YM | Futures | 18860.0 | 18909.8 | 18854.7 | 18906.6 | 11928.0 |
> showing 50 of 1,320 rows — these rows as CSV