PREVIEW / etf_30min / 2001-10-09
file: by_date/etf_30min/2001/2001-10-09.parquet size: 15 KB rows: 391
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-10-09 09:30:00 | SPY | ETF | 106.61 | 106.75 | 105.87 | 106.07 | 2391100.0 |
| 2001-10-09 10:00:00 | SPY | ETF | 106.06 | 106.23 | 105.6 | 105.96 | 1448200.0 |
| 2001-10-09 10:30:00 | SPY | ETF | 106.0 | 106.68 | 105.76 | 106.5 | 1470700.0 |
| 2001-10-09 11:00:00 | SPY | ETF | 106.46 | 106.52 | 106.15 | 106.21 | 846800.0 |
| 2001-10-09 11:30:00 | SPY | ETF | 106.2 | 106.25 | 105.9 | 106.05 | 815700.0 |
| 2001-10-09 12:00:00 | SPY | ETF | 106.09 | 106.16 | 105.89 | 105.98 | 572400.0 |
| 2001-10-09 12:30:00 | SPY | ETF | 106.03 | 106.14 | 105.66 | 105.95 | 1112100.0 |
| 2001-10-09 13:00:00 | SPY | ETF | 105.95 | 106.33 | 105.87 | 106.02 | 628700.0 |
| 2001-10-09 13:30:00 | SPY | ETF | 106.04 | 106.16 | 105.85 | 106.0 | 531600.0 |
| 2001-10-09 14:00:00 | SPY | ETF | 105.97 | 106.01 | 105.7 | 105.99 | 552700.0 |
| 2001-10-09 14:30:00 | SPY | ETF | 105.97 | 106.28 | 105.82 | 106.05 | 628600.0 |
| 2001-10-09 15:00:00 | SPY | ETF | 106.03 | 106.4 | 105.79 | 105.83 | 834600.0 |
| 2001-10-09 15:30:00 | SPY | ETF | 105.86 | 106.15 | 105.62 | 105.92 | 1775600.0 |
| 2001-10-09 16:00:00 | SPY | ETF | 105.92 | 106.25 | 105.86 | 106.0 | 1049300.0 |
| 2001-10-09 16:30:00 | SPY | ETF | 106.0 | 106.05 | 106.0 | 106.05 | 10500.0 |
| 2001-10-09 09:30:00 | QQQ | ETF | 31.86 | 32.02 | 31.25 | 31.4 | 9635200.0 |
| 2001-10-09 10:00:00 | QQQ | ETF | 31.43 | 31.47 | 31.08 | 31.38 | 5425800.0 |
| 2001-10-09 10:30:00 | QQQ | ETF | 31.38 | 31.79 | 31.25 | 31.66 | 6113000.0 |
| 2001-10-09 11:00:00 | QQQ | ETF | 31.7 | 31.71 | 31.27 | 31.31 | 3606600.0 |
| 2001-10-09 11:30:00 | QQQ | ETF | 31.3 | 31.38 | 31.01 | 31.16 | 4667500.0 |
| 2001-10-09 12:00:00 | QQQ | ETF | 31.16 | 31.3 | 31.05 | 31.23 | 2922500.0 |
| 2001-10-09 12:30:00 | QQQ | ETF | 31.19 | 31.3 | 31.05 | 31.19 | 2154400.0 |
| 2001-10-09 13:00:00 | QQQ | ETF | 31.18 | 31.47 | 31.1 | 31.33 | 2785300.0 |
| 2001-10-09 13:30:00 | QQQ | ETF | 31.35 | 31.45 | 31.18 | 31.27 | 2054400.0 |
| 2001-10-09 14:00:00 | QQQ | ETF | 31.28 | 31.28 | 31.09 | 31.25 | 2128900.0 |
| 2001-10-09 14:30:00 | QQQ | ETF | 31.25 | 31.38 | 31.08 | 31.2 | 2468200.0 |
| 2001-10-09 15:00:00 | QQQ | ETF | 31.2 | 31.43 | 31.01 | 31.06 | 3228100.0 |
| 2001-10-09 15:30:00 | QQQ | ETF | 31.04 | 31.13 | 30.87 | 30.97 | 6619700.0 |
| 2001-10-09 16:00:00 | QQQ | ETF | 31.0 | 31.14 | 30.96 | 31.09 | 1387400.0 |
| 2001-10-09 16:30:00 | QQQ | ETF | 31.1 | 31.2 | 31.03 | 31.15 | 140000.0 |
| 2001-10-09 17:00:00 | QQQ | ETF | 31.15 | 31.25 | 31.14 | 31.25 | 58800.0 |
| 2001-10-09 17:30:00 | QQQ | ETF | 31.2 | 31.25 | 31.0 | 31.15 | 145800.0 |
| 2001-10-09 18:00:00 | QQQ | ETF | 31.15 | 31.15 | 31.07 | 31.1 | 20100.0 |
| 2001-10-09 09:30:00 | IWM | ETF | 40.825 | 40.95 | 40.53 | 40.6 | 17400.0 |
| 2001-10-09 10:00:00 | IWM | ETF | 40.53 | 40.585 | 40.5 | 40.55 | 86200.0 |
| 2001-10-09 10:30:00 | IWM | ETF | 40.5 | 40.975 | 40.5 | 40.895 | 34600.0 |
| 2001-10-09 11:00:00 | IWM | ETF | 40.805 | 40.84 | 40.805 | 40.84 | 48000.0 |
| 2001-10-09 11:30:00 | IWM | ETF | 40.835 | 40.835 | 40.755 | 40.755 | 22000.0 |
| 2001-10-09 12:00:00 | IWM | ETF | 40.725 | 40.8 | 40.62 | 40.62 | 14800.0 |
| 2001-10-09 12:30:00 | IWM | ETF | 40.76 | 40.795 | 40.7 | 40.785 | 8000.0 |
| 2001-10-09 13:00:00 | IWM | ETF | 40.795 | 40.8 | 40.795 | 40.8 | 6200.0 |
| 2001-10-09 13:30:00 | IWM | ETF | 40.8 | 40.81 | 40.79 | 40.81 | 5200.0 |
| 2001-10-09 14:00:00 | IWM | ETF | 40.7 | 40.765 | 40.7 | 40.705 | 7200.0 |
| 2001-10-09 14:30:00 | IWM | ETF | 40.705 | 40.825 | 40.7 | 40.8 | 223200.0 |
| 2001-10-09 15:00:00 | IWM | ETF | 40.8 | 40.9 | 40.75 | 40.795 | 230000.0 |
| 2001-10-09 15:30:00 | IWM | ETF | 40.79 | 40.825 | 40.595 | 40.715 | 268600.0 |
| 2001-10-09 16:00:00 | IWM | ETF | 40.725 | 40.725 | 40.585 | 40.585 | 16200.0 |
| 2001-10-09 09:30:00 | DIA | ETF | 90.99 | 90.99 | 90.4 | 90.54 | 379300.0 |
| 2001-10-09 10:00:00 | DIA | ETF | 90.5 | 90.55 | 90.2 | 90.39 | 292600.0 |
| 2001-10-09 10:30:00 | DIA | ETF | 90.32 | 91.1 | 90.2 | 90.8 | 346300.0 |
> showing 50 of 391 rows — these rows as CSV