PREVIEW / futures_1hour / 2015-12-04
file: by_date/futures_1hour/2015/2015-12-04.parquet size: 45 KB rows: 1,314
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-04 00:00:00 | ES | Futures | 2200.82 | 2201.09 | 2198.41 | 2199.75 | 3792.0 |
| 2015-12-04 01:00:00 | ES | Futures | 2200.02 | 2200.55 | 2198.14 | 2199.48 | 3167.0 |
| 2015-12-04 02:00:00 | ES | Futures | 2199.48 | 2204.3 | 2197.34 | 2203.23 | 13438.0 |
| 2015-12-04 03:00:00 | ES | Futures | 2203.49 | 2207.77 | 2200.82 | 2206.44 | 33396.0 |
| 2015-12-04 04:00:00 | ES | Futures | 2206.7 | 2207.24 | 2202.42 | 2204.3 | 21556.0 |
| 2015-12-04 05:00:00 | ES | Futures | 2204.03 | 2205.63 | 2201.35 | 2205.63 | 16100.0 |
| 2015-12-04 06:00:00 | ES | Futures | 2205.37 | 2206.17 | 2202.16 | 2204.3 | 16212.0 |
| 2015-12-04 07:00:00 | ES | Futures | 2204.03 | 2204.3 | 2199.21 | 2199.75 | 25177.0 |
| 2015-12-04 08:00:00 | ES | Futures | 2199.75 | 2207.77 | 2198.14 | 2198.68 | 108700.0 |
| 2015-12-04 09:00:00 | ES | Futures | 2198.41 | 2215.27 | 2190.65 | 2211.25 | 378305.0 |
| 2015-12-04 10:00:00 | ES | Futures | 2211.25 | 2223.03 | 2207.77 | 2222.22 | 346867.0 |
| 2015-12-04 11:00:00 | ES | Futures | 2222.49 | 2224.1 | 2214.73 | 2216.6 | 239935.0 |
| 2015-12-04 12:00:00 | ES | Futures | 2216.34 | 2230.25 | 2213.93 | 2229.98 | 214258.0 |
| 2015-12-04 13:00:00 | ES | Futures | 2229.98 | 2235.87 | 2229.18 | 2233.46 | 221133.0 |
| 2015-12-04 14:00:00 | ES | Futures | 2233.46 | 2238.81 | 2229.98 | 2238.55 | 165268.0 |
| 2015-12-04 15:00:00 | ES | Futures | 2238.55 | 2240.15 | 2232.93 | 2236.14 | 275004.0 |
| 2015-12-04 16:00:00 | ES | Futures | 2236.14 | 2236.67 | 2234.0 | 2235.34 | 110778.0 |
| 2015-12-04 00:00:00 | NQ | Futures | 5480.93 | 5481.53 | 5474.71 | 5478.56 | 511.0 |
| 2015-12-04 01:00:00 | NQ | Futures | 5478.86 | 5481.82 | 5475.6 | 5479.15 | 415.0 |
| 2015-12-04 02:00:00 | NQ | Futures | 5479.15 | 5490.42 | 5473.22 | 5488.35 | 2100.0 |
| 2015-12-04 03:00:00 | NQ | Futures | 5488.05 | 5497.83 | 5480.64 | 5495.76 | 4416.0 |
| 2015-12-04 04:00:00 | NQ | Futures | 5496.05 | 5497.54 | 5482.71 | 5487.46 | 2741.0 |
| 2015-12-04 05:00:00 | NQ | Futures | 5487.75 | 5488.64 | 5477.67 | 5488.35 | 2600.0 |
| 2015-12-04 06:00:00 | NQ | Futures | 5488.05 | 5490.42 | 5480.04 | 5485.38 | 2098.0 |
| 2015-12-04 07:00:00 | NQ | Futures | 5485.38 | 5485.68 | 5472.33 | 5474.71 | 4096.0 |
| 2015-12-04 08:00:00 | NQ | Futures | 5474.71 | 5490.12 | 5470.26 | 5474.71 | 16281.0 |
| 2015-12-04 09:00:00 | NQ | Futures | 5474.71 | 5529.56 | 5458.99 | 5520.66 | 66175.0 |
| 2015-12-04 10:00:00 | NQ | Futures | 5520.66 | 5554.76 | 5507.32 | 5552.98 | 45886.0 |
| 2015-12-04 11:00:00 | NQ | Futures | 5553.28 | 5559.5 | 5536.38 | 5544.68 | 34303.0 |
| 2015-12-04 12:00:00 | NQ | Futures | 5544.98 | 5578.18 | 5538.45 | 5577.59 | 27444.0 |
| 2015-12-04 13:00:00 | NQ | Futures | 5577.89 | 5588.56 | 5574.92 | 5585.3 | 24438.0 |
| 2015-12-04 14:00:00 | NQ | Futures | 5585.59 | 5597.75 | 5577.0 | 5597.16 | 18838.0 |
| 2015-12-04 15:00:00 | NQ | Futures | 5596.86 | 5601.6 | 5584.7 | 5590.63 | 30951.0 |
| 2015-12-04 16:00:00 | NQ | Futures | 5590.93 | 5596.86 | 5586.48 | 5591.23 | 9654.0 |
| 2015-12-04 00:00:00 | YM | Futures | 18566.6 | 18569.8 | 18552.8 | 18561.3 | 465.0 |
| 2015-12-04 01:00:00 | YM | Futures | 18561.3 | 18564.5 | 18549.6 | 18556.0 | 689.0 |
| 2015-12-04 02:00:00 | YM | Futures | 18554.9 | 18588.8 | 18540.1 | 18584.6 | 1854.0 |
| 2015-12-04 03:00:00 | YM | Futures | 18585.7 | 18621.7 | 18564.5 | 18616.4 | 5597.0 |
| 2015-12-04 04:00:00 | YM | Futures | 18614.3 | 18618.5 | 18580.4 | 18594.1 | 2344.0 |
| 2015-12-04 05:00:00 | YM | Futures | 18593.1 | 18602.6 | 18569.8 | 18602.6 | 1523.0 |
| 2015-12-04 06:00:00 | YM | Futures | 18601.5 | 18605.8 | 18574.0 | 18591.0 | 1852.0 |
| 2015-12-04 07:00:00 | YM | Futures | 18589.9 | 18591.0 | 18551.8 | 18553.9 | 2919.0 |
| 2015-12-04 08:00:00 | YM | Futures | 18553.9 | 18625.9 | 18540.1 | 18545.4 | 13100.0 |
| 2015-12-04 09:00:00 | YM | Futures | 18545.4 | 18719.1 | 18478.7 | 18685.2 | 40775.0 |
| 2015-12-04 10:00:00 | YM | Futures | 18686.3 | 18788.0 | 18671.5 | 18782.7 | 32855.0 |
| 2015-12-04 11:00:00 | YM | Futures | 18781.6 | 18795.4 | 18728.7 | 18739.3 | 18154.0 |
| 2015-12-04 12:00:00 | YM | Futures | 18739.3 | 18847.3 | 18720.2 | 18842.0 | 19503.0 |
| 2015-12-04 13:00:00 | YM | Futures | 18843.1 | 18892.8 | 18836.7 | 18868.5 | 16639.0 |
| 2015-12-04 14:00:00 | YM | Futures | 18868.5 | 18900.3 | 18840.9 | 18896.0 | 12737.0 |
| 2015-12-04 15:00:00 | YM | Futures | 18896.0 | 18913.0 | 18853.7 | 18886.5 | 18287.0 |
> showing 50 of 1,314 rows — these rows as CSV