PREVIEW / etf_1hour / 2024-09-12
file: by_date/etf_1hour/2024/2024-09-12.parquet size: 541 KB rows: 20,535
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-09-12 04:00:00 | SPY | ETF | 554.87 | 556.0 | 554.87 | 555.56 | 33163.0 |
| 2024-09-12 05:00:00 | SPY | ETF | 555.57 | 556.25 | 555.53 | 555.58 | 20144.0 |
| 2024-09-12 06:00:00 | SPY | ETF | 555.62 | 556.05 | 555.5 | 555.59 | 25312.0 |
| 2024-09-12 07:00:00 | SPY | ETF | 555.61 | 555.93 | 555.37 | 555.93 | 121065.0 |
| 2024-09-12 08:00:00 | SPY | ETF | 555.67 | 556.85 | 554.99 | 555.16 | 429972.0 |
| 2024-09-12 09:00:00 | SPY | ETF | 555.23 | 555.75 | 552.74 | 553.77 | 3842820.0 |
| 2024-09-12 10:00:00 | SPY | ETF | 553.81 | 556.28 | 553.31 | 554.45 | 4751034.0 |
| 2024-09-12 11:00:00 | SPY | ETF | 554.41 | 556.64 | 554.06 | 554.5 | 3365046.0 |
| 2024-09-12 12:00:00 | SPY | ETF | 554.47 | 557.24 | 554.35 | 557.12 | 2793797.0 |
| 2024-09-12 13:00:00 | SPY | ETF | 557.13 | 559.37 | 557.0 | 559.14 | 3806395.0 |
| 2024-09-12 14:00:00 | SPY | ETF | 559.145 | 559.4 | 556.54 | 558.68 | 4624545.0 |
| 2024-09-12 15:00:00 | SPY | ETF | 558.66 | 559.22 | 558.12 | 559.02 | 8646277.0 |
| 2024-09-12 16:00:00 | SPY | ETF | 559.02 | 559.09 | 558.0 | 558.32 | 2977379.0 |
| 2024-09-12 17:00:00 | SPY | ETF | 558.22 | 558.51 | 558.22 | 558.43 | 51994.0 |
| 2024-09-12 18:00:00 | SPY | ETF | 558.43 | 559.05 | 558.43 | 559.03 | 32641.0 |
| 2024-09-12 19:00:00 | SPY | ETF | 558.94 | 559.54 | 558.94 | 559.24 | 40027.0 |
| 2024-09-12 04:00:00 | QQQ | ETF | 469.13 | 469.89 | 468.68 | 469.48 | 75933.0 |
| 2024-09-12 05:00:00 | QQQ | ETF | 469.57 | 470.34 | 469.46 | 469.46 | 114306.0 |
| 2024-09-12 06:00:00 | QQQ | ETF | 469.51 | 469.84 | 469.21 | 469.37 | 35103.0 |
| 2024-09-12 07:00:00 | QQQ | ETF | 469.3 | 469.67 | 468.98 | 469.55 | 165491.0 |
| 2024-09-12 08:00:00 | QQQ | ETF | 469.23 | 470.59 | 468.4 | 468.63 | 620757.0 |
| 2024-09-12 09:00:00 | QQQ | ETF | 468.61 | 469.33 | 466.8491 | 468.6 | 3683867.0 |
| 2024-09-12 10:00:00 | QQQ | ETF | 468.6 | 471.22 | 467.75 | 469.14 | 4624248.0 |
| 2024-09-12 11:00:00 | QQQ | ETF | 469.12 | 471.79 | 468.3498 | 468.765 | 3075133.0 |
| 2024-09-12 12:00:00 | QQQ | ETF | 468.76 | 471.663 | 468.64 | 471.6 | 1968873.0 |
| 2024-09-12 13:00:00 | QQQ | ETF | 471.61 | 473.72 | 471.38 | 473.63 | 2378910.0 |
| 2024-09-12 14:00:00 | QQQ | ETF | 473.64 | 474.04 | 471.03 | 473.33 | 4225281.0 |
| 2024-09-12 15:00:00 | QQQ | ETF | 473.32 | 473.6 | 472.27 | 473.24 | 5095722.0 |
| 2024-09-12 16:00:00 | QQQ | ETF | 473.28 | 473.4 | 472.07 | 472.35 | 1357915.0 |
| 2024-09-12 17:00:00 | QQQ | ETF | 472.3481 | 472.39 | 472.2 | 472.32 | 21445.0 |
| 2024-09-12 18:00:00 | QQQ | ETF | 472.34 | 473.07 | 472.34 | 473.07 | 86372.0 |
| 2024-09-12 19:00:00 | QQQ | ETF | 473.11 | 473.65 | 473.11 | 473.3353 | 55602.0 |
| 2024-09-12 04:00:00 | IWM | ETF | 209.39 | 210.03 | 209.38 | 209.76 | 18258.0 |
| 2024-09-12 05:00:00 | IWM | ETF | 209.77 | 210.23 | 209.7 | 209.93 | 12270.0 |
| 2024-09-12 06:00:00 | IWM | ETF | 209.93 | 210.29 | 209.93 | 210.23 | 33129.0 |
| 2024-09-12 07:00:00 | IWM | ETF | 210.24 | 210.26 | 209.85 | 210.08 | 45025.0 |
| 2024-09-12 08:00:00 | IWM | ETF | 210.1817 | 210.2335 | 209.07 | 209.5 | 355508.0 |
| 2024-09-12 09:00:00 | IWM | ETF | 209.43 | 210.88 | 208.41 | 208.955 | 3744576.0 |
| 2024-09-12 10:00:00 | IWM | ETF | 208.97 | 211.1568 | 208.54 | 210.24 | 2584940.0 |
| 2024-09-12 11:00:00 | IWM | ETF | 210.24 | 211.55 | 210.14 | 210.5 | 2080272.0 |
| 2024-09-12 12:00:00 | IWM | ETF | 210.48 | 211.57 | 210.36 | 211.48 | 1384192.0 |
| 2024-09-12 13:00:00 | IWM | ETF | 211.495 | 212.78 | 211.17 | 212.6712 | 2536719.0 |
| 2024-09-12 14:00:00 | IWM | ETF | 212.68 | 212.6935 | 210.9401 | 211.58 | 2580348.0 |
| 2024-09-12 15:00:00 | IWM | ETF | 211.575 | 211.93 | 211.17 | 211.63 | 3767240.0 |
| 2024-09-12 16:00:00 | IWM | ETF | 211.61 | 211.71 | 211.2 | 211.65 | 1204754.0 |
| 2024-09-12 17:00:00 | IWM | ETF | 211.66 | 211.7 | 211.54 | 211.54 | 10328.0 |
| 2024-09-12 18:00:00 | IWM | ETF | 211.69 | 211.94 | 211.69 | 211.9 | 13479.0 |
| 2024-09-12 19:00:00 | IWM | ETF | 211.86 | 212.1 | 211.845 | 211.99 | 36270.0 |
| 2024-09-12 04:00:00 | DIA | ETF | 410.08 | 410.08 | 409.9 | 410.0 | 349.0 |
| 2024-09-12 05:00:00 | DIA | ETF | 410.19 | 410.19 | 410.19 | 410.19 | 500.0 |
> showing 50 of 20,535 rows — these rows as CSV