PREVIEW / futures_1hour / 2015-07-24
file: by_date/futures_1hour/2015/2015-07-24.parquet size: 43 KB rows: 1,265
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-07-24 00:00:00 | ES | Futures | 2234.36 | 2234.62 | 2233.82 | 2234.36 | 948.0 |
| 2015-07-24 01:00:00 | ES | Futures | 2234.62 | 2236.49 | 2234.36 | 2236.49 | 3496.0 |
| 2015-07-24 02:00:00 | ES | Futures | 2236.22 | 2236.22 | 2234.09 | 2235.42 | 5002.0 |
| 2015-07-24 03:00:00 | ES | Futures | 2235.69 | 2237.02 | 2234.36 | 2237.02 | 13057.0 |
| 2015-07-24 04:00:00 | ES | Futures | 2236.75 | 2240.75 | 2236.75 | 2239.95 | 17490.0 |
| 2015-07-24 05:00:00 | ES | Futures | 2239.68 | 2240.21 | 2237.55 | 2239.95 | 9424.0 |
| 2015-07-24 06:00:00 | ES | Futures | 2239.95 | 2240.48 | 2238.35 | 2239.15 | 5686.0 |
| 2015-07-24 07:00:00 | ES | Futures | 2238.88 | 2239.15 | 2235.69 | 2235.95 | 8898.0 |
| 2015-07-24 08:00:00 | ES | Futures | 2236.22 | 2236.75 | 2231.96 | 2232.76 | 34977.0 |
| 2015-07-24 09:00:00 | ES | Futures | 2232.49 | 2234.09 | 2227.17 | 2231.43 | 176978.0 |
| 2015-07-24 10:00:00 | ES | Futures | 2231.16 | 2231.69 | 2221.58 | 2221.84 | 238688.0 |
| 2015-07-24 11:00:00 | ES | Futures | 2221.84 | 2224.5 | 2220.78 | 2222.11 | 166639.0 |
| 2015-07-24 12:00:00 | ES | Futures | 2222.11 | 2222.37 | 2215.45 | 2215.72 | 127397.0 |
| 2015-07-24 13:00:00 | ES | Futures | 2215.98 | 2217.58 | 2208.26 | 2211.99 | 237176.0 |
| 2015-07-24 14:00:00 | ES | Futures | 2211.99 | 2212.79 | 2204.27 | 2207.73 | 207115.0 |
| 2015-07-24 15:00:00 | ES | Futures | 2207.73 | 2211.19 | 2205.33 | 2208.26 | 288438.0 |
| 2015-07-24 16:00:00 | ES | Futures | 2208.53 | 2214.39 | 2208.0 | 2213.85 | 105961.0 |
| 2015-07-24 17:00:00 | ES | Futures | 2214.12 | 2214.12 | 2213.32 | 2213.85 | 1949.0 |
| 2015-07-24 00:00:00 | NQ | Futures | 5469.15 | 5470.92 | 5468.26 | 5470.63 | 382.0 |
| 2015-07-24 01:00:00 | NQ | Futures | 5470.92 | 5476.54 | 5470.63 | 5475.65 | 689.0 |
| 2015-07-24 02:00:00 | NQ | Futures | 5475.95 | 5475.95 | 5470.03 | 5474.17 | 596.0 |
| 2015-07-24 03:00:00 | NQ | Futures | 5474.17 | 5478.02 | 5470.33 | 5477.13 | 1807.0 |
| 2015-07-24 04:00:00 | NQ | Futures | 5477.13 | 5488.37 | 5476.84 | 5485.71 | 2894.0 |
| 2015-07-24 05:00:00 | NQ | Futures | 5486.01 | 5486.6 | 5480.39 | 5486.6 | 1424.0 |
| 2015-07-24 06:00:00 | NQ | Futures | 5486.3 | 5487.49 | 5482.16 | 5483.64 | 1385.0 |
| 2015-07-24 07:00:00 | NQ | Futures | 5483.64 | 5483.94 | 5471.22 | 5472.99 | 2640.0 |
| 2015-07-24 08:00:00 | NQ | Futures | 5472.99 | 5478.32 | 5467.08 | 5468.26 | 6120.0 |
| 2015-07-24 09:00:00 | NQ | Futures | 5468.55 | 5470.92 | 5443.12 | 5456.43 | 33594.0 |
| 2015-07-24 10:00:00 | NQ | Futures | 5455.84 | 5460.57 | 5431.58 | 5435.72 | 33400.0 |
| 2015-07-24 11:00:00 | NQ | Futures | 5436.02 | 5444.6 | 5430.1 | 5435.43 | 19854.0 |
| 2015-07-24 12:00:00 | NQ | Futures | 5435.43 | 5436.61 | 5414.72 | 5415.61 | 17255.0 |
| 2015-07-24 13:00:00 | NQ | Futures | 5415.9 | 5420.34 | 5391.95 | 5406.73 | 30480.0 |
| 2015-07-24 14:00:00 | NQ | Futures | 5406.73 | 5408.21 | 5378.34 | 5387.21 | 27185.0 |
| 2015-07-24 15:00:00 | NQ | Futures | 5387.21 | 5394.9 | 5376.86 | 5385.14 | 41231.0 |
| 2015-07-24 16:00:00 | NQ | Futures | 5385.73 | 5399.64 | 5384.55 | 5398.75 | 9015.0 |
| 2015-07-24 17:00:00 | NQ | Futures | 5398.75 | 5400.23 | 5397.27 | 5399.93 | 338.0 |
| 2015-07-24 00:00:00 | YM | Futures | 18605.2 | 18609.4 | 18604.1 | 18608.3 | 139.0 |
| 2015-07-24 01:00:00 | YM | Futures | 18607.3 | 18621.0 | 18607.3 | 18619.9 | 451.0 |
| 2015-07-24 02:00:00 | YM | Futures | 18619.9 | 18619.9 | 18606.2 | 18612.5 | 697.0 |
| 2015-07-24 03:00:00 | YM | Futures | 18614.6 | 18629.4 | 18603.1 | 18627.3 | 1311.0 |
| 2015-07-24 04:00:00 | YM | Futures | 18627.3 | 18657.8 | 18627.3 | 18648.4 | 1544.0 |
| 2015-07-24 05:00:00 | YM | Futures | 18648.4 | 18649.4 | 18626.2 | 18647.3 | 1052.0 |
| 2015-07-24 06:00:00 | YM | Futures | 18647.3 | 18651.5 | 18637.8 | 18645.2 | 746.0 |
| 2015-07-24 07:00:00 | YM | Futures | 18644.1 | 18651.5 | 18624.1 | 18628.3 | 1147.0 |
| 2015-07-24 08:00:00 | YM | Futures | 18630.4 | 18635.7 | 18589.4 | 18594.6 | 4430.0 |
| 2015-07-24 09:00:00 | YM | Futures | 18593.6 | 18613.6 | 18567.2 | 18603.1 | 15699.0 |
| 2015-07-24 10:00:00 | YM | Futures | 18598.8 | 18608.3 | 18512.5 | 18512.5 | 19850.0 |
| 2015-07-24 11:00:00 | YM | Futures | 18513.5 | 18531.4 | 18497.7 | 18510.3 | 12940.0 |
| 2015-07-24 12:00:00 | YM | Futures | 18510.3 | 18512.5 | 18466.1 | 18469.3 | 8321.0 |
| 2015-07-24 13:00:00 | YM | Futures | 18469.3 | 18480.9 | 18428.2 | 18452.4 | 15870.0 |
> showing 50 of 1,265 rows — these rows as CSV