PREVIEW / futures_1hour / 2013-12-06
file: by_date/futures_1hour/2013/2013-12-06.parquet size: 42 KB rows: 1,248
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-06 00:00:00 | ES | Futures | 1844.67 | 1845.45 | 1844.42 | 1845.19 | 2557.0 |
| 2013-12-06 01:00:00 | ES | Futures | 1845.19 | 1845.45 | 1844.67 | 1844.93 | 1965.0 |
| 2013-12-06 02:00:00 | ES | Futures | 1844.93 | 1847.0 | 1844.42 | 1846.74 | 7766.0 |
| 2013-12-06 03:00:00 | ES | Futures | 1846.74 | 1846.74 | 1845.45 | 1845.96 | 15740.0 |
| 2013-12-06 04:00:00 | ES | Futures | 1845.96 | 1850.09 | 1845.45 | 1849.06 | 31016.0 |
| 2013-12-06 05:00:00 | ES | Futures | 1849.32 | 1849.58 | 1847.51 | 1847.51 | 8179.0 |
| 2013-12-06 06:00:00 | ES | Futures | 1847.51 | 1850.61 | 1847.25 | 1850.61 | 9905.0 |
| 2013-12-06 07:00:00 | ES | Futures | 1850.35 | 1850.87 | 1847.51 | 1848.8 | 22170.0 |
| 2013-12-06 08:00:00 | ES | Futures | 1848.8 | 1861.18 | 1842.61 | 1858.35 | 330339.0 |
| 2013-12-06 09:00:00 | ES | Futures | 1858.35 | 1861.18 | 1855.51 | 1857.57 | 264804.0 |
| 2013-12-06 10:00:00 | ES | Futures | 1857.57 | 1859.12 | 1853.45 | 1855.25 | 249963.0 |
| 2013-12-06 11:00:00 | ES | Futures | 1855.25 | 1859.89 | 1854.48 | 1859.64 | 154854.0 |
| 2013-12-06 12:00:00 | ES | Futures | 1859.64 | 1861.96 | 1857.57 | 1861.18 | 101482.0 |
| 2013-12-06 13:00:00 | ES | Futures | 1861.18 | 1863.51 | 1860.15 | 1862.22 | 113367.0 |
| 2013-12-06 14:00:00 | ES | Futures | 1862.22 | 1863.51 | 1860.67 | 1861.7 | 68294.0 |
| 2013-12-06 15:00:00 | ES | Futures | 1861.44 | 1862.47 | 1858.09 | 1861.44 | 210603.0 |
| 2013-12-06 16:00:00 | ES | Futures | 1861.44 | 1862.99 | 1860.41 | 1862.73 | 89375.0 |
| 2013-12-06 17:00:00 | ES | Futures | 1862.73 | 1863.25 | 1862.47 | 1863.25 | 2613.0 |
| 2013-12-06 00:00:00 | NQ | Futures | 4046.31 | 4048.92 | 4046.02 | 4048.63 | 649.0 |
| 2013-12-06 01:00:00 | NQ | Futures | 4048.63 | 4048.63 | 4047.18 | 4047.47 | 232.0 |
| 2013-12-06 02:00:00 | NQ | Futures | 4047.47 | 4051.53 | 4046.6 | 4050.66 | 819.0 |
| 2013-12-06 03:00:00 | NQ | Futures | 4050.37 | 4051.24 | 4047.76 | 4048.92 | 2837.0 |
| 2013-12-06 04:00:00 | NQ | Futures | 4048.92 | 4059.67 | 4048.34 | 4058.79 | 4266.0 |
| 2013-12-06 05:00:00 | NQ | Futures | 4058.79 | 4059.38 | 4054.15 | 4054.44 | 1929.0 |
| 2013-12-06 06:00:00 | NQ | Futures | 4054.73 | 4059.08 | 4052.7 | 4058.79 | 1622.0 |
| 2013-12-06 07:00:00 | NQ | Futures | 4058.5 | 4059.08 | 4053.28 | 4055.31 | 3035.0 |
| 2013-12-06 08:00:00 | NQ | Futures | 4055.02 | 4076.8 | 4043.4 | 4073.03 | 41465.0 |
| 2013-12-06 09:00:00 | NQ | Futures | 4073.03 | 4077.67 | 4064.31 | 4069.83 | 47254.0 |
| 2013-12-06 10:00:00 | NQ | Futures | 4070.12 | 4073.61 | 4050.08 | 4059.38 | 41681.0 |
| 2013-12-06 11:00:00 | NQ | Futures | 4059.38 | 4074.19 | 4057.05 | 4073.61 | 25215.0 |
| 2013-12-06 12:00:00 | NQ | Futures | 4073.9 | 4078.83 | 4071.57 | 4076.8 | 18382.0 |
| 2013-12-06 13:00:00 | NQ | Futures | 4076.51 | 4077.96 | 4070.7 | 4074.19 | 14734.0 |
| 2013-12-06 14:00:00 | NQ | Futures | 4074.19 | 4077.38 | 4071.28 | 4072.74 | 9662.0 |
| 2013-12-06 15:00:00 | NQ | Futures | 4072.74 | 4074.48 | 4065.18 | 4069.25 | 29734.0 |
| 2013-12-06 16:00:00 | NQ | Futures | 4069.54 | 4072.74 | 4068.67 | 4072.44 | 4896.0 |
| 2013-12-06 17:00:00 | NQ | Futures | 4072.44 | 4073.03 | 4072.44 | 4072.74 | 136.0 |
| 2013-12-06 00:00:00 | YM | Futures | 16185.7 | 16194.9 | 16184.7 | 16191.9 | 811.0 |
| 2013-12-06 01:00:00 | YM | Futures | 16190.9 | 16191.9 | 16183.7 | 16187.8 | 323.0 |
| 2013-12-06 02:00:00 | YM | Futures | 16186.8 | 16204.1 | 16183.7 | 16201.1 | 1609.0 |
| 2013-12-06 03:00:00 | YM | Futures | 16200.0 | 16201.1 | 16187.8 | 16196.0 | 2251.0 |
| 2013-12-06 04:00:00 | YM | Futures | 16196.0 | 16224.6 | 16192.9 | 16218.4 | 3800.0 |
| 2013-12-06 05:00:00 | YM | Futures | 16218.4 | 16222.5 | 16205.1 | 16205.1 | 1125.0 |
| 2013-12-06 06:00:00 | YM | Futures | 16205.1 | 16223.5 | 16201.1 | 16222.5 | 1428.0 |
| 2013-12-06 07:00:00 | YM | Futures | 16222.5 | 16228.6 | 16204.1 | 16216.4 | 2327.0 |
| 2013-12-06 08:00:00 | YM | Futures | 16216.4 | 16416.5 | 16166.3 | 16289.9 | 30220.0 |
| 2013-12-06 09:00:00 | YM | Futures | 16289.9 | 16315.4 | 16273.6 | 16293.0 | 21794.0 |
| 2013-12-06 10:00:00 | YM | Futures | 16294.0 | 16309.3 | 16250.1 | 16278.7 | 23212.0 |
| 2013-12-06 11:00:00 | YM | Futures | 16277.7 | 16319.5 | 16269.5 | 16318.5 | 14040.0 |
| 2013-12-06 12:00:00 | YM | Futures | 16317.5 | 16337.9 | 16295.0 | 16333.8 | 10365.0 |
| 2013-12-06 13:00:00 | YM | Futures | 16333.8 | 16360.4 | 16327.7 | 16347.1 | 10208.0 |
> showing 50 of 1,248 rows — these rows as CSV