PREVIEW / etf_30min / 2022-11-25
file: by_date/etf_30min/2022/2022-11-25.parquet size: 404 KB rows: 14,860
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-25 04:00:00 | SPY | ETF | 402.97 | 403.17 | 402.84 | 402.84 | 14842.0 |
| 2022-11-25 04:30:00 | SPY | ETF | 402.95 | 403.31 | 402.33 | 402.53 | 29107.0 |
| 2022-11-25 05:00:00 | SPY | ETF | 402.46 | 402.71 | 402.3 | 402.69 | 19906.0 |
| 2022-11-25 05:30:00 | SPY | ETF | 402.83 | 403.01 | 402.74 | 403.0 | 12823.0 |
| 2022-11-25 06:00:00 | SPY | ETF | 402.89 | 403.07 | 402.78 | 403.01 | 4125.0 |
| 2022-11-25 06:30:00 | SPY | ETF | 403.11 | 403.11 | 402.65 | 402.72 | 7381.0 |
| 2022-11-25 07:00:00 | SPY | ETF | 402.67 | 403.15 | 402.67 | 403.02 | 23324.0 |
| 2022-11-25 07:30:00 | SPY | ETF | 403.02 | 403.1 | 402.72 | 402.72 | 24443.0 |
| 2022-11-25 08:00:00 | SPY | ETF | 402.8399 | 403.38 | 402.46 | 402.47 | 420189.0 |
| 2022-11-25 08:30:00 | SPY | ETF | 402.45 | 402.45 | 402.02 | 402.07 | 101614.0 |
| 2022-11-25 09:00:00 | SPY | ETF | 402.07 | 402.2 | 401.52 | 401.8 | 188154.0 |
| 2022-11-25 09:30:00 | SPY | ETF | 401.83 | 402.56 | 401.535 | 402.44 | 2948131.0 |
| 2022-11-25 10:00:00 | SPY | ETF | 402.44 | 402.78 | 402.28 | 402.5 | 2208780.0 |
| 2022-11-25 10:30:00 | SPY | ETF | 402.485 | 402.72 | 402.33 | 402.62 | 1610091.0 |
| 2022-11-25 11:00:00 | SPY | ETF | 402.62 | 402.91 | 402.185 | 402.2788 | 1737021.0 |
| 2022-11-25 11:30:00 | SPY | ETF | 402.285 | 402.61 | 401.98 | 402.478 | 1718269.0 |
| 2022-11-25 12:00:00 | SPY | ETF | 402.47 | 402.59 | 402.205 | 402.52 | 1598701.0 |
| 2022-11-25 12:30:00 | SPY | ETF | 402.54 | 402.55 | 401.845 | 402.26 | 4034193.0 |
| 2022-11-25 13:00:00 | SPY | ETF | 402.26 | 402.64 | 402.14 | 402.34 | 1061621.0 |
| 2022-11-25 13:30:00 | SPY | ETF | 402.33 | 402.41 | 402.11 | 402.27 | 212122.0 |
| 2022-11-25 14:00:00 | SPY | ETF | 402.27 | 402.59 | 402.2101 | 402.53 | 84131.0 |
| 2022-11-25 14:30:00 | SPY | ETF | 402.53 | 402.53 | 402.3 | 402.3 | 21445.0 |
| 2022-11-25 15:00:00 | SPY | ETF | 402.3 | 402.5001 | 402.3 | 402.45 | 24173.0 |
| 2022-11-25 15:30:00 | SPY | ETF | 402.36 | 402.48 | 402.35 | 402.37 | 2734.0 |
| 2022-11-25 16:00:00 | SPY | ETF | 402.33 | 402.47 | 402.15 | 402.28 | 59966.0 |
| 2022-11-25 16:30:00 | SPY | ETF | 402.28 | 402.3 | 402.0 | 402.01 | 31573.0 |
| 2022-11-25 04:00:00 | QQQ | ETF | 289.82 | 289.82 | 289.07 | 289.15 | 43334.0 |
| 2022-11-25 04:30:00 | QQQ | ETF | 289.19 | 289.46 | 288.41 | 288.5 | 42746.0 |
| 2022-11-25 05:00:00 | QQQ | ETF | 288.53 | 288.72 | 288.39 | 288.72 | 8358.0 |
| 2022-11-25 05:30:00 | QQQ | ETF | 288.8 | 289.02 | 288.74 | 288.82 | 16396.0 |
| 2022-11-25 06:00:00 | QQQ | ETF | 288.81 | 288.81 | 288.53 | 288.76 | 6434.0 |
| 2022-11-25 06:30:00 | QQQ | ETF | 288.77 | 288.84 | 288.25 | 288.26 | 17414.0 |
| 2022-11-25 07:00:00 | QQQ | ETF | 288.27 | 288.53 | 288.27 | 288.46 | 38115.0 |
| 2022-11-25 07:30:00 | QQQ | ETF | 288.46 | 288.57 | 288.02 | 288.09 | 62082.0 |
| 2022-11-25 08:00:00 | QQQ | ETF | 288.38 | 289.95 | 288.04 | 288.17 | 141430.0 |
| 2022-11-25 08:30:00 | QQQ | ETF | 288.14 | 288.14 | 287.6 | 287.71 | 115380.0 |
| 2022-11-25 09:00:00 | QQQ | ETF | 287.71 | 287.8 | 287.01 | 287.16 | 204207.0 |
| 2022-11-25 09:30:00 | QQQ | ETF | 287.19 | 287.58 | 286.42 | 287.33 | 3110789.0 |
| 2022-11-25 10:00:00 | QQQ | ETF | 287.33 | 287.91 | 287.09 | 287.37 | 1430153.0 |
| 2022-11-25 10:30:00 | QQQ | ETF | 287.355 | 287.62 | 287.15 | 287.395 | 847240.0 |
| 2022-11-25 11:00:00 | QQQ | ETF | 287.395 | 287.81 | 286.88 | 286.97 | 1203864.0 |
| 2022-11-25 11:30:00 | QQQ | ETF | 286.98 | 287.31 | 286.52 | 287.21 | 1400206.0 |
| 2022-11-25 12:00:00 | QQQ | ETF | 287.205 | 287.29 | 286.85 | 287.28 | 1170481.0 |
| 2022-11-25 12:30:00 | QQQ | ETF | 287.29 | 287.3199 | 286.6801 | 286.85 | 1977014.0 |
| 2022-11-25 13:00:00 | QQQ | ETF | 286.86 | 286.95 | 286.62 | 286.9 | 506469.0 |
| 2022-11-25 13:30:00 | QQQ | ETF | 286.9 | 286.95 | 286.8399 | 286.91 | 388328.0 |
| 2022-11-25 14:00:00 | QQQ | ETF | 286.82 | 286.96 | 286.7999 | 286.9 | 29093.0 |
| 2022-11-25 14:30:00 | QQQ | ETF | 286.92 | 286.92 | 286.85 | 286.9 | 4574.0 |
| 2022-11-25 15:00:00 | QQQ | ETF | 286.875 | 286.89 | 286.82 | 286.88 | 4344.0 |
| 2022-11-25 15:30:00 | QQQ | ETF | 286.87 | 286.88 | 286.8499 | 286.8499 | 6508.0 |
> showing 50 of 14,860 rows — these rows as CSV