PREVIEW / futures_30min / 2008-08-24
file: by_date/futures_30min/2008/2008-08-24.parquet size: 17 KB rows: 366
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-08-24 18:00:00 | ES | Futures | 1200.19 | 1201.35 | 1199.73 | 1200.43 | 1785.0 |
| 2008-08-24 18:30:00 | ES | Futures | 1200.43 | 1200.43 | 1199.5 | 1200.19 | 567.0 |
| 2008-08-24 19:00:00 | ES | Futures | 1200.19 | 1200.43 | 1199.03 | 1199.03 | 895.0 |
| 2008-08-24 19:30:00 | ES | Futures | 1199.03 | 1199.03 | 1196.94 | 1197.64 | 2340.0 |
| 2008-08-24 20:00:00 | ES | Futures | 1197.64 | 1198.57 | 1197.4 | 1198.1 | 1082.0 |
| 2008-08-24 20:30:00 | ES | Futures | 1198.1 | 1198.33 | 1197.64 | 1198.1 | 748.0 |
| 2008-08-24 21:00:00 | ES | Futures | 1198.1 | 1199.96 | 1197.87 | 1199.96 | 1979.0 |
| 2008-08-24 21:30:00 | ES | Futures | 1199.73 | 1199.96 | 1198.57 | 1199.03 | 685.0 |
| 2008-08-24 22:00:00 | ES | Futures | 1198.8 | 1199.26 | 1198.33 | 1198.8 | 745.0 |
| 2008-08-24 22:30:00 | ES | Futures | 1198.57 | 1199.26 | 1198.57 | 1198.8 | 506.0 |
| 2008-08-24 23:00:00 | ES | Futures | 1198.8 | 1199.26 | 1198.8 | 1199.03 | 164.0 |
| 2008-08-24 23:30:00 | ES | Futures | 1198.8 | 1199.26 | 1198.8 | 1199.26 | 315.0 |
| 2008-08-24 18:00:00 | NQ | Futures | 2171.55 | 2171.55 | 2169.02 | 2169.86 | 109.0 |
| 2008-08-24 18:30:00 | NQ | Futures | 2170.42 | 2170.71 | 2168.46 | 2169.86 | 45.0 |
| 2008-08-24 19:00:00 | NQ | Futures | 2169.86 | 2169.86 | 2167.89 | 2168.17 | 42.0 |
| 2008-08-24 19:30:00 | NQ | Futures | 2167.61 | 2167.61 | 2163.95 | 2165.92 | 488.0 |
| 2008-08-24 20:00:00 | NQ | Futures | 2166.2 | 2166.77 | 2165.92 | 2165.92 | 134.0 |
| 2008-08-24 20:30:00 | NQ | Futures | 2166.2 | 2167.05 | 2165.92 | 2166.77 | 79.0 |
| 2008-08-24 21:00:00 | NQ | Futures | 2167.33 | 2170.42 | 2165.92 | 2170.42 | 267.0 |
| 2008-08-24 21:30:00 | NQ | Futures | 2169.86 | 2170.42 | 2167.33 | 2169.02 | 134.0 |
| 2008-08-24 22:00:00 | NQ | Futures | 2168.74 | 2169.02 | 2167.61 | 2168.46 | 18.0 |
| 2008-08-24 22:30:00 | NQ | Futures | 2168.46 | 2169.02 | 2167.61 | 2168.17 | 6.0 |
| 2008-08-24 23:00:00 | NQ | Futures | 2168.17 | 2168.17 | 2168.17 | 2168.17 | 9.0 |
| 2008-08-24 23:30:00 | NQ | Futures | 2169.3 | 2169.3 | 2168.17 | 2168.46 | 35.0 |
| 2008-08-24 18:00:00 | YM | Futures | 10558.4 | 10561.1 | 10544.8 | 10552.0 | 113.0 |
| 2008-08-24 18:30:00 | YM | Futures | 10552.9 | 10552.9 | 10546.6 | 10549.3 | 33.0 |
| 2008-08-24 19:00:00 | YM | Futures | 10550.2 | 10552.0 | 10544.8 | 10544.8 | 114.0 |
| 2008-08-24 19:30:00 | YM | Futures | 10545.7 | 10545.7 | 10530.2 | 10532.9 | 158.0 |
| 2008-08-24 20:00:00 | YM | Futures | 10533.9 | 10541.1 | 10532.0 | 10537.5 | 90.0 |
| 2008-08-24 20:30:00 | YM | Futures | 10537.5 | 10542.9 | 10533.9 | 10541.1 | 111.0 |
| 2008-08-24 21:00:00 | YM | Futures | 10540.2 | 10551.1 | 10538.4 | 10550.2 | 164.0 |
| 2008-08-24 21:30:00 | YM | Futures | 10550.2 | 10551.1 | 10539.3 | 10544.8 | 79.0 |
| 2008-08-24 22:00:00 | YM | Futures | 10544.8 | 10546.6 | 10541.1 | 10543.8 | 42.0 |
| 2008-08-24 22:30:00 | YM | Futures | 10542.9 | 10548.4 | 10540.2 | 10542.9 | 48.0 |
| 2008-08-24 23:00:00 | YM | Futures | 10545.7 | 10548.4 | 10542.9 | 10542.9 | 56.0 |
| 2008-08-24 23:30:00 | YM | Futures | 10544.8 | 10549.3 | 10538.4 | 10546.6 | 108.0 |
| 2008-08-24 18:00:00 | CL | Futures | 433.64 | 434.43 | 432.46 | 432.81 | 457.0 |
| 2008-08-24 18:30:00 | CL | Futures | 432.81 | 432.92 | 431.33 | 431.78 | 223.0 |
| 2008-08-24 19:00:00 | CL | Futures | 431.63 | 432.58 | 431.33 | 432.31 | 338.0 |
| 2008-08-24 19:30:00 | CL | Futures | 432.35 | 433.15 | 431.97 | 433.15 | 142.0 |
| 2008-08-24 20:00:00 | CL | Futures | 433.03 | 433.64 | 431.97 | 432.2 | 176.0 |
| 2008-08-24 20:30:00 | CL | Futures | 432.28 | 432.28 | 431.37 | 431.67 | 148.0 |
| 2008-08-24 21:00:00 | CL | Futures | 431.41 | 432.12 | 431.14 | 431.71 | 148.0 |
| 2008-08-24 21:30:00 | CL | Futures | 431.6 | 432.43 | 431.33 | 432.35 | 157.0 |
| 2008-08-24 22:00:00 | CL | Futures | 432.24 | 433.49 | 432.24 | 433.15 | 91.0 |
| 2008-08-24 22:30:00 | CL | Futures | 432.88 | 433.56 | 432.65 | 433.37 | 117.0 |
| 2008-08-24 23:00:00 | CL | Futures | 433.6 | 433.94 | 432.92 | 433.75 | 159.0 |
| 2008-08-24 23:30:00 | CL | Futures | 433.6 | 433.6 | 432.96 | 433.15 | 57.0 |
| 2008-08-24 18:00:00 | GC | Futures | 1186.2 | 1186.3 | 1179.5 | 1182.0 | 535.0 |
| 2008-08-24 18:30:00 | GC | Futures | 1182.2 | 1183.2 | 1181.0 | 1182.2 | 70.0 |
> showing 50 of 366 rows — these rows as CSV