PREVIEW / etf_1hour / 2024-03-15
file: by_date/etf_1hour/2024/2024-03-15.parquet size: 527 KB rows: 19,420
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-03-15 04:00:00 | SPY | ETF | 512.65 | 513.43 | 512.61 | 513.4 | 90204.0 |
| 2024-03-15 05:00:00 | SPY | ETF | 513.4 | 514.19 | 513.4 | 514.04 | 22760.0 |
| 2024-03-15 06:00:00 | SPY | ETF | 514.07 | 514.55 | 514.07 | 514.38 | 36051.0 |
| 2024-03-15 07:00:00 | SPY | ETF | 514.34 | 514.51 | 513.92 | 514.0 | 98226.0 |
| 2024-03-15 08:00:00 | SPY | ETF | 514.03 | 514.52 | 512.62 | 513.53 | 391500.0 |
| 2024-03-15 09:00:00 | SPY | ETF | 513.51 | 513.61 | 509.62 | 509.84 | 10844952.0 |
| 2024-03-15 10:00:00 | SPY | ETF | 509.83 | 511.7 | 508.87 | 511.08 | 8951108.0 |
| 2024-03-15 11:00:00 | SPY | ETF | 511.1 | 511.19 | 509.54 | 509.71 | 5559751.0 |
| 2024-03-15 12:00:00 | SPY | ETF | 509.7 | 509.89 | 508.36 | 508.46 | 6588147.0 |
| 2024-03-15 13:00:00 | SPY | ETF | 508.47 | 509.95 | 508.43 | 509.905 | 5469264.0 |
| 2024-03-15 14:00:00 | SPY | ETF | 509.92 | 510.545 | 509.18 | 510.19 | 6105042.0 |
| 2024-03-15 15:00:00 | SPY | ETF | 510.19 | 510.53 | 509.22 | 509.74 | 14139903.0 |
| 2024-03-15 16:00:00 | SPY | ETF | 509.75 | 510.2 | 509.57 | 509.7 | 5121778.0 |
| 2024-03-15 17:00:00 | SPY | ETF | 509.84 | 510.0 | 509.7135 | 509.75 | 246677.0 |
| 2024-03-15 18:00:00 | SPY | ETF | 509.83 | 510.0 | 509.67 | 509.75 | 327360.0 |
| 2024-03-15 19:00:00 | SPY | ETF | 509.75 | 510.0 | 509.74 | 509.79 | 19214.0 |
| 2024-03-15 04:00:00 | QQQ | ETF | 437.7 | 438.93 | 437.7 | 438.84 | 47294.0 |
| 2024-03-15 05:00:00 | QQQ | ETF | 438.88 | 439.81 | 438.69 | 439.53 | 56738.0 |
| 2024-03-15 06:00:00 | QQQ | ETF | 439.56 | 440.35 | 439.56 | 440.02 | 56322.0 |
| 2024-03-15 07:00:00 | QQQ | ETF | 439.98 | 440.02 | 439.201 | 439.35 | 85409.0 |
| 2024-03-15 08:00:00 | QQQ | ETF | 439.96 | 440.1504 | 437.58 | 438.65 | 511164.0 |
| 2024-03-15 09:00:00 | QQQ | ETF | 438.62 | 438.7 | 434.22 | 434.87 | 8950439.0 |
| 2024-03-15 10:00:00 | QQQ | ETF | 434.83 | 436.69 | 433.3 | 435.55 | 6907994.0 |
| 2024-03-15 11:00:00 | QQQ | ETF | 435.58 | 435.68 | 433.76 | 434.105 | 3524289.0 |
| 2024-03-15 12:00:00 | QQQ | ETF | 434.1 | 434.39 | 432.7417 | 432.85 | 4180893.0 |
| 2024-03-15 13:00:00 | QQQ | ETF | 432.85 | 434.61 | 432.8 | 434.52 | 3233635.0 |
| 2024-03-15 14:00:00 | QQQ | ETF | 434.53 | 434.99 | 433.6 | 434.57 | 3282148.0 |
| 2024-03-15 15:00:00 | QQQ | ETF | 434.56 | 435.09 | 433.565 | 433.88 | 7856658.0 |
| 2024-03-15 16:00:00 | QQQ | ETF | 433.89 | 434.44 | 433.8483 | 434.05 | 5083557.0 |
| 2024-03-15 17:00:00 | QQQ | ETF | 434.0 | 434.05 | 433.9 | 433.9 | 345176.0 |
| 2024-03-15 18:00:00 | QQQ | ETF | 433.91 | 434.14 | 433.8646 | 434.03 | 13400.0 |
| 2024-03-15 19:00:00 | QQQ | ETF | 434.0699 | 434.2 | 434.01 | 434.1 | 13713.0 |
| 2024-03-15 04:00:00 | IWM | ETF | 201.85 | 202.24 | 201.85 | 202.06 | 19361.0 |
| 2024-03-15 05:00:00 | IWM | ETF | 202.11 | 202.62 | 202.1 | 202.57 | 26827.0 |
| 2024-03-15 06:00:00 | IWM | ETF | 202.6 | 202.71 | 202.17 | 202.25 | 25366.0 |
| 2024-03-15 07:00:00 | IWM | ETF | 202.21 | 202.55 | 202.21 | 202.3 | 47300.0 |
| 2024-03-15 08:00:00 | IWM | ETF | 202.23 | 202.55 | 201.7 | 202.16 | 122218.0 |
| 2024-03-15 09:00:00 | IWM | ETF | 202.17 | 203.08 | 201.13 | 202.14 | 4688989.0 |
| 2024-03-15 10:00:00 | IWM | ETF | 202.13 | 202.83 | 201.39 | 202.6 | 4612552.0 |
| 2024-03-15 11:00:00 | IWM | ETF | 202.61 | 202.68 | 202.08 | 202.35 | 2635638.0 |
| 2024-03-15 12:00:00 | IWM | ETF | 202.35 | 202.46 | 201.42 | 201.47 | 2501010.0 |
| 2024-03-15 13:00:00 | IWM | ETF | 201.47 | 202.3999 | 201.45 | 202.3 | 2801850.0 |
| 2024-03-15 14:00:00 | IWM | ETF | 202.31 | 202.64 | 201.98 | 202.47 | 2753165.0 |
| 2024-03-15 15:00:00 | IWM | ETF | 202.46 | 202.775 | 202.185 | 202.37 | 7574420.0 |
| 2024-03-15 16:00:00 | IWM | ETF | 202.41 | 202.59 | 202.3 | 202.39 | 1323185.0 |
| 2024-03-15 17:00:00 | IWM | ETF | 202.38 | 202.43 | 202.25 | 202.34 | 41933.0 |
| 2024-03-15 18:00:00 | IWM | ETF | 202.31 | 202.34 | 202.21 | 202.32 | 2847.0 |
| 2024-03-15 19:00:00 | IWM | ETF | 202.32 | 202.41 | 202.21 | 202.21 | 9851.0 |
| 2024-03-15 04:00:00 | DIA | ETF | 388.75 | 388.76 | 388.75 | 388.76 | 2000.0 |
| 2024-03-15 06:00:00 | DIA | ETF | 389.6 | 389.61 | 389.47 | 389.47 | 1125.0 |
> showing 50 of 19,420 rows — these rows as CSV