PREVIEW / futures_30min / 2010-01-07
file: by_date/futures_30min/2010/2010-01-07.parquet size: 69 KB rows: 2,554
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-07 00:00:00 | ES | Futures | 1100.99 | 1101.23 | 1100.26 | 1100.26 | 2287.0 |
| 2010-01-07 00:30:00 | ES | Futures | 1100.5 | 1100.99 | 1100.02 | 1100.26 | 1332.0 |
| 2010-01-07 01:00:00 | ES | Futures | 1100.5 | 1100.5 | 1099.53 | 1099.53 | 2700.0 |
| 2010-01-07 01:30:00 | ES | Futures | 1099.77 | 1100.02 | 1099.04 | 1099.77 | 2967.0 |
| 2010-01-07 02:00:00 | ES | Futures | 1100.02 | 1100.02 | 1099.04 | 1099.29 | 3639.0 |
| 2010-01-07 02:30:00 | ES | Futures | 1099.53 | 1100.75 | 1099.53 | 1100.5 | 4707.0 |
| 2010-01-07 03:00:00 | ES | Futures | 1100.5 | 1100.75 | 1099.04 | 1100.26 | 8234.0 |
| 2010-01-07 03:30:00 | ES | Futures | 1100.02 | 1100.26 | 1097.58 | 1097.83 | 13933.0 |
| 2010-01-07 04:00:00 | ES | Futures | 1098.07 | 1100.02 | 1097.58 | 1099.77 | 6643.0 |
| 2010-01-07 04:30:00 | ES | Futures | 1099.77 | 1099.77 | 1096.61 | 1097.1 | 13220.0 |
| 2010-01-07 05:00:00 | ES | Futures | 1097.34 | 1098.31 | 1096.85 | 1098.07 | 6837.0 |
| 2010-01-07 05:30:00 | ES | Futures | 1097.83 | 1098.56 | 1097.1 | 1097.83 | 4282.0 |
| 2010-01-07 06:00:00 | ES | Futures | 1097.83 | 1099.29 | 1097.34 | 1099.04 | 5176.0 |
| 2010-01-07 06:30:00 | ES | Futures | 1099.29 | 1099.53 | 1098.31 | 1098.31 | 5296.0 |
| 2010-01-07 07:00:00 | ES | Futures | 1098.56 | 1099.53 | 1097.83 | 1098.8 | 6054.0 |
| 2010-01-07 07:30:00 | ES | Futures | 1099.04 | 1099.29 | 1098.07 | 1098.07 | 12190.0 |
| 2010-01-07 08:00:00 | ES | Futures | 1098.31 | 1100.02 | 1098.07 | 1099.04 | 19228.0 |
| 2010-01-07 08:30:00 | ES | Futures | 1099.04 | 1100.5 | 1098.56 | 1099.77 | 20766.0 |
| 2010-01-07 09:00:00 | ES | Futures | 1099.77 | 1100.5 | 1099.53 | 1100.26 | 18424.0 |
| 2010-01-07 09:30:00 | ES | Futures | 1100.02 | 1101.96 | 1097.1 | 1097.83 | 177459.0 |
| 2010-01-07 10:00:00 | ES | Futures | 1097.58 | 1100.02 | 1097.34 | 1099.77 | 103276.0 |
| 2010-01-07 10:30:00 | ES | Futures | 1099.77 | 1104.39 | 1099.29 | 1103.18 | 161158.0 |
| 2010-01-07 11:00:00 | ES | Futures | 1102.94 | 1103.91 | 1102.69 | 1102.94 | 59316.0 |
| 2010-01-07 11:30:00 | ES | Futures | 1102.69 | 1103.42 | 1101.96 | 1102.94 | 67613.0 |
| 2010-01-07 12:00:00 | ES | Futures | 1102.69 | 1104.64 | 1102.45 | 1103.67 | 82245.0 |
| 2010-01-07 12:30:00 | ES | Futures | 1103.91 | 1105.37 | 1103.42 | 1103.67 | 68525.0 |
| 2010-01-07 13:00:00 | ES | Futures | 1103.67 | 1104.64 | 1102.69 | 1104.39 | 45832.0 |
| 2010-01-07 13:30:00 | ES | Futures | 1104.15 | 1105.12 | 1103.67 | 1104.15 | 61729.0 |
| 2010-01-07 14:00:00 | ES | Futures | 1104.15 | 1105.37 | 1103.91 | 1105.37 | 53754.0 |
| 2010-01-07 14:30:00 | ES | Futures | 1105.37 | 1107.8 | 1105.12 | 1107.07 | 127341.0 |
| 2010-01-07 15:00:00 | ES | Futures | 1106.83 | 1107.31 | 1103.91 | 1106.83 | 165224.0 |
| 2010-01-07 15:30:00 | ES | Futures | 1106.83 | 1108.04 | 1106.58 | 1107.07 | 130320.0 |
| 2010-01-07 16:00:00 | ES | Futures | 1106.83 | 1107.31 | 1106.34 | 1107.07 | 79335.0 |
| 2010-01-07 16:30:00 | ES | Futures | 1106.58 | 1107.07 | 1106.1 | 1106.83 | 4589.0 |
| 2010-01-07 17:00:00 | ES | Futures | 1106.83 | 1106.83 | 1106.34 | 1106.34 | 1122.0 |
| 2010-01-07 18:00:00 | ES | Futures | 1106.58 | 1106.83 | 1106.1 | 1106.34 | 1624.0 |
| 2010-01-07 18:30:00 | ES | Futures | 1106.58 | 1106.83 | 1106.1 | 1106.83 | 1720.0 |
| 2010-01-07 19:00:00 | ES | Futures | 1106.58 | 1107.31 | 1106.58 | 1107.07 | 2040.0 |
| 2010-01-07 19:30:00 | ES | Futures | 1107.31 | 1107.31 | 1106.83 | 1107.07 | 956.0 |
| 2010-01-07 20:00:00 | ES | Futures | 1107.31 | 1107.56 | 1106.58 | 1106.83 | 1435.0 |
| 2010-01-07 20:30:00 | ES | Futures | 1106.83 | 1107.07 | 1106.34 | 1106.58 | 1262.0 |
| 2010-01-07 21:00:00 | ES | Futures | 1106.58 | 1107.07 | 1106.58 | 1107.07 | 730.0 |
| 2010-01-07 21:30:00 | ES | Futures | 1107.07 | 1107.07 | 1106.34 | 1106.83 | 1314.0 |
| 2010-01-07 22:00:00 | ES | Futures | 1106.83 | 1107.8 | 1106.83 | 1107.56 | 1524.0 |
| 2010-01-07 22:30:00 | ES | Futures | 1107.56 | 1108.04 | 1107.31 | 1107.31 | 1337.0 |
| 2010-01-07 23:00:00 | ES | Futures | 1107.56 | 1107.56 | 1106.1 | 1106.83 | 1567.0 |
| 2010-01-07 23:30:00 | ES | Futures | 1106.83 | 1107.56 | 1106.58 | 1107.07 | 558.0 |
| 2010-01-07 00:00:00 | NQ | Futures | 2144.22 | 2144.22 | 2142.79 | 2143.08 | 100.0 |
| 2010-01-07 00:30:00 | NQ | Futures | 2142.79 | 2143.65 | 2142.79 | 2143.08 | 70.0 |
| 2010-01-07 01:00:00 | NQ | Futures | 2142.79 | 2143.08 | 2141.36 | 2141.36 | 112.0 |
> showing 50 of 2,554 rows — these rows as CSV