PREVIEW / etf_1hour / 2024-12-16
file: by_date/etf_1hour/2024/2024-12-16.parquet size: 614 KB rows: 23,233
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-16 04:00:00 | SPY | ETF | 604.12 | 605.16 | 604.12 | 605.16 | 8748.0 |
| 2024-12-16 05:00:00 | SPY | ETF | 605.25 | 605.67 | 605.18 | 605.44 | 17294.0 |
| 2024-12-16 06:00:00 | SPY | ETF | 605.31 | 605.39 | 604.99 | 605.34 | 11792.0 |
| 2024-12-16 07:00:00 | SPY | ETF | 605.34 | 605.77 | 605.301 | 605.62 | 60501.0 |
| 2024-12-16 08:00:00 | SPY | ETF | 605.6588 | 606.38 | 604.42 | 606.38 | 145807.0 |
| 2024-12-16 09:00:00 | SPY | ETF | 606.37 | 606.4 | 605.5801 | 606.27 | 2800203.0 |
| 2024-12-16 10:00:00 | SPY | ETF | 606.3 | 607.11 | 605.21 | 606.71 | 3004146.0 |
| 2024-12-16 11:00:00 | SPY | ETF | 606.71 | 606.98 | 606.4 | 606.95 | 1867964.0 |
| 2024-12-16 12:00:00 | SPY | ETF | 606.96 | 607.34 | 606.56 | 607.255 | 1487484.0 |
| 2024-12-16 13:00:00 | SPY | ETF | 607.26 | 607.7795 | 607.16 | 607.62 | 1905035.0 |
| 2024-12-16 14:00:00 | SPY | ETF | 607.61 | 607.66 | 607.29 | 607.5 | 2315088.0 |
| 2024-12-16 15:00:00 | SPY | ETF | 607.51 | 607.775 | 606.055 | 606.775 | 8702769.0 |
| 2024-12-16 16:00:00 | SPY | ETF | 606.76 | 607.8704 | 606.08 | 606.32 | 3991899.0 |
| 2024-12-16 17:00:00 | SPY | ETF | 606.45 | 606.6959 | 606.15 | 606.3 | 101858.0 |
| 2024-12-16 18:00:00 | SPY | ETF | 606.34 | 606.35 | 605.79 | 606.12 | 41588.0 |
| 2024-12-16 19:00:00 | SPY | ETF | 606.1 | 606.1 | 605.9 | 605.98 | 11865.0 |
| 2024-12-16 04:00:00 | QQQ | ETF | 530.87 | 531.83 | 530.84 | 531.82 | 26273.0 |
| 2024-12-16 05:00:00 | QQQ | ETF | 531.92 | 532.25 | 531.8 | 532.25 | 25549.0 |
| 2024-12-16 06:00:00 | QQQ | ETF | 531.9 | 532.31 | 531.61 | 532.26 | 75525.0 |
| 2024-12-16 07:00:00 | QQQ | ETF | 532.15 | 532.68 | 532.02 | 532.51 | 100403.0 |
| 2024-12-16 08:00:00 | QQQ | ETF | 532.1502 | 533.4 | 530.133 | 533.35 | 327610.0 |
| 2024-12-16 09:00:00 | QQQ | ETF | 533.36 | 534.85 | 532.6 | 534.83 | 3260016.0 |
| 2024-12-16 10:00:00 | QQQ | ETF | 534.85 | 536.08 | 533.78 | 535.26 | 3091340.0 |
| 2024-12-16 11:00:00 | QQQ | ETF | 535.27 | 536.86 | 535.26 | 536.832 | 2136642.0 |
| 2024-12-16 12:00:00 | QQQ | ETF | 536.82 | 537.57 | 536.39 | 537.54 | 1873908.0 |
| 2024-12-16 13:00:00 | QQQ | ETF | 537.55 | 538.52 | 537.41 | 538.32 | 1970469.0 |
| 2024-12-16 14:00:00 | QQQ | ETF | 538.29 | 538.89 | 538.0001 | 538.48 | 1778209.0 |
| 2024-12-16 15:00:00 | QQQ | ETF | 538.48 | 539.15 | 537.8137 | 538.2 | 4000824.0 |
| 2024-12-16 16:00:00 | QQQ | ETF | 538.2 | 538.34 | 537.79 | 538.21 | 1527175.0 |
| 2024-12-16 17:00:00 | QQQ | ETF | 538.19 | 538.2 | 537.95 | 538.1 | 43908.0 |
| 2024-12-16 18:00:00 | QQQ | ETF | 538.1 | 538.22 | 537.48 | 537.9 | 89892.0 |
| 2024-12-16 19:00:00 | QQQ | ETF | 537.81 | 537.85 | 537.57 | 537.59 | 25637.0 |
| 2024-12-16 04:00:00 | IWM | ETF | 233.4 | 233.6 | 233.27 | 233.56 | 13307.0 |
| 2024-12-16 05:00:00 | IWM | ETF | 233.57 | 233.8 | 233.17 | 233.17 | 8023.0 |
| 2024-12-16 06:00:00 | IWM | ETF | 233.18 | 233.27 | 232.96 | 233.05 | 21210.0 |
| 2024-12-16 07:00:00 | IWM | ETF | 233.11 | 233.25 | 232.89 | 233.03 | 63037.0 |
| 2024-12-16 08:00:00 | IWM | ETF | 233.04 | 233.83 | 232.94 | 233.4901 | 202421.0 |
| 2024-12-16 09:00:00 | IWM | ETF | 233.5 | 234.36 | 232.35 | 234.1001 | 3121723.0 |
| 2024-12-16 10:00:00 | IWM | ETF | 234.16 | 235.26 | 233.65 | 234.84 | 2771332.0 |
| 2024-12-16 11:00:00 | IWM | ETF | 234.86 | 234.98 | 234.25 | 234.715 | 1712829.0 |
| 2024-12-16 12:00:00 | IWM | ETF | 234.725 | 235.26 | 234.54 | 235.21 | 1511923.0 |
| 2024-12-16 13:00:00 | IWM | ETF | 235.205 | 235.43 | 234.98 | 235.19 | 1624944.0 |
| 2024-12-16 14:00:00 | IWM | ETF | 235.19 | 235.63 | 234.9 | 235.545 | 1665401.0 |
| 2024-12-16 15:00:00 | IWM | ETF | 235.55 | 235.55 | 234.17 | 234.49 | 5491436.0 |
| 2024-12-16 16:00:00 | IWM | ETF | 234.49 | 234.8408 | 234.44 | 234.46 | 2698027.0 |
| 2024-12-16 17:00:00 | IWM | ETF | 234.59 | 234.65 | 234.4 | 234.44 | 24469.0 |
| 2024-12-16 18:00:00 | IWM | ETF | 234.47 | 234.47 | 234.15 | 234.29 | 27130.0 |
| 2024-12-16 19:00:00 | IWM | ETF | 234.3 | 234.48 | 234.25 | 234.36 | 57413.0 |
| 2024-12-16 04:00:00 | DIA | ETF | 439.47 | 439.64 | 439.47 | 439.62 | 680.0 |
| 2024-12-16 05:00:00 | DIA | ETF | 439.78 | 439.78 | 439.7 | 439.7 | 300.0 |
> showing 50 of 23,233 rows — these rows as CSV