PREVIEW / futures_1hour / 2015-06-05
file: by_date/futures_1hour/2015/2015-06-05.parquet size: 43 KB rows: 1,269
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-06-05 00:00:00 | ES | Futures | 2215.95 | 2216.74 | 2215.68 | 2215.95 | 1402.0 |
| 2015-06-05 01:00:00 | ES | Futures | 2215.95 | 2217.0 | 2215.68 | 2215.95 | 2548.0 |
| 2015-06-05 02:00:00 | ES | Futures | 2215.95 | 2217.8 | 2215.42 | 2216.48 | 8448.0 |
| 2015-06-05 03:00:00 | ES | Futures | 2216.74 | 2221.49 | 2214.89 | 2218.06 | 27590.0 |
| 2015-06-05 04:00:00 | ES | Futures | 2218.06 | 2220.44 | 2215.68 | 2216.48 | 20819.0 |
| 2015-06-05 05:00:00 | ES | Futures | 2216.48 | 2218.06 | 2215.16 | 2215.16 | 10519.0 |
| 2015-06-05 06:00:00 | ES | Futures | 2215.16 | 2215.95 | 2209.35 | 2211.46 | 36690.0 |
| 2015-06-05 07:00:00 | ES | Futures | 2211.72 | 2215.42 | 2210.4 | 2213.84 | 42677.0 |
| 2015-06-05 08:00:00 | ES | Futures | 2213.84 | 2215.16 | 2204.06 | 2210.93 | 138071.0 |
| 2015-06-05 09:00:00 | ES | Futures | 2210.67 | 2213.84 | 2201.16 | 2208.55 | 286277.0 |
| 2015-06-05 10:00:00 | ES | Futures | 2208.55 | 2218.33 | 2208.29 | 2211.46 | 250831.0 |
| 2015-06-05 11:00:00 | ES | Futures | 2211.46 | 2214.36 | 2209.61 | 2211.46 | 116561.0 |
| 2015-06-05 12:00:00 | ES | Futures | 2211.46 | 2212.78 | 2206.18 | 2211.99 | 116205.0 |
| 2015-06-05 13:00:00 | ES | Futures | 2211.99 | 2213.57 | 2209.87 | 2210.4 | 73865.0 |
| 2015-06-05 14:00:00 | ES | Futures | 2210.67 | 2213.84 | 2209.61 | 2211.46 | 78312.0 |
| 2015-06-05 15:00:00 | ES | Futures | 2211.46 | 2213.04 | 2207.23 | 2209.87 | 158104.0 |
| 2015-06-05 16:00:00 | ES | Futures | 2209.87 | 2210.93 | 2208.29 | 2209.87 | 66010.0 |
| 2015-06-05 17:00:00 | ES | Futures | 2210.14 | 2210.14 | 2208.82 | 2209.61 | 1408.0 |
| 2015-06-05 00:00:00 | NQ | Futures | 5284.62 | 5285.2 | 5283.15 | 5283.73 | 453.0 |
| 2015-06-05 01:00:00 | NQ | Futures | 5283.73 | 5287.26 | 5283.15 | 5283.44 | 584.0 |
| 2015-06-05 02:00:00 | NQ | Futures | 5283.44 | 5289.32 | 5282.26 | 5285.2 | 877.0 |
| 2015-06-05 03:00:00 | NQ | Futures | 5285.2 | 5300.79 | 5280.79 | 5291.67 | 5026.0 |
| 2015-06-05 04:00:00 | NQ | Futures | 5291.38 | 5297.55 | 5282.85 | 5286.97 | 3793.0 |
| 2015-06-05 05:00:00 | NQ | Futures | 5287.26 | 5293.14 | 5284.03 | 5284.62 | 1767.0 |
| 2015-06-05 06:00:00 | NQ | Futures | 5284.32 | 5285.2 | 5270.79 | 5276.38 | 5026.0 |
| 2015-06-05 07:00:00 | NQ | Futures | 5275.79 | 5284.62 | 5273.15 | 5281.68 | 5050.0 |
| 2015-06-05 08:00:00 | NQ | Futures | 5282.26 | 5284.03 | 5254.62 | 5269.91 | 20442.0 |
| 2015-06-05 09:00:00 | NQ | Futures | 5269.62 | 5281.09 | 5233.45 | 5253.74 | 55823.0 |
| 2015-06-05 10:00:00 | NQ | Futures | 5253.74 | 5285.2 | 5253.15 | 5268.74 | 47159.0 |
| 2015-06-05 11:00:00 | NQ | Futures | 5269.03 | 5280.5 | 5265.5 | 5273.15 | 18161.0 |
| 2015-06-05 12:00:00 | NQ | Futures | 5272.85 | 5273.44 | 5258.74 | 5271.38 | 16440.0 |
| 2015-06-05 13:00:00 | NQ | Futures | 5271.68 | 5276.09 | 5266.38 | 5269.32 | 9605.0 |
| 2015-06-05 14:00:00 | NQ | Futures | 5269.91 | 5278.73 | 5268.44 | 5272.56 | 11811.0 |
| 2015-06-05 15:00:00 | NQ | Futures | 5272.85 | 5276.09 | 5262.56 | 5266.97 | 18589.0 |
| 2015-06-05 16:00:00 | NQ | Futures | 5266.68 | 5272.85 | 5264.03 | 5271.38 | 5868.0 |
| 2015-06-05 17:00:00 | NQ | Futures | 5271.38 | 5271.38 | 5267.85 | 5270.21 | 139.0 |
| 2015-06-05 00:00:00 | YM | Futures | 18783.7 | 18789.0 | 18781.6 | 18783.7 | 214.0 |
| 2015-06-05 01:00:00 | YM | Futures | 18783.7 | 18794.2 | 18782.7 | 18784.8 | 353.0 |
| 2015-06-05 02:00:00 | YM | Futures | 18783.7 | 18796.3 | 18777.4 | 18787.9 | 1070.0 |
| 2015-06-05 03:00:00 | YM | Futures | 18785.8 | 18826.7 | 18769.0 | 18798.4 | 4378.0 |
| 2015-06-05 04:00:00 | YM | Futures | 18798.4 | 18817.3 | 18779.5 | 18789.0 | 2956.0 |
| 2015-06-05 05:00:00 | YM | Futures | 18789.0 | 18801.5 | 18779.5 | 18780.6 | 1828.0 |
| 2015-06-05 06:00:00 | YM | Futures | 18779.5 | 18783.7 | 18731.3 | 18747.0 | 4915.0 |
| 2015-06-05 07:00:00 | YM | Futures | 18747.0 | 18778.5 | 18738.6 | 18768.0 | 11269.0 |
| 2015-06-05 08:00:00 | YM | Futures | 18766.9 | 18775.3 | 18691.4 | 18741.8 | 18765.0 |
| 2015-06-05 09:00:00 | YM | Futures | 18741.8 | 18789.0 | 18674.7 | 18721.8 | 36711.0 |
| 2015-06-05 10:00:00 | YM | Futures | 18722.9 | 18804.7 | 18719.7 | 18744.9 | 29964.0 |
| 2015-06-05 11:00:00 | YM | Futures | 18744.9 | 18766.9 | 18719.7 | 18734.4 | 12470.0 |
| 2015-06-05 12:00:00 | YM | Futures | 18733.4 | 18742.8 | 18692.5 | 18736.5 | 12937.0 |
| 2015-06-05 13:00:00 | YM | Futures | 18736.5 | 18742.8 | 18706.1 | 18712.4 | 9042.0 |
> showing 50 of 1,269 rows — these rows as CSV