PREVIEW / etf_30min / 2005-09-21
file: by_date/etf_30min/2005/2005-09-21.parquet size: 50 KB rows: 1,732
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-09-21 05:30:00 | SPY | ETF | 122.22 | 122.22 | 122.22 | 122.22 | 200.0 |
| 2005-09-21 06:00:00 | SPY | ETF | 122.12 | 122.12 | 122.12 | 122.12 | 200.0 |
| 2005-09-21 07:00:00 | SPY | ETF | 122.05 | 122.06 | 121.98 | 121.99 | 10900.0 |
| 2005-09-21 07:30:00 | SPY | ETF | 121.98 | 122.0 | 121.85 | 121.93 | 210700.0 |
| 2005-09-21 08:00:00 | SPY | ETF | 121.97 | 122.0 | 121.76 | 121.82 | 833300.0 |
| 2005-09-21 08:30:00 | SPY | ETF | 121.8 | 122.05 | 121.79 | 121.83 | 1602900.0 |
| 2005-09-21 09:00:00 | SPY | ETF | 121.83 | 121.85 | 121.78 | 121.8 | 827000.0 |
| 2005-09-21 09:30:00 | SPY | ETF | 121.79 | 121.87 | 121.49 | 121.64 | 8969900.0 |
| 2005-09-21 10:00:00 | SPY | ETF | 121.65 | 121.71 | 121.37 | 121.53 | 10253500.0 |
| 2005-09-21 10:30:00 | SPY | ETF | 121.5 | 121.82 | 121.5 | 121.79 | 10314700.0 |
| 2005-09-21 11:00:00 | SPY | ETF | 121.79 | 121.85 | 121.49 | 121.55 | 4456400.0 |
| 2005-09-21 11:30:00 | SPY | ETF | 121.53 | 121.67 | 121.27 | 121.28 | 6097300.0 |
| 2005-09-21 12:00:00 | SPY | ETF | 121.31 | 121.69 | 121.2 | 121.37 | 3388900.0 |
| 2005-09-21 12:30:00 | SPY | ETF | 121.34 | 121.5 | 121.27 | 121.43 | 2716600.0 |
| 2005-09-21 13:00:00 | SPY | ETF | 121.43 | 121.57 | 121.25 | 121.3 | 3105800.0 |
| 2005-09-21 13:30:00 | SPY | ETF | 121.31 | 121.33 | 120.94 | 121.15 | 7820800.0 |
| 2005-09-21 14:00:00 | SPY | ETF | 121.15 | 121.32 | 120.95 | 121.2 | 6355900.0 |
| 2005-09-21 14:30:00 | SPY | ETF | 121.19 | 121.53 | 121.09 | 121.4 | 6481200.0 |
| 2005-09-21 15:00:00 | SPY | ETF | 121.39 | 121.5 | 121.06 | 121.06 | 6675900.0 |
| 2005-09-21 15:30:00 | SPY | ETF | 121.06 | 121.15 | 120.86 | 120.89 | 8376900.0 |
| 2005-09-21 16:00:00 | SPY | ETF | 120.89 | 120.99 | 120.77 | 120.92 | 1749300.0 |
| 2005-09-21 16:30:00 | SPY | ETF | 120.92 | 120.95 | 120.85 | 120.85 | 324600.0 |
| 2005-09-21 17:00:00 | SPY | ETF | 120.89 | 120.89 | 120.83 | 120.89 | 3300.0 |
| 2005-09-21 17:30:00 | SPY | ETF | 120.89 | 120.93 | 120.84 | 120.84 | 274600.0 |
| 2005-09-21 18:00:00 | SPY | ETF | 120.83 | 120.83 | 120.7 | 120.76 | 28600.0 |
| 2005-09-21 18:30:00 | SPY | ETF | 120.78 | 120.78 | 120.78 | 120.78 | 1100.0 |
| 2005-09-21 19:00:00 | SPY | ETF | 120.79 | 120.81 | 120.77 | 120.77 | 8700.0 |
| 2005-09-21 19:30:00 | SPY | ETF | 120.8 | 120.83 | 120.79 | 120.82 | 9000.0 |
| 2005-09-21 09:30:00 | QQQ | ETF | 38.82 | 38.87 | 38.61 | 38.69 | 15938800.0 |
| 2005-09-21 10:00:00 | QQQ | ETF | 38.69 | 38.75 | 38.62 | 38.68 | 9904200.0 |
| 2005-09-21 10:30:00 | QQQ | ETF | 38.68 | 38.83 | 38.67 | 38.8 | 9690400.0 |
| 2005-09-21 11:00:00 | QQQ | ETF | 38.8 | 38.82 | 38.65 | 38.66 | 6138900.0 |
| 2005-09-21 11:30:00 | QQQ | ETF | 38.66 | 38.68 | 38.56 | 38.59 | 6997900.0 |
| 2005-09-21 12:00:00 | QQQ | ETF | 38.58 | 38.65 | 38.54 | 38.64 | 5133400.0 |
| 2005-09-21 12:30:00 | QQQ | ETF | 38.64 | 38.69 | 38.6 | 38.67 | 4073000.0 |
| 2005-09-21 13:00:00 | QQQ | ETF | 38.67 | 38.71 | 38.58 | 38.63 | 2844900.0 |
| 2005-09-21 13:30:00 | QQQ | ETF | 38.63 | 38.63 | 38.48 | 38.55 | 7444700.0 |
| 2005-09-21 14:00:00 | QQQ | ETF | 38.55 | 38.65 | 38.5 | 38.58 | 4702100.0 |
| 2005-09-21 14:30:00 | QQQ | ETF | 38.59 | 38.71 | 38.55 | 38.67 | 6725800.0 |
| 2005-09-21 15:00:00 | QQQ | ETF | 38.67 | 38.68 | 38.51 | 38.52 | 6665400.0 |
| 2005-09-21 15:30:00 | QQQ | ETF | 38.52 | 38.56 | 38.47 | 38.5 | 11394800.0 |
| 2005-09-21 08:00:00 | IWM | ETF | 65.5 | 65.5 | 65.46 | 65.5 | 6100.0 |
| 2005-09-21 08:30:00 | IWM | ETF | 65.48 | 65.51 | 65.48 | 65.51 | 7000.0 |
| 2005-09-21 09:00:00 | IWM | ETF | 65.52 | 65.54 | 65.47 | 65.53 | 119300.0 |
| 2005-09-21 09:30:00 | IWM | ETF | 65.53 | 65.53 | 65.04 | 65.12 | 3775700.0 |
| 2005-09-21 10:00:00 | IWM | ETF | 65.13 | 65.33 | 65.11 | 65.31 | 3486900.0 |
| 2005-09-21 10:30:00 | IWM | ETF | 65.31 | 65.57 | 65.29 | 65.54 | 1377300.0 |
| 2005-09-21 11:00:00 | IWM | ETF | 65.54 | 65.61 | 65.23 | 65.25 | 2155400.0 |
| 2005-09-21 11:30:00 | IWM | ETF | 65.24 | 65.33 | 64.99 | 65.0 | 1618900.0 |
| 2005-09-21 12:00:00 | IWM | ETF | 65.0 | 65.15 | 64.94 | 65.12 | 1020700.0 |
> showing 50 of 1,732 rows — these rows as CSV