PREVIEW / futures_30min / 2009-10-18
file: by_date/futures_30min/2009/2009-10-18.parquet size: 19 KB rows: 438
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-18 18:00:00 | ES | Futures | 1046.64 | 1047.12 | 1044.94 | 1045.67 | 5120.0 |
| 2009-10-18 18:30:00 | ES | Futures | 1045.91 | 1046.64 | 1045.67 | 1046.64 | 1251.0 |
| 2009-10-18 19:00:00 | ES | Futures | 1046.64 | 1047.37 | 1045.91 | 1045.91 | 1121.0 |
| 2009-10-18 19:30:00 | ES | Futures | 1046.16 | 1046.64 | 1045.43 | 1046.64 | 1789.0 |
| 2009-10-18 20:00:00 | ES | Futures | 1046.4 | 1046.4 | 1042.76 | 1043.25 | 7310.0 |
| 2009-10-18 20:30:00 | ES | Futures | 1043.25 | 1045.43 | 1042.76 | 1044.46 | 5526.0 |
| 2009-10-18 21:00:00 | ES | Futures | 1044.46 | 1044.46 | 1043.01 | 1043.49 | 3188.0 |
| 2009-10-18 21:30:00 | ES | Futures | 1043.49 | 1044.22 | 1043.25 | 1043.98 | 765.0 |
| 2009-10-18 22:00:00 | ES | Futures | 1043.98 | 1045.19 | 1043.98 | 1044.7 | 1927.0 |
| 2009-10-18 22:30:00 | ES | Futures | 1044.94 | 1046.16 | 1044.46 | 1045.91 | 1671.0 |
| 2009-10-18 23:00:00 | ES | Futures | 1045.91 | 1046.4 | 1045.67 | 1045.67 | 1195.0 |
| 2009-10-18 23:30:00 | ES | Futures | 1045.67 | 1047.12 | 1045.19 | 1046.4 | 1936.0 |
| 2009-10-18 18:00:00 | NQ | Futures | 1973.54 | 1973.54 | 1970.41 | 1971.83 | 434.0 |
| 2009-10-18 18:30:00 | NQ | Futures | 1971.83 | 1972.69 | 1971.55 | 1972.69 | 23.0 |
| 2009-10-18 19:00:00 | NQ | Futures | 1972.97 | 1974.68 | 1971.83 | 1971.83 | 96.0 |
| 2009-10-18 19:30:00 | NQ | Futures | 1972.12 | 1972.97 | 1970.98 | 1972.97 | 76.0 |
| 2009-10-18 20:00:00 | NQ | Futures | 1972.97 | 1972.97 | 1965.84 | 1966.7 | 738.0 |
| 2009-10-18 20:30:00 | NQ | Futures | 1967.27 | 1970.69 | 1966.13 | 1969.27 | 380.0 |
| 2009-10-18 21:00:00 | NQ | Futures | 1969.27 | 1969.27 | 1966.7 | 1967.27 | 237.0 |
| 2009-10-18 21:30:00 | NQ | Futures | 1967.55 | 1968.98 | 1967.27 | 1968.7 | 82.0 |
| 2009-10-18 22:00:00 | NQ | Futures | 1968.7 | 1970.98 | 1968.41 | 1970.12 | 241.0 |
| 2009-10-18 22:30:00 | NQ | Futures | 1970.12 | 1972.69 | 1970.12 | 1972.4 | 288.0 |
| 2009-10-18 23:00:00 | NQ | Futures | 1972.12 | 1973.26 | 1971.55 | 1972.12 | 131.0 |
| 2009-10-18 23:30:00 | NQ | Futures | 1971.83 | 1974.4 | 1971.26 | 1973.26 | 410.0 |
| 2009-10-18 18:00:00 | YM | Futures | 9220.0 | 9220.0 | 9205.1 | 9211.6 | 271.0 |
| 2009-10-18 18:30:00 | YM | Futures | 9210.7 | 9216.3 | 9208.8 | 9216.3 | 35.0 |
| 2009-10-18 19:00:00 | YM | Futures | 9218.1 | 9222.8 | 9212.5 | 9212.5 | 74.0 |
| 2009-10-18 19:30:00 | YM | Futures | 9210.7 | 9215.3 | 9208.8 | 9215.3 | 146.0 |
| 2009-10-18 20:00:00 | YM | Futures | 9216.3 | 9216.3 | 9186.5 | 9190.2 | 627.0 |
| 2009-10-18 20:30:00 | YM | Futures | 9190.2 | 9203.2 | 9184.6 | 9196.7 | 801.0 |
| 2009-10-18 21:00:00 | YM | Futures | 9197.7 | 9197.7 | 9188.4 | 9190.2 | 370.0 |
| 2009-10-18 21:30:00 | YM | Futures | 9191.2 | 9198.6 | 9191.2 | 9193.9 | 77.0 |
| 2009-10-18 22:00:00 | YM | Futures | 9196.7 | 9206.0 | 9195.8 | 9203.2 | 101.0 |
| 2009-10-18 22:30:00 | YM | Futures | 9204.2 | 9211.6 | 9199.5 | 9210.7 | 222.0 |
| 2009-10-18 23:00:00 | YM | Futures | 9209.8 | 9212.5 | 9207.9 | 9210.7 | 113.0 |
| 2009-10-18 23:30:00 | YM | Futures | 9210.7 | 9217.2 | 9205.1 | 9213.5 | 124.0 |
| 2009-10-18 18:00:00 | CL | Futures | 176.79 | 177.04 | 176.19 | 176.97 | 387.0 |
| 2009-10-18 18:30:00 | CL | Futures | 176.99 | 177.35 | 176.77 | 177.33 | 297.0 |
| 2009-10-18 19:00:00 | CL | Futures | 177.33 | 177.62 | 177.24 | 177.31 | 249.0 |
| 2009-10-18 19:30:00 | CL | Futures | 177.31 | 177.35 | 177.13 | 177.31 | 102.0 |
| 2009-10-18 20:00:00 | CL | Futures | 177.28 | 177.28 | 176.37 | 176.39 | 617.0 |
| 2009-10-18 20:30:00 | CL | Futures | 176.39 | 176.48 | 175.99 | 176.23 | 595.0 |
| 2009-10-18 21:00:00 | CL | Futures | 176.3 | 176.41 | 175.99 | 176.14 | 263.0 |
| 2009-10-18 21:30:00 | CL | Futures | 176.14 | 176.34 | 175.99 | 176.08 | 343.0 |
| 2009-10-18 22:00:00 | CL | Futures | 176.17 | 176.48 | 176.17 | 176.23 | 197.0 |
| 2009-10-18 22:30:00 | CL | Futures | 176.3 | 176.75 | 176.3 | 176.66 | 331.0 |
| 2009-10-18 23:00:00 | CL | Futures | 176.61 | 176.9 | 176.5 | 176.9 | 189.0 |
| 2009-10-18 23:30:00 | CL | Futures | 176.9 | 177.06 | 176.7 | 177.06 | 194.0 |
| 2009-10-18 18:00:00 | GC | Futures | 1487.1 | 1489.2 | 1485.1 | 1489.1 | 279.0 |
| 2009-10-18 18:30:00 | GC | Futures | 1488.9 | 1491.3 | 1488.5 | 1490.7 | 366.0 |
> showing 50 of 438 rows — these rows as CSV