PREVIEW / futures_30min / 2013-09-15
file: by_date/futures_30min/2013/2013-09-15.parquet size: 20 KB rows: 507
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-09-15 18:00:00 | ES | Futures | 1746.91 | 1755.68 | 1745.88 | 1753.36 | 44909.0 |
| 2013-09-15 18:30:00 | ES | Futures | 1753.36 | 1758.0 | 1753.36 | 1754.9 | 20067.0 |
| 2013-09-15 19:00:00 | ES | Futures | 1754.9 | 1755.94 | 1754.65 | 1755.16 | 5799.0 |
| 2013-09-15 19:30:00 | ES | Futures | 1755.16 | 1755.16 | 1753.36 | 1754.13 | 5828.0 |
| 2013-09-15 20:00:00 | ES | Futures | 1753.87 | 1754.39 | 1753.36 | 1753.87 | 4007.0 |
| 2013-09-15 20:30:00 | ES | Futures | 1753.87 | 1754.65 | 1753.61 | 1753.87 | 4058.0 |
| 2013-09-15 21:00:00 | ES | Futures | 1753.87 | 1754.39 | 1753.61 | 1753.87 | 3342.0 |
| 2013-09-15 21:30:00 | ES | Futures | 1753.87 | 1754.13 | 1753.1 | 1753.61 | 1819.0 |
| 2013-09-15 22:00:00 | ES | Futures | 1753.36 | 1753.87 | 1753.1 | 1753.87 | 1219.0 |
| 2013-09-15 22:30:00 | ES | Futures | 1753.87 | 1754.13 | 1753.61 | 1754.13 | 1247.0 |
| 2013-09-15 23:00:00 | ES | Futures | 1754.13 | 1754.9 | 1753.61 | 1754.13 | 1988.0 |
| 2013-09-15 23:30:00 | ES | Futures | 1754.13 | 1754.9 | 1754.13 | 1754.9 | 803.0 |
| 2013-09-15 18:00:00 | NQ | Futures | 3718.12 | 3727.41 | 3713.76 | 3723.05 | 3462.0 |
| 2013-09-15 18:30:00 | NQ | Futures | 3723.34 | 3732.93 | 3723.34 | 3726.83 | 1822.0 |
| 2013-09-15 19:00:00 | NQ | Futures | 3726.83 | 3728.57 | 3726.54 | 3727.12 | 608.0 |
| 2013-09-15 19:30:00 | NQ | Futures | 3726.83 | 3726.83 | 3721.89 | 3722.76 | 869.0 |
| 2013-09-15 20:00:00 | NQ | Futures | 3722.76 | 3723.05 | 3721.6 | 3721.6 | 498.0 |
| 2013-09-15 20:30:00 | NQ | Futures | 3721.6 | 3723.34 | 3721.31 | 3721.89 | 481.0 |
| 2013-09-15 21:00:00 | NQ | Futures | 3721.6 | 3722.47 | 3721.31 | 3722.18 | 227.0 |
| 2013-09-15 21:30:00 | NQ | Futures | 3722.18 | 3722.18 | 3720.44 | 3721.02 | 303.0 |
| 2013-09-15 22:00:00 | NQ | Futures | 3720.73 | 3721.89 | 3719.86 | 3721.89 | 179.0 |
| 2013-09-15 22:30:00 | NQ | Futures | 3721.6 | 3722.76 | 3721.6 | 3721.89 | 116.0 |
| 2013-09-15 23:00:00 | NQ | Futures | 3722.18 | 3724.51 | 3721.89 | 3723.05 | 209.0 |
| 2013-09-15 23:30:00 | NQ | Futures | 3722.47 | 3723.64 | 3722.47 | 3723.34 | 132.0 |
| 2013-09-15 18:00:00 | YM | Futures | 15696.6 | 15802.8 | 15696.6 | 15798.7 | 3503.0 |
| 2013-09-15 18:30:00 | YM | Futures | 15798.7 | 15840.6 | 15798.7 | 15817.1 | 1834.0 |
| 2013-09-15 19:00:00 | YM | Futures | 15816.1 | 15823.2 | 15814.0 | 15817.1 | 277.0 |
| 2013-09-15 19:30:00 | YM | Futures | 15816.1 | 15818.1 | 15803.8 | 15809.9 | 464.0 |
| 2013-09-15 20:00:00 | YM | Futures | 15807.9 | 15809.9 | 15800.7 | 15803.8 | 517.0 |
| 2013-09-15 20:30:00 | YM | Futures | 15802.8 | 15808.9 | 15800.7 | 15802.8 | 326.0 |
| 2013-09-15 21:00:00 | YM | Futures | 15803.8 | 15804.8 | 15801.8 | 15803.8 | 191.0 |
| 2013-09-15 21:30:00 | YM | Futures | 15804.8 | 15804.8 | 15797.7 | 15798.7 | 141.0 |
| 2013-09-15 22:00:00 | YM | Futures | 15798.7 | 15802.8 | 15797.7 | 15800.7 | 185.0 |
| 2013-09-15 22:30:00 | YM | Futures | 15801.8 | 15802.8 | 15799.7 | 15801.8 | 164.0 |
| 2013-09-15 23:00:00 | YM | Futures | 15801.8 | 15810.9 | 15800.7 | 15804.8 | 128.0 |
| 2013-09-15 23:30:00 | YM | Futures | 15803.8 | 15809.9 | 15803.8 | 15808.9 | 112.0 |
| 2013-09-15 18:00:00 | CL | Futures | 170.38 | 170.38 | 168.68 | 169.34 | 1667.0 |
| 2013-09-15 18:30:00 | CL | Futures | 169.34 | 169.68 | 169.34 | 169.59 | 225.0 |
| 2013-09-15 19:00:00 | CL | Futures | 169.59 | 169.59 | 169.34 | 169.43 | 168.0 |
| 2013-09-15 19:30:00 | CL | Futures | 169.45 | 169.61 | 169.34 | 169.51 | 109.0 |
| 2013-09-15 20:00:00 | CL | Futures | 169.51 | 169.65 | 169.46 | 169.61 | 123.0 |
| 2013-09-15 20:30:00 | CL | Futures | 169.57 | 170.0 | 169.57 | 169.96 | 249.0 |
| 2013-09-15 21:00:00 | CL | Futures | 169.97 | 169.97 | 169.65 | 169.73 | 280.0 |
| 2013-09-15 21:30:00 | CL | Futures | 169.75 | 169.8 | 169.65 | 169.78 | 114.0 |
| 2013-09-15 22:00:00 | CL | Futures | 169.78 | 169.8 | 169.59 | 169.64 | 83.0 |
| 2013-09-15 22:30:00 | CL | Futures | 169.64 | 169.7 | 169.62 | 169.65 | 51.0 |
| 2013-09-15 23:00:00 | CL | Futures | 169.65 | 169.67 | 169.46 | 169.51 | 111.0 |
| 2013-09-15 23:30:00 | CL | Futures | 169.49 | 169.7 | 169.49 | 169.7 | 17.0 |
| 2013-09-15 18:00:00 | GC | Futures | 1827.9 | 1831.3 | 1816.1 | 1828.2 | 6886.0 |
| 2013-09-15 18:30:00 | GC | Futures | 1827.8 | 1829.3 | 1823.4 | 1824.5 | 1395.0 |
> showing 50 of 507 rows — these rows as CSV