PREVIEW / futures_1hour / 2015-08-03
file: by_date/futures_1hour/2015/2015-08-03.parquet size: 50 KB rows: 1,536
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-08-03 00:00:00 | ES | Futures | 2233.29 | 2233.56 | 2232.23 | 2233.29 | 884.0 |
| 2015-08-03 01:00:00 | ES | Futures | 2233.29 | 2233.82 | 2231.69 | 2231.96 | 2675.0 |
| 2015-08-03 02:00:00 | ES | Futures | 2232.23 | 2233.29 | 2230.36 | 2233.29 | 6932.0 |
| 2015-08-03 03:00:00 | ES | Futures | 2233.29 | 2239.15 | 2229.56 | 2237.82 | 29009.0 |
| 2015-08-03 04:00:00 | ES | Futures | 2237.82 | 2238.62 | 2229.03 | 2233.29 | 27159.0 |
| 2015-08-03 05:00:00 | ES | Futures | 2233.56 | 2235.95 | 2231.16 | 2232.23 | 13934.0 |
| 2015-08-03 06:00:00 | ES | Futures | 2232.23 | 2235.42 | 2231.96 | 2234.36 | 10323.0 |
| 2015-08-03 07:00:00 | ES | Futures | 2234.36 | 2236.22 | 2233.29 | 2233.56 | 15408.0 |
| 2015-08-03 08:00:00 | ES | Futures | 2233.56 | 2236.22 | 2232.76 | 2233.02 | 21760.0 |
| 2015-08-03 09:00:00 | ES | Futures | 2233.29 | 2236.49 | 2227.17 | 2232.49 | 169755.0 |
| 2015-08-03 10:00:00 | ES | Futures | 2232.76 | 2233.82 | 2225.3 | 2230.36 | 224486.0 |
| 2015-08-03 11:00:00 | ES | Futures | 2230.1 | 2234.36 | 2229.3 | 2231.43 | 118534.0 |
| 2015-08-03 12:00:00 | ES | Futures | 2231.16 | 2231.96 | 2217.85 | 2218.91 | 181345.0 |
| 2015-08-03 13:00:00 | ES | Futures | 2218.91 | 2221.31 | 2215.19 | 2219.45 | 192974.0 |
| 2015-08-03 14:00:00 | ES | Futures | 2219.18 | 2221.04 | 2215.72 | 2217.85 | 174445.0 |
| 2015-08-03 15:00:00 | ES | Futures | 2217.85 | 2227.7 | 2217.32 | 2226.9 | 231689.0 |
| 2015-08-03 16:00:00 | ES | Futures | 2226.9 | 2227.97 | 2225.57 | 2227.17 | 67495.0 |
| 2015-08-03 17:00:00 | ES | Futures | 2227.17 | 2227.43 | 2226.37 | 2226.9 | 1240.0 |
| 2015-08-03 18:00:00 | ES | Futures | 2226.37 | 2226.9 | 2225.04 | 2226.37 | 3852.0 |
| 2015-08-03 19:00:00 | ES | Futures | 2226.63 | 2226.63 | 2222.64 | 2223.71 | 3530.0 |
| 2015-08-03 20:00:00 | ES | Futures | 2223.17 | 2224.24 | 2222.37 | 2223.97 | 3363.0 |
| 2015-08-03 21:00:00 | ES | Futures | 2223.71 | 2226.37 | 2223.17 | 2225.3 | 3074.0 |
| 2015-08-03 22:00:00 | ES | Futures | 2225.3 | 2226.37 | 2224.77 | 2225.57 | 1830.0 |
| 2015-08-03 23:00:00 | ES | Futures | 2225.57 | 2226.37 | 2224.77 | 2225.04 | 1814.0 |
| 2015-08-03 00:00:00 | NQ | Futures | 5416.5 | 5416.79 | 5413.83 | 5416.79 | 199.0 |
| 2015-08-03 01:00:00 | NQ | Futures | 5416.5 | 5417.68 | 5412.35 | 5412.35 | 578.0 |
| 2015-08-03 02:00:00 | NQ | Futures | 5412.35 | 5417.09 | 5409.99 | 5417.09 | 1073.0 |
| 2015-08-03 03:00:00 | NQ | Futures | 5417.38 | 5430.69 | 5404.96 | 5428.33 | 4172.0 |
| 2015-08-03 04:00:00 | NQ | Futures | 5428.62 | 5430.4 | 5405.85 | 5418.57 | 4388.0 |
| 2015-08-03 05:00:00 | NQ | Futures | 5418.27 | 5425.96 | 5413.24 | 5417.09 | 1607.0 |
| 2015-08-03 06:00:00 | NQ | Futures | 5417.09 | 5427.74 | 5417.09 | 5424.48 | 1463.0 |
| 2015-08-03 07:00:00 | NQ | Futures | 5424.48 | 5428.33 | 5420.64 | 5421.52 | 1267.0 |
| 2015-08-03 08:00:00 | NQ | Futures | 5421.52 | 5428.62 | 5419.45 | 5422.41 | 2566.0 |
| 2015-08-03 09:00:00 | NQ | Futures | 5423.0 | 5441.64 | 5419.16 | 5436.91 | 34405.0 |
| 2015-08-03 10:00:00 | NQ | Futures | 5436.91 | 5437.79 | 5407.62 | 5418.27 | 40702.0 |
| 2015-08-03 11:00:00 | NQ | Futures | 5418.57 | 5435.13 | 5416.5 | 5430.1 | 20533.0 |
| 2015-08-03 12:00:00 | NQ | Futures | 5429.81 | 5431.88 | 5377.75 | 5383.07 | 32561.0 |
| 2015-08-03 13:00:00 | NQ | Futures | 5382.78 | 5397.27 | 5372.13 | 5391.06 | 33276.0 |
| 2015-08-03 14:00:00 | NQ | Futures | 5390.76 | 5398.45 | 5381.3 | 5389.58 | 26132.0 |
| 2015-08-03 15:00:00 | NQ | Futures | 5389.28 | 5411.47 | 5384.85 | 5409.99 | 35025.0 |
| 2015-08-03 16:00:00 | NQ | Futures | 5409.69 | 5414.72 | 5407.33 | 5410.88 | 7833.0 |
| 2015-08-03 17:00:00 | NQ | Futures | 5411.17 | 5411.47 | 5409.4 | 5411.47 | 172.0 |
| 2015-08-03 18:00:00 | NQ | Futures | 5407.62 | 5407.62 | 5402.59 | 5407.62 | 920.0 |
| 2015-08-03 19:00:00 | NQ | Futures | 5407.03 | 5407.03 | 5398.16 | 5400.23 | 762.0 |
| 2015-08-03 20:00:00 | NQ | Futures | 5399.93 | 5403.19 | 5398.16 | 5402.3 | 798.0 |
| 2015-08-03 21:00:00 | NQ | Futures | 5402.59 | 5409.1 | 5400.82 | 5406.44 | 605.0 |
| 2015-08-03 22:00:00 | NQ | Futures | 5406.14 | 5408.21 | 5404.37 | 5405.85 | 414.0 |
| 2015-08-03 23:00:00 | NQ | Futures | 5406.14 | 5408.51 | 5404.37 | 5404.96 | 376.0 |
| 2015-08-03 00:00:00 | YM | Futures | 18552.5 | 18555.6 | 18549.3 | 18555.6 | 180.0 |
| 2015-08-03 01:00:00 | YM | Futures | 18554.6 | 18560.9 | 18545.1 | 18546.2 | 353.0 |
> showing 50 of 1,536 rows — these rows as CSV