PREVIEW / futures_1hour / 2014-02-10
file: by_date/futures_1hour/2014/2014-02-10.parquet size: 48 KB rows: 1,525
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-10 00:00:00 | ES | Futures | 1854.29 | 1855.84 | 1854.03 | 1854.8 | 4742.0 |
| 2014-02-10 01:00:00 | ES | Futures | 1854.8 | 1855.32 | 1854.03 | 1854.8 | 3316.0 |
| 2014-02-10 02:00:00 | ES | Futures | 1854.54 | 1854.54 | 1851.96 | 1852.73 | 9288.0 |
| 2014-02-10 03:00:00 | ES | Futures | 1852.73 | 1852.99 | 1849.63 | 1851.44 | 29408.0 |
| 2014-02-10 04:00:00 | ES | Futures | 1851.18 | 1852.22 | 1849.63 | 1851.44 | 17583.0 |
| 2014-02-10 05:00:00 | ES | Futures | 1851.7 | 1852.22 | 1849.89 | 1850.15 | 9010.0 |
| 2014-02-10 06:00:00 | ES | Futures | 1849.89 | 1850.92 | 1848.08 | 1849.37 | 21763.0 |
| 2014-02-10 07:00:00 | ES | Futures | 1849.37 | 1851.96 | 1849.11 | 1851.96 | 21796.0 |
| 2014-02-10 08:00:00 | ES | Futures | 1851.96 | 1853.25 | 1850.41 | 1852.22 | 28987.0 |
| 2014-02-10 09:00:00 | ES | Futures | 1852.22 | 1855.32 | 1849.89 | 1854.03 | 226857.0 |
| 2014-02-10 10:00:00 | ES | Futures | 1854.03 | 1854.8 | 1848.85 | 1850.41 | 180834.0 |
| 2014-02-10 11:00:00 | ES | Futures | 1850.66 | 1854.54 | 1848.59 | 1853.25 | 129002.0 |
| 2014-02-10 12:00:00 | ES | Futures | 1853.25 | 1854.29 | 1851.96 | 1853.25 | 61118.0 |
| 2014-02-10 13:00:00 | ES | Futures | 1853.51 | 1854.8 | 1851.96 | 1854.03 | 52811.0 |
| 2014-02-10 14:00:00 | ES | Futures | 1854.29 | 1857.65 | 1853.77 | 1856.35 | 78847.0 |
| 2014-02-10 15:00:00 | ES | Futures | 1856.61 | 1857.13 | 1854.29 | 1856.87 | 159972.0 |
| 2014-02-10 16:00:00 | ES | Futures | 1857.13 | 1857.39 | 1856.35 | 1857.39 | 65998.0 |
| 2014-02-10 17:00:00 | ES | Futures | 1857.13 | 1858.17 | 1856.87 | 1857.65 | 5177.0 |
| 2014-02-10 18:00:00 | ES | Futures | 1857.39 | 1857.91 | 1856.35 | 1856.87 | 4128.0 |
| 2014-02-10 19:00:00 | ES | Futures | 1856.87 | 1860.23 | 1856.87 | 1858.42 | 6362.0 |
| 2014-02-10 20:00:00 | ES | Futures | 1858.42 | 1861.01 | 1858.17 | 1859.98 | 5675.0 |
| 2014-02-10 21:00:00 | ES | Futures | 1859.98 | 1860.75 | 1859.2 | 1859.98 | 3598.0 |
| 2014-02-10 22:00:00 | ES | Futures | 1859.98 | 1862.3 | 1859.72 | 1861.79 | 4279.0 |
| 2014-02-10 23:00:00 | ES | Futures | 1862.04 | 1863.08 | 1861.01 | 1862.56 | 3871.0 |
| 2014-02-10 00:00:00 | NQ | Futures | 4139.06 | 4141.68 | 4138.19 | 4140.51 | 441.0 |
| 2014-02-10 01:00:00 | NQ | Futures | 4140.51 | 4142.55 | 4138.19 | 4139.93 | 603.0 |
| 2014-02-10 02:00:00 | NQ | Futures | 4139.35 | 4139.64 | 4134.12 | 4135.28 | 1258.0 |
| 2014-02-10 03:00:00 | NQ | Futures | 4134.99 | 4135.57 | 4130.92 | 4134.99 | 3181.0 |
| 2014-02-10 04:00:00 | NQ | Futures | 4134.99 | 4136.73 | 4131.5 | 4134.99 | 1695.0 |
| 2014-02-10 05:00:00 | NQ | Futures | 4135.57 | 4137.32 | 4131.79 | 4131.79 | 909.0 |
| 2014-02-10 06:00:00 | NQ | Futures | 4131.5 | 4133.83 | 4128.3 | 4130.05 | 1665.0 |
| 2014-02-10 07:00:00 | NQ | Futures | 4130.05 | 4135.86 | 4129.47 | 4135.86 | 2481.0 |
| 2014-02-10 08:00:00 | NQ | Futures | 4135.86 | 4138.19 | 4132.66 | 4135.86 | 4394.0 |
| 2014-02-10 09:00:00 | NQ | Futures | 4135.57 | 4153.88 | 4131.79 | 4149.82 | 48474.0 |
| 2014-02-10 10:00:00 | NQ | Futures | 4149.82 | 4150.98 | 4137.61 | 4143.13 | 34514.0 |
| 2014-02-10 11:00:00 | NQ | Futures | 4142.84 | 4157.66 | 4139.93 | 4154.76 | 25681.0 |
| 2014-02-10 12:00:00 | NQ | Futures | 4155.05 | 4157.66 | 4151.27 | 4151.56 | 12556.0 |
| 2014-02-10 13:00:00 | NQ | Futures | 4151.56 | 4154.18 | 4146.33 | 4151.85 | 10241.0 |
| 2014-02-10 14:00:00 | NQ | Futures | 4152.14 | 4161.73 | 4151.56 | 4158.25 | 16072.0 |
| 2014-02-10 15:00:00 | NQ | Futures | 4158.25 | 4159.99 | 4153.3 | 4159.99 | 31208.0 |
| 2014-02-10 16:00:00 | NQ | Futures | 4159.7 | 4162.61 | 4157.37 | 4162.02 | 4983.0 |
| 2014-02-10 17:00:00 | NQ | Futures | 4162.02 | 4164.64 | 4161.44 | 4163.77 | 313.0 |
| 2014-02-10 18:00:00 | NQ | Futures | 4161.73 | 4163.19 | 4160.86 | 4161.73 | 740.0 |
| 2014-02-10 19:00:00 | NQ | Futures | 4162.02 | 4168.13 | 4162.02 | 4165.51 | 760.0 |
| 2014-02-10 20:00:00 | NQ | Futures | 4165.51 | 4169.58 | 4164.06 | 4166.38 | 896.0 |
| 2014-02-10 21:00:00 | NQ | Futures | 4166.97 | 4168.42 | 4166.68 | 4167.26 | 316.0 |
| 2014-02-10 22:00:00 | NQ | Futures | 4166.97 | 4171.04 | 4166.38 | 4170.45 | 463.0 |
| 2014-02-10 23:00:00 | NQ | Futures | 4169.87 | 4172.49 | 4168.42 | 4170.45 | 390.0 |
| 2014-02-10 00:00:00 | YM | Futures | 16139.8 | 16150.1 | 16136.8 | 16143.9 | 585.0 |
| 2014-02-10 01:00:00 | YM | Futures | 16143.9 | 16145.0 | 16134.7 | 16138.8 | 388.0 |
> showing 50 of 1,525 rows — these rows as CSV