PREVIEW / etf_1hour / 2024-12-09
file: by_date/etf_1hour/2024/2024-12-09.parquet size: 618 KB rows: 23,126
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-12-09 04:00:00 | SPY | ETF | 608.5 | 608.5 | 607.62 | 607.68 | 16525.0 |
| 2024-12-09 05:00:00 | SPY | ETF | 607.68 | 607.74 | 607.4 | 607.54 | 15957.0 |
| 2024-12-09 06:00:00 | SPY | ETF | 607.7 | 607.7 | 607.0 | 607.44 | 26102.0 |
| 2024-12-09 07:00:00 | SPY | ETF | 607.57 | 607.92 | 607.5 | 607.74 | 35182.0 |
| 2024-12-09 08:00:00 | SPY | ETF | 607.5546 | 608.52 | 607.5005 | 607.72 | 85050.0 |
| 2024-12-09 09:00:00 | SPY | ETF | 607.67 | 607.94 | 607.2 | 607.46 | 2030203.0 |
| 2024-12-09 10:00:00 | SPY | ETF | 607.48 | 607.58 | 605.26 | 605.38 | 3724111.0 |
| 2024-12-09 11:00:00 | SPY | ETF | 605.38 | 606.125 | 604.61 | 606.01 | 2935341.0 |
| 2024-12-09 12:00:00 | SPY | ETF | 606.01 | 606.07 | 605.2732 | 605.3499 | 1111983.0 |
| 2024-12-09 13:00:00 | SPY | ETF | 605.335 | 606.43 | 605.04 | 606.01 | 1382630.0 |
| 2024-12-09 14:00:00 | SPY | ETF | 606.01 | 606.01 | 604.51 | 604.99 | 1960020.0 |
| 2024-12-09 15:00:00 | SPY | ETF | 605.0 | 605.07 | 604.08 | 604.66 | 7999530.0 |
| 2024-12-09 16:00:00 | SPY | ETF | 604.63 | 604.68 | 604.0801 | 604.47 | 2772822.0 |
| 2024-12-09 17:00:00 | SPY | ETF | 604.39 | 604.78 | 604.35 | 604.62 | 198342.0 |
| 2024-12-09 18:00:00 | SPY | ETF | 604.56 | 604.59 | 604.16 | 604.3 | 111576.0 |
| 2024-12-09 19:00:00 | SPY | ETF | 604.25 | 604.45 | 604.19 | 604.42 | 21577.0 |
| 2024-12-09 04:00:00 | QQQ | ETF | 526.72 | 527.63 | 525.83 | 525.99 | 67753.0 |
| 2024-12-09 05:00:00 | QQQ | ETF | 525.85 | 526.0 | 525.5 | 525.59 | 48214.0 |
| 2024-12-09 06:00:00 | QQQ | ETF | 525.68 | 525.83 | 524.93 | 525.56 | 66996.0 |
| 2024-12-09 07:00:00 | QQQ | ETF | 525.55 | 525.92 | 525.36 | 525.86 | 93109.0 |
| 2024-12-09 08:00:00 | QQQ | ETF | 525.61 | 527.59 | 525.07 | 525.67 | 135651.0 |
| 2024-12-09 09:00:00 | QQQ | ETF | 525.6699 | 526.35 | 524.75 | 525.76 | 1831092.0 |
| 2024-12-09 10:00:00 | QQQ | ETF | 525.725 | 525.95 | 522.82 | 522.91 | 2678423.0 |
| 2024-12-09 11:00:00 | QQQ | ETF | 522.93 | 523.43 | 521.22 | 523.04 | 2556726.0 |
| 2024-12-09 12:00:00 | QQQ | ETF | 523.01 | 523.33 | 522.4137 | 522.45 | 738815.0 |
| 2024-12-09 13:00:00 | QQQ | ETF | 522.47 | 523.96 | 522.11 | 523.47 | 1171589.0 |
| 2024-12-09 14:00:00 | QQQ | ETF | 523.47 | 523.4901 | 521.42 | 522.19 | 1314416.0 |
| 2024-12-09 15:00:00 | QQQ | ETF | 522.17 | 522.48 | 521.33 | 522.36 | 2780733.0 |
| 2024-12-09 16:00:00 | QQQ | ETF | 522.39 | 522.4316 | 521.84 | 522.13 | 1730271.0 |
| 2024-12-09 17:00:00 | QQQ | ETF | 522.25 | 522.39 | 522.15 | 522.25 | 57414.0 |
| 2024-12-09 18:00:00 | QQQ | ETF | 522.2301 | 522.2301 | 521.81 | 521.96 | 60270.0 |
| 2024-12-09 19:00:00 | QQQ | ETF | 521.86 | 522.27 | 521.83 | 522.23 | 98872.0 |
| 2024-12-09 04:00:00 | IWM | ETF | 239.82 | 239.98 | 239.67 | 239.7 | 16211.0 |
| 2024-12-09 05:00:00 | IWM | ETF | 239.76 | 239.83 | 239.37 | 239.62 | 6214.0 |
| 2024-12-09 06:00:00 | IWM | ETF | 239.7 | 239.81 | 239.4 | 239.73 | 6762.0 |
| 2024-12-09 07:00:00 | IWM | ETF | 239.65 | 240.05 | 239.616 | 239.91 | 36451.0 |
| 2024-12-09 08:00:00 | IWM | ETF | 239.8499 | 240.34 | 239.16 | 240.21 | 131446.0 |
| 2024-12-09 09:00:00 | IWM | ETF | 240.23 | 241.27 | 240.19 | 240.94 | 2007203.0 |
| 2024-12-09 10:00:00 | IWM | ETF | 240.97 | 241.38 | 238.44 | 238.77 | 3124745.0 |
| 2024-12-09 11:00:00 | IWM | ETF | 238.77 | 239.73 | 237.93 | 239.365 | 1775067.0 |
| 2024-12-09 12:00:00 | IWM | ETF | 239.37 | 239.42 | 238.68 | 238.82 | 785102.0 |
| 2024-12-09 13:00:00 | IWM | ETF | 238.82 | 239.19 | 238.7 | 239.01 | 634154.0 |
| 2024-12-09 14:00:00 | IWM | ETF | 239.0 | 239.0 | 238.36 | 238.61 | 789555.0 |
| 2024-12-09 15:00:00 | IWM | ETF | 238.6 | 238.66 | 237.65 | 237.72 | 2467089.0 |
| 2024-12-09 16:00:00 | IWM | ETF | 237.73 | 237.92 | 237.59 | 237.8704 | 776799.0 |
| 2024-12-09 17:00:00 | IWM | ETF | 237.87 | 237.92 | 237.73 | 237.76 | 16550.0 |
| 2024-12-09 18:00:00 | IWM | ETF | 237.78 | 237.96 | 237.61 | 237.8904 | 7525.0 |
| 2024-12-09 19:00:00 | IWM | ETF | 237.93 | 237.9399 | 237.7 | 237.92 | 7225.0 |
| 2024-12-09 04:00:00 | DIA | ETF | 447.09 | 447.42 | 447.0 | 447.2 | 3541.0 |
| 2024-12-09 05:00:00 | DIA | ETF | 447.18 | 447.28 | 447.0 | 447.28 | 4194.0 |
> showing 50 of 23,126 rows — these rows as CSV