PREVIEW / etf_1hour / 2024-02-13
file: by_date/etf_1hour/2024/2024-02-13.parquet size: 550 KB rows: 20,400
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-02-13 04:00:00 | SPY | ETF | 499.54 | 499.8 | 499.28 | 499.46 | 18091.0 |
| 2024-02-13 05:00:00 | SPY | ETF | 499.42 | 499.5 | 498.95 | 499.17 | 19445.0 |
| 2024-02-13 06:00:00 | SPY | ETF | 499.2 | 499.45 | 499.02 | 499.02 | 135786.0 |
| 2024-02-13 07:00:00 | SPY | ETF | 499.06 | 499.28 | 498.71 | 499.14 | 136817.0 |
| 2024-02-13 08:00:00 | SPY | ETF | 499.1296 | 500.93 | 494.59 | 494.78 | 2563270.0 |
| 2024-02-13 09:00:00 | SPY | ETF | 494.86 | 495.19 | 493.62 | 493.825 | 10482270.0 |
| 2024-02-13 10:00:00 | SPY | ETF | 493.825 | 495.32 | 493.22 | 494.56 | 12076074.0 |
| 2024-02-13 11:00:00 | SPY | ETF | 494.57 | 495.85 | 494.56 | 495.0899 | 6503117.0 |
| 2024-02-13 12:00:00 | SPY | ETF | 495.08 | 495.31 | 494.15 | 494.33 | 5163136.0 |
| 2024-02-13 13:00:00 | SPY | ETF | 494.32 | 494.4799 | 493.36 | 493.59 | 5758517.0 |
| 2024-02-13 14:00:00 | SPY | ETF | 493.585 | 493.59 | 491.09 | 491.4 | 11555156.0 |
| 2024-02-13 15:00:00 | SPY | ETF | 491.39 | 494.21 | 490.715 | 494.14 | 25470344.0 |
| 2024-02-13 16:00:00 | SPY | ETF | 494.14 | 494.41 | 490.98 | 494.33 | 8105182.0 |
| 2024-02-13 17:00:00 | SPY | ETF | 494.29 | 494.74 | 494.26 | 494.55 | 231880.0 |
| 2024-02-13 18:00:00 | SPY | ETF | 494.55 | 494.56 | 494.11 | 494.29 | 208324.0 |
| 2024-02-13 19:00:00 | SPY | ETF | 494.3 | 494.37 | 493.97 | 494.27 | 112649.0 |
| 2024-02-13 04:00:00 | QQQ | ETF | 433.65 | 434.0 | 433.06 | 433.1 | 46437.0 |
| 2024-02-13 05:00:00 | QQQ | ETF | 433.11 | 433.2 | 432.5 | 432.7 | 81524.0 |
| 2024-02-13 06:00:00 | QQQ | ETF | 432.69 | 432.82 | 432.33 | 432.42 | 65291.0 |
| 2024-02-13 07:00:00 | QQQ | ETF | 432.43 | 432.51 | 431.63 | 432.25 | 239152.0 |
| 2024-02-13 08:00:00 | QQQ | ETF | 435.01 | 435.3 | 427.54 | 428.1 | 2567034.0 |
| 2024-02-13 09:00:00 | QQQ | ETF | 428.01 | 428.665 | 426.28 | 428.4206 | 8560975.0 |
| 2024-02-13 10:00:00 | QQQ | ETF | 428.415 | 431.27 | 427.38 | 429.69 | 8205525.0 |
| 2024-02-13 11:00:00 | QQQ | ETF | 429.7 | 430.91 | 429.43 | 429.57 | 4238739.0 |
| 2024-02-13 12:00:00 | QQQ | ETF | 429.56 | 429.73 | 428.18 | 428.41 | 3546193.0 |
| 2024-02-13 13:00:00 | QQQ | ETF | 428.41 | 428.99 | 427.78 | 428.015 | 3300891.0 |
| 2024-02-13 14:00:00 | QQQ | ETF | 428.01 | 428.01 | 425.9 | 426.11 | 6053426.0 |
| 2024-02-13 15:00:00 | QQQ | ETF | 426.11 | 428.56 | 425.3305 | 428.52 | 11321309.0 |
| 2024-02-13 16:00:00 | QQQ | ETF | 428.55 | 429.1 | 428.31 | 429.0 | 2298795.0 |
| 2024-02-13 17:00:00 | QQQ | ETF | 429.0 | 429.3399 | 429.0 | 429.3 | 80530.0 |
| 2024-02-13 18:00:00 | QQQ | ETF | 429.3 | 429.3 | 428.62 | 428.84 | 108359.0 |
| 2024-02-13 19:00:00 | QQQ | ETF | 428.8 | 428.91 | 428.45 | 428.72 | 83741.0 |
| 2024-02-13 04:00:00 | IWM | ETF | 202.91 | 202.91 | 201.97 | 202.51 | 22395.0 |
| 2024-02-13 05:00:00 | IWM | ETF | 202.47 | 202.52 | 201.99 | 202.23 | 14833.0 |
| 2024-02-13 06:00:00 | IWM | ETF | 202.2 | 202.43 | 202.16 | 202.24 | 39921.0 |
| 2024-02-13 07:00:00 | IWM | ETF | 202.26 | 202.82 | 202.07 | 202.57 | 78815.0 |
| 2024-02-13 08:00:00 | IWM | ETF | 202.14 | 203.35 | 196.07 | 196.49 | 2766002.0 |
| 2024-02-13 09:00:00 | IWM | ETF | 196.55 | 197.19 | 195.45 | 195.65 | 9310682.0 |
| 2024-02-13 10:00:00 | IWM | ETF | 195.65 | 196.67 | 194.395 | 196.23 | 10918682.0 |
| 2024-02-13 11:00:00 | IWM | ETF | 196.23 | 197.63 | 196.23 | 196.95 | 9454092.0 |
| 2024-02-13 12:00:00 | IWM | ETF | 196.94 | 197.01 | 195.995 | 196.27 | 4478214.0 |
| 2024-02-13 13:00:00 | IWM | ETF | 196.27 | 196.27 | 195.295 | 195.56 | 4814689.0 |
| 2024-02-13 14:00:00 | IWM | ETF | 195.57 | 195.57 | 193.81 | 193.92 | 7723239.0 |
| 2024-02-13 15:00:00 | IWM | ETF | 193.92 | 194.7 | 193.06 | 194.68 | 14432561.0 |
| 2024-02-13 16:00:00 | IWM | ETF | 194.61 | 194.91 | 193.7008 | 194.84 | 3100282.0 |
| 2024-02-13 17:00:00 | IWM | ETF | 194.86 | 195.12 | 194.79 | 195.0419 | 81468.0 |
| 2024-02-13 18:00:00 | IWM | ETF | 195.04 | 195.23 | 194.8 | 195.0 | 132387.0 |
| 2024-02-13 19:00:00 | IWM | ETF | 194.91 | 195.0 | 194.7 | 194.93 | 40755.0 |
| 2024-02-13 04:00:00 | DIA | ETF | 387.46 | 387.59 | 387.39 | 387.59 | 3631.0 |
| 2024-02-13 05:00:00 | DIA | ETF | 387.61 | 387.78 | 387.53 | 387.78 | 1345.0 |
> showing 50 of 20,400 rows — these rows as CSV