PREVIEW / futures_1hour / 2015-04-24
file: by_date/futures_1hour/2015/2015-04-24.parquet size: 44 KB rows: 1,301
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-24 00:00:00 | ES | Futures | 2226.78 | 2227.04 | 2225.46 | 2225.46 | 1918.0 |
| 2015-04-24 01:00:00 | ES | Futures | 2225.46 | 2225.72 | 2221.76 | 2222.29 | 8344.0 |
| 2015-04-24 02:00:00 | ES | Futures | 2222.55 | 2226.78 | 2222.29 | 2225.46 | 9134.0 |
| 2015-04-24 03:00:00 | ES | Futures | 2225.46 | 2228.1 | 2223.34 | 2225.46 | 24275.0 |
| 2015-04-24 04:00:00 | ES | Futures | 2225.72 | 2232.59 | 2225.19 | 2231.53 | 29711.0 |
| 2015-04-24 05:00:00 | ES | Futures | 2231.8 | 2232.06 | 2227.31 | 2227.57 | 16278.0 |
| 2015-04-24 06:00:00 | ES | Futures | 2227.83 | 2229.15 | 2224.4 | 2228.1 | 22848.0 |
| 2015-04-24 07:00:00 | ES | Futures | 2228.1 | 2230.21 | 2226.78 | 2228.36 | 12186.0 |
| 2015-04-24 08:00:00 | ES | Futures | 2228.36 | 2230.74 | 2226.51 | 2230.21 | 25972.0 |
| 2015-04-24 09:00:00 | ES | Futures | 2229.95 | 2232.32 | 2224.93 | 2229.68 | 188860.0 |
| 2015-04-24 10:00:00 | ES | Futures | 2229.68 | 2229.95 | 2224.93 | 2228.89 | 120608.0 |
| 2015-04-24 11:00:00 | ES | Futures | 2228.89 | 2232.32 | 2228.1 | 2230.21 | 91538.0 |
| 2015-04-24 12:00:00 | ES | Futures | 2230.47 | 2234.17 | 2230.21 | 2231.53 | 76003.0 |
| 2015-04-24 13:00:00 | ES | Futures | 2231.53 | 2233.12 | 2229.95 | 2231.53 | 49674.0 |
| 2015-04-24 14:00:00 | ES | Futures | 2231.8 | 2232.59 | 2228.1 | 2229.15 | 79062.0 |
| 2015-04-24 15:00:00 | ES | Futures | 2228.89 | 2231.27 | 2228.1 | 2230.47 | 121731.0 |
| 2015-04-24 16:00:00 | ES | Futures | 2230.47 | 2231.8 | 2230.21 | 2231.8 | 52848.0 |
| 2015-04-24 17:00:00 | ES | Futures | 2231.8 | 2232.06 | 2231.0 | 2231.0 | 2024.0 |
| 2015-04-24 00:00:00 | NQ | Futures | 5292.56 | 5293.44 | 5287.85 | 5288.14 | 449.0 |
| 2015-04-24 01:00:00 | NQ | Futures | 5288.14 | 5288.14 | 5281.97 | 5282.56 | 1050.0 |
| 2015-04-24 02:00:00 | NQ | Futures | 5282.85 | 5291.67 | 5282.26 | 5290.79 | 1672.0 |
| 2015-04-24 03:00:00 | NQ | Futures | 5290.79 | 5301.08 | 5287.56 | 5297.55 | 6090.0 |
| 2015-04-24 04:00:00 | NQ | Futures | 5297.26 | 5310.49 | 5297.26 | 5307.55 | 5078.0 |
| 2015-04-24 05:00:00 | NQ | Futures | 5307.85 | 5308.14 | 5301.08 | 5302.26 | 2582.0 |
| 2015-04-24 06:00:00 | NQ | Futures | 5301.97 | 5307.55 | 5296.97 | 5302.85 | 5322.0 |
| 2015-04-24 07:00:00 | NQ | Futures | 5302.85 | 5307.55 | 5298.14 | 5305.2 | 4042.0 |
| 2015-04-24 08:00:00 | NQ | Futures | 5304.91 | 5309.91 | 5302.55 | 5308.14 | 7509.0 |
| 2015-04-24 09:00:00 | NQ | Futures | 5308.14 | 5321.67 | 5306.08 | 5317.55 | 52029.0 |
| 2015-04-24 10:00:00 | NQ | Futures | 5317.55 | 5322.55 | 5303.73 | 5319.61 | 29539.0 |
| 2015-04-24 11:00:00 | NQ | Futures | 5319.9 | 5328.14 | 5316.67 | 5324.9 | 18719.0 |
| 2015-04-24 12:00:00 | NQ | Futures | 5325.2 | 5335.78 | 5324.31 | 5327.25 | 14696.0 |
| 2015-04-24 13:00:00 | NQ | Futures | 5327.55 | 5332.25 | 5323.43 | 5325.2 | 8990.0 |
| 2015-04-24 14:00:00 | NQ | Futures | 5324.9 | 5335.49 | 5324.31 | 5327.84 | 15311.0 |
| 2015-04-24 15:00:00 | NQ | Futures | 5327.55 | 5332.55 | 5324.02 | 5327.25 | 20834.0 |
| 2015-04-24 16:00:00 | NQ | Futures | 5326.96 | 5329.61 | 5324.61 | 5328.73 | 4678.0 |
| 2015-04-24 17:00:00 | NQ | Futures | 5328.73 | 5334.31 | 5328.14 | 5328.14 | 554.0 |
| 2015-04-24 00:00:00 | YM | Futures | 18859.2 | 18861.3 | 18848.7 | 18852.9 | 589.0 |
| 2015-04-24 01:00:00 | YM | Futures | 18854.0 | 18854.0 | 18816.2 | 18821.5 | 1735.0 |
| 2015-04-24 02:00:00 | YM | Futures | 18822.5 | 18865.5 | 18821.5 | 18851.9 | 2153.0 |
| 2015-04-24 03:00:00 | YM | Futures | 18854.0 | 18874.9 | 18835.1 | 18855.0 | 4108.0 |
| 2015-04-24 04:00:00 | YM | Futures | 18857.1 | 18914.8 | 18855.0 | 18908.5 | 5008.0 |
| 2015-04-24 05:00:00 | YM | Futures | 18908.5 | 18910.6 | 18866.6 | 18869.7 | 2110.0 |
| 2015-04-24 06:00:00 | YM | Futures | 18870.8 | 18881.2 | 18843.5 | 18870.8 | 3731.0 |
| 2015-04-24 07:00:00 | YM | Futures | 18871.8 | 18885.4 | 18859.2 | 18870.8 | 1640.0 |
| 2015-04-24 08:00:00 | YM | Futures | 18869.7 | 18885.4 | 18851.9 | 18873.9 | 3176.0 |
| 2015-04-24 09:00:00 | YM | Futures | 18874.9 | 18893.8 | 18804.7 | 18860.3 | 20253.0 |
| 2015-04-24 10:00:00 | YM | Futures | 18862.4 | 18873.9 | 18823.6 | 18859.2 | 13248.0 |
| 2015-04-24 11:00:00 | YM | Futures | 18859.2 | 18892.8 | 18851.9 | 18872.9 | 7640.0 |
| 2015-04-24 12:00:00 | YM | Futures | 18873.9 | 18913.8 | 18871.8 | 18888.6 | 6803.0 |
| 2015-04-24 13:00:00 | YM | Futures | 18890.7 | 18902.2 | 18878.1 | 18893.8 | 4712.0 |
> showing 50 of 1,301 rows — these rows as CSV