PREVIEW / etf_30min / 2000-10-12
file: by_date/etf_30min/2000/2000-10-12.parquet size: 12 KB rows: 313
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-10-12 09:30:00 | SPY | ETF | 137.2812 | 137.5938 | 134.75 | 135.0 | 1429900.0 |
| 2000-10-12 10:00:00 | SPY | ETF | 134.75 | 135.5 | 133.25 | 134.375 | 2074000.0 |
| 2000-10-12 10:30:00 | SPY | ETF | 134.1875 | 136.0 | 134.1875 | 135.7812 | 1017100.0 |
| 2000-10-12 11:00:00 | SPY | ETF | 135.875 | 135.9688 | 134.625 | 134.6875 | 685700.0 |
| 2000-10-12 11:30:00 | SPY | ETF | 134.625 | 135.5 | 134.5 | 134.625 | 648900.0 |
| 2000-10-12 12:00:00 | SPY | ETF | 134.625 | 134.75 | 133.875 | 133.9062 | 704700.0 |
| 2000-10-12 12:30:00 | SPY | ETF | 133.9062 | 134.5938 | 133.5 | 134.0625 | 383300.0 |
| 2000-10-12 13:00:00 | SPY | ETF | 134.0625 | 134.6875 | 133.9688 | 134.375 | 446000.0 |
| 2000-10-12 13:30:00 | SPY | ETF | 134.2812 | 134.5312 | 133.5 | 133.9688 | 538400.0 |
| 2000-10-12 14:00:00 | SPY | ETF | 133.9375 | 134.2812 | 133.1562 | 133.8438 | 715000.0 |
| 2000-10-12 14:30:00 | SPY | ETF | 133.875 | 134.25 | 133.25 | 134.1562 | 349900.0 |
| 2000-10-12 15:00:00 | SPY | ETF | 133.9688 | 134.6875 | 133.6562 | 134.0 | 401800.0 |
| 2000-10-12 15:30:00 | SPY | ETF | 134.0938 | 134.125 | 132.7812 | 133.1562 | 1338700.0 |
| 2000-10-12 16:00:00 | SPY | ETF | 133.0 | 133.5 | 132.9688 | 133.5 | 508300.0 |
| 2000-10-12 16:30:00 | SPY | ETF | 133.5 | 133.625 | 133.5 | 133.625 | 600.0 |
| 2000-10-12 17:00:00 | SPY | ETF | 133.2812 | 133.3438 | 133.25 | 133.3438 | 1000000.0 |
| 2000-10-12 17:30:00 | SPY | ETF | 133.625 | 133.625 | 133.625 | 133.625 | 500.0 |
| 2000-10-12 18:00:00 | SPY | ETF | 133.25 | 133.25 | 133.25 | 133.25 | 100.0 |
| 2000-10-12 09:30:00 | QQQ | ETF | 79.25 | 79.5625 | 77.1875 | 77.25 | 7294000.0 |
| 2000-10-12 10:00:00 | QQQ | ETF | 77.25 | 77.75 | 75.0625 | 76.75 | 9109900.0 |
| 2000-10-12 10:30:00 | QQQ | ETF | 76.9375 | 78.75 | 76.75 | 78.5 | 4315200.0 |
| 2000-10-12 11:00:00 | QQQ | ETF | 78.5 | 79.0 | 77.0 | 77.25 | 2968900.0 |
| 2000-10-12 11:30:00 | QQQ | ETF | 77.25 | 78.125 | 76.5625 | 76.75 | 1922100.0 |
| 2000-10-12 12:00:00 | QQQ | ETF | 76.9375 | 77.125 | 76.0625 | 76.4375 | 1645700.0 |
| 2000-10-12 12:30:00 | QQQ | ETF | 76.4375 | 77.125 | 75.875 | 76.625 | 2414200.0 |
| 2000-10-12 13:00:00 | QQQ | ETF | 76.7188 | 77.25 | 76.125 | 76.8125 | 3180000.0 |
| 2000-10-12 13:30:00 | QQQ | ETF | 77.0 | 77.0625 | 76.125 | 76.375 | 1643900.0 |
| 2000-10-12 14:00:00 | QQQ | ETF | 76.5 | 76.625 | 75.125 | 75.6562 | 3294400.0 |
| 2000-10-12 14:30:00 | QQQ | ETF | 75.8125 | 76.25 | 75.125 | 75.875 | 2964200.0 |
| 2000-10-12 15:00:00 | QQQ | ETF | 75.75 | 76.8125 | 75.5312 | 76.0312 | 3414500.0 |
| 2000-10-12 15:30:00 | QQQ | ETF | 76.0625 | 76.1875 | 74.4062 | 74.875 | 5347800.0 |
| 2000-10-12 16:00:00 | QQQ | ETF | 74.875 | 75.5 | 74.5 | 75.375 | 1027700.0 |
| 2000-10-12 16:30:00 | QQQ | ETF | 75.25 | 76.5 | 75.0625 | 76.0625 | 163000.0 |
| 2000-10-12 17:00:00 | QQQ | ETF | 76.1875 | 76.5 | 75.0 | 75.75 | 408100.0 |
| 2000-10-12 17:30:00 | QQQ | ETF | 75.75 | 76.0625 | 75.6875 | 75.9375 | 9400.0 |
| 2000-10-12 18:00:00 | QQQ | ETF | 75.75 | 75.8125 | 75.5 | 75.5 | 1500.0 |
| 2000-10-12 09:30:00 | IWM | ETF | 47.8438 | 47.8438 | 47.5625 | 47.5625 | 17800.0 |
| 2000-10-12 10:00:00 | IWM | ETF | 47.1094 | 47.1094 | 46.875 | 46.9531 | 6000.0 |
| 2000-10-12 10:30:00 | IWM | ETF | 46.9688 | 47.1875 | 46.9375 | 47.1875 | 4800.0 |
| 2000-10-12 11:00:00 | IWM | ETF | 47.1875 | 47.25 | 46.9375 | 47.0 | 28600.0 |
| 2000-10-12 11:30:00 | IWM | ETF | 46.9688 | 46.9688 | 46.9688 | 46.9688 | 10000.0 |
| 2000-10-12 12:00:00 | IWM | ETF | 46.75 | 46.75 | 46.6562 | 46.6875 | 11400.0 |
| 2000-10-12 12:30:00 | IWM | ETF | 46.7188 | 46.7188 | 46.5 | 46.5 | 18000.0 |
| 2000-10-12 13:00:00 | IWM | ETF | 46.5312 | 46.6562 | 46.4062 | 46.5938 | 18000.0 |
| 2000-10-12 13:30:00 | IWM | ETF | 46.5938 | 46.625 | 46.4062 | 46.4062 | 5400.0 |
| 2000-10-12 14:00:00 | IWM | ETF | 46.3438 | 46.3438 | 46.2656 | 46.2656 | 11000.0 |
| 2000-10-12 14:30:00 | IWM | ETF | 46.375 | 46.3906 | 46.2812 | 46.2812 | 2200.0 |
| 2000-10-12 15:00:00 | IWM | ETF | 46.375 | 46.4375 | 46.375 | 46.4375 | 16600.0 |
| 2000-10-12 15:30:00 | IWM | ETF | 46.4375 | 46.4375 | 46.0938 | 46.1562 | 11200.0 |
| 2000-10-12 16:00:00 | IWM | ETF | 46.0 | 46.0 | 45.9688 | 45.9688 | 400.0 |
> showing 50 of 313 rows — these rows as CSV