PREVIEW / etf_1hour / 2024-10-21
file: by_date/etf_1hour/2024/2024-10-21.parquet size: 574 KB rows: 21,877
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-10-21 04:00:00 | SPY | ETF | 584.28 | 584.59 | 584.22 | 584.46 | 19944.0 |
| 2024-10-21 05:00:00 | SPY | ETF | 584.46 | 584.46 | 583.27 | 583.81 | 19866.0 |
| 2024-10-21 06:00:00 | SPY | ETF | 583.8 | 583.8 | 582.8 | 582.84 | 34713.0 |
| 2024-10-21 07:00:00 | SPY | ETF | 582.81 | 583.04 | 582.38 | 582.62 | 178940.0 |
| 2024-10-21 08:00:00 | SPY | ETF | 582.91 | 584.75 | 582.4 | 583.31 | 171460.0 |
| 2024-10-21 09:00:00 | SPY | ETF | 583.29 | 584.47 | 583.26 | 584.0399 | 2222825.0 |
| 2024-10-21 10:00:00 | SPY | ETF | 584.05 | 584.85 | 582.0653 | 582.6 | 4695400.0 |
| 2024-10-21 11:00:00 | SPY | ETF | 582.595 | 582.65 | 580.6001 | 582.3549 | 4067961.0 |
| 2024-10-21 12:00:00 | SPY | ETF | 582.33 | 582.8813 | 581.8 | 582.82 | 1605859.0 |
| 2024-10-21 13:00:00 | SPY | ETF | 582.83 | 583.38 | 582.6 | 583.25 | 1542745.0 |
| 2024-10-21 14:00:00 | SPY | ETF | 583.28 | 583.29 | 582.26 | 582.3888 | 1845945.0 |
| 2024-10-21 15:00:00 | SPY | ETF | 582.385 | 583.73 | 582.1701 | 583.67 | 5443645.0 |
| 2024-10-21 16:00:00 | SPY | ETF | 583.68 | 584.03 | 583.24 | 583.88 | 1722506.0 |
| 2024-10-21 17:00:00 | SPY | ETF | 583.95 | 584.019 | 583.5375 | 583.96 | 433932.0 |
| 2024-10-21 18:00:00 | SPY | ETF | 583.96 | 584.0 | 583.64 | 583.65 | 32316.0 |
| 2024-10-21 19:00:00 | SPY | ETF | 583.69 | 583.76 | 583.56 | 583.61 | 23887.0 |
| 2024-10-21 04:00:00 | QQQ | ETF | 494.02 | 494.04 | 493.56 | 494.04 | 27755.0 |
| 2024-10-21 05:00:00 | QQQ | ETF | 493.96 | 493.96 | 492.55 | 493.16 | 23663.0 |
| 2024-10-21 06:00:00 | QQQ | ETF | 493.13 | 493.33 | 491.9 | 491.9 | 59749.0 |
| 2024-10-21 07:00:00 | QQQ | ETF | 491.95 | 492.19 | 491.29 | 491.62 | 189964.0 |
| 2024-10-21 08:00:00 | QQQ | ETF | 492.0 | 494.47 | 491.37 | 492.61 | 200229.0 |
| 2024-10-21 09:00:00 | QQQ | ETF | 492.58 | 495.0 | 492.5 | 494.77 | 2266330.0 |
| 2024-10-21 10:00:00 | QQQ | ETF | 494.83 | 496.23 | 492.17 | 493.33 | 4152500.0 |
| 2024-10-21 11:00:00 | QQQ | ETF | 493.26 | 494.1112 | 491.31 | 493.904 | 3418658.0 |
| 2024-10-21 12:00:00 | QQQ | ETF | 493.87 | 494.39 | 493.19 | 494.25 | 1718819.0 |
| 2024-10-21 13:00:00 | QQQ | ETF | 494.24 | 494.9091 | 493.92 | 494.79 | 1766674.0 |
| 2024-10-21 14:00:00 | QQQ | ETF | 494.8 | 494.9 | 493.82 | 493.95 | 1705720.0 |
| 2024-10-21 15:00:00 | QQQ | ETF | 493.96 | 495.53 | 493.68 | 495.48 | 4024871.0 |
| 2024-10-21 16:00:00 | QQQ | ETF | 495.48 | 496.11 | 494.4706 | 495.93 | 1903154.0 |
| 2024-10-21 17:00:00 | QQQ | ETF | 496.02 | 496.02 | 495.42 | 495.94 | 73035.0 |
| 2024-10-21 18:00:00 | QQQ | ETF | 495.93 | 495.97 | 495.38 | 495.4 | 48002.0 |
| 2024-10-21 19:00:00 | QQQ | ETF | 495.4 | 495.59 | 495.2399 | 495.4 | 51554.0 |
| 2024-10-21 04:00:00 | IWM | ETF | 225.61 | 226.16 | 225.61 | 226.16 | 10200.0 |
| 2024-10-21 05:00:00 | IWM | ETF | 226.03 | 226.08 | 225.64 | 225.65 | 3274.0 |
| 2024-10-21 06:00:00 | IWM | ETF | 225.56 | 225.6 | 224.81 | 224.82 | 16329.0 |
| 2024-10-21 07:00:00 | IWM | ETF | 224.87 | 224.99 | 224.66 | 224.75 | 40704.0 |
| 2024-10-21 08:00:00 | IWM | ETF | 224.8691 | 225.9796 | 224.67 | 225.47 | 64809.0 |
| 2024-10-21 09:00:00 | IWM | ETF | 225.46 | 225.69 | 224.34 | 224.49 | 2581030.0 |
| 2024-10-21 10:00:00 | IWM | ETF | 224.51 | 224.59 | 222.47 | 222.56 | 3305901.0 |
| 2024-10-21 11:00:00 | IWM | ETF | 222.56 | 222.61 | 221.53 | 222.36 | 3352415.0 |
| 2024-10-21 12:00:00 | IWM | ETF | 222.35 | 222.43 | 221.95 | 222.34 | 1408542.0 |
| 2024-10-21 13:00:00 | IWM | ETF | 222.33 | 222.685 | 222.22 | 222.4301 | 1186140.0 |
| 2024-10-21 14:00:00 | IWM | ETF | 222.43 | 222.46 | 221.97 | 222.06 | 1420372.0 |
| 2024-10-21 15:00:00 | IWM | ETF | 222.06 | 222.36 | 221.85 | 222.09 | 3436705.0 |
| 2024-10-21 16:00:00 | IWM | ETF | 222.1 | 222.26 | 222.0 | 222.19 | 1346589.0 |
| 2024-10-21 17:00:00 | IWM | ETF | 222.2 | 222.26 | 222.1 | 222.15 | 113453.0 |
| 2024-10-21 18:00:00 | IWM | ETF | 222.14 | 222.25 | 221.81 | 221.87 | 38953.0 |
| 2024-10-21 19:00:00 | IWM | ETF | 221.91 | 222.02 | 221.79 | 221.79 | 27214.0 |
| 2024-10-21 04:00:00 | DIA | ETF | 433.1 | 433.1 | 433.02 | 433.02 | 1371.0 |
| 2024-10-21 05:00:00 | DIA | ETF | 432.89 | 432.89 | 432.35 | 432.37 | 950.0 |
> showing 50 of 21,877 rows — these rows as CSV