PREVIEW / etf_30min / 2024-08-15
file: by_date/etf_30min/2024/2024-08-15.parquet size: 828 KB rows: 33,275
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-08-15 04:00:00 | SPY | ETF | 545.37 | 545.44 | 544.61 | 544.61 | 14533.0 |
| 2024-08-15 04:30:00 | SPY | ETF | 544.4 | 544.73 | 544.11 | 544.64 | 4034.0 |
| 2024-08-15 05:00:00 | SPY | ETF | 544.82 | 544.86 | 544.7 | 544.86 | 6957.0 |
| 2024-08-15 05:30:00 | SPY | ETF | 544.9 | 544.95 | 544.69 | 544.91 | 1838.0 |
| 2024-08-15 06:00:00 | SPY | ETF | 544.99 | 545.05 | 544.38 | 544.4 | 7416.0 |
| 2024-08-15 06:30:00 | SPY | ETF | 544.3 | 544.45 | 543.94 | 543.95 | 15499.0 |
| 2024-08-15 07:00:00 | SPY | ETF | 543.92 | 545.17 | 543.5 | 545.16 | 167552.0 |
| 2024-08-15 07:30:00 | SPY | ETF | 545.16 | 545.38 | 545.07 | 545.21 | 55515.0 |
| 2024-08-15 08:00:00 | SPY | ETF | 544.3 | 545.5 | 543.69 | 545.12 | 99201.0 |
| 2024-08-15 08:30:00 | SPY | ETF | 545.5 | 549.71 | 545.07 | 549.045 | 1251354.0 |
| 2024-08-15 09:00:00 | SPY | ETF | 549.07 | 549.59 | 548.6 | 549.51 | 471218.0 |
| 2024-08-15 09:30:00 | SPY | ETF | 549.5 | 550.29 | 548.95 | 550.17 | 5525294.0 |
| 2024-08-15 10:00:00 | SPY | ETF | 550.17 | 550.67 | 548.88 | 550.4 | 3523443.0 |
| 2024-08-15 10:30:00 | SPY | ETF | 550.4 | 551.25 | 550.36 | 550.9331 | 2882099.0 |
| 2024-08-15 11:00:00 | SPY | ETF | 550.92 | 551.89 | 550.7882 | 551.385 | 2146059.0 |
| 2024-08-15 11:30:00 | SPY | ETF | 551.39 | 552.13 | 551.28 | 551.61 | 1614303.0 |
| 2024-08-15 12:00:00 | SPY | ETF | 551.61 | 552.71 | 551.58 | 552.58 | 1876502.0 |
| 2024-08-15 12:30:00 | SPY | ETF | 552.58 | 552.62 | 551.261 | 551.93 | 1785289.0 |
| 2024-08-15 13:00:00 | SPY | ETF | 551.94 | 552.3 | 551.445 | 552.05 | 1269998.0 |
| 2024-08-15 13:30:00 | SPY | ETF | 552.04 | 552.68 | 552.03 | 552.645 | 1213757.0 |
| 2024-08-15 14:00:00 | SPY | ETF | 552.65 | 552.92 | 552.45 | 552.8 | 1584934.0 |
| 2024-08-15 14:30:00 | SPY | ETF | 552.81 | 553.09 | 552.63 | 552.92 | 1680989.0 |
| 2024-08-15 15:00:00 | SPY | ETF | 552.92 | 553.18 | 552.45 | 553.07 | 2406028.0 |
| 2024-08-15 15:30:00 | SPY | ETF | 553.07 | 553.36 | 551.91 | 553.0678 | 11403411.0 |
| 2024-08-15 16:00:00 | SPY | ETF | 553.07 | 553.24 | 552.5 | 553.19 | 3804329.0 |
| 2024-08-15 16:30:00 | SPY | ETF | 553.17 | 553.2 | 552.7 | 552.85 | 170849.0 |
| 2024-08-15 17:00:00 | SPY | ETF | 552.8 | 553.07 | 552.78 | 552.96 | 49423.0 |
| 2024-08-15 17:30:00 | SPY | ETF | 552.87 | 553.02 | 552.87 | 552.95 | 12594.0 |
| 2024-08-15 18:00:00 | SPY | ETF | 552.96 | 553.44 | 552.82 | 553.401 | 60048.0 |
| 2024-08-15 18:30:00 | SPY | ETF | 553.39 | 553.74 | 553.32 | 553.5 | 21871.0 |
| 2024-08-15 19:00:00 | SPY | ETF | 553.55 | 554.0 | 553.52 | 553.9 | 37438.0 |
| 2024-08-15 19:30:00 | SPY | ETF | 553.87 | 553.87 | 553.45 | 553.55 | 30937.0 |
| 2024-08-15 04:00:00 | QQQ | ETF | 465.03 | 465.03 | 463.83 | 463.83 | 15626.0 |
| 2024-08-15 04:30:00 | QQQ | ETF | 463.83 | 464.05 | 463.31 | 463.82 | 10354.0 |
| 2024-08-15 05:00:00 | QQQ | ETF | 463.97 | 464.22 | 463.91 | 464.14 | 16210.0 |
| 2024-08-15 05:30:00 | QQQ | ETF | 464.25 | 464.36 | 464.04 | 464.28 | 8493.0 |
| 2024-08-15 06:00:00 | QQQ | ETF | 464.4 | 464.4 | 463.51 | 463.58 | 5932.0 |
| 2024-08-15 06:30:00 | QQQ | ETF | 463.5 | 463.87 | 463.02 | 463.02 | 39667.0 |
| 2024-08-15 07:00:00 | QQQ | ETF | 463.01 | 464.52 | 462.9 | 464.32 | 94478.0 |
| 2024-08-15 07:30:00 | QQQ | ETF | 464.35 | 464.7 | 464.12 | 464.22 | 60672.0 |
| 2024-08-15 08:00:00 | QQQ | ETF | 464.29 | 465.62 | 463.02 | 464.0 | 192958.0 |
| 2024-08-15 08:30:00 | QQQ | ETF | 464.0 | 469.15 | 464.0 | 468.42 | 997773.0 |
| 2024-08-15 09:00:00 | QQQ | ETF | 468.49 | 468.84 | 467.933 | 468.8 | 350761.0 |
| 2024-08-15 09:30:00 | QQQ | ETF | 468.76 | 471.4 | 468.38 | 471.38 | 4904467.0 |
| 2024-08-15 10:00:00 | QQQ | ETF | 471.37 | 472.03 | 470.03 | 471.71 | 3656923.0 |
| 2024-08-15 10:30:00 | QQQ | ETF | 471.74 | 472.69 | 471.51 | 471.865 | 2009806.0 |
| 2024-08-15 11:00:00 | QQQ | ETF | 471.83 | 472.97 | 471.635 | 472.34 | 1158189.0 |
| 2024-08-15 11:30:00 | QQQ | ETF | 472.38 | 473.4475 | 472.14 | 472.94 | 1524493.0 |
| 2024-08-15 12:00:00 | QQQ | ETF | 472.95 | 473.99 | 472.91 | 473.9099 | 1207344.0 |
| 2024-08-15 12:30:00 | QQQ | ETF | 473.91 | 473.96 | 472.63 | 473.225 | 1271872.0 |
> showing 50 of 33,275 rows — these rows as CSV