PREVIEW / etf_1hour / 2025-05-09
file: by_date/etf_1hour/2025/2025-05-09.parquet size: 624 KB rows: 23,628
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-09 04:00:00 | SPY | ETF | 565.38 | 565.6 | 564.79 | 565.01 | 12935.0 |
| 2025-05-09 05:00:00 | SPY | ETF | 565.28 | 565.77 | 565.19 | 565.77 | 7743.0 |
| 2025-05-09 06:00:00 | SPY | ETF | 566.03 | 566.81 | 566.03 | 566.62 | 46440.0 |
| 2025-05-09 07:00:00 | SPY | ETF | 566.57 | 567.99 | 564.14 | 566.22 | 823562.0 |
| 2025-05-09 08:00:00 | SPY | ETF | 566.13 | 567.63 | 564.2 | 566.775 | 409490.0 |
| 2025-05-09 09:00:00 | SPY | ETF | 566.79 | 567.5 | 565.81 | 567.0 | 2562277.0 |
| 2025-05-09 10:00:00 | SPY | ETF | 566.97 | 567.36 | 562.7636 | 564.56 | 5339279.0 |
| 2025-05-09 11:00:00 | SPY | ETF | 564.58 | 565.59 | 563.88 | 565.55 | 3022356.0 |
| 2025-05-09 12:00:00 | SPY | ETF | 565.56 | 565.6353 | 563.085 | 563.4 | 2361457.0 |
| 2025-05-09 13:00:00 | SPY | ETF | 563.4 | 565.355 | 562.87 | 565.23 | 2765714.0 |
| 2025-05-09 14:00:00 | SPY | ETF | 565.22 | 565.2951 | 564.09 | 564.83 | 1550230.0 |
| 2025-05-09 15:00:00 | SPY | ETF | 564.84 | 565.89 | 564.1 | 564.29 | 6193023.0 |
| 2025-05-09 16:00:00 | SPY | ETF | 564.28 | 564.89 | 563.98 | 564.87 | 2595277.0 |
| 2025-05-09 17:00:00 | SPY | ETF | 564.8 | 564.9659 | 564.44 | 564.92 | 66404.0 |
| 2025-05-09 18:00:00 | SPY | ETF | 564.9 | 565.1 | 564.63 | 565.0 | 25572.0 |
| 2025-05-09 19:00:00 | SPY | ETF | 565.0 | 565.13 | 564.86 | 565.0 | 58255.0 |
| 2025-05-09 04:00:00 | QQQ | ETF | 489.42 | 489.58 | 488.54 | 488.92 | 40730.0 |
| 2025-05-09 05:00:00 | QQQ | ETF | 488.95 | 489.57 | 488.95 | 489.57 | 22918.0 |
| 2025-05-09 06:00:00 | QQQ | ETF | 489.6 | 490.47 | 489.6 | 490.22 | 57666.0 |
| 2025-05-09 07:00:00 | QQQ | ETF | 490.27 | 492.0 | 488.28 | 489.8 | 333959.0 |
| 2025-05-09 08:00:00 | QQQ | ETF | 490.22 | 490.85 | 487.924 | 490.36 | 356438.0 |
| 2025-05-09 09:00:00 | QQQ | ETF | 490.33 | 491.54 | 489.72 | 490.91 | 2260650.0 |
| 2025-05-09 10:00:00 | QQQ | ETF | 490.86 | 491.4 | 486.195 | 488.2 | 4183538.0 |
| 2025-05-09 11:00:00 | QQQ | ETF | 488.2 | 489.0 | 487.19 | 488.8201 | 2377807.0 |
| 2025-05-09 12:00:00 | QQQ | ETF | 488.91 | 488.96 | 486.54 | 486.91 | 1763848.0 |
| 2025-05-09 13:00:00 | QQQ | ETF | 486.87 | 488.65 | 486.26 | 488.51 | 1739614.0 |
| 2025-05-09 14:00:00 | QQQ | ETF | 488.48 | 488.6 | 487.43 | 488.15 | 1252572.0 |
| 2025-05-09 15:00:00 | QQQ | ETF | 488.16 | 489.21 | 487.83 | 488.05 | 3303245.0 |
| 2025-05-09 16:00:00 | QQQ | ETF | 488.07 | 488.35 | 487.69 | 488.23 | 846747.0 |
| 2025-05-09 17:00:00 | QQQ | ETF | 488.1601 | 488.25 | 487.85 | 487.97 | 39739.0 |
| 2025-05-09 18:00:00 | QQQ | ETF | 487.9 | 488.39 | 487.9 | 488.06 | 25756.0 |
| 2025-05-09 19:00:00 | QQQ | ETF | 488.0372 | 488.09 | 487.6614 | 487.9151 | 37632.0 |
| 2025-05-09 04:00:00 | IWM | ETF | 200.72 | 200.92 | 200.44 | 200.83 | 20226.0 |
| 2025-05-09 05:00:00 | IWM | ETF | 200.88 | 201.02 | 200.68 | 201.01 | 23387.0 |
| 2025-05-09 06:00:00 | IWM | ETF | 200.99 | 201.65 | 200.99 | 201.41 | 19708.0 |
| 2025-05-09 07:00:00 | IWM | ETF | 201.4 | 202.11 | 200.53 | 201.49 | 171342.0 |
| 2025-05-09 08:00:00 | IWM | ETF | 201.53 | 201.98 | 200.78 | 201.579 | 102209.0 |
| 2025-05-09 09:00:00 | IWM | ETF | 201.68 | 202.28 | 201.26 | 202.1 | 1602468.0 |
| 2025-05-09 10:00:00 | IWM | ETF | 202.08 | 202.27 | 200.36 | 201.12 | 2346691.0 |
| 2025-05-09 11:00:00 | IWM | ETF | 201.12 | 201.33 | 200.45 | 200.73 | 1672137.0 |
| 2025-05-09 12:00:00 | IWM | ETF | 200.72 | 200.75 | 199.96 | 200.18 | 1073778.0 |
| 2025-05-09 13:00:00 | IWM | ETF | 200.19 | 201.1801 | 200.15 | 201.07 | 1155920.0 |
| 2025-05-09 14:00:00 | IWM | ETF | 201.04 | 201.095 | 200.61 | 201.01 | 571031.0 |
| 2025-05-09 15:00:00 | IWM | ETF | 201.0 | 201.24 | 200.61 | 200.83 | 2969117.0 |
| 2025-05-09 16:00:00 | IWM | ETF | 200.81 | 201.2 | 200.75 | 201.2 | 1054875.0 |
| 2025-05-09 17:00:00 | IWM | ETF | 201.16 | 201.23 | 200.94 | 201.17 | 4403.0 |
| 2025-05-09 18:00:00 | IWM | ETF | 201.06 | 201.18 | 201.01 | 201.07 | 8796.0 |
| 2025-05-09 19:00:00 | IWM | ETF | 201.01 | 201.09 | 200.81 | 200.93 | 4512.0 |
| 2025-05-09 04:00:00 | DIA | ETF | 413.58 | 413.63 | 413.2 | 413.2 | 3255.0 |
| 2025-05-09 05:00:00 | DIA | ETF | 413.52 | 413.54 | 413.5 | 413.54 | 400.0 |
> showing 50 of 23,628 rows — these rows as CSV