PREVIEW / futures_30min / 2015-03-08
file: by_date/futures_30min/2015/2015-03-08.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 |
|---|---|---|---|---|---|---|---|
| 2015-03-08 18:00:00 | ES | Futures | 2182.58 | 2183.37 | 2178.11 | 2179.95 | 7030.0 |
| 2015-03-08 18:30:00 | ES | Futures | 2179.95 | 2180.74 | 2179.42 | 2179.42 | 1390.0 |
| 2015-03-08 19:00:00 | ES | Futures | 2179.42 | 2179.42 | 2177.32 | 2178.37 | 2833.0 |
| 2015-03-08 19:30:00 | ES | Futures | 2178.63 | 2179.16 | 2178.11 | 2178.37 | 1084.0 |
| 2015-03-08 20:00:00 | ES | Futures | 2178.63 | 2178.63 | 2176.27 | 2177.06 | 4664.0 |
| 2015-03-08 20:30:00 | ES | Futures | 2177.32 | 2177.32 | 2176.27 | 2176.79 | 1890.0 |
| 2015-03-08 21:00:00 | ES | Futures | 2176.79 | 2177.32 | 2175.74 | 2176.53 | 2842.0 |
| 2015-03-08 21:30:00 | ES | Futures | 2176.53 | 2178.11 | 2176.0 | 2176.53 | 2713.0 |
| 2015-03-08 22:00:00 | ES | Futures | 2176.53 | 2177.06 | 2176.27 | 2176.53 | 1804.0 |
| 2015-03-08 22:30:00 | ES | Futures | 2176.53 | 2176.53 | 2176.0 | 2176.53 | 765.0 |
| 2015-03-08 23:00:00 | ES | Futures | 2176.53 | 2176.79 | 2176.27 | 2176.53 | 1015.0 |
| 2015-03-08 23:30:00 | ES | Futures | 2176.27 | 2176.79 | 2176.0 | 2176.27 | 1212.0 |
| 2015-03-08 18:00:00 | NQ | Futures | 5182.72 | 5185.66 | 5173.03 | 5176.85 | 1052.0 |
| 2015-03-08 18:30:00 | NQ | Futures | 5177.14 | 5178.31 | 5175.08 | 5176.26 | 85.0 |
| 2015-03-08 19:00:00 | NQ | Futures | 5176.55 | 5177.14 | 5171.85 | 5173.91 | 390.0 |
| 2015-03-08 19:30:00 | NQ | Futures | 5174.2 | 5175.96 | 5173.03 | 5173.61 | 102.0 |
| 2015-03-08 20:00:00 | NQ | Futures | 5173.03 | 5174.2 | 5168.33 | 5170.97 | 412.0 |
| 2015-03-08 20:30:00 | NQ | Futures | 5170.68 | 5170.68 | 5168.33 | 5169.8 | 162.0 |
| 2015-03-08 21:00:00 | NQ | Futures | 5169.8 | 5170.68 | 5166.86 | 5168.33 | 431.0 |
| 2015-03-08 21:30:00 | NQ | Futures | 5168.92 | 5173.03 | 5167.15 | 5169.21 | 397.0 |
| 2015-03-08 22:00:00 | NQ | Futures | 5168.92 | 5170.09 | 5167.74 | 5169.5 | 407.0 |
| 2015-03-08 22:30:00 | NQ | Futures | 5169.5 | 5169.8 | 5168.33 | 5169.8 | 81.0 |
| 2015-03-08 23:00:00 | NQ | Futures | 5169.8 | 5170.68 | 5168.92 | 5168.92 | 161.0 |
| 2015-03-08 23:30:00 | NQ | Futures | 5168.92 | 5170.38 | 5168.33 | 5168.33 | 511.0 |
| 2015-03-08 18:00:00 | YM | Futures | 18659.3 | 18679.1 | 18632.2 | 18645.7 | 1134.0 |
| 2015-03-08 18:30:00 | YM | Futures | 18644.7 | 18651.0 | 18640.5 | 18642.6 | 122.0 |
| 2015-03-08 19:00:00 | YM | Futures | 18642.6 | 18642.6 | 18625.9 | 18636.3 | 423.0 |
| 2015-03-08 19:30:00 | YM | Futures | 18636.3 | 18641.6 | 18631.1 | 18635.3 | 144.0 |
| 2015-03-08 20:00:00 | YM | Futures | 18634.3 | 18635.3 | 18617.6 | 18623.8 | 463.0 |
| 2015-03-08 20:30:00 | YM | Futures | 18624.9 | 18625.9 | 18615.5 | 18621.7 | 322.0 |
| 2015-03-08 21:00:00 | YM | Futures | 18620.7 | 18623.8 | 18611.3 | 18617.6 | 277.0 |
| 2015-03-08 21:30:00 | YM | Futures | 18618.6 | 18631.1 | 18612.3 | 18618.6 | 293.0 |
| 2015-03-08 22:00:00 | YM | Futures | 18617.6 | 18619.6 | 18614.4 | 18616.5 | 162.0 |
| 2015-03-08 22:30:00 | YM | Futures | 18616.5 | 18616.5 | 18612.3 | 18616.5 | 168.0 |
| 2015-03-08 23:00:00 | YM | Futures | 18616.5 | 18618.6 | 18614.4 | 18615.5 | 78.0 |
| 2015-03-08 23:30:00 | YM | Futures | 18614.4 | 18618.6 | 18614.4 | 18616.5 | 247.0 |
| 2015-03-08 18:00:00 | CL | Futures | 81.93 | 82.2 | 81.92 | 82.01 | 372.0 |
| 2015-03-08 18:30:00 | CL | Futures | 82.01 | 82.03 | 81.8 | 81.92 | 598.0 |
| 2015-03-08 19:00:00 | CL | Futures | 81.9 | 81.93 | 81.5 | 81.55 | 675.0 |
| 2015-03-08 19:30:00 | CL | Futures | 81.54 | 81.65 | 81.47 | 81.59 | 599.0 |
| 2015-03-08 20:00:00 | CL | Futures | 81.57 | 81.78 | 81.57 | 81.73 | 720.0 |
| 2015-03-08 20:30:00 | CL | Futures | 81.75 | 81.78 | 81.65 | 81.7 | 503.0 |
| 2015-03-08 21:00:00 | CL | Futures | 81.7 | 81.78 | 81.62 | 81.65 | 791.0 |
| 2015-03-08 21:30:00 | CL | Futures | 81.67 | 81.72 | 81.54 | 81.55 | 533.0 |
| 2015-03-08 22:00:00 | CL | Futures | 81.57 | 81.63 | 81.54 | 81.62 | 293.0 |
| 2015-03-08 22:30:00 | CL | Futures | 81.62 | 81.73 | 81.59 | 81.65 | 352.0 |
| 2015-03-08 23:00:00 | CL | Futures | 81.65 | 81.7 | 81.49 | 81.49 | 390.0 |
| 2015-03-08 23:30:00 | CL | Futures | 81.49 | 81.62 | 81.49 | 81.55 | 200.0 |
| 2015-03-08 18:00:00 | GC | Futures | 1598.4 | 1598.6 | 1593.9 | 1596.7 | 1377.0 |
| 2015-03-08 18:30:00 | GC | Futures | 1596.7 | 1597.5 | 1595.7 | 1596.9 | 513.0 |
> showing 50 of 507 rows — these rows as CSV