PREVIEW / futures_30min / 2010-08-22
file: by_date/futures_30min/2010/2010-08-22.parquet size: 17 KB rows: 411
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-22 18:00:00 | ES | Futures | 1050.22 | 1054.4 | 1049.24 | 1053.66 | 6356.0 |
| 2010-08-22 18:30:00 | ES | Futures | 1053.66 | 1054.15 | 1052.92 | 1053.17 | 1681.0 |
| 2010-08-22 19:00:00 | ES | Futures | 1053.17 | 1053.41 | 1052.19 | 1052.19 | 924.0 |
| 2010-08-22 19:30:00 | ES | Futures | 1052.19 | 1053.41 | 1052.19 | 1052.19 | 1382.0 |
| 2010-08-22 20:00:00 | ES | Futures | 1052.19 | 1053.91 | 1052.19 | 1053.17 | 3457.0 |
| 2010-08-22 20:30:00 | ES | Futures | 1053.41 | 1053.66 | 1052.19 | 1052.92 | 2804.0 |
| 2010-08-22 21:00:00 | ES | Futures | 1052.92 | 1053.41 | 1052.19 | 1052.19 | 2646.0 |
| 2010-08-22 21:30:00 | ES | Futures | 1052.19 | 1054.4 | 1052.19 | 1054.15 | 3886.0 |
| 2010-08-22 22:00:00 | ES | Futures | 1054.15 | 1054.64 | 1053.41 | 1053.91 | 2531.0 |
| 2010-08-22 22:30:00 | ES | Futures | 1053.91 | 1054.89 | 1053.41 | 1054.15 | 1883.0 |
| 2010-08-22 23:00:00 | ES | Futures | 1053.91 | 1054.4 | 1053.17 | 1053.17 | 1194.0 |
| 2010-08-22 23:30:00 | ES | Futures | 1053.17 | 1053.66 | 1052.19 | 1053.17 | 2624.0 |
| 2010-08-22 18:00:00 | NQ | Futures | 2091.65 | 2100.53 | 2091.36 | 2098.81 | 634.0 |
| 2010-08-22 18:30:00 | NQ | Futures | 2098.81 | 2099.96 | 2097.66 | 2098.52 | 138.0 |
| 2010-08-22 19:00:00 | NQ | Futures | 2098.24 | 2098.52 | 2096.8 | 2097.09 | 236.0 |
| 2010-08-22 19:30:00 | NQ | Futures | 2097.09 | 2099.1 | 2097.09 | 2097.66 | 341.0 |
| 2010-08-22 20:00:00 | NQ | Futures | 2097.66 | 2100.24 | 2097.66 | 2098.81 | 277.0 |
| 2010-08-22 20:30:00 | NQ | Futures | 2099.1 | 2099.67 | 2096.8 | 2097.95 | 266.0 |
| 2010-08-22 21:00:00 | NQ | Futures | 2097.95 | 2098.81 | 2095.37 | 2095.66 | 313.0 |
| 2010-08-22 21:30:00 | NQ | Futures | 2095.66 | 2100.53 | 2095.66 | 2099.96 | 254.0 |
| 2010-08-22 22:00:00 | NQ | Futures | 2100.24 | 2101.1 | 2098.81 | 2099.67 | 151.0 |
| 2010-08-22 22:30:00 | NQ | Futures | 2099.1 | 2101.1 | 2098.52 | 2099.38 | 221.0 |
| 2010-08-22 23:00:00 | NQ | Futures | 2099.38 | 2100.24 | 2097.66 | 2097.95 | 103.0 |
| 2010-08-22 23:30:00 | NQ | Futures | 2097.95 | 2098.52 | 2096.23 | 2098.52 | 142.0 |
| 2010-08-22 18:00:00 | YM | Futures | 9657.3 | 9686.6 | 9646.9 | 9680.9 | 232.0 |
| 2010-08-22 18:30:00 | YM | Futures | 9679.1 | 9683.8 | 9677.2 | 9680.9 | 28.0 |
| 2010-08-22 19:00:00 | YM | Futures | 9677.2 | 9678.1 | 9669.6 | 9669.6 | 101.0 |
| 2010-08-22 19:30:00 | YM | Futures | 9670.5 | 9678.1 | 9669.6 | 9670.5 | 55.0 |
| 2010-08-22 20:00:00 | YM | Futures | 9669.6 | 9682.8 | 9669.6 | 9676.2 | 87.0 |
| 2010-08-22 20:30:00 | YM | Futures | 9678.1 | 9680.0 | 9668.6 | 9676.2 | 113.0 |
| 2010-08-22 21:00:00 | YM | Futures | 9676.2 | 9676.2 | 9667.7 | 9667.7 | 90.0 |
| 2010-08-22 21:30:00 | YM | Futures | 9667.7 | 9684.7 | 9667.7 | 9682.8 | 199.0 |
| 2010-08-22 22:00:00 | YM | Futures | 9683.8 | 9687.6 | 9679.1 | 9680.0 | 170.0 |
| 2010-08-22 22:30:00 | YM | Futures | 9680.9 | 9688.5 | 9679.1 | 9683.8 | 181.0 |
| 2010-08-22 23:00:00 | YM | Futures | 9683.8 | 9686.6 | 9676.2 | 9676.2 | 70.0 |
| 2010-08-22 23:30:00 | YM | Futures | 9677.2 | 9679.1 | 9668.6 | 9677.2 | 73.0 |
| 2010-08-22 18:00:00 | CL | Futures | 141.25 | 141.67 | 141.08 | 141.33 | 640.0 |
| 2010-08-22 18:30:00 | CL | Futures | 141.33 | 141.52 | 141.2 | 141.37 | 245.0 |
| 2010-08-22 19:00:00 | CL | Futures | 141.37 | 141.41 | 141.02 | 141.14 | 244.0 |
| 2010-08-22 19:30:00 | CL | Futures | 141.08 | 141.25 | 140.99 | 141.14 | 320.0 |
| 2010-08-22 20:00:00 | CL | Futures | 141.12 | 141.39 | 141.01 | 141.23 | 336.0 |
| 2010-08-22 20:30:00 | CL | Futures | 141.27 | 141.46 | 141.2 | 141.31 | 247.0 |
| 2010-08-22 21:00:00 | CL | Futures | 141.33 | 141.41 | 141.18 | 141.25 | 209.0 |
| 2010-08-22 21:30:00 | CL | Futures | 141.29 | 141.6 | 141.2 | 141.58 | 308.0 |
| 2010-08-22 22:00:00 | CL | Futures | 141.6 | 142.02 | 141.56 | 141.77 | 819.0 |
| 2010-08-22 22:30:00 | CL | Futures | 141.79 | 141.81 | 141.56 | 141.6 | 282.0 |
| 2010-08-22 23:00:00 | CL | Futures | 141.6 | 141.96 | 141.5 | 141.67 | 279.0 |
| 2010-08-22 23:30:00 | CL | Futures | 141.67 | 141.73 | 141.48 | 141.66 | 216.0 |
| 2010-08-22 18:00:00 | GC | Futures | 1719.7 | 1722.4 | 1718.2 | 1719.3 | 350.0 |
| 2010-08-22 18:30:00 | GC | Futures | 1719.1 | 1721.8 | 1718.7 | 1721.8 | 154.0 |
> showing 50 of 411 rows — these rows as CSV