PREVIEW / futures_1hour / 2015-04-21
file: by_date/futures_1hour/2015/2015-04-21.parquet size: 50 KB rows: 1,570
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-04-21 00:00:00 | ES | Futures | 2214.36 | 2214.36 | 2212.78 | 2213.04 | 1287.0 |
| 2015-04-21 01:00:00 | ES | Futures | 2212.78 | 2215.68 | 2212.78 | 2214.89 | 3758.0 |
| 2015-04-21 02:00:00 | ES | Futures | 2214.89 | 2218.85 | 2214.63 | 2218.33 | 14638.0 |
| 2015-04-21 03:00:00 | ES | Futures | 2218.33 | 2224.14 | 2218.06 | 2223.08 | 33700.0 |
| 2015-04-21 04:00:00 | ES | Futures | 2223.08 | 2223.61 | 2219.38 | 2220.17 | 17056.0 |
| 2015-04-21 05:00:00 | ES | Futures | 2220.17 | 2221.23 | 2213.57 | 2217.8 | 26410.0 |
| 2015-04-21 06:00:00 | ES | Futures | 2217.8 | 2219.65 | 2215.95 | 2216.74 | 12188.0 |
| 2015-04-21 07:00:00 | ES | Futures | 2216.74 | 2220.17 | 2215.68 | 2218.85 | 16319.0 |
| 2015-04-21 08:00:00 | ES | Futures | 2218.85 | 2219.65 | 2217.27 | 2219.38 | 18193.0 |
| 2015-04-21 09:00:00 | ES | Futures | 2219.65 | 2222.29 | 2213.31 | 2214.1 | 190171.0 |
| 2015-04-21 10:00:00 | ES | Futures | 2214.1 | 2216.21 | 2209.61 | 2211.99 | 183960.0 |
| 2015-04-21 11:00:00 | ES | Futures | 2211.99 | 2214.89 | 2207.76 | 2209.61 | 119865.0 |
| 2015-04-21 12:00:00 | ES | Futures | 2209.61 | 2211.46 | 2208.29 | 2210.14 | 54277.0 |
| 2015-04-21 13:00:00 | ES | Futures | 2210.4 | 2212.78 | 2207.23 | 2207.23 | 60807.0 |
| 2015-04-21 14:00:00 | ES | Futures | 2207.23 | 2211.99 | 2205.12 | 2210.67 | 93490.0 |
| 2015-04-21 15:00:00 | ES | Futures | 2210.93 | 2211.19 | 2207.23 | 2209.35 | 124753.0 |
| 2015-04-21 16:00:00 | ES | Futures | 2209.08 | 2210.14 | 2208.02 | 2209.61 | 49086.0 |
| 2015-04-21 17:00:00 | ES | Futures | 2209.87 | 2210.14 | 2209.35 | 2209.87 | 955.0 |
| 2015-04-21 18:00:00 | ES | Futures | 2210.14 | 2211.99 | 2210.14 | 2211.19 | 2764.0 |
| 2015-04-21 19:00:00 | ES | Futures | 2211.19 | 2211.99 | 2210.67 | 2211.46 | 1242.0 |
| 2015-04-21 20:00:00 | ES | Futures | 2211.19 | 2211.99 | 2209.87 | 2211.72 | 4016.0 |
| 2015-04-21 21:00:00 | ES | Futures | 2211.72 | 2212.78 | 2210.67 | 2211.46 | 3373.0 |
| 2015-04-21 22:00:00 | ES | Futures | 2211.46 | 2212.51 | 2210.67 | 2211.46 | 2224.0 |
| 2015-04-21 23:00:00 | ES | Futures | 2211.46 | 2211.99 | 2210.4 | 2210.93 | 1869.0 |
| 2015-04-21 00:00:00 | NQ | Futures | 5196.1 | 5196.69 | 5192.87 | 5193.16 | 339.0 |
| 2015-04-21 01:00:00 | NQ | Futures | 5193.16 | 5199.93 | 5192.87 | 5197.87 | 865.0 |
| 2015-04-21 02:00:00 | NQ | Futures | 5198.16 | 5209.04 | 5198.16 | 5207.28 | 2078.0 |
| 2015-04-21 03:00:00 | NQ | Futures | 5207.87 | 5223.74 | 5207.28 | 5221.98 | 4818.0 |
| 2015-04-21 04:00:00 | NQ | Futures | 5221.69 | 5222.57 | 5212.57 | 5212.86 | 3203.0 |
| 2015-04-21 05:00:00 | NQ | Futures | 5212.86 | 5214.04 | 5195.22 | 5207.57 | 5442.0 |
| 2015-04-21 06:00:00 | NQ | Futures | 5207.57 | 5211.69 | 5201.4 | 5202.87 | 2592.0 |
| 2015-04-21 07:00:00 | NQ | Futures | 5203.16 | 5212.86 | 5201.1 | 5208.16 | 3563.0 |
| 2015-04-21 08:00:00 | NQ | Futures | 5208.16 | 5214.92 | 5205.81 | 5214.04 | 4934.0 |
| 2015-04-21 09:00:00 | NQ | Futures | 5214.33 | 5225.8 | 5202.87 | 5207.57 | 41748.0 |
| 2015-04-21 10:00:00 | NQ | Futures | 5208.16 | 5217.28 | 5202.28 | 5209.04 | 33534.0 |
| 2015-04-21 11:00:00 | NQ | Futures | 5209.04 | 5216.39 | 5205.22 | 5208.45 | 18238.0 |
| 2015-04-21 12:00:00 | NQ | Futures | 5208.75 | 5214.63 | 5205.51 | 5211.69 | 9246.0 |
| 2015-04-21 13:00:00 | NQ | Futures | 5211.69 | 5220.8 | 5209.63 | 5209.63 | 11289.0 |
| 2015-04-21 14:00:00 | NQ | Futures | 5209.63 | 5219.63 | 5203.45 | 5216.39 | 15436.0 |
| 2015-04-21 15:00:00 | NQ | Futures | 5216.39 | 5217.57 | 5206.98 | 5208.75 | 22271.0 |
| 2015-04-21 16:00:00 | NQ | Futures | 5208.45 | 5212.57 | 5206.69 | 5211.39 | 6714.0 |
| 2015-04-21 17:00:00 | NQ | Futures | 5211.1 | 5211.98 | 5211.1 | 5211.69 | 155.0 |
| 2015-04-21 18:00:00 | NQ | Futures | 5214.33 | 5218.75 | 5213.16 | 5215.22 | 633.0 |
| 2015-04-21 19:00:00 | NQ | Futures | 5215.22 | 5216.98 | 5215.22 | 5216.1 | 212.0 |
| 2015-04-21 20:00:00 | NQ | Futures | 5216.69 | 5217.86 | 5213.45 | 5216.98 | 577.0 |
| 2015-04-21 21:00:00 | NQ | Futures | 5216.98 | 5219.04 | 5213.75 | 5215.22 | 568.0 |
| 2015-04-21 22:00:00 | NQ | Futures | 5215.8 | 5218.45 | 5214.33 | 5215.51 | 459.0 |
| 2015-04-21 23:00:00 | NQ | Futures | 5215.51 | 5217.57 | 5213.75 | 5214.92 | 440.0 |
| 2015-04-21 00:00:00 | YM | Futures | 18865.5 | 18868.7 | 18852.9 | 18855.0 | 601.0 |
| 2015-04-21 01:00:00 | YM | Futures | 18854.0 | 18879.1 | 18851.9 | 18869.7 | 873.0 |
> showing 50 of 1,570 rows — these rows as CSV