PREVIEW / etf_1hour / 2024-09-11
file: by_date/etf_1hour/2024/2024-09-11.parquet size: 544 KB rows: 20,562
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-09-11 04:00:00 | SPY | ETF | 546.52 | 547.92 | 546.52 | 546.75 | 26634.0 |
| 2024-09-11 05:00:00 | SPY | ETF | 546.85 | 547.55 | 546.55 | 547.55 | 41376.0 |
| 2024-09-11 06:00:00 | SPY | ETF | 547.59 | 547.69 | 547.14 | 547.69 | 4893.0 |
| 2024-09-11 07:00:00 | SPY | ETF | 547.61 | 548.35 | 547.4 | 548.24 | 101525.0 |
| 2024-09-11 08:00:00 | SPY | ETF | 547.53 | 548.58 | 545.53 | 548.06 | 960190.0 |
| 2024-09-11 09:00:00 | SPY | ETF | 548.14 | 549.34 | 544.51 | 544.69 | 4563147.0 |
| 2024-09-11 10:00:00 | SPY | ETF | 544.69 | 544.78 | 539.96 | 541.16 | 8466870.0 |
| 2024-09-11 11:00:00 | SPY | ETF | 541.12 | 545.28 | 540.56 | 544.5 | 6589752.0 |
| 2024-09-11 12:00:00 | SPY | ETF | 544.48 | 547.55 | 544.27 | 547.3113 | 4818320.0 |
| 2024-09-11 13:00:00 | SPY | ETF | 547.34 | 550.82 | 547.34 | 550.0 | 5357707.0 |
| 2024-09-11 14:00:00 | SPY | ETF | 549.98 | 552.69 | 549.7 | 551.67 | 5792562.0 |
| 2024-09-11 15:00:00 | SPY | ETF | 551.65 | 555.36 | 551.24 | 554.36 | 11666311.0 |
| 2024-09-11 16:00:00 | SPY | ETF | 554.35 | 555.07 | 554.04 | 554.41 | 3392328.0 |
| 2024-09-11 17:00:00 | SPY | ETF | 554.49 | 554.5 | 554.27 | 554.38 | 47976.0 |
| 2024-09-11 18:00:00 | SPY | ETF | 554.42 | 554.43 | 554.2 | 554.36 | 45996.0 |
| 2024-09-11 19:00:00 | SPY | ETF | 554.39 | 554.43 | 554.2 | 554.31 | 43372.0 |
| 2024-09-11 04:00:00 | QQQ | ETF | 457.71 | 457.91 | 456.51 | 456.83 | 40765.0 |
| 2024-09-11 05:00:00 | QQQ | ETF | 456.9 | 457.65 | 456.67 | 457.59 | 24085.0 |
| 2024-09-11 06:00:00 | QQQ | ETF | 457.57 | 457.68 | 457.15 | 457.42 | 15234.0 |
| 2024-09-11 07:00:00 | QQQ | ETF | 457.44 | 458.35 | 457.25 | 458.18 | 212333.0 |
| 2024-09-11 08:00:00 | QQQ | ETF | 457.71 | 459.18 | 455.19 | 458.95 | 1202295.0 |
| 2024-09-11 09:00:00 | QQQ | ETF | 459.0118 | 460.52 | 456.76 | 457.21 | 4419073.0 |
| 2024-09-11 10:00:00 | QQQ | ETF | 457.21 | 457.77 | 451.28 | 452.67 | 6847413.0 |
| 2024-09-11 11:00:00 | QQQ | ETF | 452.65 | 457.83 | 451.81 | 457.115 | 5435697.0 |
| 2024-09-11 12:00:00 | QQQ | ETF | 457.15 | 460.74 | 456.99 | 460.06 | 4994196.0 |
| 2024-09-11 13:00:00 | QQQ | ETF | 460.08 | 463.9 | 459.99 | 463.175 | 3680261.0 |
| 2024-09-11 14:00:00 | QQQ | ETF | 463.12 | 466.59 | 463.0 | 465.325 | 7446057.0 |
| 2024-09-11 15:00:00 | QQQ | ETF | 465.32 | 469.37 | 464.63 | 468.45 | 7582326.0 |
| 2024-09-11 16:00:00 | QQQ | ETF | 468.43 | 469.39 | 467.81 | 468.25 | 2280673.0 |
| 2024-09-11 17:00:00 | QQQ | ETF | 468.31 | 468.32 | 467.8801 | 467.9 | 36270.0 |
| 2024-09-11 18:00:00 | QQQ | ETF | 467.94 | 468.3 | 467.8 | 468.19 | 45982.0 |
| 2024-09-11 19:00:00 | QQQ | ETF | 468.2 | 468.2896 | 467.97 | 468.2 | 99303.0 |
| 2024-09-11 04:00:00 | IWM | ETF | 207.38 | 207.42 | 206.96 | 207.04 | 17771.0 |
| 2024-09-11 05:00:00 | IWM | ETF | 207.0 | 207.39 | 207.0 | 207.36 | 8317.0 |
| 2024-09-11 06:00:00 | IWM | ETF | 207.4 | 207.86 | 207.2 | 207.83 | 13605.0 |
| 2024-09-11 07:00:00 | IWM | ETF | 207.86 | 208.65 | 207.75 | 208.55 | 30121.0 |
| 2024-09-11 08:00:00 | IWM | ETF | 207.85 | 211.0 | 205.48 | 207.37 | 1066542.0 |
| 2024-09-11 09:00:00 | IWM | ETF | 207.44 | 207.86 | 206.13 | 206.25 | 3046980.0 |
| 2024-09-11 10:00:00 | IWM | ETF | 206.24 | 206.46 | 204.21 | 205.03 | 3932310.0 |
| 2024-09-11 11:00:00 | IWM | ETF | 205.03 | 206.7 | 204.81 | 205.98 | 2472522.0 |
| 2024-09-11 12:00:00 | IWM | ETF | 205.99 | 207.54 | 205.92 | 207.34 | 1722841.0 |
| 2024-09-11 13:00:00 | IWM | ETF | 207.34 | 208.65 | 207.31 | 208.06 | 2252298.0 |
| 2024-09-11 14:00:00 | IWM | ETF | 208.07 | 209.1 | 207.79 | 208.44 | 1792946.0 |
| 2024-09-11 15:00:00 | IWM | ETF | 208.46 | 209.25 | 208.18 | 208.89 | 3608394.0 |
| 2024-09-11 16:00:00 | IWM | ETF | 208.92 | 209.07 | 208.68 | 208.95 | 1136029.0 |
| 2024-09-11 17:00:00 | IWM | ETF | 208.98 | 209.1 | 208.81 | 208.95 | 21674.0 |
| 2024-09-11 18:00:00 | IWM | ETF | 208.99 | 209.054 | 208.84 | 208.95 | 10356.0 |
| 2024-09-11 19:00:00 | IWM | ETF | 208.92 | 208.93 | 208.835 | 208.92 | 44595.0 |
| 2024-09-11 04:00:00 | DIA | ETF | 407.25 | 407.25 | 406.75 | 406.75 | 400.0 |
| 2024-09-11 05:00:00 | DIA | ETF | 406.56 | 406.75 | 406.56 | 406.75 | 200.0 |
> showing 50 of 20,562 rows — these rows as CSV