PREVIEW / etf_30min / 2000-06-07
file: by_date/etf_30min/2000/2000-06-07.parquet size: 10 KB rows: 247
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-07 09:30:00 | SPY | ETF | 146.625 | 146.9375 | 146.3438 | 146.6875 | 587500.0 |
| 2000-06-07 10:00:00 | SPY | ETF | 146.625 | 146.875 | 146.0 | 146.1562 | 457400.0 |
| 2000-06-07 10:30:00 | SPY | ETF | 146.2188 | 146.4688 | 146.0625 | 146.3125 | 187100.0 |
| 2000-06-07 11:00:00 | SPY | ETF | 146.3438 | 146.75 | 146.3125 | 146.75 | 416800.0 |
| 2000-06-07 11:30:00 | SPY | ETF | 146.75 | 147.25 | 146.6875 | 146.875 | 567900.0 |
| 2000-06-07 12:00:00 | SPY | ETF | 146.9688 | 147.2188 | 146.8125 | 146.875 | 158300.0 |
| 2000-06-07 12:30:00 | SPY | ETF | 146.875 | 146.9375 | 146.625 | 146.7188 | 40900.0 |
| 2000-06-07 13:00:00 | SPY | ETF | 146.875 | 147.0625 | 146.7812 | 147.0 | 38400.0 |
| 2000-06-07 13:30:00 | SPY | ETF | 146.9062 | 147.0938 | 146.5312 | 146.9688 | 116700.0 |
| 2000-06-07 14:00:00 | SPY | ETF | 147.0625 | 147.7188 | 146.9688 | 147.4062 | 543200.0 |
| 2000-06-07 14:30:00 | SPY | ETF | 147.5 | 148.0 | 147.4688 | 147.75 | 198000.0 |
| 2000-06-07 15:00:00 | SPY | ETF | 147.6875 | 147.9375 | 147.1875 | 147.5 | 637800.0 |
| 2000-06-07 15:30:00 | SPY | ETF | 147.5625 | 148.0 | 147.375 | 147.5625 | 419200.0 |
| 2000-06-07 16:00:00 | SPY | ETF | 147.6875 | 147.6875 | 147.1875 | 147.4688 | 525200.0 |
| 2000-06-07 09:30:00 | QQQ | ETF | 91.5625 | 92.25 | 90.375 | 91.5 | 3535900.0 |
| 2000-06-07 10:00:00 | QQQ | ETF | 91.5 | 91.875 | 89.5625 | 90.125 | 2966700.0 |
| 2000-06-07 10:30:00 | QQQ | ETF | 90.125 | 90.9375 | 90.0 | 90.125 | 1294200.0 |
| 2000-06-07 11:00:00 | QQQ | ETF | 90.375 | 91.1875 | 90.1562 | 91.125 | 989200.0 |
| 2000-06-07 11:30:00 | QQQ | ETF | 91.125 | 91.75 | 91.0 | 91.375 | 1320900.0 |
| 2000-06-07 12:00:00 | QQQ | ETF | 91.3125 | 91.625 | 90.875 | 90.9375 | 561400.0 |
| 2000-06-07 12:30:00 | QQQ | ETF | 90.875 | 91.375 | 90.625 | 91.3125 | 796500.0 |
| 2000-06-07 13:00:00 | QQQ | ETF | 91.25 | 91.625 | 91.1562 | 91.4375 | 759900.0 |
| 2000-06-07 13:30:00 | QQQ | ETF | 91.4375 | 91.5 | 90.6875 | 91.1875 | 658000.0 |
| 2000-06-07 14:00:00 | QQQ | ETF | 91.2188 | 92.375 | 91.0312 | 92.3125 | 1900800.0 |
| 2000-06-07 14:30:00 | QQQ | ETF | 92.3125 | 92.9688 | 92.125 | 92.4375 | 2506600.0 |
| 2000-06-07 15:00:00 | QQQ | ETF | 92.375 | 92.625 | 91.4688 | 92.0 | 1602000.0 |
| 2000-06-07 15:30:00 | QQQ | ETF | 92.0625 | 93.125 | 91.75 | 92.9375 | 2948400.0 |
| 2000-06-07 16:00:00 | QQQ | ETF | 93.0312 | 93.25 | 92.875 | 93.1875 | 547300.0 |
| 2000-06-07 16:30:00 | QQQ | ETF | 93.1875 | 93.4375 | 93.0 | 93.4375 | 4900.0 |
| 2000-06-07 17:00:00 | QQQ | ETF | 93.4375 | 93.75 | 93.4375 | 93.75 | 1700.0 |
| 2000-06-07 17:30:00 | QQQ | ETF | 94.0 | 94.0 | 93.3125 | 93.3125 | 800.0 |
| 2000-06-07 18:00:00 | QQQ | ETF | 93.4375 | 93.75 | 93.4375 | 93.6875 | 1100.0 |
| 2000-06-07 09:30:00 | IWM | ETF | 51.1875 | 51.3906 | 51.1875 | 51.375 | 2800.0 |
| 2000-06-07 10:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 1000.0 |
| 2000-06-07 10:30:00 | IWM | ETF | 50.7188 | 50.875 | 50.7188 | 50.875 | 1800.0 |
| 2000-06-07 11:30:00 | IWM | ETF | 51.125 | 51.125 | 51.0625 | 51.0625 | 2400.0 |
| 2000-06-07 12:00:00 | IWM | ETF | 50.9844 | 51.125 | 50.9844 | 51.125 | 6000.0 |
| 2000-06-07 12:30:00 | IWM | ETF | 50.9375 | 51.0312 | 50.9375 | 51.0312 | 101000.0 |
| 2000-06-07 13:00:00 | IWM | ETF | 51.0312 | 51.0312 | 51.0312 | 51.0312 | 4000.0 |
| 2000-06-07 13:30:00 | IWM | ETF | 51.0938 | 51.0938 | 51.0938 | 51.0938 | 400.0 |
| 2000-06-07 14:00:00 | IWM | ETF | 51.0312 | 51.1562 | 51.0312 | 51.1562 | 2400.0 |
| 2000-06-07 14:30:00 | IWM | ETF | 51.3125 | 51.3125 | 51.3125 | 51.3125 | 2000.0 |
| 2000-06-07 15:00:00 | IWM | ETF | 51.25 | 51.2812 | 51.1562 | 51.1875 | 3000.0 |
| 2000-06-07 15:30:00 | IWM | ETF | 51.1094 | 51.5625 | 51.1094 | 51.5625 | 4200.0 |
| 2000-06-07 09:30:00 | DIA | ETF | 107.375 | 107.75 | 107.375 | 107.4375 | 80800.0 |
| 2000-06-07 10:00:00 | DIA | ETF | 107.5938 | 107.5938 | 107.0625 | 107.0938 | 25900.0 |
| 2000-06-07 10:30:00 | DIA | ETF | 107.2188 | 107.4688 | 107.0312 | 107.0312 | 10000.0 |
| 2000-06-07 11:00:00 | DIA | ETF | 107.3438 | 107.5938 | 107.2188 | 107.375 | 27400.0 |
| 2000-06-07 11:30:00 | DIA | ETF | 107.5625 | 107.7188 | 107.4688 | 107.625 | 31200.0 |
| 2000-06-07 12:00:00 | DIA | ETF | 107.5 | 107.6875 | 107.375 | 107.375 | 7600.0 |
> showing 50 of 247 rows — these rows as CSV