PREVIEW / etf_30min / 2005-04-12
file: by_date/etf_30min/2005/2005-04-12.parquet size: 44 KB rows: 1,493
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-12 07:30:00 | SPY | ETF | 118.03 | 118.09 | 118.03 | 118.09 | 7900.0 |
| 2005-04-12 08:00:00 | SPY | ETF | 118.09 | 118.1 | 118.06 | 118.09 | 52200.0 |
| 2005-04-12 08:30:00 | SPY | ETF | 118.01 | 118.01 | 117.75 | 117.9 | 467900.0 |
| 2005-04-12 09:00:00 | SPY | ETF | 117.89 | 117.93 | 117.85 | 117.91 | 23600.0 |
| 2005-04-12 09:30:00 | SPY | ETF | 117.89 | 117.93 | 117.46 | 117.53 | 7024900.0 |
| 2005-04-12 10:00:00 | SPY | ETF | 117.54 | 117.62 | 117.39 | 117.62 | 3996600.0 |
| 2005-04-12 10:30:00 | SPY | ETF | 117.62 | 117.62 | 117.13 | 117.25 | 7280200.0 |
| 2005-04-12 11:00:00 | SPY | ETF | 117.26 | 117.37 | 117.2 | 117.31 | 2915300.0 |
| 2005-04-12 11:30:00 | SPY | ETF | 117.31 | 117.39 | 117.24 | 117.35 | 2853100.0 |
| 2005-04-12 12:00:00 | SPY | ETF | 117.36 | 117.38 | 117.26 | 117.32 | 1838800.0 |
| 2005-04-12 12:30:00 | SPY | ETF | 117.32 | 117.43 | 117.32 | 117.33 | 2006900.0 |
| 2005-04-12 13:00:00 | SPY | ETF | 117.33 | 117.4 | 117.25 | 117.3 | 2435700.0 |
| 2005-04-12 13:30:00 | SPY | ETF | 117.3 | 117.33 | 117.17 | 117.25 | 2681600.0 |
| 2005-04-12 14:00:00 | SPY | ETF | 117.25 | 118.33 | 117.07 | 118.14 | 22582500.0 |
| 2005-04-12 14:30:00 | SPY | ETF | 118.14 | 118.85 | 118.06 | 118.73 | 11595100.0 |
| 2005-04-12 15:00:00 | SPY | ETF | 118.74 | 118.94 | 118.65 | 118.86 | 6259200.0 |
| 2005-04-12 15:30:00 | SPY | ETF | 118.85 | 119.06 | 118.7 | 118.76 | 8569900.0 |
| 2005-04-12 16:00:00 | SPY | ETF | 118.75 | 118.78 | 118.64 | 118.71 | 999400.0 |
| 2005-04-12 16:30:00 | SPY | ETF | 118.69 | 118.74 | 118.69 | 118.7 | 150000.0 |
| 2005-04-12 17:00:00 | SPY | ETF | 118.69 | 118.88 | 118.68 | 118.71 | 125400.0 |
| 2005-04-12 17:30:00 | SPY | ETF | 118.72 | 118.8286 | 118.71 | 118.75 | 22800.0 |
| 2005-04-12 18:00:00 | SPY | ETF | 118.75 | 118.77 | 118.7 | 118.7 | 13100.0 |
| 2005-04-12 18:30:00 | SPY | ETF | 118.74 | 118.78 | 118.74 | 118.78 | 8500.0 |
| 2005-04-12 19:00:00 | SPY | ETF | 118.78 | 118.78 | 118.77 | 118.77 | 8300.0 |
| 2005-04-12 19:30:00 | SPY | ETF | 118.79 | 118.8 | 118.79 | 118.8 | 6300.0 |
| 2005-04-12 09:30:00 | QQQ | ETF | 36.42 | 36.44 | 36.17 | 36.21 | 13965300.0 |
| 2005-04-12 10:00:00 | QQQ | ETF | 36.21 | 36.28 | 36.16 | 36.27 | 10110100.0 |
| 2005-04-12 10:30:00 | QQQ | ETF | 36.27 | 36.29 | 36.14 | 36.17 | 10652200.0 |
| 2005-04-12 11:00:00 | QQQ | ETF | 36.18 | 36.21 | 36.16 | 36.18 | 3851300.0 |
| 2005-04-12 11:30:00 | QQQ | ETF | 36.18 | 36.23 | 36.17 | 36.21 | 4021300.0 |
| 2005-04-12 12:00:00 | QQQ | ETF | 36.21 | 36.22 | 36.17 | 36.19 | 1347700.0 |
| 2005-04-12 12:30:00 | QQQ | ETF | 36.2 | 36.22 | 36.17 | 36.18 | 3910200.0 |
| 2005-04-12 13:00:00 | QQQ | ETF | 36.18 | 36.18 | 36.14 | 36.16 | 2854000.0 |
| 2005-04-12 13:30:00 | QQQ | ETF | 36.15 | 36.16 | 36.01 | 36.06 | 10537100.0 |
| 2005-04-12 14:00:00 | QQQ | ETF | 36.06 | 36.91 | 35.91 | 36.31 | 30588700.0 |
| 2005-04-12 14:30:00 | QQQ | ETF | 36.31 | 36.65 | 36.28 | 36.6 | 19573400.0 |
| 2005-04-12 15:00:00 | QQQ | ETF | 36.6 | 36.68 | 36.09 | 36.65 | 11748400.0 |
| 2005-04-12 15:30:00 | QQQ | ETF | 36.65 | 36.74 | 36.63 | 36.68 | 11181600.0 |
| 2005-04-12 09:00:00 | IWM | ETF | 60.115 | 60.205 | 60.115 | 60.205 | 1400.0 |
| 2005-04-12 09:30:00 | IWM | ETF | 60.26 | 60.26 | 59.825 | 59.865 | 5585000.0 |
| 2005-04-12 10:00:00 | IWM | ETF | 59.865 | 60.01 | 59.8 | 60.005 | 2609000.0 |
| 2005-04-12 10:30:00 | IWM | ETF | 60.005 | 60.015 | 59.685 | 59.775 | 2616400.0 |
| 2005-04-12 11:00:00 | IWM | ETF | 59.775 | 59.865 | 59.73 | 59.84 | 1220800.0 |
| 2005-04-12 11:30:00 | IWM | ETF | 59.85 | 59.93 | 59.82 | 59.885 | 417200.0 |
| 2005-04-12 12:00:00 | IWM | ETF | 59.885 | 59.915 | 59.82 | 59.8905 | 499800.0 |
| 2005-04-12 12:30:00 | IWM | ETF | 59.895 | 59.94 | 59.835 | 59.835 | 510200.0 |
| 2005-04-12 13:00:00 | IWM | ETF | 59.825 | 59.855 | 59.775 | 59.795 | 1321800.0 |
| 2005-04-12 13:30:00 | IWM | ETF | 59.8 | 59.805 | 59.71 | 59.75 | 977600.0 |
| 2005-04-12 14:00:00 | IWM | ETF | 59.745 | 60.6 | 59.65 | 60.455 | 6131200.0 |
| 2005-04-12 14:30:00 | IWM | ETF | 60.455 | 60.93 | 60.4 | 60.875 | 4780800.0 |
> showing 50 of 1,493 rows — these rows as CSV