PREVIEW / futures_1hour / 2015-04-10
file: by_date/futures_1hour/2015/2015-04-10.parquet size: 41 KB rows: 1,244
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-10 00:00:00 | ES | Futures | 2201.16 | 2202.21 | 2201.16 | 2201.95 | 989.0 |
| 2015-04-10 01:00:00 | ES | Futures | 2201.95 | 2204.59 | 2201.42 | 2203.8 | 4172.0 |
| 2015-04-10 02:00:00 | ES | Futures | 2204.06 | 2205.38 | 2202.21 | 2202.74 | 9375.0 |
| 2015-04-10 03:00:00 | ES | Futures | 2202.74 | 2204.06 | 2200.89 | 2201.69 | 14954.0 |
| 2015-04-10 04:00:00 | ES | Futures | 2201.69 | 2202.21 | 2201.16 | 2201.69 | 6172.0 |
| 2015-04-10 05:00:00 | ES | Futures | 2201.69 | 2203.8 | 2200.89 | 2203.53 | 8114.0 |
| 2015-04-10 06:00:00 | ES | Futures | 2203.27 | 2207.5 | 2203.27 | 2205.65 | 16066.0 |
| 2015-04-10 07:00:00 | ES | Futures | 2205.38 | 2208.55 | 2205.12 | 2206.97 | 17497.0 |
| 2015-04-10 08:00:00 | ES | Futures | 2206.97 | 2207.23 | 2205.12 | 2205.12 | 14728.0 |
| 2015-04-10 09:00:00 | ES | Futures | 2205.38 | 2206.7 | 2202.21 | 2204.86 | 168187.0 |
| 2015-04-10 10:00:00 | ES | Futures | 2204.86 | 2211.46 | 2204.86 | 2209.61 | 160980.0 |
| 2015-04-10 11:00:00 | ES | Futures | 2209.61 | 2213.04 | 2209.35 | 2210.67 | 82910.0 |
| 2015-04-10 12:00:00 | ES | Futures | 2210.93 | 2212.51 | 2210.4 | 2211.72 | 48788.0 |
| 2015-04-10 13:00:00 | ES | Futures | 2211.72 | 2212.78 | 2209.61 | 2211.99 | 50903.0 |
| 2015-04-10 14:00:00 | ES | Futures | 2211.99 | 2214.36 | 2210.4 | 2213.04 | 73944.0 |
| 2015-04-10 15:00:00 | ES | Futures | 2213.04 | 2213.84 | 2210.4 | 2213.57 | 119709.0 |
| 2015-04-10 16:00:00 | ES | Futures | 2213.84 | 2214.36 | 2213.04 | 2213.84 | 65962.0 |
| 2015-04-10 17:00:00 | ES | Futures | 2213.84 | 2214.63 | 2213.57 | 2214.1 | 1125.0 |
| 2015-04-10 00:00:00 | NQ | Futures | 5170.52 | 5172.87 | 5170.52 | 5171.99 | 217.0 |
| 2015-04-10 01:00:00 | NQ | Futures | 5172.28 | 5176.99 | 5169.93 | 5174.34 | 560.0 |
| 2015-04-10 02:00:00 | NQ | Futures | 5174.34 | 5177.87 | 5171.4 | 5172.28 | 1002.0 |
| 2015-04-10 03:00:00 | NQ | Futures | 5173.17 | 5177.87 | 5169.93 | 5171.99 | 1672.0 |
| 2015-04-10 04:00:00 | NQ | Futures | 5171.99 | 5172.28 | 5168.46 | 5169.93 | 721.0 |
| 2015-04-10 05:00:00 | NQ | Futures | 5169.93 | 5174.05 | 5167.58 | 5173.46 | 1005.0 |
| 2015-04-10 06:00:00 | NQ | Futures | 5173.46 | 5179.93 | 5173.17 | 5174.05 | 2171.0 |
| 2015-04-10 07:00:00 | NQ | Futures | 5173.75 | 5179.64 | 5172.58 | 5175.52 | 1973.0 |
| 2015-04-10 08:00:00 | NQ | Futures | 5175.52 | 5176.69 | 5172.28 | 5172.58 | 2836.0 |
| 2015-04-10 09:00:00 | NQ | Futures | 5172.87 | 5176.99 | 5158.76 | 5169.93 | 30854.0 |
| 2015-04-10 10:00:00 | NQ | Futures | 5170.23 | 5183.16 | 5169.34 | 5180.52 | 24627.0 |
| 2015-04-10 11:00:00 | NQ | Futures | 5180.52 | 5186.4 | 5179.05 | 5182.28 | 11795.0 |
| 2015-04-10 12:00:00 | NQ | Futures | 5182.58 | 5189.05 | 5180.81 | 5185.81 | 7118.0 |
| 2015-04-10 13:00:00 | NQ | Futures | 5186.1 | 5190.81 | 5181.69 | 5190.22 | 6327.0 |
| 2015-04-10 14:00:00 | NQ | Futures | 5190.22 | 5194.34 | 5186.69 | 5191.4 | 10471.0 |
| 2015-04-10 15:00:00 | NQ | Futures | 5191.4 | 5194.04 | 5185.81 | 5193.46 | 15898.0 |
| 2015-04-10 16:00:00 | NQ | Futures | 5193.16 | 5194.34 | 5189.93 | 5192.57 | 4942.0 |
| 2015-04-10 17:00:00 | NQ | Futures | 5192.57 | 5193.75 | 5192.28 | 5193.75 | 61.0 |
| 2015-04-10 00:00:00 | YM | Futures | 18736.5 | 18744.9 | 18736.5 | 18743.9 | 469.0 |
| 2015-04-10 01:00:00 | YM | Futures | 18743.9 | 18762.7 | 18738.6 | 18753.3 | 575.0 |
| 2015-04-10 02:00:00 | YM | Futures | 18754.4 | 18769.0 | 18746.0 | 18749.1 | 1249.0 |
| 2015-04-10 03:00:00 | YM | Futures | 18751.2 | 18760.6 | 18734.4 | 18741.8 | 1692.0 |
| 2015-04-10 04:00:00 | YM | Futures | 18740.7 | 18741.8 | 18734.4 | 18737.6 | 1025.0 |
| 2015-04-10 05:00:00 | YM | Futures | 18738.6 | 18760.6 | 18731.3 | 18757.5 | 1804.0 |
| 2015-04-10 06:00:00 | YM | Futures | 18757.5 | 18807.8 | 18755.4 | 18785.8 | 3408.0 |
| 2015-04-10 07:00:00 | YM | Futures | 18784.8 | 18806.8 | 18779.5 | 18795.3 | 2392.0 |
| 2015-04-10 08:00:00 | YM | Futures | 18794.2 | 18796.3 | 18777.4 | 18779.5 | 1961.0 |
| 2015-04-10 09:00:00 | YM | Futures | 18779.5 | 18793.2 | 18729.2 | 18764.8 | 21044.0 |
| 2015-04-10 10:00:00 | YM | Futures | 18764.8 | 18826.7 | 18763.8 | 18811.0 | 15395.0 |
| 2015-04-10 11:00:00 | YM | Futures | 18811.0 | 18851.9 | 18806.8 | 18823.6 | 8703.0 |
| 2015-04-10 12:00:00 | YM | Futures | 18824.6 | 18836.1 | 18816.2 | 18832.0 | 3925.0 |
| 2015-04-10 13:00:00 | YM | Futures | 18833.0 | 18850.8 | 18820.4 | 18842.4 | 4676.0 |
> showing 50 of 1,244 rows — these rows as CSV