PREVIEW / etf_1hour / 2024-02-01
file: by_date/etf_1hour/2024/2024-02-01.parquet size: 540 KB rows: 19,893
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-01 04:00:00 | SPY | ETF | 484.71 | 484.9 | 484.49 | 484.79 | 41101.0 |
| 2024-02-01 05:00:00 | SPY | ETF | 484.81 | 485.15 | 484.77 | 485.15 | 27389.0 |
| 2024-02-01 06:00:00 | SPY | ETF | 485.15 | 485.21 | 484.92 | 485.2 | 83270.0 |
| 2024-02-01 07:00:00 | SPY | ETF | 485.17 | 485.82 | 484.9 | 485.59 | 226734.0 |
| 2024-02-01 08:00:00 | SPY | ETF | 485.6 | 485.79 | 483.7 | 485.27 | 532040.0 |
| 2024-02-01 09:00:00 | SPY | ETF | 485.2 | 485.75 | 484.4 | 485.08 | 7657821.0 |
| 2024-02-01 10:00:00 | SPY | ETF | 485.01 | 486.21 | 484.08 | 484.09 | 11838851.0 |
| 2024-02-01 11:00:00 | SPY | ETF | 484.08 | 485.81 | 483.8 | 485.67 | 8116994.0 |
| 2024-02-01 12:00:00 | SPY | ETF | 485.715 | 488.24 | 485.67 | 487.4 | 9569055.0 |
| 2024-02-01 13:00:00 | SPY | ETF | 487.39 | 487.6 | 486.21 | 487.23 | 6525883.0 |
| 2024-02-01 14:00:00 | SPY | ETF | 487.25 | 488.5657 | 487.08 | 488.53 | 6856366.0 |
| 2024-02-01 15:00:00 | SPY | ETF | 488.54 | 489.23 | 488.1 | 489.23 | 12930225.0 |
| 2024-02-01 16:00:00 | SPY | ETF | 489.22 | 492.61 | 484.4437 | 492.16 | 5084263.0 |
| 2024-02-01 17:00:00 | SPY | ETF | 492.18 | 492.46 | 491.44 | 491.44 | 375754.0 |
| 2024-02-01 18:00:00 | SPY | ETF | 491.53 | 491.79 | 491.39 | 491.64 | 168666.0 |
| 2024-02-01 19:00:00 | SPY | ETF | 491.67 | 491.76 | 491.3 | 491.74 | 72410.0 |
| 2024-02-01 04:00:00 | QQQ | ETF | 419.12 | 419.98 | 419.12 | 419.38 | 80644.0 |
| 2024-02-01 05:00:00 | QQQ | ETF | 419.41 | 419.96 | 419.33 | 419.96 | 41086.0 |
| 2024-02-01 06:00:00 | QQQ | ETF | 419.84 | 420.0 | 419.33 | 419.57 | 66807.0 |
| 2024-02-01 07:00:00 | QQQ | ETF | 419.61 | 420.15 | 419.38 | 419.76 | 189631.0 |
| 2024-02-01 08:00:00 | QQQ | ETF | 419.6 | 420.18 | 417.93 | 419.53 | 705858.0 |
| 2024-02-01 09:00:00 | QQQ | ETF | 419.56 | 419.86 | 418.3399 | 418.82 | 4464542.0 |
| 2024-02-01 10:00:00 | QQQ | ETF | 418.73 | 420.39 | 417.84 | 418.05 | 5988659.0 |
| 2024-02-01 11:00:00 | QQQ | ETF | 418.035 | 419.49 | 417.81 | 419.24 | 3923881.0 |
| 2024-02-01 12:00:00 | QQQ | ETF | 419.25 | 421.3875 | 419.205 | 420.69 | 4527499.0 |
| 2024-02-01 13:00:00 | QQQ | ETF | 420.7 | 421.1 | 419.39 | 420.441 | 3585809.0 |
| 2024-02-01 14:00:00 | QQQ | ETF | 420.46 | 421.96 | 420.45 | 421.88 | 3654592.0 |
| 2024-02-01 15:00:00 | QQQ | ETF | 421.88 | 422.375 | 421.19 | 422.08 | 6030564.0 |
| 2024-02-01 16:00:00 | QQQ | ETF | 422.08 | 427.01 | 421.5 | 426.7 | 4560878.0 |
| 2024-02-01 17:00:00 | QQQ | ETF | 426.7 | 426.9 | 416.97 | 425.8 | 605490.0 |
| 2024-02-01 18:00:00 | QQQ | ETF | 425.65 | 426.07 | 425.49 | 425.75 | 222331.0 |
| 2024-02-01 19:00:00 | QQQ | ETF | 425.75 | 426.01 | 425.53 | 426.01 | 198608.0 |
| 2024-02-01 04:00:00 | IWM | ETF | 194.15 | 194.35 | 193.98 | 194.18 | 55674.0 |
| 2024-02-01 05:00:00 | IWM | ETF | 194.3 | 194.77 | 194.29 | 194.74 | 19518.0 |
| 2024-02-01 06:00:00 | IWM | ETF | 194.74 | 195.18 | 194.74 | 195.18 | 85462.0 |
| 2024-02-01 07:00:00 | IWM | ETF | 195.12 | 195.5 | 194.8 | 195.12 | 312233.0 |
| 2024-02-01 08:00:00 | IWM | ETF | 195.1 | 195.42 | 193.75 | 194.49 | 435242.0 |
| 2024-02-01 09:00:00 | IWM | ETF | 194.56 | 195.34 | 193.145 | 193.5 | 5641309.0 |
| 2024-02-01 10:00:00 | IWM | ETF | 193.45 | 194.22 | 191.72 | 191.73 | 8815363.0 |
| 2024-02-01 11:00:00 | IWM | ETF | 191.72 | 193.05 | 191.53 | 193.01 | 6325851.0 |
| 2024-02-01 12:00:00 | IWM | ETF | 193.01 | 195.085 | 192.99 | 194.65 | 7130386.0 |
| 2024-02-01 13:00:00 | IWM | ETF | 194.64 | 195.23 | 193.86 | 195.09 | 4599724.0 |
| 2024-02-01 14:00:00 | IWM | ETF | 195.1 | 195.615 | 194.555 | 195.44 | 4749401.0 |
| 2024-02-01 15:00:00 | IWM | ETF | 195.45 | 195.74 | 194.95 | 195.6 | 8323374.0 |
| 2024-02-01 16:00:00 | IWM | ETF | 195.44 | 195.9 | 194.95 | 195.43 | 2287765.0 |
| 2024-02-01 17:00:00 | IWM | ETF | 195.56 | 195.79 | 195.44 | 195.62 | 109929.0 |
| 2024-02-01 18:00:00 | IWM | ETF | 195.62 | 195.98 | 195.62 | 195.75 | 71541.0 |
| 2024-02-01 19:00:00 | IWM | ETF | 195.71 | 195.95 | 195.65 | 195.89 | 64820.0 |
| 2024-02-01 04:00:00 | DIA | ETF | 382.03 | 382.1 | 381.98 | 382.1 | 2587.0 |
| 2024-02-01 05:00:00 | DIA | ETF | 382.04 | 382.1 | 381.99 | 382.1 | 800.0 |
> showing 50 of 19,893 rows — these rows as CSV