PREVIEW / etf_1hour / 2024-12-12
file: by_date/etf_1hour/2024/2024-12-12.parquet size: 599 KB rows: 22,428
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-12 04:00:00 | SPY | ETF | 606.58 | 606.82 | 606.52 | 606.56 | 28119.0 |
| 2024-12-12 05:00:00 | SPY | ETF | 606.49 | 606.73 | 606.49 | 606.68 | 5395.0 |
| 2024-12-12 06:00:00 | SPY | ETF | 606.76 | 606.78 | 606.39 | 606.52 | 8672.0 |
| 2024-12-12 07:00:00 | SPY | ETF | 606.5 | 606.75 | 606.34 | 606.39 | 74431.0 |
| 2024-12-12 08:00:00 | SPY | ETF | 606.49 | 607.06 | 605.56 | 606.04 | 315887.0 |
| 2024-12-12 09:00:00 | SPY | ETF | 606.19 | 606.66 | 605.72 | 606.1999 | 2388960.0 |
| 2024-12-12 10:00:00 | SPY | ETF | 606.19 | 606.97 | 605.13 | 606.799 | 2929430.0 |
| 2024-12-12 11:00:00 | SPY | ETF | 606.79 | 607.16 | 605.77 | 605.79 | 1405002.0 |
| 2024-12-12 12:00:00 | SPY | ETF | 605.77 | 606.89 | 605.77 | 606.8 | 1553160.0 |
| 2024-12-12 13:00:00 | SPY | ETF | 606.78 | 606.95 | 605.72 | 605.76 | 1221662.0 |
| 2024-12-12 14:00:00 | SPY | ETF | 605.75 | 606.12 | 604.83 | 605.12 | 2260118.0 |
| 2024-12-12 15:00:00 | SPY | ETF | 605.1 | 605.35 | 604.34 | 604.35 | 5400028.0 |
| 2024-12-12 16:00:00 | SPY | ETF | 604.35 | 604.76 | 603.91 | 604.31 | 3594899.0 |
| 2024-12-12 17:00:00 | SPY | ETF | 604.31 | 605.49 | 604.27 | 605.29 | 141758.0 |
| 2024-12-12 18:00:00 | SPY | ETF | 605.06 | 605.07 | 604.63 | 604.96 | 73007.0 |
| 2024-12-12 19:00:00 | SPY | ETF | 604.86 | 605.57 | 604.81 | 605.38 | 73878.0 |
| 2024-12-12 04:00:00 | QQQ | ETF | 529.07 | 529.33 | 528.57 | 528.6 | 36631.0 |
| 2024-12-12 05:00:00 | QQQ | ETF | 528.6 | 528.9 | 528.47 | 528.72 | 25510.0 |
| 2024-12-12 06:00:00 | QQQ | ETF | 528.78 | 528.89 | 528.33 | 528.42 | 33665.0 |
| 2024-12-12 07:00:00 | QQQ | ETF | 528.42 | 528.55 | 527.67 | 527.82 | 118332.0 |
| 2024-12-12 08:00:00 | QQQ | ETF | 528.5 | 529.35 | 526.6 | 527.37 | 476037.0 |
| 2024-12-12 09:00:00 | QQQ | ETF | 527.37 | 527.77 | 526.7611 | 527.43 | 2214726.0 |
| 2024-12-12 10:00:00 | QQQ | ETF | 527.407 | 528.56 | 526.02 | 528.37 | 2568510.0 |
| 2024-12-12 11:00:00 | QQQ | ETF | 528.36 | 528.83 | 527.16 | 527.22 | 1347708.0 |
| 2024-12-12 12:00:00 | QQQ | ETF | 527.19 | 528.86 | 527.11 | 528.7929 | 1612564.0 |
| 2024-12-12 13:00:00 | QQQ | ETF | 528.82 | 528.96 | 527.74 | 527.789 | 1271651.0 |
| 2024-12-12 14:00:00 | QQQ | ETF | 527.8 | 528.24 | 527.01 | 527.52 | 1431584.0 |
| 2024-12-12 15:00:00 | QQQ | ETF | 527.45 | 527.55 | 526.5 | 526.5 | 2713089.0 |
| 2024-12-12 16:00:00 | QQQ | ETF | 526.51 | 527.93 | 525.57 | 526.25 | 1065617.0 |
| 2024-12-12 17:00:00 | QQQ | ETF | 526.28 | 529.41 | 526.24 | 528.98 | 422571.0 |
| 2024-12-12 18:00:00 | QQQ | ETF | 529.01 | 529.13 | 528.32 | 529.03 | 338401.0 |
| 2024-12-12 19:00:00 | QQQ | ETF | 528.85 | 529.51 | 528.85 | 529.39 | 122930.0 |
| 2024-12-12 04:00:00 | IWM | ETF | 237.6 | 237.83 | 237.55 | 237.58 | 11739.0 |
| 2024-12-12 05:00:00 | IWM | ETF | 237.57 | 237.62 | 237.46 | 237.49 | 9045.0 |
| 2024-12-12 06:00:00 | IWM | ETF | 237.47 | 237.65 | 237.42 | 237.54 | 18964.0 |
| 2024-12-12 07:00:00 | IWM | ETF | 237.51 | 237.6 | 237.18 | 237.19 | 109241.0 |
| 2024-12-12 08:00:00 | IWM | ETF | 237.42 | 237.9 | 236.26 | 236.63 | 518948.0 |
| 2024-12-12 09:00:00 | IWM | ETF | 236.63 | 237.65 | 236.51 | 236.67 | 1758389.0 |
| 2024-12-12 10:00:00 | IWM | ETF | 236.69 | 236.84 | 235.53 | 236.39 | 2763902.0 |
| 2024-12-12 11:00:00 | IWM | ETF | 236.38 | 236.7 | 235.59 | 235.62 | 1080423.0 |
| 2024-12-12 12:00:00 | IWM | ETF | 235.62 | 236.36 | 235.48 | 235.88 | 1259116.0 |
| 2024-12-12 13:00:00 | IWM | ETF | 235.87 | 236.21 | 235.58 | 235.6 | 825653.0 |
| 2024-12-12 14:00:00 | IWM | ETF | 235.59 | 235.88 | 234.96 | 235.43 | 1437509.0 |
| 2024-12-12 15:00:00 | IWM | ETF | 235.41 | 235.515 | 234.35 | 234.65 | 4180048.0 |
| 2024-12-12 16:00:00 | IWM | ETF | 234.68 | 234.73 | 234.38 | 234.57 | 2148648.0 |
| 2024-12-12 17:00:00 | IWM | ETF | 234.6 | 234.73 | 234.4 | 234.5 | 18124.0 |
| 2024-12-12 18:00:00 | IWM | ETF | 234.67 | 234.68 | 234.0 | 234.15 | 49534.0 |
| 2024-12-12 19:00:00 | IWM | ETF | 234.12 | 234.6 | 234.09 | 234.49 | 25488.0 |
| 2024-12-12 04:00:00 | DIA | ETF | 441.49 | 441.78 | 441.49 | 441.78 | 2817.0 |
| 2024-12-12 05:00:00 | DIA | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 400.0 |
> showing 50 of 22,428 rows — these rows as CSV