PREVIEW / futures_30min / 2008-08-03
file: by_date/futures_30min/2008/2008-08-03.parquet size: 18 KB rows: 419
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-03 18:00:00 | ES | Futures | 1172.54 | 1173.7 | 1171.14 | 1173.47 | 1975.0 |
| 2008-08-03 18:30:00 | ES | Futures | 1173.47 | 1174.39 | 1173.0 | 1173.7 | 862.0 |
| 2008-08-03 19:00:00 | ES | Futures | 1173.7 | 1173.7 | 1173.23 | 1173.7 | 178.0 |
| 2008-08-03 19:30:00 | ES | Futures | 1173.47 | 1173.7 | 1172.77 | 1173.23 | 795.0 |
| 2008-08-03 20:00:00 | ES | Futures | 1173.23 | 1173.93 | 1172.3 | 1172.54 | 1076.0 |
| 2008-08-03 20:30:00 | ES | Futures | 1172.54 | 1172.77 | 1171.37 | 1171.61 | 1173.0 |
| 2008-08-03 21:00:00 | ES | Futures | 1171.84 | 1172.07 | 1171.14 | 1171.37 | 822.0 |
| 2008-08-03 21:30:00 | ES | Futures | 1171.61 | 1171.61 | 1170.68 | 1171.14 | 1215.0 |
| 2008-08-03 22:00:00 | ES | Futures | 1171.14 | 1171.61 | 1170.21 | 1170.44 | 885.0 |
| 2008-08-03 22:30:00 | ES | Futures | 1170.68 | 1170.68 | 1169.75 | 1169.98 | 808.0 |
| 2008-08-03 23:00:00 | ES | Futures | 1170.21 | 1170.68 | 1169.98 | 1170.44 | 525.0 |
| 2008-08-03 23:30:00 | ES | Futures | 1170.68 | 1170.68 | 1169.98 | 1170.68 | 327.0 |
| 2008-08-03 18:00:00 | NQ | Futures | 2062.69 | 2065.78 | 2061.85 | 2065.78 | 151.0 |
| 2008-08-03 18:30:00 | NQ | Futures | 2065.78 | 2067.19 | 2064.94 | 2065.5 | 170.0 |
| 2008-08-03 19:00:00 | NQ | Futures | 2065.22 | 2066.07 | 2065.22 | 2066.07 | 13.0 |
| 2008-08-03 19:30:00 | NQ | Futures | 2065.5 | 2065.5 | 2063.53 | 2064.38 | 89.0 |
| 2008-08-03 20:00:00 | NQ | Futures | 2064.38 | 2065.78 | 2062.97 | 2062.97 | 31.0 |
| 2008-08-03 20:30:00 | NQ | Futures | 2062.97 | 2063.53 | 2061.85 | 2061.85 | 78.0 |
| 2008-08-03 21:00:00 | NQ | Futures | 2061.85 | 2061.85 | 2061.28 | 2061.57 | 31.0 |
| 2008-08-03 21:30:00 | NQ | Futures | 2061.57 | 2061.57 | 2059.88 | 2059.88 | 82.0 |
| 2008-08-03 22:00:00 | NQ | Futures | 2060.16 | 2062.69 | 2059.6 | 2059.6 | 32.0 |
| 2008-08-03 22:30:00 | NQ | Futures | 2059.88 | 2060.44 | 2059.03 | 2059.6 | 27.0 |
| 2008-08-03 23:00:00 | NQ | Futures | 2059.03 | 2059.88 | 2058.75 | 2059.32 | 61.0 |
| 2008-08-03 23:30:00 | NQ | Futures | 2059.03 | 2059.88 | 2058.75 | 2059.6 | 14.0 |
| 2008-08-03 18:00:00 | YM | Futures | 10279.4 | 10292.1 | 10279.4 | 10289.4 | 191.0 |
| 2008-08-03 18:30:00 | YM | Futures | 10289.4 | 10294.8 | 10288.5 | 10291.2 | 71.0 |
| 2008-08-03 19:00:00 | YM | Futures | 10291.2 | 10293.0 | 10288.5 | 10293.0 | 31.0 |
| 2008-08-03 19:30:00 | YM | Futures | 10293.0 | 10293.9 | 10284.8 | 10290.3 | 53.0 |
| 2008-08-03 20:00:00 | YM | Futures | 10288.5 | 10293.0 | 10283.0 | 10283.0 | 48.0 |
| 2008-08-03 20:30:00 | YM | Futures | 10282.1 | 10283.9 | 10273.0 | 10273.0 | 70.0 |
| 2008-08-03 21:00:00 | YM | Futures | 10275.7 | 10277.5 | 10271.2 | 10273.0 | 102.0 |
| 2008-08-03 21:30:00 | YM | Futures | 10273.0 | 10273.0 | 10265.7 | 10267.6 | 59.0 |
| 2008-08-03 22:00:00 | YM | Futures | 10272.1 | 10275.7 | 10263.0 | 10263.0 | 78.0 |
| 2008-08-03 22:30:00 | YM | Futures | 10264.8 | 10265.7 | 10262.1 | 10263.0 | 132.0 |
| 2008-08-03 23:00:00 | YM | Futures | 10261.2 | 10267.6 | 10261.2 | 10267.6 | 47.0 |
| 2008-08-03 23:30:00 | YM | Futures | 10264.8 | 10266.6 | 10263.9 | 10265.7 | 9.0 |
| 2008-08-03 18:00:00 | CL | Futures | 476.32 | 476.32 | 474.02 | 475.57 | 416.0 |
| 2008-08-03 18:30:00 | CL | Futures | 475.34 | 477.57 | 475.34 | 475.98 | 382.0 |
| 2008-08-03 19:00:00 | CL | Futures | 475.98 | 476.7 | 475.68 | 476.21 | 143.0 |
| 2008-08-03 19:30:00 | CL | Futures | 476.13 | 476.7 | 475.87 | 476.7 | 104.0 |
| 2008-08-03 20:00:00 | CL | Futures | 476.51 | 476.66 | 475.87 | 476.06 | 169.0 |
| 2008-08-03 20:30:00 | CL | Futures | 476.06 | 476.4 | 475.83 | 476.25 | 109.0 |
| 2008-08-03 21:00:00 | CL | Futures | 476.25 | 476.51 | 476.1 | 476.4 | 158.0 |
| 2008-08-03 21:30:00 | CL | Futures | 476.48 | 477.34 | 476.36 | 477.34 | 354.0 |
| 2008-08-03 22:00:00 | CL | Futures | 477.31 | 477.42 | 477.12 | 477.16 | 201.0 |
| 2008-08-03 22:30:00 | CL | Futures | 477.12 | 477.72 | 476.97 | 477.16 | 422.0 |
| 2008-08-03 23:00:00 | CL | Futures | 477.19 | 477.57 | 476.44 | 477.34 | 138.0 |
| 2008-08-03 23:30:00 | CL | Futures | 477.46 | 477.53 | 477.16 | 477.19 | 62.0 |
| 2008-08-03 18:00:00 | GC | Futures | 1311.6 | 1315.0 | 1311.5 | 1314.5 | 253.0 |
| 2008-08-03 18:30:00 | GC | Futures | 1314.0 | 1317.0 | 1314.0 | 1314.9 | 164.0 |
> showing 50 of 419 rows — these rows as CSV