PREVIEW / etf_1hour / 2024-07-30
file: by_date/etf_1hour/2024/2024-07-30.parquet size: 544 KB rows: 20,499
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-30 04:00:00 | SPY | ETF | 545.05 | 545.94 | 545.05 | 545.79 | 12292.0 |
| 2024-07-30 05:00:00 | SPY | ETF | 545.71 | 545.99 | 545.18 | 545.71 | 4519.0 |
| 2024-07-30 06:00:00 | SPY | ETF | 545.65 | 546.11 | 545.53 | 545.88 | 18606.0 |
| 2024-07-30 07:00:00 | SPY | ETF | 545.88 | 546.18 | 545.36 | 545.83 | 253782.0 |
| 2024-07-30 08:00:00 | SPY | ETF | 546.0 | 546.13 | 544.0 | 545.8 | 148369.0 |
| 2024-07-30 09:00:00 | SPY | ETF | 545.86 | 547.34 | 545.74 | 546.25 | 3906371.0 |
| 2024-07-30 10:00:00 | SPY | ETF | 546.24 | 546.43 | 543.68 | 543.85 | 3652189.0 |
| 2024-07-30 11:00:00 | SPY | ETF | 543.84 | 543.99 | 540.44 | 540.53 | 5269174.0 |
| 2024-07-30 12:00:00 | SPY | ETF | 540.54 | 541.27 | 538.79 | 538.835 | 3391604.0 |
| 2024-07-30 13:00:00 | SPY | ETF | 538.87 | 541.51 | 538.515 | 541.32 | 3078453.0 |
| 2024-07-30 14:00:00 | SPY | ETF | 541.31 | 542.66 | 540.98 | 541.45 | 2952491.0 |
| 2024-07-30 15:00:00 | SPY | ETF | 541.44 | 543.655 | 540.77 | 541.91 | 7860345.0 |
| 2024-07-30 16:00:00 | SPY | ETF | 541.92 | 542.38 | 537.97 | 540.03 | 3286786.0 |
| 2024-07-30 17:00:00 | SPY | ETF | 539.88 | 540.55 | 539.0 | 540.0 | 188721.0 |
| 2024-07-30 18:00:00 | SPY | ETF | 540.16 | 542.04 | 539.94 | 541.35 | 204297.0 |
| 2024-07-30 19:00:00 | SPY | ETF | 541.31 | 542.82 | 541.31 | 542.72 | 242613.0 |
| 2024-07-30 04:00:00 | QQQ | ETF | 464.02 | 465.03 | 463.52 | 464.8 | 56744.0 |
| 2024-07-30 05:00:00 | QQQ | ETF | 464.88 | 465.27 | 463.89 | 464.39 | 40916.0 |
| 2024-07-30 06:00:00 | QQQ | ETF | 464.32 | 465.04 | 464.32 | 464.92 | 22302.0 |
| 2024-07-30 07:00:00 | QQQ | ETF | 464.96 | 465.59 | 464.84 | 465.24 | 68957.0 |
| 2024-07-30 08:00:00 | QQQ | ETF | 465.24 | 465.5993 | 462.47 | 465.3301 | 195394.0 |
| 2024-07-30 09:00:00 | QQQ | ETF | 465.42 | 466.561 | 463.86 | 464.31 | 2571827.0 |
| 2024-07-30 10:00:00 | QQQ | ETF | 464.33 | 464.77 | 461.27 | 461.465 | 3321490.0 |
| 2024-07-30 11:00:00 | QQQ | ETF | 461.42 | 461.675 | 457.12 | 457.2 | 4403387.0 |
| 2024-07-30 12:00:00 | QQQ | ETF | 457.21 | 458.25 | 454.37 | 454.48 | 2785293.0 |
| 2024-07-30 13:00:00 | QQQ | ETF | 454.48 | 457.7352 | 454.15 | 457.4 | 3378594.0 |
| 2024-07-30 14:00:00 | QQQ | ETF | 457.45 | 458.9 | 457.06 | 457.78 | 2669628.0 |
| 2024-07-30 15:00:00 | QQQ | ETF | 457.78 | 459.24 | 456.5501 | 457.38 | 5364445.0 |
| 2024-07-30 16:00:00 | QQQ | ETF | 457.39 | 457.74 | 452.31 | 455.57 | 4147731.0 |
| 2024-07-30 17:00:00 | QQQ | ETF | 455.47 | 456.34 | 454.9 | 455.1 | 215264.0 |
| 2024-07-30 18:00:00 | QQQ | ETF | 455.4 | 459.4 | 455.35 | 458.21 | 774485.0 |
| 2024-07-30 19:00:00 | QQQ | ETF | 458.3 | 460.51 | 458.2 | 460.42 | 290959.0 |
| 2024-07-30 04:00:00 | IWM | ETF | 222.0 | 222.5 | 221.88 | 222.46 | 21253.0 |
| 2024-07-30 05:00:00 | IWM | ETF | 222.44 | 222.59 | 221.98 | 222.12 | 8022.0 |
| 2024-07-30 06:00:00 | IWM | ETF | 222.25 | 222.75 | 222.15 | 222.57 | 31325.0 |
| 2024-07-30 07:00:00 | IWM | ETF | 222.53 | 222.65 | 222.21 | 222.21 | 54888.0 |
| 2024-07-30 08:00:00 | IWM | ETF | 222.49 | 222.75 | 220.99 | 222.42 | 80391.0 |
| 2024-07-30 09:00:00 | IWM | ETF | 222.45 | 224.46 | 222.45 | 223.5397 | 3231944.0 |
| 2024-07-30 10:00:00 | IWM | ETF | 223.52 | 223.53 | 222.05 | 222.23 | 3374684.0 |
| 2024-07-30 11:00:00 | IWM | ETF | 222.23 | 222.57 | 221.32 | 221.73 | 2939080.0 |
| 2024-07-30 12:00:00 | IWM | ETF | 221.72 | 222.38 | 221.19 | 221.3801 | 1962507.0 |
| 2024-07-30 13:00:00 | IWM | ETF | 221.4 | 222.19 | 221.11 | 221.995 | 2067932.0 |
| 2024-07-30 14:00:00 | IWM | ETF | 221.99 | 222.61 | 221.77 | 222.055 | 2839907.0 |
| 2024-07-30 15:00:00 | IWM | ETF | 222.05 | 223.39 | 221.8 | 222.53 | 3710773.0 |
| 2024-07-30 16:00:00 | IWM | ETF | 222.57 | 222.8591 | 221.95 | 222.81 | 929637.0 |
| 2024-07-30 17:00:00 | IWM | ETF | 222.81 | 222.95 | 222.4 | 222.88 | 28993.0 |
| 2024-07-30 18:00:00 | IWM | ETF | 222.85 | 223.08 | 222.0 | 222.36 | 128978.0 |
| 2024-07-30 19:00:00 | IWM | ETF | 222.36 | 222.83 | 222.35 | 222.6505 | 60567.0 |
| 2024-07-30 04:00:00 | DIA | ETF | 406.08 | 406.08 | 405.65 | 405.65 | 200.0 |
| 2024-07-30 06:00:00 | DIA | ETF | 406.02 | 406.05 | 406.02 | 406.05 | 417.0 |
> showing 50 of 20,499 rows — these rows as CSV