PREVIEW / etf_1hour / 2024-12-11
file: by_date/etf_1hour/2024/2024-12-11.parquet size: 607 KB rows: 22,568
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-11 04:00:00 | SPY | ETF | 603.34 | 603.57 | 603.33 | 603.52 | 12207.0 |
| 2024-12-11 05:00:00 | SPY | ETF | 603.44 | 603.44 | 603.21 | 603.43 | 4900.0 |
| 2024-12-11 06:00:00 | SPY | ETF | 603.43 | 603.64 | 603.43 | 603.52 | 4421.0 |
| 2024-12-11 07:00:00 | SPY | ETF | 603.45 | 603.57 | 603.27 | 603.36 | 91202.0 |
| 2024-12-11 08:00:00 | SPY | ETF | 603.4115 | 605.3609 | 602.9 | 605.34 | 574882.0 |
| 2024-12-11 09:00:00 | SPY | ETF | 605.33 | 606.655 | 605.27 | 606.61 | 3162213.0 |
| 2024-12-11 10:00:00 | SPY | ETF | 606.6 | 607.25 | 606.3202 | 606.7783 | 2782042.0 |
| 2024-12-11 11:00:00 | SPY | ETF | 606.79 | 607.87 | 606.51 | 607.74 | 2012377.0 |
| 2024-12-11 12:00:00 | SPY | ETF | 607.75 | 608.19 | 607.61 | 608.12 | 1737919.0 |
| 2024-12-11 13:00:00 | SPY | ETF | 608.125 | 608.435 | 607.73 | 607.81 | 1500630.0 |
| 2024-12-11 14:00:00 | SPY | ETF | 607.815 | 608.2168 | 607.56 | 607.94 | 1802305.0 |
| 2024-12-11 15:00:00 | SPY | ETF | 607.95 | 608.09 | 607.31 | 607.5 | 3732980.0 |
| 2024-12-11 16:00:00 | SPY | ETF | 607.5 | 607.53 | 602.8 | 607.0 | 2673510.0 |
| 2024-12-11 17:00:00 | SPY | ETF | 607.04 | 607.1284 | 606.95 | 607.05 | 29601.0 |
| 2024-12-11 18:00:00 | SPY | ETF | 607.02 | 607.09 | 606.83 | 606.92 | 45390.0 |
| 2024-12-11 19:00:00 | SPY | ETF | 606.94 | 606.95 | 606.5 | 606.76 | 63836.0 |
| 2024-12-11 04:00:00 | QQQ | ETF | 521.27 | 521.78 | 521.27 | 521.65 | 45871.0 |
| 2024-12-11 05:00:00 | QQQ | ETF | 521.65 | 521.72 | 521.31 | 521.6 | 20338.0 |
| 2024-12-11 06:00:00 | QQQ | ETF | 521.62 | 521.89 | 521.41 | 521.46 | 23144.0 |
| 2024-12-11 07:00:00 | QQQ | ETF | 521.44 | 521.59 | 521.24 | 521.38 | 42765.0 |
| 2024-12-11 08:00:00 | QQQ | ETF | 520.91 | 523.68 | 520.63 | 523.59 | 423951.0 |
| 2024-12-11 09:00:00 | QQQ | ETF | 523.56 | 527.59 | 523.51 | 527.56 | 3601589.0 |
| 2024-12-11 10:00:00 | QQQ | ETF | 527.56 | 528.52 | 527.02 | 527.6 | 3685776.0 |
| 2024-12-11 11:00:00 | QQQ | ETF | 527.62 | 529.3491 | 527.44 | 529.12 | 2318322.0 |
| 2024-12-11 12:00:00 | QQQ | ETF | 529.14 | 529.87 | 529.1031 | 529.6401 | 1684360.0 |
| 2024-12-11 13:00:00 | QQQ | ETF | 529.62 | 530.359 | 529.58 | 529.939 | 1802993.0 |
| 2024-12-11 14:00:00 | QQQ | ETF | 529.94 | 530.34 | 529.59 | 530.09 | 1683431.0 |
| 2024-12-11 15:00:00 | QQQ | ETF | 530.09 | 530.61 | 529.83 | 529.94 | 4896283.0 |
| 2024-12-11 16:00:00 | QQQ | ETF | 529.94 | 529.96 | 520.6 | 529.08 | 1997834.0 |
| 2024-12-11 17:00:00 | QQQ | ETF | 529.0601 | 529.218 | 529.05 | 529.181 | 23988.0 |
| 2024-12-11 18:00:00 | QQQ | ETF | 529.14 | 529.34 | 528.95 | 529.17 | 42127.0 |
| 2024-12-11 19:00:00 | QQQ | ETF | 529.1 | 529.23 | 528.78 | 529.03 | 170708.0 |
| 2024-12-11 04:00:00 | IWM | ETF | 236.77 | 236.86 | 236.63 | 236.82 | 26119.0 |
| 2024-12-11 05:00:00 | IWM | ETF | 236.77 | 236.85 | 236.65 | 236.81 | 7239.0 |
| 2024-12-11 06:00:00 | IWM | ETF | 236.79 | 237.16 | 236.75 | 237.04 | 5297.0 |
| 2024-12-11 07:00:00 | IWM | ETF | 237.02 | 237.25 | 237.01 | 237.25 | 28658.0 |
| 2024-12-11 08:00:00 | IWM | ETF | 236.98 | 239.16 | 236.68 | 238.91 | 722671.0 |
| 2024-12-11 09:00:00 | IWM | ETF | 238.93 | 238.93 | 237.68 | 237.775 | 2243882.0 |
| 2024-12-11 10:00:00 | IWM | ETF | 237.77 | 238.25 | 236.9 | 237.03 | 2122849.0 |
| 2024-12-11 11:00:00 | IWM | ETF | 237.05 | 238.59 | 236.83 | 238.53 | 1927662.0 |
| 2024-12-11 12:00:00 | IWM | ETF | 238.52 | 238.78 | 237.94 | 238.45 | 1129122.0 |
| 2024-12-11 13:00:00 | IWM | ETF | 238.455 | 239.14 | 238.31 | 238.36 | 1514339.0 |
| 2024-12-11 14:00:00 | IWM | ETF | 238.35 | 239.285 | 238.305 | 239.185 | 1538927.0 |
| 2024-12-11 15:00:00 | IWM | ETF | 239.18 | 239.2 | 237.78 | 237.81 | 4119823.0 |
| 2024-12-11 16:00:00 | IWM | ETF | 237.77 | 237.91 | 237.7 | 237.85 | 1593660.0 |
| 2024-12-11 17:00:00 | IWM | ETF | 237.81 | 237.98 | 237.81 | 237.9 | 6073.0 |
| 2024-12-11 18:00:00 | IWM | ETF | 237.81 | 237.93 | 237.77 | 237.92 | 10853.0 |
| 2024-12-11 19:00:00 | IWM | ETF | 237.89 | 237.92 | 237.58 | 237.77 | 24216.0 |
| 2024-12-11 04:00:00 | DIA | ETF | 443.5 | 443.5 | 443.12 | 443.12 | 2779.0 |
| 2024-12-11 05:00:00 | DIA | ETF | 442.97 | 443.02 | 442.97 | 443.02 | 300.0 |
> showing 50 of 22,568 rows — these rows as CSV