PREVIEW / futures_30min / 2010-03-18
file: by_date/futures_30min/2010/2010-03-18.parquet size: 66 KB rows: 2,469
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-03-18 00:00:00 | ES | Futures | 1135.85 | 1136.34 | 1135.85 | 1136.34 | 700.0 |
| 2010-03-18 00:30:00 | ES | Futures | 1136.34 | 1136.58 | 1135.6 | 1135.6 | 558.0 |
| 2010-03-18 01:00:00 | ES | Futures | 1135.85 | 1135.85 | 1133.65 | 1133.89 | 4513.0 |
| 2010-03-18 01:30:00 | ES | Futures | 1133.65 | 1134.38 | 1133.4 | 1133.65 | 2625.0 |
| 2010-03-18 02:00:00 | ES | Futures | 1133.65 | 1133.89 | 1132.92 | 1133.16 | 2147.0 |
| 2010-03-18 02:30:00 | ES | Futures | 1133.16 | 1133.89 | 1132.92 | 1133.4 | 1355.0 |
| 2010-03-18 03:00:00 | ES | Futures | 1133.65 | 1133.89 | 1132.92 | 1133.16 | 4848.0 |
| 2010-03-18 03:30:00 | ES | Futures | 1133.16 | 1133.4 | 1131.69 | 1131.94 | 5585.0 |
| 2010-03-18 04:00:00 | ES | Futures | 1131.69 | 1132.92 | 1131.45 | 1132.92 | 12161.0 |
| 2010-03-18 04:30:00 | ES | Futures | 1132.67 | 1133.65 | 1132.43 | 1132.92 | 5973.0 |
| 2010-03-18 05:00:00 | ES | Futures | 1132.92 | 1132.92 | 1131.69 | 1132.92 | 5934.0 |
| 2010-03-18 05:30:00 | ES | Futures | 1132.67 | 1134.14 | 1132.43 | 1133.65 | 6395.0 |
| 2010-03-18 06:00:00 | ES | Futures | 1133.65 | 1134.38 | 1132.67 | 1133.65 | 5847.0 |
| 2010-03-18 06:30:00 | ES | Futures | 1133.65 | 1134.14 | 1133.65 | 1134.14 | 3851.0 |
| 2010-03-18 07:00:00 | ES | Futures | 1134.14 | 1134.38 | 1133.4 | 1134.38 | 5023.0 |
| 2010-03-18 07:30:00 | ES | Futures | 1134.38 | 1134.63 | 1133.65 | 1134.38 | 10887.0 |
| 2010-03-18 08:00:00 | ES | Futures | 1134.38 | 1135.36 | 1134.38 | 1134.87 | 16203.0 |
| 2010-03-18 08:30:00 | ES | Futures | 1134.87 | 1136.58 | 1134.14 | 1135.12 | 33930.0 |
| 2010-03-18 09:00:00 | ES | Futures | 1134.87 | 1136.09 | 1134.63 | 1135.85 | 16958.0 |
| 2010-03-18 09:30:00 | ES | Futures | 1135.6 | 1136.58 | 1134.38 | 1135.85 | 145775.0 |
| 2010-03-18 10:00:00 | ES | Futures | 1135.85 | 1137.32 | 1134.38 | 1134.87 | 111459.0 |
| 2010-03-18 10:30:00 | ES | Futures | 1134.87 | 1135.6 | 1132.92 | 1135.12 | 109101.0 |
| 2010-03-18 11:00:00 | ES | Futures | 1135.12 | 1136.34 | 1134.63 | 1135.12 | 126520.0 |
| 2010-03-18 11:30:00 | ES | Futures | 1135.36 | 1135.6 | 1131.69 | 1132.18 | 156350.0 |
| 2010-03-18 12:00:00 | ES | Futures | 1132.43 | 1132.67 | 1130.47 | 1132.18 | 128672.0 |
| 2010-03-18 12:30:00 | ES | Futures | 1132.43 | 1132.43 | 1130.47 | 1131.69 | 68905.0 |
| 2010-03-18 13:00:00 | ES | Futures | 1131.94 | 1133.89 | 1131.69 | 1133.4 | 56755.0 |
| 2010-03-18 13:30:00 | ES | Futures | 1133.4 | 1134.63 | 1132.67 | 1133.65 | 47899.0 |
| 2010-03-18 14:00:00 | ES | Futures | 1133.65 | 1134.38 | 1132.92 | 1133.65 | 56686.0 |
| 2010-03-18 14:30:00 | ES | Futures | 1133.65 | 1135.6 | 1132.43 | 1133.65 | 105038.0 |
| 2010-03-18 15:00:00 | ES | Futures | 1133.89 | 1134.87 | 1132.92 | 1134.87 | 73341.0 |
| 2010-03-18 15:30:00 | ES | Futures | 1134.63 | 1136.09 | 1134.14 | 1134.87 | 178144.0 |
| 2010-03-18 16:00:00 | ES | Futures | 1134.87 | 1136.09 | 1134.38 | 1135.85 | 83315.0 |
| 2010-03-18 16:30:00 | ES | Futures | 1135.36 | 1135.85 | 1135.12 | 1135.36 | 5442.0 |
| 2010-03-18 17:00:00 | ES | Futures | 1135.6 | 1135.85 | 1135.36 | 1135.36 | 1478.0 |
| 2010-03-18 18:00:00 | ES | Futures | 1135.6 | 1136.09 | 1135.12 | 1135.6 | 2660.0 |
| 2010-03-18 18:30:00 | ES | Futures | 1135.6 | 1135.6 | 1135.36 | 1135.6 | 478.0 |
| 2010-03-18 19:00:00 | ES | Futures | 1135.36 | 1135.85 | 1135.12 | 1135.12 | 884.0 |
| 2010-03-18 19:30:00 | ES | Futures | 1135.12 | 1135.12 | 1134.38 | 1134.63 | 1803.0 |
| 2010-03-18 20:00:00 | ES | Futures | 1134.87 | 1134.87 | 1134.38 | 1134.63 | 784.0 |
| 2010-03-18 20:30:00 | ES | Futures | 1134.63 | 1135.6 | 1134.63 | 1135.12 | 1176.0 |
| 2010-03-18 21:00:00 | ES | Futures | 1135.12 | 1135.36 | 1134.87 | 1134.87 | 429.0 |
| 2010-03-18 21:30:00 | ES | Futures | 1135.12 | 1136.34 | 1135.12 | 1135.85 | 1972.0 |
| 2010-03-18 22:00:00 | ES | Futures | 1135.85 | 1136.09 | 1135.12 | 1135.36 | 1090.0 |
| 2010-03-18 22:30:00 | ES | Futures | 1135.6 | 1136.34 | 1135.36 | 1135.36 | 2460.0 |
| 2010-03-18 23:00:00 | ES | Futures | 1135.36 | 1135.85 | 1135.12 | 1135.6 | 1035.0 |
| 2010-03-18 23:30:00 | ES | Futures | 1135.6 | 1135.85 | 1135.12 | 1135.36 | 629.0 |
| 2010-03-18 00:00:00 | NQ | Futures | 2215.38 | 2216.24 | 2215.38 | 2216.24 | 23.0 |
| 2010-03-18 00:30:00 | NQ | Futures | 2216.24 | 2216.52 | 2214.23 | 2214.23 | 36.0 |
| 2010-03-18 01:00:00 | NQ | Futures | 2214.23 | 2214.52 | 2212.8 | 2213.09 | 156.0 |
> showing 50 of 2,469 rows — these rows as CSV