PREVIEW / futures_1hour / 2015-11-30
file: by_date/futures_1hour/2015/2015-11-30.parquet size: 50 KB rows: 1,584
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-30 00:00:00 | ES | Futures | 2233.46 | 2234.0 | 2232.12 | 2233.19 | 3495.0 |
| 2015-11-30 01:00:00 | ES | Futures | 2233.19 | 2233.46 | 2232.39 | 2233.19 | 2764.0 |
| 2015-11-30 02:00:00 | ES | Futures | 2233.19 | 2233.46 | 2231.59 | 2231.86 | 4887.0 |
| 2015-11-30 03:00:00 | ES | Futures | 2231.86 | 2234.0 | 2228.65 | 2233.19 | 22859.0 |
| 2015-11-30 04:00:00 | ES | Futures | 2233.19 | 2239.08 | 2232.93 | 2236.14 | 19762.0 |
| 2015-11-30 05:00:00 | ES | Futures | 2236.14 | 2236.41 | 2234.0 | 2236.14 | 11784.0 |
| 2015-11-30 06:00:00 | ES | Futures | 2236.14 | 2240.95 | 2235.6 | 2238.28 | 19452.0 |
| 2015-11-30 07:00:00 | ES | Futures | 2238.28 | 2242.29 | 2237.21 | 2241.49 | 22771.0 |
| 2015-11-30 08:00:00 | ES | Futures | 2241.49 | 2242.29 | 2239.88 | 2241.49 | 24087.0 |
| 2015-11-30 09:00:00 | ES | Futures | 2241.49 | 2241.76 | 2231.05 | 2231.32 | 165217.0 |
| 2015-11-30 10:00:00 | ES | Futures | 2231.32 | 2235.34 | 2229.72 | 2231.86 | 186906.0 |
| 2015-11-30 11:00:00 | ES | Futures | 2231.86 | 2234.8 | 2226.51 | 2227.84 | 159586.0 |
| 2015-11-30 12:00:00 | ES | Futures | 2227.84 | 2231.05 | 2226.77 | 2228.91 | 80705.0 |
| 2015-11-30 13:00:00 | ES | Futures | 2228.91 | 2234.8 | 2227.84 | 2233.46 | 89438.0 |
| 2015-11-30 14:00:00 | ES | Futures | 2233.73 | 2234.0 | 2227.58 | 2228.11 | 94506.0 |
| 2015-11-30 15:00:00 | ES | Futures | 2227.84 | 2229.45 | 2224.63 | 2226.24 | 318472.0 |
| 2015-11-30 16:00:00 | ES | Futures | 2226.24 | 2232.39 | 2225.43 | 2231.86 | 117948.0 |
| 2015-11-30 18:00:00 | ES | Futures | 2232.12 | 2236.14 | 2231.86 | 2234.0 | 11122.0 |
| 2015-11-30 19:00:00 | ES | Futures | 2234.0 | 2236.94 | 2233.46 | 2235.87 | 8487.0 |
| 2015-11-30 20:00:00 | ES | Futures | 2236.14 | 2238.01 | 2235.07 | 2237.48 | 9978.0 |
| 2015-11-30 21:00:00 | ES | Futures | 2237.74 | 2239.88 | 2237.48 | 2238.28 | 10846.0 |
| 2015-11-30 22:00:00 | ES | Futures | 2238.28 | 2238.81 | 2237.21 | 2237.48 | 9099.0 |
| 2015-11-30 23:00:00 | ES | Futures | 2237.74 | 2239.35 | 2237.48 | 2238.81 | 6547.0 |
| 2015-11-30 00:00:00 | NQ | Futures | 5544.38 | 5547.05 | 5543.79 | 5545.57 | 311.0 |
| 2015-11-30 01:00:00 | NQ | Futures | 5545.57 | 5547.64 | 5544.09 | 5547.64 | 278.0 |
| 2015-11-30 02:00:00 | NQ | Futures | 5547.35 | 5548.83 | 5544.68 | 5544.68 | 596.0 |
| 2015-11-30 03:00:00 | NQ | Futures | 5544.68 | 5548.24 | 5534.6 | 5547.35 | 2800.0 |
| 2015-11-30 04:00:00 | NQ | Futures | 5547.05 | 5565.43 | 5546.75 | 5558.32 | 3272.0 |
| 2015-11-30 05:00:00 | NQ | Futures | 5558.61 | 5559.21 | 5553.57 | 5558.02 | 1248.0 |
| 2015-11-30 06:00:00 | NQ | Futures | 5557.72 | 5570.18 | 5557.13 | 5564.25 | 2367.0 |
| 2015-11-30 07:00:00 | NQ | Futures | 5564.54 | 5574.62 | 5563.06 | 5573.14 | 2499.0 |
| 2015-11-30 08:00:00 | NQ | Futures | 5572.85 | 5574.62 | 5569.88 | 5572.55 | 2980.0 |
| 2015-11-30 09:00:00 | NQ | Futures | 5572.55 | 5572.85 | 5546.16 | 5546.16 | 27193.0 |
| 2015-11-30 10:00:00 | NQ | Futures | 5547.05 | 5554.46 | 5536.08 | 5543.2 | 29599.0 |
| 2015-11-30 11:00:00 | NQ | Futures | 5542.9 | 5549.42 | 5521.26 | 5523.33 | 22571.0 |
| 2015-11-30 12:00:00 | NQ | Futures | 5523.03 | 5529.56 | 5518.88 | 5526.59 | 13889.0 |
| 2015-11-30 13:00:00 | NQ | Futures | 5526.3 | 5551.2 | 5520.37 | 5547.94 | 14919.0 |
| 2015-11-30 14:00:00 | NQ | Futures | 5547.94 | 5552.98 | 5536.38 | 5536.97 | 14612.0 |
| 2015-11-30 15:00:00 | NQ | Futures | 5536.97 | 5540.82 | 5528.67 | 5535.78 | 27252.0 |
| 2015-11-30 16:00:00 | NQ | Futures | 5536.08 | 5550.9 | 5534.0 | 5550.02 | 7898.0 |
| 2015-11-30 18:00:00 | NQ | Futures | 5548.83 | 5559.8 | 5548.83 | 5554.17 | 1141.0 |
| 2015-11-30 19:00:00 | NQ | Futures | 5554.17 | 5561.88 | 5553.28 | 5558.91 | 1206.0 |
| 2015-11-30 20:00:00 | NQ | Futures | 5558.91 | 5565.43 | 5558.32 | 5563.65 | 1208.0 |
| 2015-11-30 21:00:00 | NQ | Futures | 5563.95 | 5569.88 | 5563.36 | 5564.54 | 1385.0 |
| 2015-11-30 22:00:00 | NQ | Futures | 5564.54 | 5568.1 | 5563.36 | 5564.84 | 610.0 |
| 2015-11-30 23:00:00 | NQ | Futures | 5564.54 | 5569.29 | 5564.54 | 5566.92 | 522.0 |
| 2015-11-30 00:00:00 | YM | Futures | 18824.0 | 18833.5 | 18820.8 | 18824.0 | 493.0 |
| 2015-11-30 01:00:00 | YM | Futures | 18824.0 | 18829.3 | 18818.7 | 18826.1 | 296.0 |
| 2015-11-30 02:00:00 | YM | Futures | 18827.2 | 18829.3 | 18815.5 | 18815.5 | 734.0 |
| 2015-11-30 03:00:00 | YM | Futures | 18816.6 | 18829.3 | 18785.9 | 18826.1 | 2839.0 |
> showing 50 of 1,584 rows — these rows as CSV