PREVIEW / futures_1hour / 2015-12-03
file: by_date/futures_1hour/2015/2015-12-03.parquet size: 55 KB rows: 1,627
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-12-03 00:00:00 | ES | Futures | 2231.86 | 2232.12 | 2229.98 | 2231.59 | 4427.0 |
| 2015-12-03 01:00:00 | ES | Futures | 2231.59 | 2232.12 | 2229.98 | 2230.52 | 2669.0 |
| 2015-12-03 02:00:00 | ES | Futures | 2230.25 | 2231.32 | 2228.11 | 2231.05 | 9077.0 |
| 2015-12-03 03:00:00 | ES | Futures | 2231.32 | 2237.21 | 2231.05 | 2236.41 | 23663.0 |
| 2015-12-03 04:00:00 | ES | Futures | 2236.14 | 2240.42 | 2233.46 | 2239.08 | 22617.0 |
| 2015-12-03 05:00:00 | ES | Futures | 2239.35 | 2242.56 | 2238.28 | 2242.29 | 19194.0 |
| 2015-12-03 06:00:00 | ES | Futures | 2242.29 | 2242.29 | 2239.88 | 2240.15 | 13275.0 |
| 2015-12-03 07:00:00 | ES | Futures | 2240.15 | 2240.42 | 2230.25 | 2234.8 | 64390.0 |
| 2015-12-03 08:00:00 | ES | Futures | 2235.07 | 2237.48 | 2217.68 | 2228.38 | 177074.0 |
| 2015-12-03 09:00:00 | ES | Futures | 2228.38 | 2234.26 | 2217.94 | 2219.82 | 308942.0 |
| 2015-12-03 10:00:00 | ES | Futures | 2219.55 | 2219.82 | 2210.45 | 2215.8 | 368352.0 |
| 2015-12-03 11:00:00 | ES | Futures | 2215.8 | 2222.49 | 2213.13 | 2215.53 | 228011.0 |
| 2015-12-03 12:00:00 | ES | Futures | 2215.53 | 2216.34 | 2201.62 | 2203.23 | 271752.0 |
| 2015-12-03 13:00:00 | ES | Futures | 2203.23 | 2208.31 | 2195.2 | 2195.47 | 210542.0 |
| 2015-12-03 14:00:00 | ES | Futures | 2195.47 | 2196.27 | 2183.43 | 2191.99 | 331592.0 |
| 2015-12-03 15:00:00 | ES | Futures | 2191.99 | 2194.4 | 2183.96 | 2192.79 | 407815.0 |
| 2015-12-03 16:00:00 | ES | Futures | 2192.79 | 2198.94 | 2191.72 | 2197.87 | 111754.0 |
| 2015-12-03 17:00:00 | ES | Futures | 2198.14 | 2198.14 | 2197.87 | 2197.87 | 14.0 |
| 2015-12-03 18:00:00 | ES | Futures | 2197.61 | 2202.42 | 2196.8 | 2197.34 | 10209.0 |
| 2015-12-03 19:00:00 | ES | Futures | 2197.34 | 2201.62 | 2197.34 | 2201.35 | 8550.0 |
| 2015-12-03 20:00:00 | ES | Futures | 2201.35 | 2202.16 | 2198.94 | 2200.28 | 6363.0 |
| 2015-12-03 21:00:00 | ES | Futures | 2200.02 | 2200.82 | 2198.14 | 2198.68 | 3328.0 |
| 2015-12-03 22:00:00 | ES | Futures | 2198.68 | 2201.62 | 2198.14 | 2199.21 | 4050.0 |
| 2015-12-03 23:00:00 | ES | Futures | 2199.21 | 2200.82 | 2197.87 | 2200.55 | 3154.0 |
| 2015-12-03 00:00:00 | NQ | Futures | 5580.26 | 5581.44 | 5576.11 | 5580.26 | 798.0 |
| 2015-12-03 01:00:00 | NQ | Futures | 5580.55 | 5581.15 | 5577.29 | 5577.89 | 487.0 |
| 2015-12-03 02:00:00 | NQ | Futures | 5577.59 | 5580.55 | 5571.96 | 5578.78 | 1282.0 |
| 2015-12-03 03:00:00 | NQ | Futures | 5578.78 | 5593.9 | 5578.78 | 5591.52 | 4081.0 |
| 2015-12-03 04:00:00 | NQ | Futures | 5591.23 | 5605.16 | 5586.19 | 5602.79 | 3891.0 |
| 2015-12-03 05:00:00 | NQ | Futures | 5602.79 | 5609.91 | 5600.72 | 5608.42 | 2941.0 |
| 2015-12-03 06:00:00 | NQ | Futures | 5608.42 | 5608.72 | 5602.79 | 5603.38 | 2001.0 |
| 2015-12-03 07:00:00 | NQ | Futures | 5603.09 | 5603.98 | 5581.44 | 5590.93 | 11029.0 |
| 2015-12-03 08:00:00 | NQ | Futures | 5590.34 | 5593.3 | 5544.68 | 5571.07 | 27467.0 |
| 2015-12-03 09:00:00 | NQ | Futures | 5571.07 | 5588.26 | 5546.46 | 5555.06 | 52108.0 |
| 2015-12-03 10:00:00 | NQ | Futures | 5554.17 | 5557.13 | 5525.7 | 5541.71 | 47899.0 |
| 2015-12-03 11:00:00 | NQ | Futures | 5541.42 | 5566.32 | 5531.93 | 5538.45 | 29982.0 |
| 2015-12-03 12:00:00 | NQ | Futures | 5537.86 | 5540.53 | 5482.12 | 5483.9 | 47634.0 |
| 2015-12-03 13:00:00 | NQ | Futures | 5483.6 | 5494.87 | 5460.48 | 5461.07 | 36514.0 |
| 2015-12-03 14:00:00 | NQ | Futures | 5461.36 | 5464.03 | 5430.53 | 5457.81 | 42989.0 |
| 2015-12-03 15:00:00 | NQ | Futures | 5457.81 | 5466.11 | 5438.83 | 5464.03 | 44422.0 |
| 2015-12-03 16:00:00 | NQ | Futures | 5464.33 | 5477.08 | 5461.07 | 5474.71 | 10385.0 |
| 2015-12-03 18:00:00 | NQ | Futures | 5474.41 | 5485.08 | 5471.45 | 5473.22 | 1837.0 |
| 2015-12-03 19:00:00 | NQ | Futures | 5473.22 | 5483.3 | 5473.22 | 5483.3 | 1433.0 |
| 2015-12-03 20:00:00 | NQ | Futures | 5483.01 | 5484.79 | 5477.67 | 5480.04 | 1048.0 |
| 2015-12-03 21:00:00 | NQ | Futures | 5479.45 | 5481.53 | 5474.11 | 5475.3 | 778.0 |
| 2015-12-03 22:00:00 | NQ | Futures | 5475.0 | 5481.23 | 5475.0 | 5476.19 | 936.0 |
| 2015-12-03 23:00:00 | NQ | Futures | 5476.19 | 5482.12 | 5473.82 | 5480.64 | 703.0 |
| 2015-12-03 00:00:00 | YM | Futures | 18834.6 | 18837.8 | 18822.9 | 18834.6 | 810.0 |
| 2015-12-03 01:00:00 | YM | Futures | 18835.6 | 18837.8 | 18821.9 | 18822.9 | 402.0 |
| 2015-12-03 02:00:00 | YM | Futures | 18824.0 | 18832.5 | 18804.9 | 18826.1 | 1162.0 |
> showing 50 of 1,627 rows — these rows as CSV