PREVIEW / etf_1hour / 2024-05-29
file: by_date/etf_1hour/2024/2024-05-29.parquet size: 539 KB rows: 20,180
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-05-29 04:00:00 | SPY | ETF | 527.7 | 529.0 | 526.7 | 527.15 | 123738.0 |
| 2024-05-29 05:00:00 | SPY | ETF | 527.17 | 527.17 | 526.42 | 526.79 | 10376.0 |
| 2024-05-29 06:00:00 | SPY | ETF | 526.71 | 527.03 | 526.6 | 526.7 | 122321.0 |
| 2024-05-29 07:00:00 | SPY | ETF | 526.7 | 527.05 | 526.3 | 526.78 | 207721.0 |
| 2024-05-29 08:00:00 | SPY | ETF | 526.75 | 528.42 | 525.93 | 526.0 | 262367.0 |
| 2024-05-29 09:00:00 | SPY | ETF | 526.01 | 526.42 | 525.37 | 526.205 | 4062132.0 |
| 2024-05-29 10:00:00 | SPY | ETF | 526.19 | 527.305 | 525.86 | 527.03 | 4039196.0 |
| 2024-05-29 11:00:00 | SPY | ETF | 527.02 | 527.07 | 526.03 | 526.6 | 2574275.0 |
| 2024-05-29 12:00:00 | SPY | ETF | 526.61 | 527.31 | 525.98 | 527.0999 | 3330103.0 |
| 2024-05-29 13:00:00 | SPY | ETF | 527.1 | 527.2 | 526.17 | 527.01 | 3114997.0 |
| 2024-05-29 14:00:00 | SPY | ETF | 527.03 | 527.14 | 526.05 | 526.165 | 2942349.0 |
| 2024-05-29 15:00:00 | SPY | ETF | 526.165 | 527.19 | 525.56 | 526.11 | 7479949.0 |
| 2024-05-29 16:00:00 | SPY | ETF | 526.11 | 526.29 | 524.3 | 524.45 | 3147547.0 |
| 2024-05-29 17:00:00 | SPY | ETF | 524.44 | 524.544 | 524.23 | 524.49 | 137173.0 |
| 2024-05-29 18:00:00 | SPY | ETF | 524.39 | 524.75 | 524.02 | 524.16 | 108829.0 |
| 2024-05-29 19:00:00 | SPY | ETF | 524.15 | 524.22 | 523.77 | 524.12 | 55086.0 |
| 2024-05-29 04:00:00 | QQQ | ETF | 457.6 | 458.11 | 456.36 | 456.96 | 52564.0 |
| 2024-05-29 05:00:00 | QQQ | ETF | 456.89 | 456.91 | 456.27 | 456.71 | 42857.0 |
| 2024-05-29 06:00:00 | QQQ | ETF | 456.7 | 457.08 | 456.54 | 456.64 | 42316.0 |
| 2024-05-29 07:00:00 | QQQ | ETF | 456.56 | 456.95 | 456.23 | 456.76 | 142627.0 |
| 2024-05-29 08:00:00 | QQQ | ETF | 456.43 | 458.45 | 455.66 | 455.84 | 232990.0 |
| 2024-05-29 09:00:00 | QQQ | ETF | 455.84 | 457.5 | 455.25 | 457.03 | 3326273.0 |
| 2024-05-29 10:00:00 | QQQ | ETF | 457.04 | 458.24 | 456.56 | 457.97 | 2414286.0 |
| 2024-05-29 11:00:00 | QQQ | ETF | 457.95 | 458.12 | 456.88 | 457.5299 | 1706426.0 |
| 2024-05-29 12:00:00 | QQQ | ETF | 457.505 | 458.18 | 456.84 | 458.03 | 1668386.0 |
| 2024-05-29 13:00:00 | QQQ | ETF | 458.03 | 458.08 | 456.7 | 457.73 | 2013817.0 |
| 2024-05-29 14:00:00 | QQQ | ETF | 457.74 | 457.88 | 456.66 | 456.93 | 1254531.0 |
| 2024-05-29 15:00:00 | QQQ | ETF | 456.91 | 457.81 | 455.921 | 456.53 | 4469338.0 |
| 2024-05-29 16:00:00 | QQQ | ETF | 456.53 | 456.62 | 454.82 | 455.02 | 2063935.0 |
| 2024-05-29 17:00:00 | QQQ | ETF | 455.04 | 455.3 | 454.9 | 455.18 | 90593.0 |
| 2024-05-29 18:00:00 | QQQ | ETF | 455.18 | 456.44 | 454.4 | 454.47 | 121638.0 |
| 2024-05-29 19:00:00 | QQQ | ETF | 454.5 | 454.53 | 454.06 | 454.46 | 92899.0 |
| 2024-05-29 04:00:00 | IWM | ETF | 203.72 | 204.02 | 203.58 | 203.75 | 28106.0 |
| 2024-05-29 05:00:00 | IWM | ETF | 203.76 | 203.76 | 202.94 | 203.05 | 157096.0 |
| 2024-05-29 06:00:00 | IWM | ETF | 203.02 | 203.26 | 202.99 | 203.11 | 55948.0 |
| 2024-05-29 07:00:00 | IWM | ETF | 203.11 | 203.41 | 202.9 | 203.11 | 85023.0 |
| 2024-05-29 08:00:00 | IWM | ETF | 203.0 | 204.28 | 202.51 | 202.53 | 168081.0 |
| 2024-05-29 09:00:00 | IWM | ETF | 202.53 | 202.715 | 201.78 | 202.65 | 3443695.0 |
| 2024-05-29 10:00:00 | IWM | ETF | 202.66 | 203.005 | 202.3 | 202.6 | 2403648.0 |
| 2024-05-29 11:00:00 | IWM | ETF | 202.59 | 202.77 | 202.2895 | 202.46 | 1252658.0 |
| 2024-05-29 12:00:00 | IWM | ETF | 202.46 | 202.775 | 202.21 | 202.66 | 1372755.0 |
| 2024-05-29 13:00:00 | IWM | ETF | 202.67 | 202.7 | 202.1 | 202.52 | 2196621.0 |
| 2024-05-29 14:00:00 | IWM | ETF | 202.51 | 202.55 | 201.92 | 202.04 | 1533431.0 |
| 2024-05-29 15:00:00 | IWM | ETF | 202.04 | 202.5 | 201.98 | 202.17 | 5046376.0 |
| 2024-05-29 16:00:00 | IWM | ETF | 202.13 | 205.1536 | 201.97 | 202.08 | 1265279.0 |
| 2024-05-29 17:00:00 | IWM | ETF | 202.05 | 202.05 | 201.76 | 201.92 | 66786.0 |
| 2024-05-29 18:00:00 | IWM | ETF | 202.01 | 202.17 | 201.81 | 201.9 | 23495.0 |
| 2024-05-29 19:00:00 | IWM | ETF | 201.93 | 201.93 | 201.67 | 201.78 | 19915.0 |
| 2024-05-29 04:00:00 | DIA | ETF | 387.02 | 387.02 | 386.69 | 386.98 | 900.0 |
| 2024-05-29 05:00:00 | DIA | ETF | 386.8 | 386.81 | 386.55 | 386.55 | 500.0 |
> showing 50 of 20,180 rows — these rows as CSV