PREVIEW / futures_1hour / 2015-12-22
file: by_date/futures_1hour/2015/2015-12-22.parquet size: 49 KB rows: 1,531
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-12-22 00:00:00 | ES | Futures | 2168.21 | 2170.63 | 2168.21 | 2170.36 | 2871.0 |
| 2015-12-22 01:00:00 | ES | Futures | 2170.09 | 2172.24 | 2169.83 | 2170.63 | 2617.0 |
| 2015-12-22 02:00:00 | ES | Futures | 2170.63 | 2174.66 | 2170.63 | 2172.51 | 7738.0 |
| 2015-12-22 03:00:00 | ES | Futures | 2172.51 | 2173.86 | 2165.26 | 2166.06 | 27879.0 |
| 2015-12-22 04:00:00 | ES | Futures | 2166.06 | 2168.48 | 2157.46 | 2159.61 | 26955.0 |
| 2015-12-22 05:00:00 | ES | Futures | 2159.61 | 2167.68 | 2159.08 | 2166.33 | 14994.0 |
| 2015-12-22 06:00:00 | ES | Futures | 2166.06 | 2170.36 | 2165.53 | 2166.87 | 13570.0 |
| 2015-12-22 07:00:00 | ES | Futures | 2166.87 | 2171.44 | 2163.11 | 2170.63 | 15928.0 |
| 2015-12-22 08:00:00 | ES | Futures | 2170.9 | 2170.9 | 2166.87 | 2169.29 | 19386.0 |
| 2015-12-22 09:00:00 | ES | Futures | 2169.29 | 2175.47 | 2162.03 | 2165.26 | 170419.0 |
| 2015-12-22 10:00:00 | ES | Futures | 2165.53 | 2170.36 | 2160.96 | 2166.87 | 161214.0 |
| 2015-12-22 11:00:00 | ES | Futures | 2167.14 | 2173.32 | 2163.65 | 2171.17 | 128439.0 |
| 2015-12-22 12:00:00 | ES | Futures | 2171.17 | 2176.27 | 2167.41 | 2176.27 | 89140.0 |
| 2015-12-22 13:00:00 | ES | Futures | 2176.27 | 2180.04 | 2173.32 | 2179.5 | 86625.0 |
| 2015-12-22 14:00:00 | ES | Futures | 2179.5 | 2181.11 | 2177.89 | 2180.84 | 83284.0 |
| 2015-12-22 15:00:00 | ES | Futures | 2180.84 | 2186.75 | 2177.08 | 2182.99 | 198154.0 |
| 2015-12-22 16:00:00 | ES | Futures | 2182.99 | 2188.9 | 2181.65 | 2185.95 | 66101.0 |
| 2015-12-22 18:00:00 | ES | Futures | 2186.22 | 2188.37 | 2185.41 | 2186.22 | 4937.0 |
| 2015-12-22 19:00:00 | ES | Futures | 2186.22 | 2186.49 | 2184.07 | 2184.34 | 3111.0 |
| 2015-12-22 20:00:00 | ES | Futures | 2184.6 | 2185.68 | 2182.72 | 2184.34 | 3969.0 |
| 2015-12-22 21:00:00 | ES | Futures | 2184.34 | 2186.75 | 2183.8 | 2185.68 | 1903.0 |
| 2015-12-22 22:00:00 | ES | Futures | 2185.68 | 2186.49 | 2184.34 | 2185.41 | 1320.0 |
| 2015-12-22 23:00:00 | ES | Futures | 2185.41 | 2185.68 | 2184.6 | 2185.41 | 847.0 |
| 2015-12-22 00:00:00 | NQ | Futures | 5424.04 | 5429.69 | 5423.45 | 5427.01 | 451.0 |
| 2015-12-22 01:00:00 | NQ | Futures | 5426.12 | 5431.47 | 5426.12 | 5427.9 | 364.0 |
| 2015-12-22 02:00:00 | NQ | Futures | 5428.2 | 5438.89 | 5428.2 | 5433.55 | 888.0 |
| 2015-12-22 03:00:00 | NQ | Futures | 5433.25 | 5436.22 | 5415.43 | 5416.62 | 3283.0 |
| 2015-12-22 04:00:00 | NQ | Futures | 5416.32 | 5421.97 | 5393.76 | 5400.59 | 4489.0 |
| 2015-12-22 05:00:00 | NQ | Futures | 5399.99 | 5417.81 | 5399.1 | 5415.14 | 2331.0 |
| 2015-12-22 06:00:00 | NQ | Futures | 5415.14 | 5424.34 | 5412.17 | 5415.14 | 2201.0 |
| 2015-12-22 07:00:00 | NQ | Futures | 5414.84 | 5427.61 | 5406.53 | 5426.12 | 2691.0 |
| 2015-12-22 08:00:00 | NQ | Futures | 5426.42 | 5427.31 | 5416.62 | 5422.86 | 2944.0 |
| 2015-12-22 09:00:00 | NQ | Futures | 5423.15 | 5437.7 | 5408.31 | 5416.32 | 25186.0 |
| 2015-12-22 10:00:00 | NQ | Futures | 5416.62 | 5432.95 | 5409.5 | 5416.62 | 26030.0 |
| 2015-12-22 11:00:00 | NQ | Futures | 5416.62 | 5429.98 | 5406.53 | 5421.97 | 18921.0 |
| 2015-12-22 12:00:00 | NQ | Futures | 5421.67 | 5430.28 | 5408.31 | 5429.39 | 14975.0 |
| 2015-12-22 13:00:00 | NQ | Futures | 5429.39 | 5434.14 | 5416.62 | 5432.36 | 13784.0 |
| 2015-12-22 14:00:00 | NQ | Futures | 5432.06 | 5439.49 | 5429.69 | 5439.49 | 10353.0 |
| 2015-12-22 15:00:00 | NQ | Futures | 5439.49 | 5450.47 | 5428.5 | 5441.86 | 24662.0 |
| 2015-12-22 16:00:00 | NQ | Futures | 5441.86 | 5457.0 | 5439.19 | 5451.07 | 7141.0 |
| 2015-12-22 18:00:00 | NQ | Futures | 5452.25 | 5454.93 | 5448.99 | 5451.36 | 519.0 |
| 2015-12-22 19:00:00 | NQ | Futures | 5451.07 | 5452.25 | 5446.02 | 5447.5 | 671.0 |
| 2015-12-22 20:00:00 | NQ | Futures | 5447.5 | 5451.36 | 5443.35 | 5447.8 | 841.0 |
| 2015-12-22 21:00:00 | NQ | Futures | 5447.8 | 5451.66 | 5446.61 | 5449.58 | 356.0 |
| 2015-12-22 22:00:00 | NQ | Futures | 5449.28 | 5450.77 | 5445.13 | 5447.21 | 347.0 |
| 2015-12-22 23:00:00 | NQ | Futures | 5447.5 | 5448.39 | 5445.42 | 5446.61 | 208.0 |
| 2015-12-22 00:00:00 | YM | Futures | 18303.7 | 18320.7 | 18301.6 | 18318.6 | 497.0 |
| 2015-12-22 01:00:00 | YM | Futures | 18318.6 | 18335.6 | 18315.4 | 18325.0 | 742.0 |
| 2015-12-22 02:00:00 | YM | Futures | 18327.1 | 18360.1 | 18327.1 | 18343.1 | 1567.0 |
| 2015-12-22 03:00:00 | YM | Futures | 18343.1 | 18354.8 | 18283.5 | 18286.7 | 5255.0 |
> showing 50 of 1,531 rows — these rows as CSV