PREVIEW / etf_1hour / 2024-10-04
file: by_date/etf_1hour/2024/2024-10-04.parquet size: 575 KB rows: 21,521
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-10-04 04:00:00 | SPY | ETF | 568.73 | 568.93 | 568.15 | 568.21 | 12095.0 |
| 2024-10-04 05:00:00 | SPY | ETF | 568.23 | 568.9 | 568.13 | 568.9 | 11918.0 |
| 2024-10-04 06:00:00 | SPY | ETF | 569.12 | 569.65 | 569.1 | 569.16 | 22515.0 |
| 2024-10-04 07:00:00 | SPY | ETF | 569.15 | 569.84 | 569.02 | 569.6 | 118804.0 |
| 2024-10-04 08:00:00 | SPY | ETF | 569.42 | 573.01 | 567.55 | 572.91 | 1898315.0 |
| 2024-10-04 09:00:00 | SPY | ETF | 572.91 | 573.24 | 569.89 | 570.11 | 5293327.0 |
| 2024-10-04 10:00:00 | SPY | ETF | 570.14 | 571.16 | 568.1 | 570.05 | 5476674.0 |
| 2024-10-04 11:00:00 | SPY | ETF | 570.035 | 570.73 | 568.28 | 570.47 | 3231450.0 |
| 2024-10-04 12:00:00 | SPY | ETF | 570.47 | 571.51 | 569.43 | 571.05 | 3085822.0 |
| 2024-10-04 13:00:00 | SPY | ETF | 571.015 | 571.57 | 569.58 | 570.2387 | 2573710.0 |
| 2024-10-04 14:00:00 | SPY | ETF | 570.22 | 571.56 | 569.7 | 571.5 | 2406349.0 |
| 2024-10-04 15:00:00 | SPY | ETF | 571.49 | 573.36 | 571.15 | 572.91 | 6552443.0 |
| 2024-10-04 16:00:00 | SPY | ETF | 572.9 | 573.03 | 572.42 | 572.48 | 2221847.0 |
| 2024-10-04 17:00:00 | SPY | ETF | 572.58 | 572.98 | 572.5 | 572.6 | 58723.0 |
| 2024-10-04 18:00:00 | SPY | ETF | 572.58 | 572.65 | 572.29 | 572.33 | 34520.0 |
| 2024-10-04 19:00:00 | SPY | ETF | 572.4 | 572.55 | 572.3 | 572.31 | 18092.0 |
| 2024-10-04 04:00:00 | QQQ | ETF | 482.87 | 483.1 | 482.07 | 482.19 | 32721.0 |
| 2024-10-04 05:00:00 | QQQ | ETF | 482.15 | 483.06 | 482.06 | 483.06 | 17096.0 |
| 2024-10-04 06:00:00 | QQQ | ETF | 483.15 | 483.87 | 483.09 | 483.31 | 51739.0 |
| 2024-10-04 07:00:00 | QQQ | ETF | 483.28 | 484.1 | 483.14 | 483.65 | 92736.0 |
| 2024-10-04 08:00:00 | QQQ | ETF | 483.2 | 487.95 | 481.229 | 487.94 | 1061490.0 |
| 2024-10-04 09:00:00 | QQQ | ETF | 487.97 | 488.35 | 483.79 | 484.09 | 4265857.0 |
| 2024-10-04 10:00:00 | QQQ | ETF | 484.09 | 485.16 | 482.385 | 485.09 | 4568226.0 |
| 2024-10-04 11:00:00 | QQQ | ETF | 485.05 | 485.85 | 482.88 | 485.38 | 2762951.0 |
| 2024-10-04 12:00:00 | QQQ | ETF | 485.39 | 486.34 | 484.0 | 485.67 | 1876175.0 |
| 2024-10-04 13:00:00 | QQQ | ETF | 485.67 | 486.08 | 484.02 | 484.78 | 1671557.0 |
| 2024-10-04 14:00:00 | QQQ | ETF | 484.82 | 486.1 | 484.29 | 486.09 | 1397856.0 |
| 2024-10-04 15:00:00 | QQQ | ETF | 486.08 | 487.88 | 485.71 | 487.49 | 4260114.0 |
| 2024-10-04 16:00:00 | QQQ | ETF | 487.47 | 487.6 | 486.77 | 486.84 | 1261167.0 |
| 2024-10-04 17:00:00 | QQQ | ETF | 486.85 | 487.32 | 486.8 | 487.1 | 179788.0 |
| 2024-10-04 18:00:00 | QQQ | ETF | 487.1 | 487.15 | 486.8519 | 486.94 | 29915.0 |
| 2024-10-04 19:00:00 | QQQ | ETF | 487.04 | 487.04 | 486.9001 | 486.9001 | 13811.0 |
| 2024-10-04 04:00:00 | IWM | ETF | 216.9 | 216.95 | 216.6 | 216.76 | 10887.0 |
| 2024-10-04 05:00:00 | IWM | ETF | 216.54 | 216.96 | 216.54 | 216.96 | 5743.0 |
| 2024-10-04 06:00:00 | IWM | ETF | 217.07 | 217.15 | 216.92 | 216.97 | 14737.0 |
| 2024-10-04 07:00:00 | IWM | ETF | 216.91 | 217.44 | 216.91 | 217.26 | 104981.0 |
| 2024-10-04 08:00:00 | IWM | ETF | 217.1004 | 220.31 | 216.25 | 219.52 | 2388469.0 |
| 2024-10-04 09:00:00 | IWM | ETF | 219.57 | 220.25 | 218.05 | 218.68 | 4212479.0 |
| 2024-10-04 10:00:00 | IWM | ETF | 218.67 | 219.28 | 217.29 | 218.84 | 3731780.0 |
| 2024-10-04 11:00:00 | IWM | ETF | 218.815 | 219.16 | 217.69 | 218.7 | 1903451.0 |
| 2024-10-04 12:00:00 | IWM | ETF | 218.7 | 219.36 | 218.4801 | 219.235 | 2021096.0 |
| 2024-10-04 13:00:00 | IWM | ETF | 219.24 | 219.35 | 218.3 | 218.35 | 1256879.0 |
| 2024-10-04 14:00:00 | IWM | ETF | 218.36 | 219.04 | 218.24 | 219.025 | 1372792.0 |
| 2024-10-04 15:00:00 | IWM | ETF | 219.02 | 219.34 | 218.71 | 219.19 | 3256698.0 |
| 2024-10-04 16:00:00 | IWM | ETF | 219.15 | 219.27 | 219.05 | 219.08 | 1115600.0 |
| 2024-10-04 17:00:00 | IWM | ETF | 219.1 | 219.25 | 219.01 | 219.16 | 16939.0 |
| 2024-10-04 18:00:00 | IWM | ETF | 219.14 | 219.23 | 219.01 | 219.03 | 2446.0 |
| 2024-10-04 19:00:00 | IWM | ETF | 219.1 | 219.19 | 219.04 | 219.0999 | 4301.0 |
| 2024-10-04 04:00:00 | DIA | ETF | 420.16 | 420.16 | 420.16 | 420.16 | 100.0 |
| 2024-10-04 05:00:00 | DIA | ETF | 419.78 | 420.03 | 419.78 | 420.03 | 200.0 |
> showing 50 of 21,521 rows — these rows as CSV