PREVIEW / futures_30min / 2010-08-29
file: by_date/futures_30min/2010/2010-08-29.parquet size: 18 KB rows: 448
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-29 18:00:00 | ES | Futures | 1044.83 | 1049.0 | 1044.09 | 1048.02 | 10009.0 |
| 2010-08-29 18:30:00 | ES | Futures | 1048.02 | 1048.02 | 1046.54 | 1046.79 | 1943.0 |
| 2010-08-29 19:00:00 | ES | Futures | 1046.79 | 1047.03 | 1046.54 | 1047.03 | 931.0 |
| 2010-08-29 19:30:00 | ES | Futures | 1046.79 | 1047.53 | 1046.3 | 1047.53 | 1875.0 |
| 2010-08-29 20:00:00 | ES | Futures | 1047.28 | 1048.02 | 1046.54 | 1047.28 | 3203.0 |
| 2010-08-29 20:30:00 | ES | Futures | 1047.28 | 1048.26 | 1047.03 | 1047.77 | 3044.0 |
| 2010-08-29 21:00:00 | ES | Futures | 1047.53 | 1052.92 | 1047.53 | 1052.19 | 12469.0 |
| 2010-08-29 21:30:00 | ES | Futures | 1052.19 | 1052.92 | 1051.7 | 1051.94 | 6007.0 |
| 2010-08-29 22:00:00 | ES | Futures | 1051.94 | 1052.43 | 1051.45 | 1051.7 | 3166.0 |
| 2010-08-29 22:30:00 | ES | Futures | 1051.7 | 1052.43 | 1051.45 | 1052.19 | 1806.0 |
| 2010-08-29 23:00:00 | ES | Futures | 1052.19 | 1052.19 | 1049.24 | 1049.98 | 5562.0 |
| 2010-08-29 23:30:00 | ES | Futures | 1049.98 | 1049.98 | 1048.02 | 1048.75 | 6132.0 |
| 2010-08-29 18:00:00 | NQ | Futures | 2052.67 | 2061.56 | 2052.1 | 2059.26 | 532.0 |
| 2010-08-29 18:30:00 | NQ | Futures | 2059.84 | 2060.41 | 2056.97 | 2056.97 | 188.0 |
| 2010-08-29 19:00:00 | NQ | Futures | 2056.68 | 2057.54 | 2056.4 | 2056.97 | 90.0 |
| 2010-08-29 19:30:00 | NQ | Futures | 2057.54 | 2058.4 | 2056.4 | 2058.4 | 39.0 |
| 2010-08-29 20:00:00 | NQ | Futures | 2058.12 | 2059.26 | 2056.4 | 2058.4 | 147.0 |
| 2010-08-29 20:30:00 | NQ | Futures | 2058.12 | 2059.84 | 2058.12 | 2058.98 | 211.0 |
| 2010-08-29 21:00:00 | NQ | Futures | 2058.98 | 2069.58 | 2058.98 | 2068.43 | 929.0 |
| 2010-08-29 21:30:00 | NQ | Futures | 2068.15 | 2068.72 | 2066.43 | 2067.57 | 325.0 |
| 2010-08-29 22:00:00 | NQ | Futures | 2067.57 | 2067.86 | 2066.14 | 2066.71 | 112.0 |
| 2010-08-29 22:30:00 | NQ | Futures | 2066.71 | 2068.15 | 2066.14 | 2068.15 | 83.0 |
| 2010-08-29 23:00:00 | NQ | Futures | 2067.86 | 2068.15 | 2061.56 | 2062.99 | 286.0 |
| 2010-08-29 23:30:00 | NQ | Futures | 2062.7 | 2062.7 | 2060.41 | 2061.27 | 251.0 |
| 2010-08-29 18:00:00 | YM | Futures | 9595.8 | 9633.6 | 9594.8 | 9627.9 | 395.0 |
| 2010-08-29 18:30:00 | YM | Futures | 9627.9 | 9627.9 | 9615.6 | 9616.6 | 66.0 |
| 2010-08-29 19:00:00 | YM | Futures | 9614.7 | 9620.4 | 9614.7 | 9620.4 | 40.0 |
| 2010-08-29 19:30:00 | YM | Futures | 9618.5 | 9624.1 | 9615.6 | 9624.1 | 52.0 |
| 2010-08-29 20:00:00 | YM | Futures | 9622.3 | 9627.9 | 9618.5 | 9625.1 | 76.0 |
| 2010-08-29 20:30:00 | YM | Futures | 9628.9 | 9630.8 | 9621.3 | 9626.0 | 66.0 |
| 2010-08-29 21:00:00 | YM | Futures | 9627.0 | 9666.7 | 9627.0 | 9661.1 | 883.0 |
| 2010-08-29 21:30:00 | YM | Futures | 9661.1 | 9665.8 | 9658.2 | 9662.0 | 217.0 |
| 2010-08-29 22:00:00 | YM | Futures | 9660.1 | 9662.0 | 9657.3 | 9657.3 | 157.0 |
| 2010-08-29 22:30:00 | YM | Futures | 9656.3 | 9663.0 | 9655.4 | 9663.0 | 80.0 |
| 2010-08-29 23:00:00 | YM | Futures | 9662.0 | 9662.0 | 9637.4 | 9639.3 | 236.0 |
| 2010-08-29 23:30:00 | YM | Futures | 9640.2 | 9640.2 | 9627.9 | 9629.8 | 241.0 |
| 2010-08-29 18:00:00 | CL | Futures | 144.31 | 144.37 | 143.87 | 144.06 | 1250.0 |
| 2010-08-29 18:30:00 | CL | Futures | 144.1 | 144.25 | 144.03 | 144.14 | 226.0 |
| 2010-08-29 19:00:00 | CL | Futures | 144.08 | 144.46 | 144.08 | 144.45 | 251.0 |
| 2010-08-29 19:30:00 | CL | Futures | 144.39 | 144.43 | 144.29 | 144.31 | 181.0 |
| 2010-08-29 20:00:00 | CL | Futures | 144.33 | 144.41 | 144.04 | 144.1 | 397.0 |
| 2010-08-29 20:30:00 | CL | Futures | 144.1 | 144.14 | 143.97 | 144.1 | 207.0 |
| 2010-08-29 21:00:00 | CL | Futures | 144.08 | 144.16 | 143.93 | 144.14 | 439.0 |
| 2010-08-29 21:30:00 | CL | Futures | 144.14 | 144.18 | 144.01 | 144.03 | 219.0 |
| 2010-08-29 22:00:00 | CL | Futures | 144.03 | 144.2 | 144.03 | 144.08 | 267.0 |
| 2010-08-29 22:30:00 | CL | Futures | 144.08 | 144.18 | 144.01 | 144.14 | 105.0 |
| 2010-08-29 23:00:00 | CL | Futures | 144.12 | 144.24 | 143.78 | 143.91 | 487.0 |
| 2010-08-29 23:30:00 | CL | Futures | 143.91 | 143.93 | 143.66 | 143.68 | 404.0 |
| 2010-08-29 18:00:00 | GC | Futures | 1733.3 | 1735.4 | 1733.3 | 1734.8 | 232.0 |
| 2010-08-29 18:30:00 | GC | Futures | 1734.4 | 1735.4 | 1733.0 | 1733.7 | 318.0 |
> showing 50 of 448 rows — these rows as CSV