PREVIEW / futures_30min / 2010-01-18
file: by_date/futures_30min/2010/2010-01-18.parquet size: 48 KB rows: 1,759
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-18 00:00:00 | ES | Futures | 1103.18 | 1103.42 | 1102.69 | 1103.18 | 563.0 |
| 2010-01-18 00:30:00 | ES | Futures | 1103.18 | 1103.91 | 1103.18 | 1103.67 | 769.0 |
| 2010-01-18 01:00:00 | ES | Futures | 1103.42 | 1103.67 | 1102.94 | 1103.18 | 358.0 |
| 2010-01-18 01:30:00 | ES | Futures | 1103.18 | 1103.91 | 1102.94 | 1103.42 | 818.0 |
| 2010-01-18 02:00:00 | ES | Futures | 1103.67 | 1104.88 | 1103.18 | 1104.15 | 4128.0 |
| 2010-01-18 02:30:00 | ES | Futures | 1104.15 | 1104.39 | 1102.94 | 1104.15 | 2098.0 |
| 2010-01-18 03:00:00 | ES | Futures | 1104.39 | 1104.64 | 1103.18 | 1103.91 | 9196.0 |
| 2010-01-18 03:30:00 | ES | Futures | 1104.15 | 1104.15 | 1101.23 | 1101.96 | 8046.0 |
| 2010-01-18 04:00:00 | ES | Futures | 1102.21 | 1103.67 | 1101.72 | 1103.18 | 6648.0 |
| 2010-01-18 04:30:00 | ES | Futures | 1103.18 | 1104.64 | 1102.94 | 1104.15 | 4642.0 |
| 2010-01-18 05:00:00 | ES | Futures | 1104.15 | 1104.64 | 1103.91 | 1104.15 | 5357.0 |
| 2010-01-18 05:30:00 | ES | Futures | 1104.39 | 1104.39 | 1103.42 | 1103.91 | 4703.0 |
| 2010-01-18 06:00:00 | ES | Futures | 1103.91 | 1104.15 | 1102.69 | 1103.91 | 5350.0 |
| 2010-01-18 06:30:00 | ES | Futures | 1103.91 | 1104.64 | 1103.67 | 1104.39 | 2723.0 |
| 2010-01-18 07:00:00 | ES | Futures | 1104.15 | 1104.64 | 1103.67 | 1104.64 | 1779.0 |
| 2010-01-18 07:30:00 | ES | Futures | 1104.39 | 1104.64 | 1104.15 | 1104.64 | 1954.0 |
| 2010-01-18 08:00:00 | ES | Futures | 1104.64 | 1104.88 | 1104.15 | 1104.88 | 3095.0 |
| 2010-01-18 08:30:00 | ES | Futures | 1104.88 | 1105.37 | 1103.91 | 1104.39 | 5769.0 |
| 2010-01-18 09:00:00 | ES | Futures | 1104.39 | 1104.88 | 1103.91 | 1104.64 | 1895.0 |
| 2010-01-18 09:30:00 | ES | Futures | 1104.88 | 1105.85 | 1104.39 | 1105.12 | 7119.0 |
| 2010-01-18 10:00:00 | ES | Futures | 1104.88 | 1105.85 | 1104.88 | 1105.61 | 4305.0 |
| 2010-01-18 10:30:00 | ES | Futures | 1105.61 | 1105.85 | 1105.12 | 1105.85 | 4572.0 |
| 2010-01-18 11:00:00 | ES | Futures | 1105.85 | 1106.34 | 1105.61 | 1106.1 | 7942.0 |
| 2010-01-18 18:00:00 | ES | Futures | 1105.85 | 1107.07 | 1105.61 | 1106.34 | 3247.0 |
| 2010-01-18 18:30:00 | ES | Futures | 1106.34 | 1106.83 | 1105.85 | 1106.34 | 2295.0 |
| 2010-01-18 19:00:00 | ES | Futures | 1106.58 | 1106.58 | 1105.12 | 1105.12 | 2359.0 |
| 2010-01-18 19:30:00 | ES | Futures | 1105.12 | 1106.1 | 1105.12 | 1105.85 | 1846.0 |
| 2010-01-18 20:00:00 | ES | Futures | 1105.85 | 1106.1 | 1105.61 | 1106.1 | 1681.0 |
| 2010-01-18 20:30:00 | ES | Futures | 1106.1 | 1106.1 | 1105.37 | 1105.37 | 1606.0 |
| 2010-01-18 21:00:00 | ES | Futures | 1105.37 | 1105.85 | 1104.39 | 1104.39 | 3740.0 |
| 2010-01-18 21:30:00 | ES | Futures | 1104.64 | 1105.12 | 1104.15 | 1104.64 | 3452.0 |
| 2010-01-18 22:00:00 | ES | Futures | 1104.39 | 1104.88 | 1104.39 | 1104.64 | 1653.0 |
| 2010-01-18 22:30:00 | ES | Futures | 1104.39 | 1105.85 | 1104.39 | 1105.12 | 1527.0 |
| 2010-01-18 23:00:00 | ES | Futures | 1105.12 | 1105.37 | 1104.39 | 1104.88 | 1257.0 |
| 2010-01-18 23:30:00 | ES | Futures | 1104.88 | 1105.12 | 1104.39 | 1104.39 | 670.0 |
| 2010-01-18 00:00:00 | NQ | Futures | 2129.08 | 2130.22 | 2128.79 | 2129.94 | 187.0 |
| 2010-01-18 00:30:00 | NQ | Futures | 2129.94 | 2130.22 | 2129.37 | 2129.65 | 267.0 |
| 2010-01-18 01:00:00 | NQ | Futures | 2129.37 | 2129.65 | 2128.51 | 2128.79 | 104.0 |
| 2010-01-18 01:30:00 | NQ | Futures | 2128.79 | 2130.22 | 2128.79 | 2129.08 | 181.0 |
| 2010-01-18 02:00:00 | NQ | Futures | 2129.37 | 2132.22 | 2128.51 | 2130.79 | 528.0 |
| 2010-01-18 02:30:00 | NQ | Futures | 2130.79 | 2131.36 | 2128.79 | 2131.08 | 218.0 |
| 2010-01-18 03:00:00 | NQ | Futures | 2130.79 | 2134.22 | 2129.37 | 2132.22 | 968.0 |
| 2010-01-18 03:30:00 | NQ | Futures | 2131.94 | 2132.51 | 2127.37 | 2129.08 | 1603.0 |
| 2010-01-18 04:00:00 | NQ | Futures | 2129.08 | 2131.36 | 2128.51 | 2130.22 | 812.0 |
| 2010-01-18 04:30:00 | NQ | Futures | 2130.22 | 2133.08 | 2129.37 | 2131.94 | 752.0 |
| 2010-01-18 05:00:00 | NQ | Futures | 2131.94 | 2132.79 | 2131.08 | 2132.22 | 313.0 |
| 2010-01-18 05:30:00 | NQ | Futures | 2132.22 | 2132.51 | 2129.65 | 2130.79 | 460.0 |
| 2010-01-18 06:00:00 | NQ | Futures | 2130.79 | 2131.36 | 2128.79 | 2130.79 | 857.0 |
| 2010-01-18 06:30:00 | NQ | Futures | 2130.79 | 2131.94 | 2130.51 | 2131.65 | 314.0 |
| 2010-01-18 07:00:00 | NQ | Futures | 2131.08 | 2131.65 | 2130.22 | 2131.36 | 309.0 |
> showing 50 of 1,759 rows — these rows as CSV