PREVIEW / etf_30min / 2024-02-13
file: by_date/etf_30min/2024/2024-02-13.parquet size: 835 KB rows: 33,063
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-02-13 04:00:00 | SPY | ETF | 499.54 | 499.8 | 499.39 | 499.63 | 10362.0 |
| 2024-02-13 04:30:00 | SPY | ETF | 499.44 | 499.49 | 499.28 | 499.46 | 7729.0 |
| 2024-02-13 05:00:00 | SPY | ETF | 499.42 | 499.5 | 499.06 | 499.27 | 14824.0 |
| 2024-02-13 05:30:00 | SPY | ETF | 499.27 | 499.46 | 498.95 | 499.17 | 4621.0 |
| 2024-02-13 06:00:00 | SPY | ETF | 499.2 | 499.45 | 499.17 | 499.28 | 105981.0 |
| 2024-02-13 06:30:00 | SPY | ETF | 499.3 | 499.3 | 499.02 | 499.02 | 29805.0 |
| 2024-02-13 07:00:00 | SPY | ETF | 499.06 | 499.14 | 498.71 | 498.98 | 62578.0 |
| 2024-02-13 07:30:00 | SPY | ETF | 498.89 | 499.28 | 498.85 | 499.14 | 74239.0 |
| 2024-02-13 08:00:00 | SPY | ETF | 499.1296 | 500.93 | 498.71 | 499.28 | 193621.0 |
| 2024-02-13 08:30:00 | SPY | ETF | 499.5 | 499.62 | 494.59 | 494.78 | 2369649.0 |
| 2024-02-13 09:00:00 | SPY | ETF | 494.86 | 494.86 | 493.8 | 494.51 | 813348.0 |
| 2024-02-13 09:30:00 | SPY | ETF | 494.51 | 495.19 | 493.62 | 493.825 | 9668922.0 |
| 2024-02-13 10:00:00 | SPY | ETF | 493.825 | 494.89 | 493.22 | 494.89 | 6558893.0 |
| 2024-02-13 10:30:00 | SPY | ETF | 494.895 | 495.32 | 494.5194 | 494.56 | 5517181.0 |
| 2024-02-13 11:00:00 | SPY | ETF | 494.57 | 495.74 | 494.56 | 495.5701 | 3618280.0 |
| 2024-02-13 11:30:00 | SPY | ETF | 495.57 | 495.85 | 494.97 | 495.0899 | 2884837.0 |
| 2024-02-13 12:00:00 | SPY | ETF | 495.08 | 495.1501 | 494.4 | 494.52 | 2662585.0 |
| 2024-02-13 12:30:00 | SPY | ETF | 494.52 | 495.31 | 494.15 | 494.33 | 2500551.0 |
| 2024-02-13 13:00:00 | SPY | ETF | 494.32 | 494.4799 | 494.02 | 494.2301 | 2519980.0 |
| 2024-02-13 13:30:00 | SPY | ETF | 494.23 | 494.3 | 493.36 | 493.59 | 3238537.0 |
| 2024-02-13 14:00:00 | SPY | ETF | 493.585 | 493.59 | 491.79 | 492.11 | 5942363.0 |
| 2024-02-13 14:30:00 | SPY | ETF | 492.1 | 492.9477 | 491.09 | 491.4 | 5612793.0 |
| 2024-02-13 15:00:00 | SPY | ETF | 491.39 | 491.55 | 490.715 | 491.3301 | 5989895.0 |
| 2024-02-13 15:30:00 | SPY | ETF | 491.335 | 494.21 | 491.21 | 494.14 | 19480449.0 |
| 2024-02-13 16:00:00 | SPY | ETF | 494.14 | 494.27 | 490.98 | 494.06 | 7767321.0 |
| 2024-02-13 16:30:00 | SPY | ETF | 494.08 | 494.41 | 494.03 | 494.33 | 337861.0 |
| 2024-02-13 17:00:00 | SPY | ETF | 494.29 | 494.64 | 494.26 | 494.62 | 170962.0 |
| 2024-02-13 17:30:00 | SPY | ETF | 494.62 | 494.74 | 494.51 | 494.55 | 60918.0 |
| 2024-02-13 18:00:00 | SPY | ETF | 494.55 | 494.56 | 494.11 | 494.25 | 197260.0 |
| 2024-02-13 18:30:00 | SPY | ETF | 494.289 | 494.42 | 494.2 | 494.29 | 11064.0 |
| 2024-02-13 19:00:00 | SPY | ETF | 494.3 | 494.31 | 493.99 | 493.99 | 49065.0 |
| 2024-02-13 19:30:00 | SPY | ETF | 494.03 | 494.37 | 493.97 | 494.27 | 63584.0 |
| 2024-02-13 04:00:00 | QQQ | ETF | 433.65 | 434.0 | 433.46 | 433.7 | 34159.0 |
| 2024-02-13 04:30:00 | QQQ | ETF | 433.59 | 433.59 | 433.06 | 433.1 | 12278.0 |
| 2024-02-13 05:00:00 | QQQ | ETF | 433.11 | 433.2 | 432.63 | 432.81 | 61500.0 |
| 2024-02-13 05:30:00 | QQQ | ETF | 432.81 | 433.03 | 432.5 | 432.7 | 20024.0 |
| 2024-02-13 06:00:00 | QQQ | ETF | 432.69 | 432.82 | 432.5 | 432.78 | 34181.0 |
| 2024-02-13 06:30:00 | QQQ | ETF | 432.75 | 432.75 | 432.33 | 432.42 | 31110.0 |
| 2024-02-13 07:00:00 | QQQ | ETF | 432.43 | 432.51 | 431.63 | 432.14 | 99531.0 |
| 2024-02-13 07:30:00 | QQQ | ETF | 432.12 | 432.34 | 431.85 | 432.25 | 139621.0 |
| 2024-02-13 08:00:00 | QQQ | ETF | 435.01 | 435.3 | 431.6696 | 432.51 | 262445.0 |
| 2024-02-13 08:30:00 | QQQ | ETF | 432.8 | 433.05 | 427.54 | 428.1 | 2304589.0 |
| 2024-02-13 09:00:00 | QQQ | ETF | 428.01 | 428.05 | 426.97 | 427.26 | 795664.0 |
| 2024-02-13 09:30:00 | QQQ | ETF | 427.28 | 428.665 | 426.28 | 428.4206 | 7765311.0 |
| 2024-02-13 10:00:00 | QQQ | ETF | 428.415 | 430.07 | 427.38 | 430.06 | 3976742.0 |
| 2024-02-13 10:30:00 | QQQ | ETF | 430.065 | 431.27 | 429.67 | 429.69 | 4228783.0 |
| 2024-02-13 11:00:00 | QQQ | ETF | 429.7 | 430.91 | 429.7 | 430.32 | 2213731.0 |
| 2024-02-13 11:30:00 | QQQ | ETF | 430.32 | 430.69 | 429.43 | 429.57 | 2025008.0 |
| 2024-02-13 12:00:00 | QQQ | ETF | 429.56 | 429.65 | 428.7 | 428.83 | 1846362.0 |
| 2024-02-13 12:30:00 | QQQ | ETF | 428.85 | 429.73 | 428.18 | 428.41 | 1699831.0 |
> showing 50 of 33,063 rows — these rows as CSV