PREVIEW / etf_30min / 2001-04-30
file: by_date/etf_30min/2001/2001-04-30.parquet size: 15 KB rows: 376
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-30 09:30:00 | SPY | ETF | 126.45 | 126.86 | 126.1 | 126.86 | 1650100.0 |
| 2001-04-30 10:00:00 | SPY | ETF | 126.8 | 127.01 | 126.53 | 126.95 | 579400.0 |
| 2001-04-30 10:30:00 | SPY | ETF | 126.86 | 127.21 | 126.82 | 126.97 | 603400.0 |
| 2001-04-30 11:00:00 | SPY | ETF | 126.97 | 127.21 | 126.85 | 127.17 | 275200.0 |
| 2001-04-30 11:30:00 | SPY | ETF | 127.17 | 127.27 | 126.8 | 126.83 | 320100.0 |
| 2001-04-30 12:00:00 | SPY | ETF | 126.85 | 127.08 | 126.77 | 126.9 | 374700.0 |
| 2001-04-30 12:30:00 | SPY | ETF | 126.83 | 127.1 | 126.75 | 127.1 | 335300.0 |
| 2001-04-30 13:00:00 | SPY | ETF | 127.1 | 127.2 | 126.92 | 126.95 | 172700.0 |
| 2001-04-30 13:30:00 | SPY | ETF | 127.0 | 127.09 | 126.3 | 126.32 | 505800.0 |
| 2001-04-30 14:00:00 | SPY | ETF | 126.45 | 126.47 | 125.91 | 125.91 | 673200.0 |
| 2001-04-30 14:30:00 | SPY | ETF | 125.91 | 125.98 | 124.81 | 124.94 | 1113000.0 |
| 2001-04-30 15:00:00 | SPY | ETF | 124.98 | 125.16 | 124.67 | 125.11 | 689000.0 |
| 2001-04-30 15:30:00 | SPY | ETF | 125.03 | 125.43 | 125.0 | 125.21 | 1020400.0 |
| 2001-04-30 16:00:00 | SPY | ETF | 125.21 | 125.25 | 124.3 | 125.1 | 1894500.0 |
| 2001-04-30 16:30:00 | SPY | ETF | 125.05 | 125.15 | 124.9 | 124.91 | 84100.0 |
| 2001-04-30 17:00:00 | SPY | ETF | 124.86 | 125.03 | 124.86 | 125.03 | 2300.0 |
| 2001-04-30 17:30:00 | SPY | ETF | 125.05 | 125.28 | 124.85 | 124.97 | 4000.0 |
| 2001-04-30 18:00:00 | SPY | ETF | 124.97 | 124.97 | 124.79 | 124.97 | 2500.0 |
| 2001-04-30 09:30:00 | QQQ | ETF | 46.25 | 46.72 | 45.95 | 46.67 | 9691600.0 |
| 2001-04-30 10:00:00 | QQQ | ETF | 46.71 | 47.19 | 46.54 | 47.0 | 6387100.0 |
| 2001-04-30 10:30:00 | QQQ | ETF | 47.0 | 47.28 | 46.78 | 47.11 | 4559100.0 |
| 2001-04-30 11:00:00 | QQQ | ETF | 47.11 | 47.47 | 47.02 | 47.4 | 3437700.0 |
| 2001-04-30 11:30:00 | QQQ | ETF | 47.4 | 47.57 | 47.17 | 47.24 | 3228200.0 |
| 2001-04-30 12:00:00 | QQQ | ETF | 47.24 | 47.36 | 47.03 | 47.05 | 2231000.0 |
| 2001-04-30 12:30:00 | QQQ | ETF | 47.05 | 47.25 | 46.84 | 47.22 | 3974900.0 |
| 2001-04-30 13:00:00 | QQQ | ETF | 47.2 | 47.42 | 47.13 | 47.25 | 2931400.0 |
| 2001-04-30 13:30:00 | QQQ | ETF | 47.25 | 47.41 | 46.75 | 46.85 | 4347800.0 |
| 2001-04-30 14:00:00 | QQQ | ETF | 46.86 | 46.9 | 46.45 | 46.45 | 4499300.0 |
| 2001-04-30 14:30:00 | QQQ | ETF | 46.45 | 46.5 | 45.65 | 45.71 | 6966700.0 |
| 2001-04-30 15:00:00 | QQQ | ETF | 45.75 | 46.25 | 45.45 | 46.15 | 6669300.0 |
| 2001-04-30 15:30:00 | QQQ | ETF | 46.15 | 46.54 | 46.01 | 46.23 | 5030800.0 |
| 2001-04-30 16:00:00 | QQQ | ETF | 46.23 | 46.5 | 45.9 | 46.5 | 3789400.0 |
| 2001-04-30 16:30:00 | QQQ | ETF | 46.17 | 46.25 | 46.1 | 46.1 | 43600.0 |
| 2001-04-30 17:00:00 | QQQ | ETF | 46.06 | 46.15 | 46.06 | 46.14 | 19000.0 |
| 2001-04-30 17:30:00 | QQQ | ETF | 46.14 | 46.15 | 46.09 | 46.12 | 15000.0 |
| 2001-04-30 18:00:00 | QQQ | ETF | 46.1 | 46.3 | 46.1 | 46.3 | 7900.0 |
| 2001-04-30 09:30:00 | IWM | ETF | 48.825 | 48.825 | 48.55 | 48.775 | 180800.0 |
| 2001-04-30 10:00:00 | IWM | ETF | 48.8 | 48.82 | 48.65 | 48.74 | 11000.0 |
| 2001-04-30 10:30:00 | IWM | ETF | 48.82 | 48.95 | 48.71 | 48.95 | 407400.0 |
| 2001-04-30 11:00:00 | IWM | ETF | 48.995 | 48.995 | 48.82 | 48.97 | 21600.0 |
| 2001-04-30 11:30:00 | IWM | ETF | 48.815 | 49.05 | 48.815 | 48.955 | 26600.0 |
| 2001-04-30 12:00:00 | IWM | ETF | 49.0 | 49.05 | 48.875 | 49.0 | 13600.0 |
| 2001-04-30 12:30:00 | IWM | ETF | 49.0 | 49.03 | 48.775 | 49.03 | 5400.0 |
| 2001-04-30 13:00:00 | IWM | ETF | 48.955 | 49.045 | 48.825 | 49.0 | 33400.0 |
| 2001-04-30 13:30:00 | IWM | ETF | 48.825 | 49.0 | 48.77 | 48.77 | 13200.0 |
| 2001-04-30 14:00:00 | IWM | ETF | 48.845 | 48.845 | 48.625 | 48.745 | 10000.0 |
| 2001-04-30 14:30:00 | IWM | ETF | 48.605 | 48.605 | 48.425 | 48.475 | 147600.0 |
| 2001-04-30 15:00:00 | IWM | ETF | 48.3 | 48.525 | 48.255 | 48.5 | 170000.0 |
| 2001-04-30 15:30:00 | IWM | ETF | 48.45 | 48.675 | 48.375 | 48.5 | 20000.0 |
| 2001-04-30 16:00:00 | IWM | ETF | 48.5 | 48.5 | 48.5 | 48.5 | 4800.0 |
> showing 50 of 376 rows — these rows as CSV