PREVIEW / etf_1hour / 2026-04-08
file: by_date/etf_1hour/2026/2026-04-08.parquet size: 766 KB rows: 30,772
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 |
|---|---|---|---|---|---|---|---|
| 2026-04-08 04:00:00 | SPY | ETF | 674.68 | 677.17 | 674.68 | 676.41 | 214994.0 |
| 2026-04-08 05:00:00 | SPY | ETF | 676.65 | 677.45 | 676.21 | 676.61 | 229645.0 |
| 2026-04-08 06:00:00 | SPY | ETF | 676.71 | 677.11 | 676.16 | 676.86 | 272798.0 |
| 2026-04-08 07:00:00 | SPY | ETF | 676.81 | 678.15 | 676.23 | 677.35 | 1172548.0 |
| 2026-04-08 08:00:00 | SPY | ETF | 677.35 | 677.91 | 675.51 | 676.8 | 1859395.0 |
| 2026-04-08 09:00:00 | SPY | ETF | 676.75 | 677.1 | 673.97 | 674.4 | 12255395.0 |
| 2026-04-08 10:00:00 | SPY | ETF | 674.37 | 675.27 | 671.46 | 672.78 | 11950588.0 |
| 2026-04-08 11:00:00 | SPY | ETF | 672.8 | 675.12 | 672.46 | 675.035 | 6130427.0 |
| 2026-04-08 12:00:00 | SPY | ETF | 675.035 | 676.23 | 674.48 | 676.14 | 4739310.0 |
| 2026-04-08 13:00:00 | SPY | ETF | 676.14 | 676.435 | 674.74 | 675.79 | 5713199.0 |
| 2026-04-08 14:00:00 | SPY | ETF | 675.8 | 676.605 | 673.06 | 673.1384 | 9711093.0 |
| 2026-04-08 15:00:00 | SPY | ETF | 673.13 | 675.53 | 672.78 | 675.48 | 15456698.0 |
| 2026-04-08 16:00:00 | SPY | ETF | 675.485 | 676.2 | 674.93 | 675.14 | 6024265.0 |
| 2026-04-08 17:00:00 | SPY | ETF | 675.09 | 675.23 | 674.89 | 675.03 | 110348.0 |
| 2026-04-08 18:00:00 | SPY | ETF | 675.02 | 675.76 | 674.56 | 675.0403 | 165851.0 |
| 2026-04-08 19:00:00 | SPY | ETF | 675.0103 | 675.55 | 674.7 | 674.81 | 77550.0 |
| 2026-04-08 20:00:00 | SPY | ETF | 674.7439 | 674.7636 | 674.7 | 674.7 | 3867.0 |
| 2026-04-08 04:00:00 | QQQ | ETF | 607.26 | 608.75 | 605.59 | 608.69 | 586401.0 |
| 2026-04-08 05:00:00 | QQQ | ETF | 608.761 | 609.82 | 608.4 | 608.76 | 236948.0 |
| 2026-04-08 06:00:00 | QQQ | ETF | 608.83 | 609.48 | 608.45 | 608.97 | 197092.0 |
| 2026-04-08 07:00:00 | QQQ | ETF | 608.96 | 609.5 | 608.22 | 608.97 | 519627.0 |
| 2026-04-08 08:00:00 | QQQ | ETF | 608.97 | 610.07 | 607.62 | 609.101 | 1063390.0 |
| 2026-04-08 09:00:00 | QQQ | ETF | 609.1502 | 609.9 | 605.41 | 605.8 | 10213499.0 |
| 2026-04-08 10:00:00 | QQQ | ETF | 605.8 | 606.33 | 602.12 | 603.56 | 8552322.0 |
| 2026-04-08 11:00:00 | QQQ | ETF | 603.57 | 606.04 | 603.3501 | 605.9676 | 5270195.0 |
| 2026-04-08 12:00:00 | QQQ | ETF | 605.97 | 607.705 | 605.4 | 607.47 | 3576656.0 |
| 2026-04-08 13:00:00 | QQQ | ETF | 607.47 | 607.695 | 605.495 | 606.21 | 3502453.0 |
| 2026-04-08 14:00:00 | QQQ | ETF | 606.1688 | 607.1 | 602.95 | 602.9999 | 5872437.0 |
| 2026-04-08 15:00:00 | QQQ | ETF | 602.99 | 605.4 | 602.55 | 605.21 | 6311969.0 |
| 2026-04-08 16:00:00 | QQQ | ETF | 605.21 | 606.36 | 604.83 | 604.95 | 3091148.0 |
| 2026-04-08 17:00:00 | QQQ | ETF | 604.97 | 605.1151 | 604.52 | 605.02 | 71956.0 |
| 2026-04-08 18:00:00 | QQQ | ETF | 605.02 | 605.48 | 604.28 | 604.7 | 112394.0 |
| 2026-04-08 19:00:00 | QQQ | ETF | 604.7 | 605.2797 | 604.49 | 604.51 | 94588.0 |
| 2026-04-08 20:00:00 | QQQ | ETF | 604.51 | 604.57 | 604.471 | 604.52 | 4579.0 |
| 2026-04-08 04:00:00 | IWM | ETF | 261.81 | 262.73 | 261.55 | 262.55 | 122987.0 |
| 2026-04-08 05:00:00 | IWM | ETF | 262.58 | 262.8 | 261.94 | 262.14 | 177145.0 |
| 2026-04-08 06:00:00 | IWM | ETF | 262.14 | 262.5 | 261.94 | 262.25 | 186191.0 |
| 2026-04-08 07:00:00 | IWM | ETF | 262.13 | 263.32 | 261.96 | 262.76 | 656884.0 |
| 2026-04-08 08:00:00 | IWM | ETF | 262.8 | 263.04 | 261.16 | 261.915 | 777450.0 |
| 2026-04-08 09:00:00 | IWM | ETF | 261.87 | 262.27 | 260.62 | 260.915 | 6445961.0 |
| 2026-04-08 10:00:00 | IWM | ETF | 260.91 | 261.28 | 258.41 | 259.2866 | 5038260.0 |
| 2026-04-08 11:00:00 | IWM | ETF | 259.29 | 260.77 | 259.23 | 260.62 | 2709197.0 |
| 2026-04-08 12:00:00 | IWM | ETF | 260.61 | 260.99 | 260.14 | 260.7073 | 1657218.0 |
| 2026-04-08 13:00:00 | IWM | ETF | 260.72 | 260.92 | 259.765 | 260.885 | 1644631.0 |
| 2026-04-08 14:00:00 | IWM | ETF | 260.88 | 261.0905 | 258.665 | 258.7 | 3126099.0 |
| 2026-04-08 15:00:00 | IWM | ETF | 258.68 | 260.45 | 258.595 | 260.44 | 4618846.0 |
| 2026-04-08 16:00:00 | IWM | ETF | 260.44 | 260.65 | 259.99 | 260.06 | 1631546.0 |
| 2026-04-08 17:00:00 | IWM | ETF | 260.08 | 260.47 | 259.85 | 259.95 | 74799.0 |
| 2026-04-08 18:00:00 | IWM | ETF | 260.15 | 260.5791 | 259.95 | 260.11 | 29425.0 |
| 2026-04-08 19:00:00 | IWM | ETF | 260.04 | 260.2 | 259.94 | 259.94 | 47874.0 |
> showing 50 of 30,772 rows — these rows as CSV