PREVIEW / etf_1hour / 2024-04-16
file: by_date/etf_1hour/2024/2024-04-16.parquet size: 536 KB rows: 20,448
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-16 04:00:00 | SPY | ETF | 504.4 | 504.54 | 504.04 | 504.51 | 37948.0 |
| 2024-04-16 05:00:00 | SPY | ETF | 504.3 | 504.49 | 503.24 | 503.8 | 29156.0 |
| 2024-04-16 06:00:00 | SPY | ETF | 503.87 | 504.48 | 503.1 | 504.43 | 100335.0 |
| 2024-04-16 07:00:00 | SPY | ETF | 504.45 | 506.24 | 504.36 | 506.03 | 557912.0 |
| 2024-04-16 08:00:00 | SPY | ETF | 506.02 | 506.19 | 503.4 | 505.5 | 616876.0 |
| 2024-04-16 09:00:00 | SPY | ETF | 505.5 | 505.76 | 502.95 | 504.44 | 7112416.0 |
| 2024-04-16 10:00:00 | SPY | ETF | 504.42 | 505.28 | 502.42 | 503.1015 | 7800410.0 |
| 2024-04-16 11:00:00 | SPY | ETF | 503.1 | 505.36 | 502.875 | 504.245 | 5735105.0 |
| 2024-04-16 12:00:00 | SPY | ETF | 504.24 | 505.1 | 503.5 | 504.5187 | 4390601.0 |
| 2024-04-16 13:00:00 | SPY | ETF | 504.55 | 505.05 | 502.21 | 503.9699 | 8973918.0 |
| 2024-04-16 14:00:00 | SPY | ETF | 503.96 | 506.5 | 502.6 | 505.8 | 9682826.0 |
| 2024-04-16 15:00:00 | SPY | ETF | 505.81 | 505.8598 | 503.295 | 503.49 | 12853598.0 |
| 2024-04-16 16:00:00 | SPY | ETF | 503.49 | 503.81 | 503.11 | 503.721 | 3077359.0 |
| 2024-04-16 17:00:00 | SPY | ETF | 503.78 | 503.98 | 503.769 | 503.97 | 71320.0 |
| 2024-04-16 18:00:00 | SPY | ETF | 503.97 | 504.37 | 503.86 | 504.15 | 164238.0 |
| 2024-04-16 19:00:00 | SPY | ETF | 504.1 | 505.0 | 503.97 | 504.91 | 77195.0 |
| 2024-04-16 04:00:00 | QQQ | ETF | 431.0 | 431.22 | 430.62 | 431.02 | 77282.0 |
| 2024-04-16 05:00:00 | QQQ | ETF | 430.8 | 431.09 | 429.83 | 430.16 | 56237.0 |
| 2024-04-16 06:00:00 | QQQ | ETF | 430.33 | 430.69 | 429.08 | 430.6 | 105946.0 |
| 2024-04-16 07:00:00 | QQQ | ETF | 430.67 | 432.06 | 430.5 | 431.91 | 284283.0 |
| 2024-04-16 08:00:00 | QQQ | ETF | 430.9 | 432.05 | 429.3404 | 431.56 | 429859.0 |
| 2024-04-16 09:00:00 | QQQ | ETF | 431.46 | 431.9285 | 429.78 | 431.6 | 4838077.0 |
| 2024-04-16 10:00:00 | QQQ | ETF | 431.6 | 432.41 | 430.07 | 430.74 | 5610169.0 |
| 2024-04-16 11:00:00 | QQQ | ETF | 430.77 | 432.53 | 430.49 | 431.42 | 3909383.0 |
| 2024-04-16 12:00:00 | QQQ | ETF | 431.42 | 432.38 | 430.74 | 431.95 | 2648531.0 |
| 2024-04-16 13:00:00 | QQQ | ETF | 431.96 | 432.35 | 429.7 | 431.37 | 5572341.0 |
| 2024-04-16 14:00:00 | QQQ | ETF | 431.4 | 433.76 | 430.34 | 432.88 | 6008773.0 |
| 2024-04-16 15:00:00 | QQQ | ETF | 432.89 | 432.99 | 430.99 | 431.08 | 6320893.0 |
| 2024-04-16 16:00:00 | QQQ | ETF | 431.08 | 431.55 | 430.99 | 431.48 | 1033297.0 |
| 2024-04-16 17:00:00 | QQQ | ETF | 431.53 | 431.74 | 431.51 | 431.74 | 35014.0 |
| 2024-04-16 18:00:00 | QQQ | ETF | 431.66 | 431.98 | 431.58 | 431.85 | 154681.0 |
| 2024-04-16 19:00:00 | QQQ | ETF | 431.85 | 432.6 | 431.69 | 432.559 | 37535.0 |
| 2024-04-16 04:00:00 | IWM | ETF | 195.42 | 195.44 | 195.0 | 195.2 | 11402.0 |
| 2024-04-16 05:00:00 | IWM | ETF | 195.0 | 195.25 | 194.4 | 194.58 | 41465.0 |
| 2024-04-16 06:00:00 | IWM | ETF | 194.63 | 194.64 | 194.1 | 194.36 | 84618.0 |
| 2024-04-16 07:00:00 | IWM | ETF | 194.43 | 195.35 | 194.42 | 195.32 | 222122.0 |
| 2024-04-16 08:00:00 | IWM | ETF | 194.8 | 195.67 | 194.42 | 194.85 | 275549.0 |
| 2024-04-16 09:00:00 | IWM | ETF | 194.8 | 195.0 | 193.36 | 193.92 | 4642687.0 |
| 2024-04-16 10:00:00 | IWM | ETF | 193.92 | 194.64 | 193.4 | 194.13 | 4075243.0 |
| 2024-04-16 11:00:00 | IWM | ETF | 194.13 | 195.4999 | 194.11 | 194.9918 | 3306353.0 |
| 2024-04-16 12:00:00 | IWM | ETF | 195.0 | 195.51 | 194.62 | 195.375 | 2484359.0 |
| 2024-04-16 13:00:00 | IWM | ETF | 195.385 | 195.6998 | 193.96 | 194.905 | 5440258.0 |
| 2024-04-16 14:00:00 | IWM | ETF | 194.91 | 196.24 | 194.45 | 195.6499 | 4924100.0 |
| 2024-04-16 15:00:00 | IWM | ETF | 195.66 | 195.66 | 194.65 | 195.09 | 5006012.0 |
| 2024-04-16 16:00:00 | IWM | ETF | 195.06 | 195.25 | 194.88 | 195.14 | 1953948.0 |
| 2024-04-16 17:00:00 | IWM | ETF | 195.06 | 195.18 | 195.06 | 195.17 | 21168.0 |
| 2024-04-16 18:00:00 | IWM | ETF | 195.18 | 195.39 | 195.18 | 195.36 | 16784.0 |
| 2024-04-16 19:00:00 | IWM | ETF | 195.29 | 195.78 | 195.16 | 195.73 | 24261.0 |
| 2024-04-16 04:00:00 | DIA | ETF | 377.01 | 377.01 | 376.9 | 376.9 | 500.0 |
| 2024-04-16 05:00:00 | DIA | ETF | 376.75 | 376.75 | 376.75 | 376.75 | 500.0 |
> showing 50 of 20,448 rows — these rows as CSV