PREVIEW / futures_30min / 2008-10-05
file: by_date/futures_30min/2008/2008-10-05.parquet size: 20 KB rows: 453
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-10-05 18:00:00 | ES | Futures | 1044.81 | 1045.04 | 1035.82 | 1036.29 | 19769.0 |
| 2008-10-05 18:30:00 | ES | Futures | 1036.53 | 1037.24 | 1032.03 | 1037.24 | 9670.0 |
| 2008-10-05 19:00:00 | ES | Futures | 1037.0 | 1037.24 | 1029.66 | 1031.32 | 7861.0 |
| 2008-10-05 19:30:00 | ES | Futures | 1031.08 | 1034.4 | 1030.37 | 1030.85 | 5505.0 |
| 2008-10-05 20:00:00 | ES | Futures | 1031.08 | 1036.05 | 1031.08 | 1032.27 | 5975.0 |
| 2008-10-05 20:30:00 | ES | Futures | 1032.27 | 1035.58 | 1031.56 | 1031.56 | 4046.0 |
| 2008-10-05 21:00:00 | ES | Futures | 1031.79 | 1033.45 | 1030.37 | 1030.85 | 6120.0 |
| 2008-10-05 21:30:00 | ES | Futures | 1030.85 | 1032.03 | 1030.37 | 1031.32 | 2338.0 |
| 2008-10-05 22:00:00 | ES | Futures | 1031.08 | 1031.56 | 1029.9 | 1030.85 | 2073.0 |
| 2008-10-05 22:30:00 | ES | Futures | 1030.85 | 1033.92 | 1030.85 | 1033.69 | 3450.0 |
| 2008-10-05 23:00:00 | ES | Futures | 1033.92 | 1034.63 | 1032.27 | 1032.5 | 1736.0 |
| 2008-10-05 23:30:00 | ES | Futures | 1032.74 | 1033.92 | 1032.27 | 1033.21 | 993.0 |
| 2008-10-05 18:00:00 | NQ | Futures | 1672.88 | 1675.14 | 1653.64 | 1655.05 | 1736.0 |
| 2008-10-05 18:30:00 | NQ | Futures | 1654.2 | 1657.03 | 1651.94 | 1656.47 | 488.0 |
| 2008-10-05 19:00:00 | NQ | Futures | 1656.18 | 1657.88 | 1647.7 | 1651.94 | 609.0 |
| 2008-10-05 19:30:00 | NQ | Futures | 1651.37 | 1654.77 | 1648.83 | 1649.68 | 178.0 |
| 2008-10-05 20:00:00 | NQ | Futures | 1651.37 | 1657.88 | 1650.81 | 1653.92 | 341.0 |
| 2008-10-05 20:30:00 | NQ | Futures | 1653.64 | 1657.6 | 1653.07 | 1653.35 | 144.0 |
| 2008-10-05 21:00:00 | NQ | Futures | 1651.94 | 1654.2 | 1648.54 | 1649.68 | 218.0 |
| 2008-10-05 21:30:00 | NQ | Futures | 1649.39 | 1650.53 | 1647.7 | 1648.54 | 266.0 |
| 2008-10-05 22:00:00 | NQ | Futures | 1648.54 | 1648.54 | 1642.89 | 1645.15 | 268.0 |
| 2008-10-05 22:30:00 | NQ | Futures | 1646.0 | 1649.96 | 1645.71 | 1649.68 | 212.0 |
| 2008-10-05 23:00:00 | NQ | Futures | 1649.96 | 1652.22 | 1648.26 | 1648.83 | 195.0 |
| 2008-10-05 23:30:00 | NQ | Futures | 1649.96 | 1650.24 | 1648.54 | 1648.83 | 178.0 |
| 2008-10-05 18:00:00 | YM | Futures | 9402.6 | 9402.6 | 9316.2 | 9321.7 | 629.0 |
| 2008-10-05 18:30:00 | YM | Futures | 9318.0 | 9327.1 | 9277.1 | 9319.8 | 1024.0 |
| 2008-10-05 19:00:00 | YM | Futures | 9320.7 | 9322.6 | 9258.9 | 9274.4 | 627.0 |
| 2008-10-05 19:30:00 | YM | Futures | 9271.6 | 9300.7 | 9258.9 | 9266.2 | 650.0 |
| 2008-10-05 20:00:00 | YM | Futures | 9268.9 | 9309.8 | 9268.9 | 9278.0 | 395.0 |
| 2008-10-05 20:30:00 | YM | Futures | 9280.7 | 9303.5 | 9273.5 | 9273.5 | 359.0 |
| 2008-10-05 21:00:00 | YM | Futures | 9274.4 | 9285.3 | 9262.5 | 9268.0 | 341.0 |
| 2008-10-05 21:30:00 | YM | Futures | 9268.9 | 9277.1 | 9261.6 | 9272.5 | 215.0 |
| 2008-10-05 22:00:00 | YM | Futures | 9268.9 | 9271.6 | 9260.7 | 9266.2 | 183.0 |
| 2008-10-05 22:30:00 | YM | Futures | 9270.7 | 9293.5 | 9270.7 | 9291.6 | 193.0 |
| 2008-10-05 23:00:00 | YM | Futures | 9292.6 | 9298.0 | 9282.5 | 9286.2 | 159.0 |
| 2008-10-05 23:30:00 | YM | Futures | 9285.3 | 9295.3 | 9282.5 | 9288.9 | 56.0 |
| 2008-10-05 18:00:00 | CL | Futures | 348.87 | 349.55 | 345.48 | 346.8 | 624.0 |
| 2008-10-05 18:30:00 | CL | Futures | 346.84 | 347.44 | 346.46 | 346.5 | 186.0 |
| 2008-10-05 19:00:00 | CL | Futures | 346.46 | 346.8 | 346.31 | 346.42 | 252.0 |
| 2008-10-05 19:30:00 | CL | Futures | 346.46 | 347.06 | 346.31 | 346.69 | 192.0 |
| 2008-10-05 20:00:00 | CL | Futures | 346.69 | 347.14 | 346.05 | 346.54 | 226.0 |
| 2008-10-05 20:30:00 | CL | Futures | 346.42 | 348.42 | 346.42 | 346.54 | 212.0 |
| 2008-10-05 21:00:00 | CL | Futures | 346.54 | 348.08 | 346.2 | 346.54 | 118.0 |
| 2008-10-05 21:30:00 | CL | Futures | 346.54 | 348.23 | 346.27 | 347.03 | 102.0 |
| 2008-10-05 22:00:00 | CL | Futures | 347.59 | 347.59 | 346.8 | 346.99 | 54.0 |
| 2008-10-05 22:30:00 | CL | Futures | 346.84 | 347.06 | 346.84 | 346.99 | 55.0 |
| 2008-10-05 23:00:00 | CL | Futures | 346.88 | 348.01 | 346.84 | 347.74 | 173.0 |
| 2008-10-05 23:30:00 | CL | Futures | 347.74 | 347.89 | 347.33 | 347.44 | 47.0 |
| 2008-10-05 18:00:00 | GC | Futures | 1193.2 | 1194.9 | 1189.9 | 1191.2 | 1072.0 |
| 2008-10-05 18:30:00 | GC | Futures | 1191.4 | 1191.7 | 1190.7 | 1190.9 | 389.0 |
> showing 50 of 453 rows — these rows as CSV