PREVIEW / etf_30min / 2024-10-04
file: by_date/etf_30min/2024/2024-10-04.parquet size: 865 KB rows: 34,506
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-04 04:00:00 | SPY | ETF | 568.73 | 568.93 | 568.18 | 568.55 | 6935.0 |
| 2024-10-04 04:30:00 | SPY | ETF | 568.53 | 568.68 | 568.15 | 568.21 | 5160.0 |
| 2024-10-04 05:00:00 | SPY | ETF | 568.23 | 568.52 | 568.13 | 568.38 | 6840.0 |
| 2024-10-04 05:30:00 | SPY | ETF | 568.41 | 568.9 | 568.39 | 568.9 | 5078.0 |
| 2024-10-04 06:00:00 | SPY | ETF | 569.12 | 569.49 | 569.1 | 569.26 | 4653.0 |
| 2024-10-04 06:30:00 | SPY | ETF | 569.32 | 569.65 | 569.15 | 569.16 | 17862.0 |
| 2024-10-04 07:00:00 | SPY | ETF | 569.15 | 569.78 | 569.02 | 569.65 | 46079.0 |
| 2024-10-04 07:30:00 | SPY | ETF | 569.7 | 569.84 | 569.4 | 569.6 | 72725.0 |
| 2024-10-04 08:00:00 | SPY | ETF | 569.42 | 570.0 | 567.55 | 570.0 | 145908.0 |
| 2024-10-04 08:30:00 | SPY | ETF | 570.1 | 573.01 | 569.96 | 572.91 | 1752407.0 |
| 2024-10-04 09:00:00 | SPY | ETF | 572.91 | 573.24 | 572.08 | 572.35 | 521026.0 |
| 2024-10-04 09:30:00 | SPY | ETF | 572.35 | 572.71 | 569.89 | 570.11 | 4772301.0 |
| 2024-10-04 10:00:00 | SPY | ETF | 570.14 | 571.16 | 568.35 | 568.83 | 3039647.0 |
| 2024-10-04 10:30:00 | SPY | ETF | 568.84 | 570.11 | 568.1 | 570.05 | 2437027.0 |
| 2024-10-04 11:00:00 | SPY | ETF | 570.035 | 570.73 | 568.32 | 568.78 | 1779257.0 |
| 2024-10-04 11:30:00 | SPY | ETF | 568.78 | 570.47 | 568.28 | 570.47 | 1452193.0 |
| 2024-10-04 12:00:00 | SPY | ETF | 570.47 | 570.78 | 569.43 | 569.805 | 1209050.0 |
| 2024-10-04 12:30:00 | SPY | ETF | 569.8 | 571.51 | 569.54 | 571.05 | 1876772.0 |
| 2024-10-04 13:00:00 | SPY | ETF | 571.015 | 571.57 | 570.7 | 571.05 | 915719.0 |
| 2024-10-04 13:30:00 | SPY | ETF | 571.05 | 571.55 | 569.58 | 570.2387 | 1657991.0 |
| 2024-10-04 14:00:00 | SPY | ETF | 570.22 | 570.86 | 569.7 | 570.785 | 1375636.0 |
| 2024-10-04 14:30:00 | SPY | ETF | 570.78 | 571.56 | 570.57 | 571.5 | 1030713.0 |
| 2024-10-04 15:00:00 | SPY | ETF | 571.49 | 572.19 | 571.15 | 572.04 | 1440670.0 |
| 2024-10-04 15:30:00 | SPY | ETF | 572.04 | 573.36 | 571.8958 | 572.91 | 5111773.0 |
| 2024-10-04 16:00:00 | SPY | ETF | 572.9 | 573.03 | 572.49 | 572.83 | 2066879.0 |
| 2024-10-04 16:30:00 | SPY | ETF | 572.83 | 572.98 | 572.42 | 572.48 | 154968.0 |
| 2024-10-04 17:00:00 | SPY | ETF | 572.58 | 572.84 | 572.5 | 572.74 | 39406.0 |
| 2024-10-04 17:30:00 | SPY | ETF | 572.71 | 572.98 | 572.57 | 572.6 | 19317.0 |
| 2024-10-04 18:00:00 | SPY | ETF | 572.58 | 572.65 | 572.29 | 572.5 | 27444.0 |
| 2024-10-04 18:30:00 | SPY | ETF | 572.5 | 572.5 | 572.3 | 572.33 | 7076.0 |
| 2024-10-04 19:00:00 | SPY | ETF | 572.4 | 572.55 | 572.3505 | 572.38 | 4329.0 |
| 2024-10-04 19:30:00 | SPY | ETF | 572.38 | 572.43 | 572.3 | 572.31 | 13763.0 |
| 2024-10-04 04:00:00 | QQQ | ETF | 482.87 | 483.1 | 482.07 | 482.58 | 20605.0 |
| 2024-10-04 04:30:00 | QQQ | ETF | 482.63 | 482.83 | 482.16 | 482.19 | 12116.0 |
| 2024-10-04 05:00:00 | QQQ | ETF | 482.15 | 482.6 | 482.06 | 482.17 | 9102.0 |
| 2024-10-04 05:30:00 | QQQ | ETF | 482.4 | 483.06 | 482.4 | 483.06 | 7994.0 |
| 2024-10-04 06:00:00 | QQQ | ETF | 483.15 | 483.83 | 483.09 | 483.6 | 23904.0 |
| 2024-10-04 06:30:00 | QQQ | ETF | 483.68 | 483.87 | 483.31 | 483.31 | 27835.0 |
| 2024-10-04 07:00:00 | QQQ | ETF | 483.28 | 483.88 | 483.14 | 483.86 | 34144.0 |
| 2024-10-04 07:30:00 | QQQ | ETF | 483.97 | 484.1 | 483.39 | 483.65 | 58592.0 |
| 2024-10-04 08:00:00 | QQQ | ETF | 483.2 | 484.12 | 481.229 | 483.89 | 127796.0 |
| 2024-10-04 08:30:00 | QQQ | ETF | 483.87 | 487.95 | 483.83 | 487.94 | 933694.0 |
| 2024-10-04 09:00:00 | QQQ | ETF | 487.97 | 488.35 | 487.35 | 487.5 | 363367.0 |
| 2024-10-04 09:30:00 | QQQ | ETF | 487.45 | 487.72 | 483.79 | 484.09 | 3902490.0 |
| 2024-10-04 10:00:00 | QQQ | ETF | 484.09 | 484.96 | 482.385 | 482.96 | 2726133.0 |
| 2024-10-04 10:30:00 | QQQ | ETF | 483.0 | 485.16 | 482.52 | 485.09 | 1842093.0 |
| 2024-10-04 11:00:00 | QQQ | ETF | 485.05 | 485.85 | 483.14 | 483.51 | 1492511.0 |
| 2024-10-04 11:30:00 | QQQ | ETF | 483.47 | 485.39 | 482.88 | 485.38 | 1270440.0 |
| 2024-10-04 12:00:00 | QQQ | ETF | 485.39 | 485.56 | 484.0 | 484.51 | 830437.0 |
| 2024-10-04 12:30:00 | QQQ | ETF | 484.46 | 486.34 | 484.3 | 485.67 | 1045738.0 |
> showing 50 of 34,506 rows — these rows as CSV