PREVIEW / etf_30min / 2001-06-07
file: by_date/etf_30min/2001/2001-06-07.parquet size: 15 KB rows: 376
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-06-07 09:30:00 | SPY | ETF | 127.05 | 127.78 | 127.05 | 127.47 | 1082300.0 |
| 2001-06-07 10:00:00 | SPY | ETF | 127.46 | 127.78 | 127.3 | 127.53 | 474100.0 |
| 2001-06-07 10:30:00 | SPY | ETF | 127.47 | 128.13 | 127.45 | 127.82 | 484400.0 |
| 2001-06-07 11:00:00 | SPY | ETF | 127.81 | 128.0 | 127.5 | 127.56 | 487000.0 |
| 2001-06-07 11:30:00 | SPY | ETF | 127.57 | 127.59 | 127.3 | 127.44 | 371900.0 |
| 2001-06-07 12:00:00 | SPY | ETF | 127.39 | 127.43 | 127.06 | 127.3 | 303400.0 |
| 2001-06-07 12:30:00 | SPY | ETF | 127.33 | 127.44 | 127.16 | 127.3 | 253200.0 |
| 2001-06-07 13:00:00 | SPY | ETF | 127.3 | 127.55 | 127.0 | 127.45 | 403500.0 |
| 2001-06-07 13:30:00 | SPY | ETF | 127.45 | 127.96 | 127.44 | 127.88 | 396300.0 |
| 2001-06-07 14:00:00 | SPY | ETF | 127.86 | 128.09 | 127.69 | 127.77 | 396800.0 |
| 2001-06-07 14:30:00 | SPY | ETF | 127.76 | 128.13 | 127.76 | 127.8 | 316200.0 |
| 2001-06-07 15:00:00 | SPY | ETF | 127.92 | 128.17 | 127.85 | 128.05 | 433300.0 |
| 2001-06-07 15:30:00 | SPY | ETF | 128.1 | 128.29 | 127.88 | 128.24 | 742300.0 |
| 2001-06-07 16:00:00 | SPY | ETF | 128.22 | 128.35 | 128.1 | 128.1 | 440100.0 |
| 2001-06-07 16:30:00 | SPY | ETF | 128.3 | 128.5 | 128.1 | 128.45 | 13300.0 |
| 2001-06-07 17:00:00 | SPY | ETF | 128.52 | 128.73 | 128.46 | 128.47 | 8300.0 |
| 2001-06-07 17:30:00 | SPY | ETF | 128.63 | 128.75 | 128.63 | 128.7 | 4000.0 |
| 2001-06-07 18:00:00 | SPY | ETF | 128.65 | 128.8 | 128.65 | 128.8 | 3600.0 |
| 2001-06-07 09:30:00 | QQQ | ETF | 47.13 | 47.89 | 47.07 | 47.76 | 8825300.0 |
| 2001-06-07 10:00:00 | QQQ | ETF | 47.77 | 48.24 | 47.72 | 48.1 | 5611600.0 |
| 2001-06-07 10:30:00 | QQQ | ETF | 48.1 | 48.6 | 48.0 | 48.26 | 5345900.0 |
| 2001-06-07 11:00:00 | QQQ | ETF | 48.23 | 48.39 | 48.0 | 48.09 | 3843700.0 |
| 2001-06-07 11:30:00 | QQQ | ETF | 48.09 | 48.2 | 47.48 | 48.03 | 1927200.0 |
| 2001-06-07 12:00:00 | QQQ | ETF | 48.03 | 48.09 | 47.74 | 47.9 | 2948500.0 |
| 2001-06-07 12:30:00 | QQQ | ETF | 47.9 | 48.06 | 47.8 | 47.96 | 1567000.0 |
| 2001-06-07 13:00:00 | QQQ | ETF | 47.97 | 48.32 | 47.79 | 48.22 | 5178300.0 |
| 2001-06-07 13:30:00 | QQQ | ETF | 48.19 | 48.66 | 48.16 | 48.6 | 3872200.0 |
| 2001-06-07 14:00:00 | QQQ | ETF | 48.61 | 48.84 | 48.5 | 48.59 | 5523200.0 |
| 2001-06-07 14:30:00 | QQQ | ETF | 48.59 | 48.83 | 48.46 | 48.7 | 2975000.0 |
| 2001-06-07 15:00:00 | QQQ | ETF | 48.68 | 48.9 | 48.5 | 48.66 | 4312400.0 |
| 2001-06-07 15:30:00 | QQQ | ETF | 48.67 | 48.91 | 48.5 | 48.89 | 5712500.0 |
| 2001-06-07 16:00:00 | QQQ | ETF | 48.88 | 49.25 | 48.35 | 49.17 | 4125700.0 |
| 2001-06-07 16:30:00 | QQQ | ETF | 49.23 | 49.55 | 48.7 | 49.4 | 1004800.0 |
| 2001-06-07 17:00:00 | QQQ | ETF | 49.35 | 49.62 | 49.35 | 49.51 | 311200.0 |
| 2001-06-07 17:30:00 | QQQ | ETF | 49.5 | 49.59 | 49.42 | 49.5 | 131800.0 |
| 2001-06-07 18:00:00 | QQQ | ETF | 49.5 | 49.8 | 49.5 | 49.69 | 50200.0 |
| 2001-06-07 09:30:00 | IWM | ETF | 51.0 | 51.275 | 51.0 | 51.275 | 27600.0 |
| 2001-06-07 10:00:00 | IWM | ETF | 51.195 | 51.225 | 51.025 | 51.025 | 4600.0 |
| 2001-06-07 10:30:00 | IWM | ETF | 51.28 | 51.375 | 51.28 | 51.375 | 2200.0 |
| 2001-06-07 11:00:00 | IWM | ETF | 51.375 | 51.375 | 51.13 | 51.13 | 15600.0 |
| 2001-06-07 11:30:00 | IWM | ETF | 51.155 | 51.275 | 51.125 | 51.17 | 8200.0 |
| 2001-06-07 12:00:00 | IWM | ETF | 51.145 | 51.145 | 51.03 | 51.1 | 1000.0 |
| 2001-06-07 12:30:00 | IWM | ETF | 51.1 | 51.1 | 51.025 | 51.025 | 4000.0 |
| 2001-06-07 13:00:00 | IWM | ETF | 51.1 | 51.1 | 51.1 | 51.1 | 4000.0 |
| 2001-06-07 13:30:00 | IWM | ETF | 51.195 | 51.25 | 51.195 | 51.25 | 12400.0 |
| 2001-06-07 14:00:00 | IWM | ETF | 51.27 | 51.4 | 51.155 | 51.23 | 48000.0 |
| 2001-06-07 14:30:00 | IWM | ETF | 51.25 | 51.395 | 51.23 | 51.375 | 12600.0 |
| 2001-06-07 15:00:00 | IWM | ETF | 51.45 | 51.5 | 51.45 | 51.45 | 3800.0 |
| 2001-06-07 15:30:00 | IWM | ETF | 51.445 | 51.45 | 51.315 | 51.45 | 76200.0 |
| 2001-06-07 16:00:00 | IWM | ETF | 51.575 | 51.575 | 51.39 | 51.39 | 36200.0 |
> showing 50 of 376 rows — these rows as CSV