PREVIEW / etf_1hour / 2024-12-13
file: by_date/etf_1hour/2024/2024-12-13.parquet size: 600 KB rows: 22,178
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-13 04:00:00 | SPY | ETF | 606.11 | 606.56 | 606.1 | 606.53 | 22884.0 |
| 2024-12-13 05:00:00 | SPY | ETF | 606.63 | 606.75 | 606.55 | 606.75 | 4881.0 |
| 2024-12-13 06:00:00 | SPY | ETF | 606.72 | 606.82 | 606.56 | 606.65 | 48485.0 |
| 2024-12-13 07:00:00 | SPY | ETF | 606.65 | 606.96 | 606.6 | 606.93 | 175207.0 |
| 2024-12-13 08:00:00 | SPY | ETF | 606.82 | 607.16 | 605.1 | 606.86 | 188106.0 |
| 2024-12-13 09:00:00 | SPY | ETF | 606.8 | 607.13 | 606.0 | 606.15 | 2816614.0 |
| 2024-12-13 10:00:00 | SPY | ETF | 606.17 | 606.2 | 603.43 | 603.47 | 3839641.0 |
| 2024-12-13 11:00:00 | SPY | ETF | 603.47 | 604.66 | 603.03 | 603.81 | 2830167.0 |
| 2024-12-13 12:00:00 | SPY | ETF | 603.785 | 603.99 | 602.83 | 602.91 | 1737643.0 |
| 2024-12-13 13:00:00 | SPY | ETF | 602.9 | 604.42 | 602.81 | 604.1 | 1609705.0 |
| 2024-12-13 14:00:00 | SPY | ETF | 604.11 | 604.63 | 603.9201 | 604.3001 | 2241509.0 |
| 2024-12-13 15:00:00 | SPY | ETF | 604.29 | 604.7 | 603.77 | 604.26 | 4647844.0 |
| 2024-12-13 16:00:00 | SPY | ETF | 604.31 | 604.31 | 603.39 | 603.75 | 2504467.0 |
| 2024-12-13 17:00:00 | SPY | ETF | 603.75 | 604.21 | 603.72 | 603.95 | 77412.0 |
| 2024-12-13 18:00:00 | SPY | ETF | 603.91 | 604.08 | 603.85 | 603.99 | 14264.0 |
| 2024-12-13 19:00:00 | SPY | ETF | 603.8748 | 604.08 | 603.68 | 603.85 | 7160.0 |
| 2024-12-13 04:00:00 | QQQ | ETF | 528.42 | 530.23 | 528.42 | 530.23 | 51506.0 |
| 2024-12-13 05:00:00 | QQQ | ETF | 530.2 | 530.46 | 530.08 | 530.35 | 52972.0 |
| 2024-12-13 06:00:00 | QQQ | ETF | 530.34 | 530.63 | 530.22 | 530.22 | 93885.0 |
| 2024-12-13 07:00:00 | QQQ | ETF | 530.23 | 531.38 | 530.11 | 531.32 | 181875.0 |
| 2024-12-13 08:00:00 | QQQ | ETF | 530.5 | 531.57 | 528.33 | 531.09 | 400383.0 |
| 2024-12-13 09:00:00 | QQQ | ETF | 531.04 | 533.1661 | 530.0 | 532.52 | 3672519.0 |
| 2024-12-13 10:00:00 | QQQ | ETF | 532.52 | 532.61 | 527.77 | 527.7901 | 3758879.0 |
| 2024-12-13 11:00:00 | QQQ | ETF | 527.83 | 529.51 | 527.3001 | 528.13 | 3138522.0 |
| 2024-12-13 12:00:00 | QQQ | ETF | 528.08 | 529.1299 | 527.64 | 527.74 | 1217303.0 |
| 2024-12-13 13:00:00 | QQQ | ETF | 527.7408 | 529.97 | 527.68 | 529.9112 | 1272709.0 |
| 2024-12-13 14:00:00 | QQQ | ETF | 529.92 | 530.92 | 529.58 | 530.56 | 1586567.0 |
| 2024-12-13 15:00:00 | QQQ | ETF | 530.6 | 531.15 | 529.95 | 530.5 | 2559080.0 |
| 2024-12-13 16:00:00 | QQQ | ETF | 530.52 | 530.5434 | 529.42 | 529.6 | 858850.0 |
| 2024-12-13 17:00:00 | QQQ | ETF | 529.65 | 529.78 | 529.54 | 529.7662 | 10682.0 |
| 2024-12-13 18:00:00 | QQQ | ETF | 529.65 | 529.85 | 529.65 | 529.7 | 11247.0 |
| 2024-12-13 19:00:00 | QQQ | ETF | 529.9 | 529.92 | 529.7 | 529.78 | 3490.0 |
| 2024-12-13 04:00:00 | IWM | ETF | 235.01 | 235.31 | 234.95 | 235.27 | 21866.0 |
| 2024-12-13 05:00:00 | IWM | ETF | 235.25 | 235.32 | 235.09 | 235.17 | 8681.0 |
| 2024-12-13 06:00:00 | IWM | ETF | 235.31 | 235.42 | 234.94 | 234.94 | 22780.0 |
| 2024-12-13 07:00:00 | IWM | ETF | 234.96 | 235.05 | 234.7 | 234.7 | 95269.0 |
| 2024-12-13 08:00:00 | IWM | ETF | 234.9596 | 235.36 | 234.34 | 234.7 | 202484.0 |
| 2024-12-13 09:00:00 | IWM | ETF | 234.66 | 234.86 | 233.51 | 233.58 | 2182714.0 |
| 2024-12-13 10:00:00 | IWM | ETF | 233.61 | 233.9299 | 232.48 | 232.545 | 2622396.0 |
| 2024-12-13 11:00:00 | IWM | ETF | 232.54 | 233.185 | 232.23 | 232.98 | 2234430.0 |
| 2024-12-13 12:00:00 | IWM | ETF | 232.97 | 233.03 | 231.88 | 232.35 | 1471341.0 |
| 2024-12-13 13:00:00 | IWM | ETF | 232.35 | 233.0 | 232.165 | 232.575 | 1244238.0 |
| 2024-12-13 14:00:00 | IWM | ETF | 232.575 | 232.92 | 232.49 | 232.76 | 934540.0 |
| 2024-12-13 15:00:00 | IWM | ETF | 232.76 | 233.25 | 232.68 | 233.1 | 2818296.0 |
| 2024-12-13 16:00:00 | IWM | ETF | 233.07 | 233.13 | 232.5 | 232.84 | 1805085.0 |
| 2024-12-13 17:00:00 | IWM | ETF | 232.85 | 233.07 | 232.599 | 232.65 | 12401.0 |
| 2024-12-13 18:00:00 | IWM | ETF | 232.65 | 232.85 | 232.6 | 232.83 | 10702.0 |
| 2024-12-13 19:00:00 | IWM | ETF | 232.8482 | 232.87 | 232.71 | 232.78 | 7761.0 |
| 2024-12-13 04:00:00 | DIA | ETF | 440.97 | 441.46 | 440.85 | 441.46 | 3125.0 |
| 2024-12-13 05:00:00 | DIA | ETF | 441.42 | 441.43 | 441.42 | 441.43 | 873.0 |
> showing 50 of 22,178 rows — these rows as CSV