PREVIEW / etf_1hour / 2025-02-21
file: by_date/etf_1hour/2025/2025-02-21.parquet size: 631 KB rows: 24,145
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 |
|---|---|---|---|---|---|---|---|
| 2025-02-21 04:00:00 | SPY | ETF | 610.3 | 610.71 | 610.3 | 610.7 | 5507.0 |
| 2025-02-21 05:00:00 | SPY | ETF | 610.63 | 610.8 | 610.56 | 610.68 | 7698.0 |
| 2025-02-21 06:00:00 | SPY | ETF | 610.77 | 610.82 | 610.5 | 610.66 | 17401.0 |
| 2025-02-21 07:00:00 | SPY | ETF | 610.59 | 611.08 | 610.2 | 610.96 | 42878.0 |
| 2025-02-21 08:00:00 | SPY | ETF | 610.29 | 611.1 | 609.89 | 610.9699 | 162026.0 |
| 2025-02-21 09:00:00 | SPY | ETF | 610.9 | 611.17 | 608.24 | 608.4701 | 3026814.0 |
| 2025-02-21 10:00:00 | SPY | ETF | 608.5 | 608.65 | 605.766 | 606.8399 | 4870316.0 |
| 2025-02-21 11:00:00 | SPY | ETF | 606.84 | 607.5 | 606.18 | 606.805 | 2998935.0 |
| 2025-02-21 12:00:00 | SPY | ETF | 606.8 | 607.1292 | 603.62 | 603.82 | 3531002.0 |
| 2025-02-21 13:00:00 | SPY | ETF | 603.83 | 603.8493 | 601.57 | 601.7535 | 5799685.0 |
| 2025-02-21 14:00:00 | SPY | ETF | 601.76 | 602.33 | 599.47 | 600.035 | 5833159.0 |
| 2025-02-21 15:00:00 | SPY | ETF | 600.03 | 600.91 | 599.5 | 600.0 | 10204041.0 |
| 2025-02-21 16:00:00 | SPY | ETF | 600.0 | 600.4 | 599.75 | 599.94 | 4586561.0 |
| 2025-02-21 17:00:00 | SPY | ETF | 599.97 | 600.33 | 599.88 | 600.33 | 712232.0 |
| 2025-02-21 18:00:00 | SPY | ETF | 600.32 | 600.35 | 600.05 | 600.11 | 40598.0 |
| 2025-02-21 19:00:00 | SPY | ETF | 600.1 | 600.38 | 600.05 | 600.24 | 42923.0 |
| 2025-02-21 04:00:00 | QQQ | ETF | 537.49 | 537.95 | 537.33 | 537.92 | 20686.0 |
| 2025-02-21 05:00:00 | QQQ | ETF | 537.94 | 538.12 | 537.75 | 537.94 | 8645.0 |
| 2025-02-21 06:00:00 | QQQ | ETF | 538.0 | 538.04 | 537.62 | 537.84 | 9582.0 |
| 2025-02-21 07:00:00 | QQQ | ETF | 537.85 | 539.16 | 537.77 | 539.1 | 86795.0 |
| 2025-02-21 08:00:00 | QQQ | ETF | 537.97 | 540.0 | 536.69 | 539.33 | 224979.0 |
| 2025-02-21 09:00:00 | QQQ | ETF | 539.26 | 539.59 | 535.9 | 536.19 | 2461936.0 |
| 2025-02-21 10:00:00 | QQQ | ETF | 536.18 | 536.54 | 532.47 | 534.049 | 3949678.0 |
| 2025-02-21 11:00:00 | QQQ | ETF | 534.03 | 534.57 | 532.93 | 533.37 | 2123033.0 |
| 2025-02-21 12:00:00 | QQQ | ETF | 533.35 | 533.83 | 529.92 | 530.28 | 3061163.0 |
| 2025-02-21 13:00:00 | QQQ | ETF | 530.27 | 530.3 | 528.09 | 528.325 | 3881544.0 |
| 2025-02-21 14:00:00 | QQQ | ETF | 528.32 | 528.61 | 525.81 | 526.3 | 4209038.0 |
| 2025-02-21 15:00:00 | QQQ | ETF | 526.26 | 527.06 | 525.71 | 526.1 | 5535094.0 |
| 2025-02-21 16:00:00 | QQQ | ETF | 526.12 | 526.5 | 525.5 | 525.6 | 3692243.0 |
| 2025-02-21 17:00:00 | QQQ | ETF | 525.6 | 526.44 | 525.57 | 526.36 | 107225.0 |
| 2025-02-21 18:00:00 | QQQ | ETF | 526.36 | 526.36 | 526.05 | 526.14 | 39961.0 |
| 2025-02-21 19:00:00 | QQQ | ETF | 526.07 | 526.12 | 525.88 | 525.979 | 36125.0 |
| 2025-02-21 04:00:00 | IWM | ETF | 224.62 | 224.62 | 224.1 | 224.51 | 31003.0 |
| 2025-02-21 05:00:00 | IWM | ETF | 224.53 | 225.03 | 224.49 | 225.03 | 10238.0 |
| 2025-02-21 06:00:00 | IWM | ETF | 225.11 | 225.18 | 224.83 | 224.83 | 23674.0 |
| 2025-02-21 07:00:00 | IWM | ETF | 224.84 | 225.07 | 224.61 | 225.07 | 23967.0 |
| 2025-02-21 08:00:00 | IWM | ETF | 224.7203 | 225.87 | 224.21 | 225.86 | 190268.0 |
| 2025-02-21 09:00:00 | IWM | ETF | 225.85 | 226.23 | 223.63 | 223.73 | 2210962.0 |
| 2025-02-21 10:00:00 | IWM | ETF | 223.71 | 223.77 | 221.34 | 221.55 | 3452764.0 |
| 2025-02-21 11:00:00 | IWM | ETF | 221.555 | 222.15 | 221.17 | 221.41 | 2488793.0 |
| 2025-02-21 12:00:00 | IWM | ETF | 221.41 | 221.52 | 219.42 | 219.555 | 2605688.0 |
| 2025-02-21 13:00:00 | IWM | ETF | 219.53 | 219.62 | 218.215 | 218.235 | 5350579.0 |
| 2025-02-21 14:00:00 | IWM | ETF | 218.24 | 218.855 | 217.48 | 217.95 | 4533819.0 |
| 2025-02-21 15:00:00 | IWM | ETF | 217.94 | 218.78 | 217.46 | 217.74 | 7076420.0 |
| 2025-02-21 16:00:00 | IWM | ETF | 217.74 | 218.0 | 217.55 | 217.79 | 3176486.0 |
| 2025-02-21 17:00:00 | IWM | ETF | 217.79 | 218.13 | 217.74 | 218.03 | 104932.0 |
| 2025-02-21 18:00:00 | IWM | ETF | 218.04 | 218.05 | 217.8 | 217.81 | 7566.0 |
| 2025-02-21 19:00:00 | IWM | ETF | 217.7501 | 217.89 | 217.45 | 217.68 | 24031.0 |
| 2025-02-21 04:00:00 | DIA | ETF | 442.01 | 442.02 | 442.0 | 442.0 | 800.0 |
| 2025-02-21 05:00:00 | DIA | ETF | 442.26 | 442.42 | 442.26 | 442.42 | 800.0 |
> showing 50 of 24,145 rows — these rows as CSV