PREVIEW / futures_30min / 2008-01-20
file: by_date/futures_30min/2008/2008-01-20.parquet size: 12 KB rows: 230
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-20 18:00:00 | ES | Futures | 1238.29 | 1241.79 | 1238.06 | 1240.16 | 3698.0 |
| 2008-01-20 18:30:00 | ES | Futures | 1240.16 | 1240.39 | 1238.76 | 1239.69 | 756.0 |
| 2008-01-20 19:00:00 | ES | Futures | 1239.69 | 1240.39 | 1238.99 | 1238.99 | 1071.0 |
| 2008-01-20 19:30:00 | ES | Futures | 1238.99 | 1239.23 | 1238.06 | 1238.29 | 451.0 |
| 2008-01-20 20:00:00 | ES | Futures | 1238.29 | 1238.99 | 1234.33 | 1237.13 | 2645.0 |
| 2008-01-20 20:30:00 | ES | Futures | 1237.13 | 1237.36 | 1231.76 | 1232.23 | 2188.0 |
| 2008-01-20 21:00:00 | ES | Futures | 1232.23 | 1233.4 | 1231.3 | 1232.7 | 2138.0 |
| 2008-01-20 21:30:00 | ES | Futures | 1232.46 | 1233.86 | 1232.23 | 1232.46 | 825.0 |
| 2008-01-20 22:00:00 | ES | Futures | 1232.46 | 1233.86 | 1232.46 | 1233.63 | 636.0 |
| 2008-01-20 22:30:00 | ES | Futures | 1233.63 | 1235.49 | 1232.23 | 1234.1 | 1075.0 |
| 2008-01-20 23:00:00 | ES | Futures | 1233.86 | 1234.33 | 1232.7 | 1232.93 | 297.0 |
| 2008-01-20 23:30:00 | ES | Futures | 1233.16 | 1233.86 | 1231.76 | 1231.76 | 688.0 |
| 2008-01-20 18:00:00 | NQ | Futures | 2102.15 | 2109.81 | 2102.15 | 2107.82 | 467.0 |
| 2008-01-20 18:30:00 | NQ | Futures | 2108.11 | 2108.67 | 2107.26 | 2107.82 | 81.0 |
| 2008-01-20 19:00:00 | NQ | Futures | 2108.67 | 2108.96 | 2106.12 | 2106.12 | 76.0 |
| 2008-01-20 19:30:00 | NQ | Futures | 2106.12 | 2107.82 | 2105.27 | 2105.27 | 66.0 |
| 2008-01-20 20:00:00 | NQ | Futures | 2105.55 | 2105.55 | 2101.01 | 2102.43 | 251.0 |
| 2008-01-20 20:30:00 | NQ | Futures | 2102.71 | 2103.57 | 2094.77 | 2095.33 | 289.0 |
| 2008-01-20 21:00:00 | NQ | Futures | 2095.05 | 2098.74 | 2095.05 | 2096.19 | 75.0 |
| 2008-01-20 21:30:00 | NQ | Futures | 2097.04 | 2099.59 | 2096.19 | 2097.6 | 129.0 |
| 2008-01-20 22:00:00 | NQ | Futures | 2097.6 | 2099.31 | 2096.47 | 2098.17 | 172.0 |
| 2008-01-20 22:30:00 | NQ | Futures | 2097.89 | 2101.29 | 2097.6 | 2099.31 | 95.0 |
| 2008-01-20 23:00:00 | NQ | Futures | 2098.74 | 2098.74 | 2097.04 | 2097.6 | 33.0 |
| 2008-01-20 23:30:00 | NQ | Futures | 2097.04 | 2097.6 | 2095.9 | 2095.9 | 14.0 |
| 2008-01-20 18:00:00 | YM | Futures | 10998.3 | 11031.9 | 10998.3 | 11026.4 | 144.0 |
| 2008-01-20 18:30:00 | YM | Futures | 11023.7 | 11028.3 | 11015.5 | 11018.3 | 77.0 |
| 2008-01-20 19:00:00 | YM | Futures | 11020.1 | 11029.2 | 11015.5 | 11015.5 | 97.0 |
| 2008-01-20 19:30:00 | YM | Futures | 11015.5 | 11020.1 | 11005.5 | 11011.0 | 46.0 |
| 2008-01-20 20:00:00 | YM | Futures | 11011.0 | 11019.2 | 10995.6 | 11008.3 | 125.0 |
| 2008-01-20 20:30:00 | YM | Futures | 11007.4 | 11008.3 | 10959.2 | 10963.8 | 134.0 |
| 2008-01-20 21:00:00 | YM | Futures | 10965.6 | 10978.3 | 10961.0 | 10968.3 | 92.0 |
| 2008-01-20 21:30:00 | YM | Futures | 10971.9 | 10982.8 | 10967.4 | 10973.7 | 29.0 |
| 2008-01-20 22:00:00 | YM | Futures | 10970.1 | 10978.3 | 10968.3 | 10972.8 | 42.0 |
| 2008-01-20 22:30:00 | YM | Futures | 10978.3 | 10989.2 | 10971.9 | 10983.7 | 82.0 |
| 2008-01-20 23:00:00 | YM | Futures | 10981.0 | 10983.7 | 10971.9 | 10974.7 | 44.0 |
| 2008-01-20 23:30:00 | YM | Futures | 10972.8 | 10979.2 | 10965.6 | 10965.6 | 77.0 |
| 2008-01-20 18:00:00 | CL | Futures | 338.33 | 339.0 | 338.33 | 338.81 | 22.0 |
| 2008-01-20 18:30:00 | CL | Futures | 339.15 | 339.9 | 339.15 | 339.9 | 16.0 |
| 2008-01-20 19:00:00 | CL | Futures | 339.75 | 339.75 | 339.41 | 339.49 | 26.0 |
| 2008-01-20 19:30:00 | CL | Futures | 339.52 | 339.71 | 339.52 | 339.52 | 16.0 |
| 2008-01-20 20:00:00 | CL | Futures | 339.71 | 339.86 | 339.52 | 339.52 | 3.0 |
| 2008-01-20 20:30:00 | CL | Futures | 339.64 | 339.71 | 339.45 | 339.64 | 36.0 |
| 2008-01-20 21:00:00 | CL | Futures | 339.64 | 339.64 | 339.52 | 339.56 | 33.0 |
| 2008-01-20 21:30:00 | CL | Futures | 339.67 | 339.82 | 339.67 | 339.71 | 9.0 |
| 2008-01-20 22:00:00 | CL | Futures | 339.71 | 339.71 | 339.52 | 339.67 | 32.0 |
| 2008-01-20 22:30:00 | CL | Futures | 339.67 | 339.67 | 339.3 | 339.34 | 9.0 |
| 2008-01-20 23:00:00 | CL | Futures | 339.56 | 339.56 | 339.34 | 339.34 | 8.0 |
> showing 47 of 230 rows — these rows as CSV