PREVIEW / futures_30min / 2013-12-06
file: by_date/futures_30min/2013/2013-12-06.parquet size: 65 KB rows: 2,333
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.19 | 1844.42 | 1844.67 | 964.0 |
| 2013-12-06 00:30:00 | ES | Futures | 1844.67 | 1845.45 | 1844.42 | 1845.19 | 1593.0 |
| 2013-12-06 01:00:00 | ES | Futures | 1845.19 | 1845.45 | 1844.67 | 1844.67 | 1077.0 |
| 2013-12-06 01:30:00 | ES | Futures | 1844.67 | 1844.93 | 1844.67 | 1844.93 | 888.0 |
| 2013-12-06 02:00:00 | ES | Futures | 1844.93 | 1846.74 | 1844.42 | 1846.22 | 4993.0 |
| 2013-12-06 02:30:00 | ES | Futures | 1846.22 | 1847.0 | 1845.96 | 1846.74 | 2773.0 |
| 2013-12-06 03:00:00 | ES | Futures | 1846.74 | 1846.74 | 1845.45 | 1845.96 | 7916.0 |
| 2013-12-06 03:30:00 | ES | Futures | 1845.96 | 1846.48 | 1845.45 | 1845.96 | 7824.0 |
| 2013-12-06 04:00:00 | ES | Futures | 1845.96 | 1847.77 | 1845.45 | 1847.51 | 15772.0 |
| 2013-12-06 04:30:00 | ES | Futures | 1847.25 | 1850.09 | 1846.74 | 1849.06 | 15244.0 |
| 2013-12-06 05:00:00 | ES | Futures | 1849.32 | 1849.58 | 1848.03 | 1848.8 | 4543.0 |
| 2013-12-06 05:30:00 | ES | Futures | 1848.54 | 1849.06 | 1847.51 | 1847.51 | 3636.0 |
| 2013-12-06 06:00:00 | ES | Futures | 1847.51 | 1848.29 | 1847.25 | 1848.03 | 3109.0 |
| 2013-12-06 06:30:00 | ES | Futures | 1848.03 | 1850.61 | 1847.25 | 1850.61 | 6796.0 |
| 2013-12-06 07:00:00 | ES | Futures | 1850.35 | 1850.87 | 1848.54 | 1848.8 | 10904.0 |
| 2013-12-06 07:30:00 | ES | Futures | 1848.54 | 1849.06 | 1847.51 | 1848.8 | 11266.0 |
| 2013-12-06 08:00:00 | ES | Futures | 1848.8 | 1850.09 | 1847.0 | 1850.09 | 30142.0 |
| 2013-12-06 08:30:00 | ES | Futures | 1849.83 | 1861.18 | 1842.61 | 1858.35 | 300197.0 |
| 2013-12-06 09:00:00 | ES | Futures | 1858.35 | 1861.18 | 1857.83 | 1858.6 | 51922.0 |
| 2013-12-06 09:30:00 | ES | Futures | 1858.6 | 1860.15 | 1855.51 | 1857.57 | 212882.0 |
| 2013-12-06 10:00:00 | ES | Futures | 1857.57 | 1859.12 | 1856.03 | 1857.06 | 129922.0 |
| 2013-12-06 10:30:00 | ES | Futures | 1857.32 | 1857.57 | 1853.45 | 1855.25 | 120041.0 |
| 2013-12-06 11:00:00 | ES | Futures | 1855.25 | 1858.35 | 1854.48 | 1856.8 | 79539.0 |
| 2013-12-06 11:30:00 | ES | Futures | 1857.06 | 1859.89 | 1856.8 | 1859.64 | 75315.0 |
| 2013-12-06 12:00:00 | ES | Futures | 1859.64 | 1859.64 | 1857.57 | 1858.6 | 30209.0 |
| 2013-12-06 12:30:00 | ES | Futures | 1858.86 | 1861.96 | 1858.6 | 1861.18 | 71273.0 |
| 2013-12-06 13:00:00 | ES | Futures | 1861.18 | 1861.96 | 1860.15 | 1860.41 | 34941.0 |
| 2013-12-06 13:30:00 | ES | Futures | 1860.41 | 1863.51 | 1860.15 | 1862.22 | 78426.0 |
| 2013-12-06 14:00:00 | ES | Futures | 1862.22 | 1863.51 | 1861.7 | 1861.96 | 38032.0 |
| 2013-12-06 14:30:00 | ES | Futures | 1862.22 | 1862.47 | 1860.67 | 1861.7 | 30262.0 |
| 2013-12-06 15:00:00 | ES | Futures | 1861.44 | 1861.96 | 1859.38 | 1859.64 | 52683.0 |
| 2013-12-06 15:30:00 | ES | Futures | 1859.64 | 1862.47 | 1858.09 | 1861.44 | 157920.0 |
| 2013-12-06 16:00:00 | ES | Futures | 1861.44 | 1862.73 | 1860.41 | 1862.22 | 83654.0 |
| 2013-12-06 16:30:00 | ES | Futures | 1862.22 | 1862.99 | 1862.22 | 1862.73 | 5721.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 | 4047.47 | 4046.02 | 4046.89 | 242.0 |
| 2013-12-06 00:30:00 | NQ | Futures | 4046.6 | 4048.92 | 4046.6 | 4048.63 | 407.0 |
| 2013-12-06 01:00:00 | NQ | Futures | 4048.63 | 4048.63 | 4047.18 | 4047.18 | 133.0 |
| 2013-12-06 01:30:00 | NQ | Futures | 4047.47 | 4048.05 | 4047.18 | 4047.47 | 99.0 |
| 2013-12-06 02:00:00 | NQ | Futures | 4047.47 | 4051.53 | 4046.6 | 4050.08 | 612.0 |
| 2013-12-06 02:30:00 | NQ | Futures | 4049.79 | 4051.24 | 4049.79 | 4050.66 | 207.0 |
| 2013-12-06 03:00:00 | NQ | Futures | 4050.37 | 4051.24 | 4048.34 | 4049.21 | 1082.0 |
| 2013-12-06 03:30:00 | NQ | Futures | 4049.5 | 4050.37 | 4047.76 | 4048.92 | 1755.0 |
| 2013-12-06 04:00:00 | NQ | Futures | 4048.92 | 4053.86 | 4048.34 | 4053.28 | 2066.0 |
| 2013-12-06 04:30:00 | NQ | Futures | 4053.28 | 4059.67 | 4053.28 | 4058.79 | 2200.0 |
| 2013-12-06 05:00:00 | NQ | Futures | 4058.79 | 4059.38 | 4055.02 | 4056.47 | 1110.0 |
| 2013-12-06 05:30:00 | NQ | Futures | 4056.47 | 4057.05 | 4054.15 | 4054.44 | 819.0 |
| 2013-12-06 06:00:00 | NQ | Futures | 4054.73 | 4055.89 | 4053.86 | 4055.02 | 558.0 |
| 2013-12-06 06:30:00 | NQ | Futures | 4054.73 | 4059.08 | 4052.7 | 4058.79 | 1064.0 |
| 2013-12-06 07:00:00 | NQ | Futures | 4058.5 | 4059.08 | 4055.31 | 4055.31 | 1353.0 |
> showing 50 of 2,333 rows — these rows as CSV