PREVIEW / futures_30min / 2010-01-08
file: by_date/futures_30min/2010/2010-01-08.parquet size: 59 KB rows: 2,062
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-08 00:00:00 | ES | Futures | 1107.07 | 1107.8 | 1107.07 | 1107.07 | 758.0 |
| 2010-01-08 00:30:00 | ES | Futures | 1106.83 | 1107.07 | 1106.58 | 1107.07 | 724.0 |
| 2010-01-08 01:00:00 | ES | Futures | 1106.83 | 1107.8 | 1106.83 | 1107.8 | 1003.0 |
| 2010-01-08 01:30:00 | ES | Futures | 1107.8 | 1108.04 | 1107.31 | 1107.8 | 1291.0 |
| 2010-01-08 02:00:00 | ES | Futures | 1107.8 | 1108.77 | 1107.31 | 1108.53 | 3084.0 |
| 2010-01-08 02:30:00 | ES | Futures | 1108.53 | 1108.77 | 1107.31 | 1107.56 | 3582.0 |
| 2010-01-08 03:00:00 | ES | Futures | 1107.31 | 1108.29 | 1106.83 | 1108.04 | 7774.0 |
| 2010-01-08 03:30:00 | ES | Futures | 1107.8 | 1108.53 | 1107.56 | 1107.8 | 4184.0 |
| 2010-01-08 04:00:00 | ES | Futures | 1107.56 | 1107.8 | 1106.58 | 1107.56 | 6464.0 |
| 2010-01-08 04:30:00 | ES | Futures | 1107.31 | 1107.56 | 1106.83 | 1107.07 | 4750.0 |
| 2010-01-08 05:00:00 | ES | Futures | 1106.83 | 1107.56 | 1106.58 | 1107.31 | 4472.0 |
| 2010-01-08 05:30:00 | ES | Futures | 1107.56 | 1108.04 | 1107.07 | 1107.56 | 3342.0 |
| 2010-01-08 06:00:00 | ES | Futures | 1107.56 | 1108.04 | 1107.31 | 1107.8 | 3403.0 |
| 2010-01-08 06:30:00 | ES | Futures | 1107.8 | 1108.04 | 1107.31 | 1107.8 | 2241.0 |
| 2010-01-08 07:00:00 | ES | Futures | 1107.8 | 1107.8 | 1106.83 | 1107.07 | 6462.0 |
| 2010-01-08 07:30:00 | ES | Futures | 1107.31 | 1107.56 | 1105.85 | 1106.34 | 13802.0 |
| 2010-01-08 08:00:00 | ES | Futures | 1106.58 | 1108.77 | 1106.34 | 1108.29 | 24490.0 |
| 2010-01-08 08:30:00 | ES | Futures | 1108.04 | 1108.04 | 1100.5 | 1103.67 | 149194.0 |
| 2010-01-08 09:00:00 | ES | Futures | 1103.42 | 1105.12 | 1101.96 | 1103.91 | 52141.0 |
| 2010-01-08 09:30:00 | ES | Futures | 1104.15 | 1105.85 | 1101.48 | 1105.61 | 220839.0 |
| 2010-01-08 10:00:00 | ES | Futures | 1105.37 | 1106.83 | 1104.64 | 1105.85 | 151616.0 |
| 2010-01-08 10:30:00 | ES | Futures | 1105.85 | 1106.58 | 1104.15 | 1106.1 | 88796.0 |
| 2010-01-08 11:00:00 | ES | Futures | 1106.1 | 1107.07 | 1105.12 | 1106.1 | 79169.0 |
| 2010-01-08 11:30:00 | ES | Futures | 1106.34 | 1106.34 | 1104.39 | 1106.1 | 64214.0 |
| 2010-01-08 12:00:00 | ES | Futures | 1105.85 | 1106.58 | 1105.37 | 1106.34 | 38903.0 |
| 2010-01-08 12:30:00 | ES | Futures | 1106.1 | 1106.83 | 1105.37 | 1105.61 | 40119.0 |
| 2010-01-08 13:00:00 | ES | Futures | 1105.37 | 1107.31 | 1105.37 | 1106.58 | 40654.0 |
| 2010-01-08 13:30:00 | ES | Futures | 1106.58 | 1107.8 | 1105.37 | 1105.61 | 62514.0 |
| 2010-01-08 14:00:00 | ES | Futures | 1105.61 | 1106.34 | 1105.12 | 1106.1 | 50749.0 |
| 2010-01-08 14:30:00 | ES | Futures | 1105.85 | 1106.58 | 1105.37 | 1105.85 | 42548.0 |
| 2010-01-08 15:00:00 | ES | Futures | 1105.85 | 1107.07 | 1105.37 | 1107.07 | 53321.0 |
| 2010-01-08 15:30:00 | ES | Futures | 1106.83 | 1110.96 | 1106.58 | 1110.48 | 182051.0 |
| 2010-01-08 16:00:00 | ES | Futures | 1110.48 | 1110.96 | 1109.99 | 1110.72 | 87151.0 |
| 2010-01-08 00:00:00 | NQ | Futures | 2145.93 | 2147.36 | 2145.93 | 2146.22 | 59.0 |
| 2010-01-08 00:30:00 | NQ | Futures | 2145.65 | 2146.22 | 2145.36 | 2145.36 | 61.0 |
| 2010-01-08 01:00:00 | NQ | Futures | 2145.36 | 2147.36 | 2145.36 | 2147.36 | 112.0 |
| 2010-01-08 01:30:00 | NQ | Futures | 2147.65 | 2148.79 | 2147.07 | 2147.93 | 206.0 |
| 2010-01-08 02:00:00 | NQ | Futures | 2147.65 | 2148.79 | 2146.5 | 2148.5 | 423.0 |
| 2010-01-08 02:30:00 | NQ | Futures | 2148.79 | 2149.07 | 2146.5 | 2146.5 | 264.0 |
| 2010-01-08 03:00:00 | NQ | Futures | 2146.5 | 2147.93 | 2145.36 | 2146.79 | 1419.0 |
| 2010-01-08 03:30:00 | NQ | Futures | 2146.79 | 2148.22 | 2145.93 | 2145.93 | 1058.0 |
| 2010-01-08 04:00:00 | NQ | Futures | 2145.93 | 2146.22 | 2144.22 | 2145.07 | 1230.0 |
| 2010-01-08 04:30:00 | NQ | Futures | 2145.36 | 2145.93 | 2144.79 | 2145.36 | 334.0 |
| 2010-01-08 05:00:00 | NQ | Futures | 2145.36 | 2146.79 | 2144.79 | 2146.5 | 410.0 |
| 2010-01-08 05:30:00 | NQ | Futures | 2146.5 | 2147.65 | 2146.22 | 2147.07 | 340.0 |
| 2010-01-08 06:00:00 | NQ | Futures | 2147.36 | 2147.36 | 2146.22 | 2147.07 | 192.0 |
| 2010-01-08 06:30:00 | NQ | Futures | 2146.79 | 2147.93 | 2145.93 | 2147.93 | 316.0 |
| 2010-01-08 07:00:00 | NQ | Futures | 2147.65 | 2147.65 | 2145.36 | 2146.79 | 538.0 |
| 2010-01-08 07:30:00 | NQ | Futures | 2146.79 | 2147.07 | 2145.07 | 2146.22 | 1296.0 |
| 2010-01-08 08:00:00 | NQ | Futures | 2145.93 | 2150.22 | 2144.79 | 2149.93 | 2875.0 |
> showing 50 of 2,062 rows — these rows as CSV