PREVIEW / etf_30min / 2001-05-29
file: by_date/etf_30min/2001/2001-05-29.parquet size: 15 KB rows: 372
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-05-29 09:30:00 | SPY | ETF | 128.22 | 128.34 | 127.84 | 127.99 | 1358100.0 |
| 2001-05-29 10:00:00 | SPY | ETF | 127.99 | 128.3 | 127.41 | 127.45 | 989700.0 |
| 2001-05-29 10:30:00 | SPY | ETF | 127.44 | 127.74 | 127.31 | 127.73 | 773300.0 |
| 2001-05-29 11:00:00 | SPY | ETF | 127.74 | 127.89 | 127.48 | 127.64 | 494200.0 |
| 2001-05-29 11:30:00 | SPY | ETF | 127.64 | 127.78 | 127.55 | 127.59 | 361600.0 |
| 2001-05-29 12:00:00 | SPY | ETF | 127.69 | 127.79 | 127.15 | 127.54 | 211600.0 |
| 2001-05-29 12:30:00 | SPY | ETF | 127.49 | 127.63 | 127.3 | 127.51 | 246100.0 |
| 2001-05-29 13:00:00 | SPY | ETF | 127.53 | 127.63 | 127.22 | 127.32 | 448900.0 |
| 2001-05-29 13:30:00 | SPY | ETF | 127.28 | 127.34 | 126.9 | 127.29 | 910400.0 |
| 2001-05-29 14:00:00 | SPY | ETF | 127.21 | 127.45 | 127.06 | 127.31 | 273800.0 |
| 2001-05-29 14:30:00 | SPY | ETF | 127.26 | 127.53 | 127.06 | 127.45 | 343100.0 |
| 2001-05-29 15:00:00 | SPY | ETF | 127.38 | 127.63 | 127.16 | 127.27 | 309300.0 |
| 2001-05-29 15:30:00 | SPY | ETF | 127.21 | 127.43 | 127.07 | 127.3 | 786300.0 |
| 2001-05-29 16:00:00 | SPY | ETF | 127.26 | 127.4 | 127.01 | 127.08 | 655600.0 |
| 2001-05-29 16:30:00 | SPY | ETF | 127.0 | 127.0 | 127.0 | 127.0 | 2500.0 |
| 2001-05-29 17:30:00 | SPY | ETF | 126.85 | 126.85 | 126.82 | 126.85 | 11800.0 |
| 2001-05-29 09:30:00 | QQQ | ETF | 48.5 | 48.5 | 47.67 | 47.82 | 7870400.0 |
| 2001-05-29 10:00:00 | QQQ | ETF | 47.85 | 48.2 | 47.27 | 47.3 | 9708700.0 |
| 2001-05-29 10:30:00 | QQQ | ETF | 47.32 | 47.6 | 47.16 | 47.45 | 5614800.0 |
| 2001-05-29 11:00:00 | QQQ | ETF | 47.45 | 47.64 | 47.23 | 47.4 | 3730300.0 |
| 2001-05-29 11:30:00 | QQQ | ETF | 47.4 | 47.55 | 47.29 | 47.38 | 1958600.0 |
| 2001-05-29 12:00:00 | QQQ | ETF | 47.38 | 47.44 | 47.08 | 47.13 | 2118600.0 |
| 2001-05-29 12:30:00 | QQQ | ETF | 47.12 | 47.15 | 47.0 | 47.07 | 2128700.0 |
| 2001-05-29 13:00:00 | QQQ | ETF | 47.08 | 47.15 | 46.72 | 46.75 | 3795900.0 |
| 2001-05-29 13:30:00 | QQQ | ETF | 46.72 | 46.79 | 46.5 | 46.75 | 4098900.0 |
| 2001-05-29 14:00:00 | QQQ | ETF | 46.75 | 46.83 | 46.45 | 46.68 | 3692900.0 |
| 2001-05-29 14:30:00 | QQQ | ETF | 46.72 | 46.88 | 46.53 | 46.88 | 5229900.0 |
| 2001-05-29 15:00:00 | QQQ | ETF | 46.83 | 47.0 | 46.56 | 46.6 | 4269700.0 |
| 2001-05-29 15:30:00 | QQQ | ETF | 46.56 | 46.85 | 46.54 | 46.7 | 6564300.0 |
| 2001-05-29 16:00:00 | QQQ | ETF | 46.7 | 46.73 | 46.08 | 46.11 | 2726000.0 |
| 2001-05-29 16:30:00 | QQQ | ETF | 46.1 | 46.71 | 46.08 | 46.2 | 168700.0 |
| 2001-05-29 17:00:00 | QQQ | ETF | 46.2 | 46.25 | 46.04 | 46.05 | 75500.0 |
| 2001-05-29 17:30:00 | QQQ | ETF | 46.07 | 46.09 | 46.02 | 46.04 | 31800.0 |
| 2001-05-29 18:00:00 | QQQ | ETF | 46.08 | 46.1 | 46.04 | 46.1 | 6300.0 |
| 2001-05-29 09:30:00 | IWM | ETF | 50.75 | 50.75 | 50.6 | 50.6 | 19600.0 |
| 2001-05-29 10:00:00 | IWM | ETF | 50.6 | 50.625 | 50.4 | 50.4 | 54800.0 |
| 2001-05-29 10:30:00 | IWM | ETF | 50.355 | 50.445 | 50.3 | 50.445 | 155400.0 |
| 2001-05-29 11:00:00 | IWM | ETF | 50.425 | 50.52 | 50.425 | 50.425 | 41400.0 |
| 2001-05-29 11:30:00 | IWM | ETF | 50.395 | 50.4 | 50.375 | 50.4 | 25600.0 |
| 2001-05-29 12:00:00 | IWM | ETF | 50.35 | 50.355 | 50.325 | 50.335 | 24600.0 |
| 2001-05-29 12:30:00 | IWM | ETF | 50.35 | 50.385 | 50.26 | 50.3 | 48000.0 |
| 2001-05-29 13:00:00 | IWM | ETF | 50.325 | 50.35 | 50.1 | 50.1 | 35800.0 |
| 2001-05-29 13:30:00 | IWM | ETF | 50.1 | 50.275 | 50.1 | 50.13 | 50600.0 |
| 2001-05-29 14:00:00 | IWM | ETF | 50.15 | 50.2 | 50.1 | 50.2 | 33600.0 |
| 2001-05-29 14:30:00 | IWM | ETF | 50.15 | 50.2 | 50.145 | 50.2 | 14600.0 |
| 2001-05-29 15:00:00 | IWM | ETF | 50.175 | 50.25 | 50.125 | 50.135 | 50600.0 |
| 2001-05-29 15:30:00 | IWM | ETF | 50.125 | 50.175 | 50.075 | 50.125 | 90200.0 |
| 2001-05-29 16:00:00 | IWM | ETF | 50.09 | 50.225 | 50.0 | 50.0 | 100600.0 |
| 2001-05-29 09:30:00 | DIA | ETF | 110.45 | 110.64 | 110.3 | 110.44 | 373600.0 |
| 2001-05-29 10:00:00 | DIA | ETF | 110.45 | 110.8 | 110.06 | 110.25 | 452000.0 |
> showing 50 of 372 rows — these rows as CSV