PREVIEW / etf_30min / 2001-02-12
file: by_date/etf_30min/2001/2001-02-12.parquet size: 13 KB rows: 327
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-02-12 09:30:00 | SPY | ETF | 131.7 | 132.2 | 131.7 | 131.72 | 1096300.0 |
| 2001-02-12 10:00:00 | SPY | ETF | 131.84 | 132.75 | 131.71 | 132.65 | 957000.0 |
| 2001-02-12 10:30:00 | SPY | ETF | 132.68 | 133.17 | 132.61 | 133.1 | 298900.0 |
| 2001-02-12 11:00:00 | SPY | ETF | 133.11 | 133.26 | 132.75 | 132.85 | 266100.0 |
| 2001-02-12 11:30:00 | SPY | ETF | 132.92 | 132.96 | 132.62 | 132.9 | 365300.0 |
| 2001-02-12 12:00:00 | SPY | ETF | 132.89 | 133.08 | 132.65 | 133.07 | 118400.0 |
| 2001-02-12 12:30:00 | SPY | ETF | 133.08 | 133.08 | 132.54 | 132.78 | 424900.0 |
| 2001-02-12 13:00:00 | SPY | ETF | 132.62 | 132.74 | 132.46 | 132.56 | 159000.0 |
| 2001-02-12 13:30:00 | SPY | ETF | 132.63 | 133.02 | 132.63 | 132.75 | 557600.0 |
| 2001-02-12 14:00:00 | SPY | ETF | 132.73 | 133.27 | 132.62 | 133.07 | 345900.0 |
| 2001-02-12 14:30:00 | SPY | ETF | 133.06 | 133.36 | 132.92 | 133.23 | 192700.0 |
| 2001-02-12 15:00:00 | SPY | ETF | 133.2 | 133.5 | 133.1 | 133.24 | 299100.0 |
| 2001-02-12 15:30:00 | SPY | ETF | 133.17 | 133.49 | 133.1 | 133.14 | 358500.0 |
| 2001-02-12 16:00:00 | SPY | ETF | 133.14 | 133.49 | 133.14 | 133.14 | 313600.0 |
| 2001-02-12 16:30:00 | SPY | ETF | 133.35 | 133.35 | 133.35 | 133.35 | 400.0 |
| 2001-02-12 17:30:00 | SPY | ETF | 133.47 | 133.47 | 133.47 | 133.47 | 500.0 |
| 2001-02-12 09:30:00 | QQQ | ETF | 56.25 | 56.55 | 55.7 | 55.73 | 8379700.0 |
| 2001-02-12 10:00:00 | QQQ | ETF | 55.76 | 57.25 | 55.62 | 57.17 | 8051400.0 |
| 2001-02-12 10:30:00 | QQQ | ETF | 57.25 | 57.75 | 56.94 | 57.66 | 4503600.0 |
| 2001-02-12 11:00:00 | QQQ | ETF | 57.6 | 57.94 | 57.05 | 57.1 | 3045700.0 |
| 2001-02-12 11:30:00 | QQQ | ETF | 57.1 | 57.29 | 56.6 | 56.9 | 2732700.0 |
| 2001-02-12 12:00:00 | QQQ | ETF | 56.81 | 57.15 | 56.65 | 57.12 | 1706800.0 |
| 2001-02-12 12:30:00 | QQQ | ETF | 57.17 | 57.18 | 56.34 | 56.44 | 2838100.0 |
| 2001-02-12 13:00:00 | QQQ | ETF | 56.42 | 56.49 | 56.01 | 56.17 | 3248900.0 |
| 2001-02-12 13:30:00 | QQQ | ETF | 56.15 | 56.68 | 56.15 | 56.26 | 2023500.0 |
| 2001-02-12 14:00:00 | QQQ | ETF | 56.25 | 56.97 | 56.05 | 56.78 | 3094800.0 |
| 2001-02-12 14:30:00 | QQQ | ETF | 56.77 | 57.22 | 56.46 | 57.1 | 2493900.0 |
| 2001-02-12 15:00:00 | QQQ | ETF | 57.11 | 57.45 | 56.81 | 56.85 | 3583000.0 |
| 2001-02-12 15:30:00 | QQQ | ETF | 56.88 | 57.32 | 56.84 | 56.99 | 3106200.0 |
| 2001-02-12 16:00:00 | QQQ | ETF | 57.02 | 57.3 | 56.49 | 57.12 | 653600.0 |
| 2001-02-12 16:30:00 | QQQ | ETF | 57.11 | 57.25 | 57.1 | 57.24 | 12200.0 |
| 2001-02-12 17:00:00 | QQQ | ETF | 57.18 | 57.24 | 57.05 | 57.2 | 15800.0 |
| 2001-02-12 17:30:00 | QQQ | ETF | 57.22 | 57.25 | 57.2 | 57.2 | 8000.0 |
| 2001-02-12 18:00:00 | QQQ | ETF | 57.15 | 57.24 | 57.15 | 57.2 | 5400.0 |
| 2001-02-12 09:30:00 | IWM | ETF | 49.325 | 49.525 | 49.325 | 49.35 | 18800.0 |
| 2001-02-12 10:00:00 | IWM | ETF | 49.255 | 49.525 | 49.255 | 49.35 | 39800.0 |
| 2001-02-12 10:30:00 | IWM | ETF | 49.75 | 49.95 | 49.75 | 49.95 | 5800.0 |
| 2001-02-12 11:00:00 | IWM | ETF | 49.95 | 49.975 | 49.875 | 49.875 | 15200.0 |
| 2001-02-12 11:30:00 | IWM | ETF | 49.875 | 49.9 | 49.875 | 49.9 | 4000.0 |
| 2001-02-12 12:00:00 | IWM | ETF | 49.85 | 50.0 | 49.85 | 49.96 | 44400.0 |
| 2001-02-12 12:30:00 | IWM | ETF | 50.045 | 50.045 | 49.85 | 49.895 | 26200.0 |
| 2001-02-12 13:00:00 | IWM | ETF | 49.985 | 49.985 | 49.985 | 49.985 | 200.0 |
| 2001-02-12 13:30:00 | IWM | ETF | 50.025 | 50.275 | 50.025 | 50.25 | 167200.0 |
| 2001-02-12 14:00:00 | IWM | ETF | 50.27 | 50.35 | 50.27 | 50.35 | 22400.0 |
| 2001-02-12 14:30:00 | IWM | ETF | 50.365 | 50.365 | 50.325 | 50.35 | 40400.0 |
| 2001-02-12 15:00:00 | IWM | ETF | 50.35 | 50.445 | 50.35 | 50.445 | 45400.0 |
| 2001-02-12 15:30:00 | IWM | ETF | 50.445 | 50.45 | 50.32 | 50.4 | 13400.0 |
| 2001-02-12 09:30:00 | DIA | ETF | 108.08 | 108.49 | 108.03 | 108.3 | 210200.0 |
| 2001-02-12 10:00:00 | DIA | ETF | 108.31 | 108.89 | 108.31 | 108.69 | 206700.0 |
| 2001-02-12 10:30:00 | DIA | ETF | 108.81 | 109.11 | 108.76 | 109.1 | 143900.0 |
> showing 50 of 327 rows — these rows as CSV