PREVIEW / etf_30min / 2021-12-22
file: by_date/etf_30min/2021/2021-12-22.parquet size: 650 KB rows: 25,241
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-22 04:00:00 | SPY | ETF | 461.98 | 462.46 | 461.83 | 462.14 | 24332.0 |
| 2021-12-22 04:30:00 | SPY | ETF | 462.16 | 462.34 | 462.02 | 462.04 | 20744.0 |
| 2021-12-22 05:00:00 | SPY | ETF | 462.18 | 462.33 | 462.1 | 462.33 | 1889.0 |
| 2021-12-22 05:30:00 | SPY | ETF | 462.39 | 463.13 | 462.25 | 463.05 | 16700.0 |
| 2021-12-22 06:00:00 | SPY | ETF | 463.08 | 463.35 | 463.01 | 463.21 | 43014.0 |
| 2021-12-22 06:30:00 | SPY | ETF | 463.2 | 463.63 | 462.98 | 463.62 | 40285.0 |
| 2021-12-22 07:00:00 | SPY | ETF | 463.6 | 463.67 | 463.33 | 463.33 | 36218.0 |
| 2021-12-22 07:30:00 | SPY | ETF | 463.33 | 463.46 | 463.01 | 463.01 | 62306.0 |
| 2021-12-22 08:00:00 | SPY | ETF | 463.26 | 463.6399 | 462.03 | 462.34 | 144774.0 |
| 2021-12-22 08:30:00 | SPY | ETF | 462.34 | 462.65 | 461.68 | 462.05 | 192049.0 |
| 2021-12-22 09:00:00 | SPY | ETF | 462.08 | 462.85 | 461.9 | 462.82 | 161247.0 |
| 2021-12-22 09:30:00 | SPY | ETF | 462.79 | 463.925 | 462.58 | 463.4799 | 5038502.0 |
| 2021-12-22 10:00:00 | SPY | ETF | 463.46 | 464.59 | 463.11 | 464.135 | 3633568.0 |
| 2021-12-22 10:30:00 | SPY | ETF | 464.1401 | 466.31 | 464.12 | 466.12 | 4008079.0 |
| 2021-12-22 11:00:00 | SPY | ETF | 466.13 | 466.56 | 465.77 | 466.29 | 2502637.0 |
| 2021-12-22 11:30:00 | SPY | ETF | 466.29 | 466.68 | 466.0079 | 466.495 | 2105713.0 |
| 2021-12-22 12:00:00 | SPY | ETF | 466.51 | 466.78 | 466.1 | 466.51 | 1824868.0 |
| 2021-12-22 12:30:00 | SPY | ETF | 466.52 | 466.91 | 466.18 | 466.825 | 1588660.0 |
| 2021-12-22 13:00:00 | SPY | ETF | 466.83 | 466.87 | 466.245 | 466.3 | 1191635.0 |
| 2021-12-22 13:30:00 | SPY | ETF | 466.3 | 466.57 | 465.61 | 465.8727 | 1521868.0 |
| 2021-12-22 14:00:00 | SPY | ETF | 465.88 | 466.0402 | 465.27 | 465.405 | 1904247.0 |
| 2021-12-22 14:30:00 | SPY | ETF | 465.42 | 466.39 | 465.415 | 466.315 | 1641187.0 |
| 2021-12-22 15:00:00 | SPY | ETF | 466.32 | 466.73 | 466.08 | 466.5 | 2810538.0 |
| 2021-12-22 15:30:00 | SPY | ETF | 466.49 | 467.81 | 466.33 | 467.7 | 8715269.0 |
| 2021-12-22 16:00:00 | SPY | ETF | 467.71 | 468.02 | 465.8499 | 468.0 | 3191418.0 |
| 2021-12-22 16:30:00 | SPY | ETF | 467.98 | 468.06 | 467.69 | 468.0 | 108677.0 |
| 2021-12-22 17:00:00 | SPY | ETF | 468.06 | 468.06 | 467.69 | 468.0 | 1360299.0 |
| 2021-12-22 17:30:00 | SPY | ETF | 468.0 | 468.07 | 467.94 | 467.95 | 54282.0 |
| 2021-12-22 18:00:00 | SPY | ETF | 467.95 | 468.3 | 467.95 | 468.06 | 32931.0 |
| 2021-12-22 18:30:00 | SPY | ETF | 467.69 | 468.25 | 467.69 | 468.11 | 11125.0 |
| 2021-12-22 19:00:00 | SPY | ETF | 468.11 | 468.11 | 467.8 | 467.9 | 23533.0 |
| 2021-12-22 19:30:00 | SPY | ETF | 467.9 | 468.13 | 467.9 | 468.0 | 23499.0 |
| 2021-12-22 04:00:00 | QQQ | ETF | 387.63 | 388.2 | 387.54 | 387.99 | 93394.0 |
| 2021-12-22 04:30:00 | QQQ | ETF | 387.93 | 388.11 | 387.6 | 387.82 | 32312.0 |
| 2021-12-22 05:00:00 | QQQ | ETF | 387.96 | 388.15 | 387.83 | 388.0 | 10087.0 |
| 2021-12-22 05:30:00 | QQQ | ETF | 388.07 | 388.91 | 387.93 | 388.76 | 11922.0 |
| 2021-12-22 06:00:00 | QQQ | ETF | 388.8 | 389.11 | 388.7 | 388.89 | 56190.0 |
| 2021-12-22 06:30:00 | QQQ | ETF | 388.91 | 389.45 | 388.8 | 389.35 | 8862.0 |
| 2021-12-22 07:00:00 | QQQ | ETF | 389.34 | 389.49 | 389.24 | 389.249 | 59912.0 |
| 2021-12-22 07:30:00 | QQQ | ETF | 389.23 | 389.35 | 388.8 | 388.81 | 51997.0 |
| 2021-12-22 08:00:00 | QQQ | ETF | 389.33 | 389.49 | 387.6996 | 388.3 | 179613.0 |
| 2021-12-22 08:30:00 | QQQ | ETF | 388.25 | 388.4 | 387.65 | 388.26 | 278454.0 |
| 2021-12-22 09:00:00 | QQQ | ETF | 388.275 | 388.98 | 388.11 | 388.91 | 275462.0 |
| 2021-12-22 09:30:00 | QQQ | ETF | 388.91 | 390.9276 | 388.23 | 390.02 | 4085715.0 |
| 2021-12-22 10:00:00 | QQQ | ETF | 389.99 | 390.65 | 388.63 | 389.91 | 3281778.0 |
| 2021-12-22 10:30:00 | QQQ | ETF | 389.93 | 392.22 | 389.9 | 392.13 | 2745602.0 |
| 2021-12-22 11:00:00 | QQQ | ETF | 392.14 | 392.87 | 391.59 | 392.64 | 2063273.0 |
| 2021-12-22 11:30:00 | QQQ | ETF | 392.65 | 393.0832 | 392.34 | 392.96 | 1277455.0 |
| 2021-12-22 12:00:00 | QQQ | ETF | 392.9699 | 393.24 | 391.98 | 392.5 | 1507182.0 |
| 2021-12-22 12:30:00 | QQQ | ETF | 392.505 | 392.71 | 391.93 | 392.6 | 1104038.0 |
> showing 50 of 25,241 rows — these rows as CSV