PREVIEW / futures_1hour / 2015-10-30
file: by_date/futures_1hour/2015/2015-10-30.parquet size: 45 KB rows: 1,314
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-10-30 00:00:00 | ES | Futures | 2237.21 | 2242.02 | 2236.67 | 2240.95 | 14535.0 |
| 2015-10-30 01:00:00 | ES | Futures | 2240.95 | 2242.02 | 2238.28 | 2239.08 | 7713.0 |
| 2015-10-30 02:00:00 | ES | Futures | 2238.81 | 2239.35 | 2236.94 | 2238.01 | 4768.0 |
| 2015-10-30 03:00:00 | ES | Futures | 2238.01 | 2240.15 | 2236.41 | 2237.21 | 9971.0 |
| 2015-10-30 04:00:00 | ES | Futures | 2236.94 | 2238.28 | 2235.07 | 2236.67 | 19007.0 |
| 2015-10-30 05:00:00 | ES | Futures | 2236.67 | 2237.21 | 2233.46 | 2233.46 | 16837.0 |
| 2015-10-30 06:00:00 | ES | Futures | 2233.46 | 2234.0 | 2229.98 | 2232.39 | 20822.0 |
| 2015-10-30 07:00:00 | ES | Futures | 2232.12 | 2232.93 | 2230.79 | 2232.12 | 13129.0 |
| 2015-10-30 08:00:00 | ES | Futures | 2232.12 | 2235.07 | 2231.86 | 2234.0 | 23180.0 |
| 2015-10-30 09:00:00 | ES | Futures | 2234.26 | 2234.26 | 2225.43 | 2226.77 | 188591.0 |
| 2015-10-30 10:00:00 | ES | Futures | 2226.77 | 2229.18 | 2223.56 | 2227.31 | 246264.0 |
| 2015-10-30 11:00:00 | ES | Futures | 2227.31 | 2228.91 | 2224.36 | 2227.58 | 147976.0 |
| 2015-10-30 12:00:00 | ES | Futures | 2227.31 | 2233.73 | 2225.7 | 2232.66 | 162947.0 |
| 2015-10-30 13:00:00 | ES | Futures | 2232.39 | 2235.07 | 2231.05 | 2232.66 | 98074.0 |
| 2015-10-30 14:00:00 | ES | Futures | 2232.93 | 2234.0 | 2223.56 | 2224.1 | 135880.0 |
| 2015-10-30 15:00:00 | ES | Futures | 2223.83 | 2228.38 | 2217.41 | 2217.94 | 445064.0 |
| 2015-10-30 16:00:00 | ES | Futures | 2217.94 | 2220.62 | 2215.27 | 2219.82 | 140562.0 |
| 2015-10-30 00:00:00 | NQ | Futures | 5552.98 | 5561.88 | 5551.79 | 5560.69 | 2251.0 |
| 2015-10-30 01:00:00 | NQ | Futures | 5560.39 | 5562.47 | 5553.57 | 5555.95 | 1381.0 |
| 2015-10-30 02:00:00 | NQ | Futures | 5555.95 | 5557.72 | 5552.39 | 5553.87 | 813.0 |
| 2015-10-30 03:00:00 | NQ | Futures | 5553.28 | 5561.88 | 5549.42 | 5552.98 | 1738.0 |
| 2015-10-30 04:00:00 | NQ | Futures | 5552.68 | 5557.13 | 5547.35 | 5550.02 | 2268.0 |
| 2015-10-30 05:00:00 | NQ | Futures | 5549.72 | 5550.31 | 5539.93 | 5540.53 | 2228.0 |
| 2015-10-30 06:00:00 | NQ | Futures | 5540.82 | 5541.42 | 5529.26 | 5535.19 | 3197.0 |
| 2015-10-30 07:00:00 | NQ | Futures | 5535.49 | 5536.67 | 5531.63 | 5535.19 | 1521.0 |
| 2015-10-30 08:00:00 | NQ | Futures | 5535.19 | 5543.2 | 5534.3 | 5539.93 | 3461.0 |
| 2015-10-30 09:00:00 | NQ | Futures | 5539.93 | 5541.42 | 5527.48 | 5534.6 | 26016.0 |
| 2015-10-30 10:00:00 | NQ | Futures | 5534.6 | 5539.93 | 5524.52 | 5530.45 | 33611.0 |
| 2015-10-30 11:00:00 | NQ | Futures | 5530.74 | 5531.93 | 5519.77 | 5526.0 | 24453.0 |
| 2015-10-30 12:00:00 | NQ | Futures | 5525.7 | 5540.53 | 5518.59 | 5535.78 | 19896.0 |
| 2015-10-30 13:00:00 | NQ | Futures | 5535.49 | 5540.82 | 5533.41 | 5536.38 | 11149.0 |
| 2015-10-30 14:00:00 | NQ | Futures | 5536.08 | 5538.75 | 5511.77 | 5513.25 | 17142.0 |
| 2015-10-30 15:00:00 | NQ | Futures | 5513.55 | 5526.59 | 5503.47 | 5504.65 | 38132.0 |
| 2015-10-30 16:00:00 | NQ | Futures | 5504.65 | 5512.66 | 5498.13 | 5508.8 | 11557.0 |
| 2015-10-30 00:00:00 | YM | Futures | 18789.0 | 18818.7 | 18784.8 | 18816.6 | 1773.0 |
| 2015-10-30 01:00:00 | YM | Futures | 18814.5 | 18821.9 | 18797.5 | 18803.9 | 1043.0 |
| 2015-10-30 02:00:00 | YM | Futures | 18804.9 | 18806.0 | 18785.9 | 18793.3 | 876.0 |
| 2015-10-30 03:00:00 | YM | Futures | 18791.2 | 18808.1 | 18780.6 | 18788.0 | 1283.0 |
| 2015-10-30 04:00:00 | YM | Futures | 18785.9 | 18793.3 | 18767.9 | 18779.5 | 2049.0 |
| 2015-10-30 05:00:00 | YM | Futures | 18780.6 | 18783.7 | 18754.1 | 18760.4 | 1449.0 |
| 2015-10-30 06:00:00 | YM | Futures | 18760.4 | 18764.7 | 18734.0 | 18754.1 | 2166.0 |
| 2015-10-30 07:00:00 | YM | Futures | 18754.1 | 18756.2 | 18738.2 | 18753.0 | 1184.0 |
| 2015-10-30 08:00:00 | YM | Futures | 18753.0 | 18776.3 | 18747.7 | 18773.1 | 2529.0 |
| 2015-10-30 09:00:00 | YM | Futures | 18774.2 | 18774.2 | 18695.8 | 18709.6 | 16599.0 |
| 2015-10-30 10:00:00 | YM | Futures | 18709.6 | 18730.8 | 18693.7 | 18722.3 | 15549.0 |
| 2015-10-30 11:00:00 | YM | Futures | 18723.4 | 18727.6 | 18692.6 | 18719.1 | 9832.0 |
| 2015-10-30 12:00:00 | YM | Futures | 18718.1 | 18765.7 | 18708.5 | 18759.4 | 10660.0 |
| 2015-10-30 13:00:00 | YM | Futures | 18759.4 | 18770.0 | 18745.6 | 18755.1 | 6488.0 |
| 2015-10-30 14:00:00 | YM | Futures | 18755.1 | 18762.6 | 18674.6 | 18678.9 | 9598.0 |
| 2015-10-30 15:00:00 | YM | Futures | 18678.9 | 18709.6 | 18623.8 | 18627.0 | 21817.0 |
> showing 50 of 1,314 rows — these rows as CSV