PREVIEW / futures_1hour / 2015-11-20
file: by_date/futures_1hour/2015/2015-11-20.parquet size: 43 KB rows: 1,300
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-11-20 00:00:00 | ES | Futures | 2224.36 | 2225.17 | 2223.83 | 2224.9 | 2677.0 |
| 2015-11-20 01:00:00 | ES | Futures | 2224.9 | 2226.24 | 2224.63 | 2225.97 | 3390.0 |
| 2015-11-20 02:00:00 | ES | Futures | 2225.97 | 2231.86 | 2224.36 | 2231.59 | 12005.0 |
| 2015-11-20 03:00:00 | ES | Futures | 2231.86 | 2232.39 | 2225.97 | 2227.31 | 24652.0 |
| 2015-11-20 04:00:00 | ES | Futures | 2227.31 | 2228.91 | 2224.1 | 2227.31 | 20269.0 |
| 2015-11-20 05:00:00 | ES | Futures | 2227.31 | 2229.98 | 2225.97 | 2229.98 | 11116.0 |
| 2015-11-20 06:00:00 | ES | Futures | 2229.98 | 2230.52 | 2229.18 | 2229.72 | 7016.0 |
| 2015-11-20 07:00:00 | ES | Futures | 2229.72 | 2232.12 | 2229.72 | 2231.86 | 13724.0 |
| 2015-11-20 08:00:00 | ES | Futures | 2231.86 | 2233.73 | 2231.32 | 2233.46 | 23719.0 |
| 2015-11-20 09:00:00 | ES | Futures | 2233.46 | 2240.69 | 2230.79 | 2239.62 | 261719.0 |
| 2015-11-20 10:00:00 | ES | Futures | 2239.88 | 2241.76 | 2235.6 | 2236.14 | 232098.0 |
| 2015-11-20 11:00:00 | ES | Futures | 2236.14 | 2239.08 | 2234.26 | 2235.07 | 135216.0 |
| 2015-11-20 12:00:00 | ES | Futures | 2235.07 | 2236.67 | 2232.93 | 2234.8 | 82959.0 |
| 2015-11-20 13:00:00 | ES | Futures | 2234.8 | 2237.21 | 2231.59 | 2233.19 | 94809.0 |
| 2015-11-20 14:00:00 | ES | Futures | 2232.93 | 2234.8 | 2229.72 | 2229.98 | 85017.0 |
| 2015-11-20 15:00:00 | ES | Futures | 2229.98 | 2234.0 | 2228.11 | 2233.19 | 172500.0 |
| 2015-11-20 16:00:00 | ES | Futures | 2233.19 | 2236.14 | 2232.93 | 2235.6 | 67786.0 |
| 2015-11-20 00:00:00 | NQ | Futures | 5522.15 | 5526.3 | 5521.26 | 5525.11 | 345.0 |
| 2015-11-20 01:00:00 | NQ | Futures | 5525.7 | 5529.85 | 5525.41 | 5528.08 | 342.0 |
| 2015-11-20 02:00:00 | NQ | Futures | 5527.48 | 5543.49 | 5525.11 | 5542.9 | 1795.0 |
| 2015-11-20 03:00:00 | NQ | Futures | 5542.9 | 5543.49 | 5527.78 | 5532.23 | 3745.0 |
| 2015-11-20 04:00:00 | NQ | Futures | 5532.82 | 5534.89 | 5523.33 | 5532.23 | 2438.0 |
| 2015-11-20 05:00:00 | NQ | Futures | 5532.52 | 5538.45 | 5528.96 | 5538.45 | 1011.0 |
| 2015-11-20 06:00:00 | NQ | Futures | 5538.75 | 5539.34 | 5535.49 | 5536.08 | 1233.0 |
| 2015-11-20 07:00:00 | NQ | Futures | 5536.38 | 5541.71 | 5536.38 | 5540.82 | 2246.0 |
| 2015-11-20 08:00:00 | NQ | Futures | 5541.12 | 5544.09 | 5537.27 | 5542.9 | 3281.0 |
| 2015-11-20 09:00:00 | NQ | Futures | 5543.2 | 5559.21 | 5536.97 | 5555.65 | 42759.0 |
| 2015-11-20 10:00:00 | NQ | Futures | 5555.35 | 5563.95 | 5548.24 | 5549.72 | 31610.0 |
| 2015-11-20 11:00:00 | NQ | Futures | 5549.72 | 5562.76 | 5547.94 | 5549.42 | 19208.0 |
| 2015-11-20 12:00:00 | NQ | Futures | 5549.13 | 5558.32 | 5545.86 | 5555.65 | 12542.0 |
| 2015-11-20 13:00:00 | NQ | Futures | 5555.65 | 5561.28 | 5548.83 | 5552.68 | 12303.0 |
| 2015-11-20 14:00:00 | NQ | Futures | 5553.28 | 5557.43 | 5547.35 | 5547.64 | 12124.0 |
| 2015-11-20 15:00:00 | NQ | Futures | 5547.94 | 5558.32 | 5542.6 | 5557.72 | 22132.0 |
| 2015-11-20 16:00:00 | NQ | Futures | 5557.72 | 5562.76 | 5557.43 | 5562.17 | 5596.0 |
| 2015-11-20 00:00:00 | YM | Futures | 18762.6 | 18777.4 | 18760.4 | 18773.1 | 663.0 |
| 2015-11-20 01:00:00 | YM | Futures | 18774.2 | 18783.7 | 18773.1 | 18780.6 | 356.0 |
| 2015-11-20 02:00:00 | YM | Futures | 18779.5 | 18826.1 | 18770.0 | 18826.1 | 1343.0 |
| 2015-11-20 03:00:00 | YM | Futures | 18825.1 | 18827.2 | 18777.4 | 18793.3 | 3036.0 |
| 2015-11-20 04:00:00 | YM | Futures | 18792.2 | 18806.0 | 18767.9 | 18801.7 | 2499.0 |
| 2015-11-20 05:00:00 | YM | Futures | 18800.7 | 18818.7 | 18789.0 | 18818.7 | 1544.0 |
| 2015-11-20 06:00:00 | YM | Futures | 18820.8 | 18820.8 | 18807.0 | 18813.4 | 1376.0 |
| 2015-11-20 07:00:00 | YM | Futures | 18814.5 | 18833.5 | 18813.4 | 18830.3 | 1947.0 |
| 2015-11-20 08:00:00 | YM | Futures | 18831.4 | 18845.2 | 18826.1 | 18844.1 | 2521.0 |
| 2015-11-20 09:00:00 | YM | Futures | 18844.1 | 18917.2 | 18824.0 | 18908.7 | 22965.0 |
| 2015-11-20 10:00:00 | YM | Futures | 18908.7 | 18943.7 | 18880.1 | 18883.3 | 19304.0 |
| 2015-11-20 11:00:00 | YM | Futures | 18883.3 | 18903.4 | 18856.8 | 18863.2 | 10345.0 |
| 2015-11-20 12:00:00 | YM | Futures | 18864.2 | 18873.8 | 18847.3 | 18855.8 | 6880.0 |
| 2015-11-20 13:00:00 | YM | Futures | 18856.8 | 18870.6 | 18824.0 | 18839.9 | 7204.0 |
| 2015-11-20 14:00:00 | YM | Futures | 18840.9 | 18853.7 | 18815.5 | 18816.6 | 5648.0 |
| 2015-11-20 15:00:00 | YM | Futures | 18816.6 | 18850.5 | 18804.9 | 18845.2 | 10180.0 |
> showing 50 of 1,300 rows — these rows as CSV