PREVIEW / etf_30min / 2000-11-30
file: by_date/etf_30min/2000/2000-11-30.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-11-30 09:30:00 | SPY | ETF | 132.5 | 133.0938 | 132.125 | 132.7812 | 1114300.0 |
| 2000-11-30 10:00:00 | SPY | ETF | 132.9062 | 133.4688 | 132.25 | 133.3438 | 1010100.0 |
| 2000-11-30 10:30:00 | SPY | ETF | 133.5 | 133.5 | 132.5625 | 132.625 | 332000.0 |
| 2000-11-30 11:00:00 | SPY | ETF | 132.8125 | 132.9375 | 132.125 | 132.1875 | 235200.0 |
| 2000-11-30 11:30:00 | SPY | ETF | 132.1875 | 132.3438 | 131.5 | 131.7812 | 456900.0 |
| 2000-11-30 12:00:00 | SPY | ETF | 131.9062 | 132.0 | 130.875 | 131.125 | 831800.0 |
| 2000-11-30 12:30:00 | SPY | ETF | 131.2812 | 131.7188 | 131.125 | 131.125 | 405100.0 |
| 2000-11-30 13:00:00 | SPY | ETF | 131.2812 | 131.5625 | 130.9062 | 131.375 | 217100.0 |
| 2000-11-30 13:30:00 | SPY | ETF | 131.4062 | 131.5 | 130.0625 | 130.5312 | 762200.0 |
| 2000-11-30 14:00:00 | SPY | ETF | 130.4375 | 130.9062 | 129.75 | 130.375 | 1018600.0 |
| 2000-11-30 14:30:00 | SPY | ETF | 130.375 | 131.4062 | 130.25 | 130.625 | 731900.0 |
| 2000-11-30 15:00:00 | SPY | ETF | 130.5625 | 133.0625 | 130.5312 | 132.5938 | 870700.0 |
| 2000-11-30 15:30:00 | SPY | ETF | 132.5625 | 132.9375 | 131.5625 | 131.625 | 1755700.0 |
| 2000-11-30 16:00:00 | SPY | ETF | 131.75 | 132.2812 | 131.375 | 132.2812 | 625300.0 |
| 2000-11-30 16:30:00 | SPY | ETF | 132.2812 | 132.2812 | 131.0312 | 131.0625 | 400200.0 |
| 2000-11-30 17:30:00 | SPY | ETF | 132.2812 | 132.2812 | 132.2812 | 132.2812 | 1100.0 |
| 2000-11-30 09:30:00 | QQQ | ETF | 61.75 | 62.375 | 61.25 | 61.9062 | 10728100.0 |
| 2000-11-30 10:00:00 | QQQ | ETF | 61.75 | 63.4688 | 61.3125 | 63.0312 | 6182300.0 |
| 2000-11-30 10:30:00 | QQQ | ETF | 63.1562 | 63.5 | 62.125 | 62.5 | 7217400.0 |
| 2000-11-30 11:00:00 | QQQ | ETF | 62.375 | 62.6875 | 61.625 | 61.75 | 2601600.0 |
| 2000-11-30 11:30:00 | QQQ | ETF | 61.75 | 61.9688 | 61.25 | 61.6875 | 4118100.0 |
| 2000-11-30 12:00:00 | QQQ | ETF | 61.6875 | 61.8125 | 60.625 | 61.0625 | 5028400.0 |
| 2000-11-30 12:30:00 | QQQ | ETF | 61.0625 | 61.75 | 61.0 | 61.125 | 3240800.0 |
| 2000-11-30 13:00:00 | QQQ | ETF | 61.125 | 61.7188 | 60.8125 | 61.4375 | 2032500.0 |
| 2000-11-30 13:30:00 | QQQ | ETF | 61.375 | 61.625 | 60.5 | 61.5 | 4027100.0 |
| 2000-11-30 14:00:00 | QQQ | ETF | 61.5 | 62.0 | 60.8125 | 61.3125 | 4196800.0 |
| 2000-11-30 14:30:00 | QQQ | ETF | 61.3125 | 62.625 | 61.125 | 62.125 | 6521300.0 |
| 2000-11-30 15:00:00 | QQQ | ETF | 62.125 | 64.25 | 61.875 | 63.8125 | 7421500.0 |
| 2000-11-30 15:30:00 | QQQ | ETF | 63.6875 | 64.0938 | 62.1875 | 62.4688 | 6191000.0 |
| 2000-11-30 16:00:00 | QQQ | ETF | 62.375 | 63.3125 | 62.25 | 63.1875 | 1563800.0 |
| 2000-11-30 16:30:00 | QQQ | ETF | 63.125 | 63.3125 | 62.0938 | 63.125 | 49000.0 |
| 2000-11-30 17:00:00 | QQQ | ETF | 63.125 | 63.8125 | 63.0625 | 63.5 | 43400.0 |
| 2000-11-30 17:30:00 | QQQ | ETF | 63.5 | 63.625 | 63.1875 | 63.5 | 31200.0 |
| 2000-11-30 18:00:00 | QQQ | ETF | 63.5 | 64.0 | 63.375 | 63.6875 | 21200.0 |
| 2000-11-30 09:30:00 | IWM | ETF | 45.0 | 45.0 | 44.7969 | 44.9375 | 22800.0 |
| 2000-11-30 10:00:00 | IWM | ETF | 44.8438 | 44.9375 | 44.75 | 44.9375 | 1400.0 |
| 2000-11-30 10:30:00 | IWM | ETF | 45.0 | 45.0625 | 44.875 | 44.875 | 73200.0 |
| 2000-11-30 11:00:00 | IWM | ETF | 44.875 | 44.875 | 44.7812 | 44.7812 | 3000.0 |
| 2000-11-30 11:30:00 | IWM | ETF | 44.5625 | 44.6562 | 44.5 | 44.5 | 6200.0 |
| 2000-11-30 12:00:00 | IWM | ETF | 44.4375 | 44.4375 | 44.3438 | 44.3438 | 1200.0 |
| 2000-11-30 12:30:00 | IWM | ETF | 44.3125 | 44.4688 | 44.2812 | 44.3438 | 8400.0 |
| 2000-11-30 13:00:00 | IWM | ETF | 44.375 | 44.375 | 44.3125 | 44.3125 | 8800.0 |
| 2000-11-30 13:30:00 | IWM | ETF | 44.3125 | 44.3125 | 44.0312 | 44.0312 | 5800.0 |
| 2000-11-30 14:00:00 | IWM | ETF | 44.0938 | 44.125 | 43.9688 | 44.0 | 2600.0 |
| 2000-11-30 14:30:00 | IWM | ETF | 44.4844 | 44.4844 | 44.375 | 44.375 | 2400.0 |
| 2000-11-30 15:00:00 | IWM | ETF | 44.5 | 45.1562 | 44.5 | 45.0312 | 13200.0 |
| 2000-11-30 15:30:00 | IWM | ETF | 45.2812 | 45.2812 | 44.7812 | 44.7812 | 32800.0 |
| 2000-11-30 16:00:00 | IWM | ETF | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 200.0 |
| 2000-11-30 09:30:00 | DIA | ETF | 105.25 | 105.9375 | 105.0625 | 105.75 | 107700.0 |
| 2000-11-30 10:00:00 | DIA | ETF | 105.75 | 105.9375 | 105.25 | 105.875 | 130500.0 |
> showing 50 of 313 rows — these rows as CSV