PREVIEW / etf_30min / 2005-05-12
file: by_date/etf_30min/2005/2005-05-12.parquet size: 46 KB rows: 1,546
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-05-12 04:00:00 | SPY | ETF | 117.42 | 117.42 | 117.42 | 117.42 | 6300.0 |
| 2005-05-12 06:30:00 | SPY | ETF | 117.29 | 117.29 | 117.29 | 117.29 | 4900.0 |
| 2005-05-12 07:00:00 | SPY | ETF | 117.31 | 117.31 | 117.16 | 117.16 | 85400.0 |
| 2005-05-12 07:30:00 | SPY | ETF | 117.13 | 117.22 | 117.11 | 117.2 | 93900.0 |
| 2005-05-12 08:00:00 | SPY | ETF | 117.19 | 117.27 | 117.17 | 117.18 | 87700.0 |
| 2005-05-12 08:30:00 | SPY | ETF | 117.17 | 117.43 | 117.17 | 117.38 | 469700.0 |
| 2005-05-12 09:00:00 | SPY | ETF | 117.38 | 117.42 | 117.31 | 117.31 | 296500.0 |
| 2005-05-12 09:30:00 | SPY | ETF | 117.32 | 117.48 | 116.99 | 117.09 | 7510500.0 |
| 2005-05-12 10:00:00 | SPY | ETF | 117.09 | 117.59 | 117.02 | 117.34 | 9774600.0 |
| 2005-05-12 10:30:00 | SPY | ETF | 117.33 | 117.53 | 116.83 | 117.08 | 13764400.0 |
| 2005-05-12 11:00:00 | SPY | ETF | 117.05 | 117.28 | 116.86 | 117.17 | 6074000.0 |
| 2005-05-12 11:30:00 | SPY | ETF | 117.16 | 117.41 | 117.08 | 117.35 | 3650600.0 |
| 2005-05-12 12:00:00 | SPY | ETF | 117.35 | 117.5 | 117.0 | 117.22 | 5751100.0 |
| 2005-05-12 12:30:00 | SPY | ETF | 117.22 | 117.26 | 117.02 | 117.21 | 2824100.0 |
| 2005-05-12 13:00:00 | SPY | ETF | 117.2 | 117.29 | 117.11 | 117.16 | 1500400.0 |
| 2005-05-12 13:30:00 | SPY | ETF | 117.15 | 117.24 | 116.72 | 116.84 | 5198200.0 |
| 2005-05-12 14:00:00 | SPY | ETF | 116.84 | 116.95 | 116.25 | 116.36 | 8335700.0 |
| 2005-05-12 14:30:00 | SPY | ETF | 116.36 | 116.47 | 116.11 | 116.36 | 8973600.0 |
| 2005-05-12 15:00:00 | SPY | ETF | 116.36 | 116.41 | 115.95 | 116.19 | 7393100.0 |
| 2005-05-12 15:30:00 | SPY | ETF | 116.19 | 116.29 | 115.95 | 116.1 | 6887500.0 |
| 2005-05-12 16:00:00 | SPY | ETF | 116.09 | 116.59 | 115.95 | 116.05 | 2498500.0 |
| 2005-05-12 16:30:00 | SPY | ETF | 116.09 | 116.18 | 115.98 | 116.17 | 371900.0 |
| 2005-05-12 17:00:00 | SPY | ETF | 116.14 | 116.21 | 116.1 | 116.2 | 75100.0 |
| 2005-05-12 17:30:00 | SPY | ETF | 116.2 | 116.2 | 115.96 | 116.15 | 403700.0 |
| 2005-05-12 18:00:00 | SPY | ETF | 116.18 | 116.21 | 116.18 | 116.21 | 4600.0 |
| 2005-05-12 18:30:00 | SPY | ETF | 116.2 | 116.2 | 116.2 | 116.2 | 2800.0 |
| 2005-05-12 19:00:00 | SPY | ETF | 116.17 | 116.17 | 116.17 | 116.17 | 200.0 |
| 2005-05-12 19:30:00 | SPY | ETF | 116.24 | 116.24 | 116.24 | 116.24 | 100.0 |
| 2005-05-12 09:30:00 | QQQ | ETF | 36.01 | 36.08 | 35.9 | 35.94 | 17337200.0 |
| 2005-05-12 10:00:00 | QQQ | ETF | 35.94 | 36.14 | 35.91 | 36.09 | 9355700.0 |
| 2005-05-12 10:30:00 | QQQ | ETF | 36.08 | 36.2 | 35.84 | 36.01 | 15676000.0 |
| 2005-05-12 11:00:00 | QQQ | ETF | 36.01 | 36.09 | 35.95 | 36.07 | 5797000.0 |
| 2005-05-12 11:30:00 | QQQ | ETF | 36.06 | 36.15 | 36.04 | 36.13 | 4630200.0 |
| 2005-05-12 12:00:00 | QQQ | ETF | 36.1 | 36.18 | 36.05 | 36.11 | 7383100.0 |
| 2005-05-12 12:30:00 | QQQ | ETF | 36.11 | 36.12 | 35.05 | 36.07 | 3520300.0 |
| 2005-05-12 13:00:00 | QQQ | ETF | 36.07 | 36.11 | 36.05 | 36.07 | 2026400.0 |
| 2005-05-12 13:30:00 | QQQ | ETF | 36.07 | 36.08 | 35.94 | 35.99 | 5950700.0 |
| 2005-05-12 14:00:00 | QQQ | ETF | 35.98 | 36.03 | 35.79 | 35.85 | 6955200.0 |
| 2005-05-12 14:30:00 | QQQ | ETF | 35.85 | 35.89 | 35.68 | 35.82 | 11998200.0 |
| 2005-05-12 15:00:00 | QQQ | ETF | 35.81 | 35.84 | 35.66 | 35.76 | 6455400.0 |
| 2005-05-12 15:30:00 | QQQ | ETF | 35.75 | 35.84 | 35.69 | 35.84 | 12918400.0 |
| 2005-05-12 07:00:00 | IWM | ETF | 59.25 | 59.25 | 59.175 | 59.19 | 19800.0 |
| 2005-05-12 07:30:00 | IWM | ETF | 59.18 | 59.18 | 59.17 | 59.17 | 40000.0 |
| 2005-05-12 08:00:00 | IWM | ETF | 59.25 | 59.25 | 59.25 | 59.25 | 200.0 |
| 2005-05-12 08:30:00 | IWM | ETF | 59.305 | 59.335 | 59.3 | 59.3 | 2200.0 |
| 2005-05-12 09:00:00 | IWM | ETF | 59.345 | 59.365 | 59.315 | 59.365 | 46400.0 |
| 2005-05-12 09:30:00 | IWM | ETF | 59.4 | 59.575 | 59.06 | 59.115 | 3081600.0 |
| 2005-05-12 10:00:00 | IWM | ETF | 59.12 | 59.465 | 59.05 | 59.3 | 3738800.0 |
| 2005-05-12 10:30:00 | IWM | ETF | 59.305 | 59.485 | 58.955 | 59.075 | 3068200.0 |
| 2005-05-12 11:00:00 | IWM | ETF | 59.09 | 59.21 | 58.97 | 59.095 | 1729200.0 |
> showing 50 of 1,546 rows — these rows as CSV