PREVIEW / etf_30min / 2024-07-02
file: by_date/etf_30min/2024/2024-07-02.parquet size: 818 KB rows: 32,771
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-07-02 04:00:00 | SPY | ETF | 543.98 | 544.28 | 543.24 | 543.24 | 12331.0 |
| 2024-07-02 04:30:00 | SPY | ETF | 543.0 | 543.5 | 542.97 | 543.49 | 6024.0 |
| 2024-07-02 05:00:00 | SPY | ETF | 543.48 | 543.67 | 543.09 | 543.27 | 2800.0 |
| 2024-07-02 05:30:00 | SPY | ETF | 543.3 | 543.46 | 543.05 | 543.34 | 3585.0 |
| 2024-07-02 06:00:00 | SPY | ETF | 543.35 | 543.36 | 543.25 | 543.33 | 1743.0 |
| 2024-07-02 06:30:00 | SPY | ETF | 543.36 | 543.63 | 543.26 | 543.42 | 16100.0 |
| 2024-07-02 07:00:00 | SPY | ETF | 543.46 | 543.48 | 542.75 | 542.9 | 86680.0 |
| 2024-07-02 07:30:00 | SPY | ETF | 542.88 | 543.07 | 542.44 | 542.97 | 122719.0 |
| 2024-07-02 08:00:00 | SPY | ETF | 542.93 | 544.8 | 542.5097 | 543.26 | 103719.0 |
| 2024-07-02 08:30:00 | SPY | ETF | 543.3 | 543.42 | 542.97 | 543.24 | 32547.0 |
| 2024-07-02 09:00:00 | SPY | ETF | 543.24 | 543.82 | 543.24 | 543.75 | 119176.0 |
| 2024-07-02 09:30:00 | SPY | ETF | 543.7 | 545.68 | 543.65 | 545.125 | 2969048.0 |
| 2024-07-02 10:00:00 | SPY | ETF | 545.14 | 545.71 | 544.47 | 545.33 | 1744753.0 |
| 2024-07-02 10:30:00 | SPY | ETF | 545.33 | 545.97 | 545.1 | 545.76 | 1162463.0 |
| 2024-07-02 11:00:00 | SPY | ETF | 545.76 | 546.1 | 545.44 | 546.06 | 1021598.0 |
| 2024-07-02 11:30:00 | SPY | ETF | 546.06 | 546.51 | 545.52 | 545.65 | 1250125.0 |
| 2024-07-02 12:00:00 | SPY | ETF | 545.64 | 545.9151 | 545.12 | 545.835 | 1080469.0 |
| 2024-07-02 12:30:00 | SPY | ETF | 545.84 | 546.0 | 545.61 | 546.0 | 762703.0 |
| 2024-07-02 13:00:00 | SPY | ETF | 546.0 | 546.92 | 545.9 | 546.6595 | 1491384.0 |
| 2024-07-02 13:30:00 | SPY | ETF | 546.66 | 547.48 | 546.4502 | 547.275 | 913928.0 |
| 2024-07-02 14:00:00 | SPY | ETF | 547.28 | 547.88 | 547.2404 | 547.725 | 1168144.0 |
| 2024-07-02 14:30:00 | SPY | ETF | 547.73 | 547.98 | 547.55 | 547.64 | 1252080.0 |
| 2024-07-02 15:00:00 | SPY | ETF | 547.63 | 548.08 | 547.48 | 547.975 | 1478190.0 |
| 2024-07-02 15:30:00 | SPY | ETF | 547.96 | 548.98 | 547.83 | 548.97 | 6231006.0 |
| 2024-07-02 16:00:00 | SPY | ETF | 548.97 | 549.01 | 548.3 | 548.4 | 2532748.0 |
| 2024-07-02 16:30:00 | SPY | ETF | 548.4 | 549.01 | 548.12 | 548.29 | 161744.0 |
| 2024-07-02 17:00:00 | SPY | ETF | 548.33 | 548.8246 | 548.2535 | 548.37 | 195577.0 |
| 2024-07-02 17:30:00 | SPY | ETF | 548.37 | 548.4 | 548.17 | 548.37 | 29696.0 |
| 2024-07-02 18:00:00 | SPY | ETF | 548.26 | 548.5 | 548.19 | 548.45 | 25789.0 |
| 2024-07-02 18:30:00 | SPY | ETF | 548.471 | 548.6 | 548.47 | 548.56 | 16166.0 |
| 2024-07-02 19:00:00 | SPY | ETF | 548.511 | 548.82 | 548.28 | 548.3 | 17301.0 |
| 2024-07-02 19:30:00 | SPY | ETF | 548.28 | 548.31 | 548.17 | 548.2599 | 16546.0 |
| 2024-07-02 04:00:00 | QQQ | ETF | 480.0 | 480.22 | 479.47 | 479.6 | 20049.0 |
| 2024-07-02 04:30:00 | QQQ | ETF | 479.48 | 479.96 | 479.46 | 479.91 | 8879.0 |
| 2024-07-02 05:00:00 | QQQ | ETF | 479.99 | 480.07 | 479.48 | 479.72 | 10095.0 |
| 2024-07-02 05:30:00 | QQQ | ETF | 479.73 | 479.91 | 479.53 | 479.9 | 12083.0 |
| 2024-07-02 06:00:00 | QQQ | ETF | 479.8 | 479.93 | 479.54 | 479.76 | 9616.0 |
| 2024-07-02 06:30:00 | QQQ | ETF | 479.71 | 479.99 | 479.59 | 479.95 | 20515.0 |
| 2024-07-02 07:00:00 | QQQ | ETF | 479.97 | 479.97 | 479.03 | 479.27 | 58330.0 |
| 2024-07-02 07:30:00 | QQQ | ETF | 479.23 | 479.42 | 478.74 | 479.22 | 99539.0 |
| 2024-07-02 08:00:00 | QQQ | ETF | 479.32 | 482.281 | 478.83 | 479.71 | 74805.0 |
| 2024-07-02 08:30:00 | QQQ | ETF | 479.72 | 479.86 | 479.24 | 479.56 | 49590.0 |
| 2024-07-02 09:00:00 | QQQ | ETF | 479.53 | 480.5 | 479.53 | 480.46 | 161924.0 |
| 2024-07-02 09:30:00 | QQQ | ETF | 480.41 | 483.18 | 480.28 | 482.33 | 2510964.0 |
| 2024-07-02 10:00:00 | QQQ | ETF | 482.36 | 482.99 | 481.28 | 482.24 | 1230221.0 |
| 2024-07-02 10:30:00 | QQQ | ETF | 482.26 | 483.78 | 482.23 | 483.4597 | 1308039.0 |
| 2024-07-02 11:00:00 | QQQ | ETF | 483.47 | 483.93 | 482.85 | 483.81 | 1044635.0 |
| 2024-07-02 11:30:00 | QQQ | ETF | 483.83 | 484.53 | 482.96 | 483.08 | 1096615.0 |
| 2024-07-02 12:00:00 | QQQ | ETF | 483.02 | 483.43 | 482.38 | 483.3401 | 859255.0 |
| 2024-07-02 12:30:00 | QQQ | ETF | 483.34 | 483.88 | 483.19 | 483.87 | 441536.0 |
> showing 50 of 32,771 rows — these rows as CSV