PREVIEW / futures_1hour / 2015-11-11
file: by_date/futures_1hour/2015/2015-11-11.parquet size: 50 KB rows: 1,557
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-11 00:00:00 | ES | Futures | 2226.77 | 2227.31 | 2224.63 | 2224.9 | 3986.0 |
| 2015-11-11 01:00:00 | ES | Futures | 2224.9 | 2226.77 | 2224.63 | 2225.17 | 2396.0 |
| 2015-11-11 02:00:00 | ES | Futures | 2225.17 | 2225.17 | 2223.56 | 2224.1 | 5476.0 |
| 2015-11-11 03:00:00 | ES | Futures | 2224.36 | 2229.72 | 2223.03 | 2229.18 | 19563.0 |
| 2015-11-11 04:00:00 | ES | Futures | 2229.18 | 2231.05 | 2227.84 | 2229.45 | 15158.0 |
| 2015-11-11 05:00:00 | ES | Futures | 2229.45 | 2229.45 | 2227.04 | 2228.11 | 8738.0 |
| 2015-11-11 06:00:00 | ES | Futures | 2227.84 | 2231.86 | 2226.77 | 2231.59 | 11773.0 |
| 2015-11-11 07:00:00 | ES | Futures | 2231.86 | 2233.73 | 2230.52 | 2233.46 | 20866.0 |
| 2015-11-11 08:00:00 | ES | Futures | 2233.46 | 2234.0 | 2229.72 | 2231.05 | 19065.0 |
| 2015-11-11 09:00:00 | ES | Futures | 2231.05 | 2231.05 | 2222.49 | 2223.03 | 180235.0 |
| 2015-11-11 10:00:00 | ES | Futures | 2223.29 | 2224.1 | 2215.0 | 2218.48 | 214839.0 |
| 2015-11-11 11:00:00 | ES | Futures | 2218.21 | 2223.56 | 2216.34 | 2222.49 | 124137.0 |
| 2015-11-11 12:00:00 | ES | Futures | 2222.76 | 2228.91 | 2221.69 | 2226.24 | 101609.0 |
| 2015-11-11 13:00:00 | ES | Futures | 2226.24 | 2226.51 | 2218.75 | 2219.82 | 104944.0 |
| 2015-11-11 14:00:00 | ES | Futures | 2220.08 | 2223.83 | 2216.6 | 2216.87 | 101821.0 |
| 2015-11-11 15:00:00 | ES | Futures | 2216.87 | 2219.55 | 2214.73 | 2215.53 | 156496.0 |
| 2015-11-11 16:00:00 | ES | Futures | 2215.53 | 2215.8 | 2213.13 | 2213.93 | 55626.0 |
| 2015-11-11 18:00:00 | ES | Futures | 2213.93 | 2215.0 | 2213.39 | 2214.73 | 4216.0 |
| 2015-11-11 19:00:00 | ES | Futures | 2214.73 | 2215.8 | 2213.66 | 2215.8 | 3397.0 |
| 2015-11-11 20:00:00 | ES | Futures | 2215.8 | 2219.55 | 2215.53 | 2219.01 | 5917.0 |
| 2015-11-11 21:00:00 | ES | Futures | 2219.01 | 2219.01 | 2216.87 | 2218.21 | 2969.0 |
| 2015-11-11 22:00:00 | ES | Futures | 2218.21 | 2220.08 | 2217.68 | 2219.55 | 3803.0 |
| 2015-11-11 23:00:00 | ES | Futures | 2219.28 | 2220.35 | 2219.01 | 2219.55 | 1763.0 |
| 2015-11-11 00:00:00 | NQ | Futures | 5510.88 | 5512.66 | 5506.43 | 5507.32 | 1248.0 |
| 2015-11-11 01:00:00 | NQ | Futures | 5507.62 | 5511.47 | 5505.54 | 5506.13 | 522.0 |
| 2015-11-11 02:00:00 | NQ | Futures | 5506.13 | 5509.1 | 5503.47 | 5506.73 | 1122.0 |
| 2015-11-11 03:00:00 | NQ | Futures | 5507.32 | 5521.26 | 5504.36 | 5520.07 | 3971.0 |
| 2015-11-11 04:00:00 | NQ | Futures | 5520.07 | 5525.7 | 5518.59 | 5520.66 | 2074.0 |
| 2015-11-11 05:00:00 | NQ | Futures | 5520.66 | 5520.66 | 5515.03 | 5517.1 | 1016.0 |
| 2015-11-11 06:00:00 | NQ | Futures | 5516.51 | 5524.52 | 5514.44 | 5523.33 | 1733.0 |
| 2015-11-11 07:00:00 | NQ | Futures | 5523.63 | 5528.67 | 5520.37 | 5527.78 | 2728.0 |
| 2015-11-11 08:00:00 | NQ | Futures | 5527.78 | 5528.67 | 5519.77 | 5522.44 | 3408.0 |
| 2015-11-11 09:00:00 | NQ | Futures | 5522.15 | 5522.15 | 5496.35 | 5498.13 | 31205.0 |
| 2015-11-11 10:00:00 | NQ | Futures | 5498.43 | 5505.54 | 5485.38 | 5495.16 | 36968.0 |
| 2015-11-11 11:00:00 | NQ | Futures | 5495.76 | 5517.7 | 5489.23 | 5515.92 | 24155.0 |
| 2015-11-11 12:00:00 | NQ | Futures | 5516.22 | 5544.09 | 5513.25 | 5535.78 | 30171.0 |
| 2015-11-11 13:00:00 | NQ | Futures | 5535.78 | 5536.67 | 5510.29 | 5512.95 | 20976.0 |
| 2015-11-11 14:00:00 | NQ | Futures | 5512.95 | 5524.81 | 5502.28 | 5502.28 | 19585.0 |
| 2015-11-11 15:00:00 | NQ | Futures | 5501.98 | 5505.84 | 5492.5 | 5494.28 | 30059.0 |
| 2015-11-11 16:00:00 | NQ | Futures | 5494.28 | 5496.35 | 5489.53 | 5493.39 | 5792.0 |
| 2015-11-11 18:00:00 | NQ | Futures | 5492.5 | 5494.28 | 5490.12 | 5492.79 | 661.0 |
| 2015-11-11 19:00:00 | NQ | Futures | 5492.79 | 5496.65 | 5490.42 | 5496.65 | 794.0 |
| 2015-11-11 20:00:00 | NQ | Futures | 5496.35 | 5506.13 | 5496.35 | 5504.65 | 1177.0 |
| 2015-11-11 21:00:00 | NQ | Futures | 5504.95 | 5504.95 | 5499.91 | 5503.17 | 598.0 |
| 2015-11-11 22:00:00 | NQ | Futures | 5503.47 | 5508.51 | 5502.58 | 5507.62 | 618.0 |
| 2015-11-11 23:00:00 | NQ | Futures | 5507.32 | 5510.88 | 5506.73 | 5509.1 | 737.0 |
| 2015-11-11 00:00:00 | YM | Futures | 18783.7 | 18788.0 | 18764.7 | 18766.8 | 973.0 |
| 2015-11-11 01:00:00 | YM | Futures | 18767.9 | 18780.6 | 18765.7 | 18771.0 | 491.0 |
| 2015-11-11 02:00:00 | YM | Futures | 18771.0 | 18771.0 | 18758.3 | 18761.5 | 714.0 |
| 2015-11-11 03:00:00 | YM | Futures | 18762.6 | 18809.2 | 18755.1 | 18807.0 | 2474.0 |
> showing 50 of 1,557 rows — these rows as CSV