PREVIEW / etf_1hour / 2024-04-15
file: by_date/etf_1hour/2024/2024-04-15.parquet size: 551 KB rows: 20,923
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-04-15 04:00:00 | SPY | ETF | 513.63 | 513.71 | 512.61 | 513.38 | 35237.0 |
| 2024-04-15 05:00:00 | SPY | ETF | 513.32 | 513.8 | 512.8 | 513.05 | 71277.0 |
| 2024-04-15 06:00:00 | SPY | ETF | 513.15 | 513.44 | 512.86 | 513.0 | 69442.0 |
| 2024-04-15 07:00:00 | SPY | ETF | 512.94 | 513.85 | 512.38 | 513.6 | 448365.0 |
| 2024-04-15 08:00:00 | SPY | ETF | 513.61 | 515.19 | 512.15 | 514.73 | 884837.0 |
| 2024-04-15 09:00:00 | SPY | ETF | 514.74 | 515.33 | 514.19 | 514.89 | 7335291.0 |
| 2024-04-15 10:00:00 | SPY | ETF | 514.9 | 515.01 | 511.07 | 511.1001 | 9961268.0 |
| 2024-04-15 11:00:00 | SPY | ETF | 511.11 | 512.6 | 510.81 | 512.315 | 6589923.0 |
| 2024-04-15 12:00:00 | SPY | ETF | 512.32 | 512.62 | 509.51 | 510.075 | 5963804.0 |
| 2024-04-15 13:00:00 | SPY | ETF | 510.06 | 510.56 | 505.01 | 506.365 | 12222419.0 |
| 2024-04-15 14:00:00 | SPY | ETF | 506.3706 | 506.49 | 504.425 | 505.14 | 9822802.0 |
| 2024-04-15 15:00:00 | SPY | ETF | 505.11 | 505.27 | 503.58 | 504.5 | 15482496.0 |
| 2024-04-15 16:00:00 | SPY | ETF | 504.5 | 504.5894 | 503.65 | 504.23 | 3767720.0 |
| 2024-04-15 17:00:00 | SPY | ETF | 504.3 | 504.3 | 503.9 | 504.1 | 118398.0 |
| 2024-04-15 18:00:00 | SPY | ETF | 504.1 | 504.74 | 504.1 | 504.68 | 141125.0 |
| 2024-04-15 19:00:00 | SPY | ETF | 504.46 | 504.79 | 503.69 | 504.49 | 98939.0 |
| 2024-04-15 04:00:00 | QQQ | ETF | 440.77 | 440.85 | 440.02 | 440.63 | 485580.0 |
| 2024-04-15 05:00:00 | QQQ | ETF | 440.63 | 441.05 | 440.24 | 440.42 | 169886.0 |
| 2024-04-15 06:00:00 | QQQ | ETF | 440.55 | 440.91 | 440.39 | 440.61 | 157574.0 |
| 2024-04-15 07:00:00 | QQQ | ETF | 440.6 | 441.1 | 440.35 | 440.949 | 172418.0 |
| 2024-04-15 08:00:00 | QQQ | ETF | 440.96 | 442.29 | 438.598 | 441.96 | 806340.0 |
| 2024-04-15 09:00:00 | QQQ | ETF | 442.03 | 442.42 | 440.27 | 441.34 | 4747736.0 |
| 2024-04-15 10:00:00 | QQQ | ETF | 441.34 | 441.84 | 438.12 | 438.14 | 6357639.0 |
| 2024-04-15 11:00:00 | QQQ | ETF | 438.13 | 439.39 | 437.82 | 439.09 | 3918343.0 |
| 2024-04-15 12:00:00 | QQQ | ETF | 439.08 | 439.48 | 436.05 | 436.67 | 3079941.0 |
| 2024-04-15 13:00:00 | QQQ | ETF | 436.65 | 437.2 | 431.05 | 432.1701 | 11640886.0 |
| 2024-04-15 14:00:00 | QQQ | ETF | 432.19 | 432.55 | 430.83 | 431.31 | 5742484.0 |
| 2024-04-15 15:00:00 | QQQ | ETF | 431.3 | 431.74 | 430.21 | 430.99 | 10954325.0 |
| 2024-04-15 16:00:00 | QQQ | ETF | 430.99 | 431.16 | 430.27 | 431.06 | 2430516.0 |
| 2024-04-15 17:00:00 | QQQ | ETF | 431.03 | 431.06 | 430.51 | 430.83 | 208388.0 |
| 2024-04-15 18:00:00 | QQQ | ETF | 430.89 | 431.379 | 430.89 | 431.11 | 138368.0 |
| 2024-04-15 19:00:00 | QQQ | ETF | 431.1 | 431.11 | 430.3 | 430.89 | 70437.0 |
| 2024-04-15 04:00:00 | IWM | ETF | 199.68 | 200.15 | 199.68 | 199.83 | 38967.0 |
| 2024-04-15 05:00:00 | IWM | ETF | 199.71 | 199.92 | 199.11 | 199.11 | 26928.0 |
| 2024-04-15 06:00:00 | IWM | ETF | 199.36 | 199.46 | 198.95 | 199.09 | 56032.0 |
| 2024-04-15 07:00:00 | IWM | ETF | 199.2 | 199.73 | 199.09 | 199.41 | 104031.0 |
| 2024-04-15 08:00:00 | IWM | ETF | 199.15 | 200.0 | 198.09 | 199.33 | 431593.0 |
| 2024-04-15 09:00:00 | IWM | ETF | 199.45 | 200.23 | 199.03 | 199.51 | 3632554.0 |
| 2024-04-15 10:00:00 | IWM | ETF | 199.5 | 199.55 | 197.51 | 197.53 | 5064357.0 |
| 2024-04-15 11:00:00 | IWM | ETF | 197.53 | 198.1 | 196.83 | 197.99 | 3621254.0 |
| 2024-04-15 12:00:00 | IWM | ETF | 197.99 | 198.29 | 196.92 | 196.97 | 2231601.0 |
| 2024-04-15 13:00:00 | IWM | ETF | 196.965 | 197.1525 | 195.5 | 196.39 | 4712157.0 |
| 2024-04-15 14:00:00 | IWM | ETF | 196.39 | 196.48 | 195.17 | 195.45 | 3892156.0 |
| 2024-04-15 15:00:00 | IWM | ETF | 195.43 | 196.08 | 194.98 | 195.81 | 6645560.0 |
| 2024-04-15 16:00:00 | IWM | ETF | 195.78 | 198.1273 | 195.49 | 195.92 | 1149316.0 |
| 2024-04-15 17:00:00 | IWM | ETF | 196.0 | 196.0 | 195.65 | 195.66 | 1130486.0 |
| 2024-04-15 18:00:00 | IWM | ETF | 195.75 | 196.09 | 195.75 | 195.83 | 46762.0 |
| 2024-04-15 19:00:00 | IWM | ETF | 195.8095 | 195.8095 | 195.35 | 195.61 | 55417.0 |
| 2024-04-15 04:00:00 | DIA | ETF | 381.5 | 381.5 | 381.45 | 381.45 | 200.0 |
| 2024-04-15 05:00:00 | DIA | ETF | 381.17 | 381.17 | 380.6 | 380.81 | 300.0 |
> showing 50 of 20,923 rows — these rows as CSV