PREVIEW / etf_1hour / 2024-06-11
file: by_date/etf_1hour/2024/2024-06-11.parquet size: 532 KB rows: 19,610
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-06-11 04:00:00 | SPY | ETF | 535.92 | 535.92 | 534.64 | 534.64 | 20203.0 |
| 2024-06-11 05:00:00 | SPY | ETF | 534.55 | 534.76 | 534.25 | 534.25 | 11988.0 |
| 2024-06-11 06:00:00 | SPY | ETF | 534.05 | 534.48 | 533.81 | 534.43 | 25905.0 |
| 2024-06-11 07:00:00 | SPY | ETF | 534.41 | 534.41 | 533.55 | 534.11 | 113205.0 |
| 2024-06-11 08:00:00 | SPY | ETF | 533.9 | 535.88 | 533.6 | 534.13 | 150401.0 |
| 2024-06-11 09:00:00 | SPY | ETF | 534.1 | 534.39 | 532.05 | 532.765 | 3269317.0 |
| 2024-06-11 10:00:00 | SPY | ETF | 532.76 | 534.71 | 532.58 | 534.69 | 2911059.0 |
| 2024-06-11 11:00:00 | SPY | ETF | 534.71 | 534.76 | 533.6708 | 533.8101 | 2698935.0 |
| 2024-06-11 12:00:00 | SPY | ETF | 533.82 | 534.27 | 533.55 | 534.1 | 1615771.0 |
| 2024-06-11 13:00:00 | SPY | ETF | 534.12 | 535.24 | 533.72 | 535.2 | 2512119.0 |
| 2024-06-11 14:00:00 | SPY | ETF | 535.21 | 536.64 | 534.94 | 536.2 | 3530229.0 |
| 2024-06-11 15:00:00 | SPY | ETF | 536.2 | 537.01 | 535.62 | 536.91 | 7800832.0 |
| 2024-06-11 16:00:00 | SPY | ETF | 536.9 | 537.12 | 536.394 | 536.94 | 1926248.0 |
| 2024-06-11 17:00:00 | SPY | ETF | 536.92 | 536.98 | 536.79 | 536.94 | 74377.0 |
| 2024-06-11 18:00:00 | SPY | ETF | 536.94 | 537.03 | 536.6 | 537.03 | 55410.0 |
| 2024-06-11 19:00:00 | SPY | ETF | 537.06 | 537.21 | 536.95 | 537.0299 | 29519.0 |
| 2024-06-11 04:00:00 | QQQ | ETF | 464.46 | 464.62 | 463.56 | 463.65 | 15332.0 |
| 2024-06-11 05:00:00 | QQQ | ETF | 463.7 | 463.95 | 463.4 | 463.4 | 12747.0 |
| 2024-06-11 06:00:00 | QQQ | ETF | 463.2 | 463.73 | 463.11 | 463.56 | 24062.0 |
| 2024-06-11 07:00:00 | QQQ | ETF | 463.62 | 463.62 | 462.9 | 463.46 | 62257.0 |
| 2024-06-11 08:00:00 | QQQ | ETF | 463.6 | 464.8 | 462.87 | 463.51 | 88251.0 |
| 2024-06-11 09:00:00 | QQQ | ETF | 463.46 | 464.83 | 462.03 | 462.96 | 2432174.0 |
| 2024-06-11 10:00:00 | QQQ | ETF | 462.94 | 465.45 | 462.81 | 465.43 | 3057216.0 |
| 2024-06-11 11:00:00 | QQQ | ETF | 465.4 | 465.4799 | 463.705 | 464.03 | 2220377.0 |
| 2024-06-11 12:00:00 | QQQ | ETF | 464.05 | 464.86 | 463.98 | 464.56 | 938005.0 |
| 2024-06-11 13:00:00 | QQQ | ETF | 464.57 | 466.19 | 464.28 | 466.15 | 2061497.0 |
| 2024-06-11 14:00:00 | QQQ | ETF | 466.15 | 467.76 | 465.86 | 467.24 | 2655642.0 |
| 2024-06-11 15:00:00 | QQQ | ETF | 467.24 | 468.14 | 466.68 | 468.05 | 2947124.0 |
| 2024-06-11 16:00:00 | QQQ | ETF | 468.01 | 468.35 | 467.65 | 468.13 | 828499.0 |
| 2024-06-11 17:00:00 | QQQ | ETF | 468.13 | 468.15 | 467.94 | 468.01 | 49000.0 |
| 2024-06-11 18:00:00 | QQQ | ETF | 468.04 | 468.39 | 467.8 | 468.35 | 35291.0 |
| 2024-06-11 19:00:00 | QQQ | ETF | 468.38 | 468.61 | 468.22 | 468.31 | 43435.0 |
| 2024-06-11 04:00:00 | IWM | ETF | 200.82 | 201.28 | 200.1 | 200.18 | 23867.0 |
| 2024-06-11 05:00:00 | IWM | ETF | 200.18 | 200.24 | 199.87 | 199.87 | 18424.0 |
| 2024-06-11 06:00:00 | IWM | ETF | 199.75 | 200.05 | 199.65 | 199.91 | 26862.0 |
| 2024-06-11 07:00:00 | IWM | ETF | 199.929 | 200.11 | 199.5 | 199.99 | 282925.0 |
| 2024-06-11 08:00:00 | IWM | ETF | 199.9295 | 201.04 | 199.61 | 199.88 | 180689.0 |
| 2024-06-11 09:00:00 | IWM | ETF | 199.85 | 199.9 | 198.42 | 198.815 | 3075541.0 |
| 2024-06-11 10:00:00 | IWM | ETF | 198.82 | 199.58 | 198.68 | 199.55 | 2722650.0 |
| 2024-06-11 11:00:00 | IWM | ETF | 199.55 | 199.73 | 199.3001 | 199.52 | 2041745.0 |
| 2024-06-11 12:00:00 | IWM | ETF | 199.53 | 200.13 | 199.47 | 199.76 | 1930955.0 |
| 2024-06-11 13:00:00 | IWM | ETF | 199.76 | 200.65 | 199.49 | 200.5 | 2276103.0 |
| 2024-06-11 14:00:00 | IWM | ETF | 200.51 | 201.02 | 200.22 | 200.629 | 2481447.0 |
| 2024-06-11 15:00:00 | IWM | ETF | 200.63 | 200.839 | 200.36 | 200.59 | 3775220.0 |
| 2024-06-11 16:00:00 | IWM | ETF | 200.64 | 200.7 | 200.48 | 200.54 | 796640.0 |
| 2024-06-11 17:00:00 | IWM | ETF | 200.56 | 200.71 | 200.48 | 200.5 | 12653.0 |
| 2024-06-11 18:00:00 | IWM | ETF | 200.58 | 200.6 | 200.35 | 200.56 | 16539.0 |
| 2024-06-11 19:00:00 | IWM | ETF | 200.56 | 200.67 | 200.52 | 200.63 | 15228.0 |
| 2024-06-11 05:00:00 | DIA | ETF | 388.11 | 388.11 | 387.91 | 387.91 | 1250.0 |
| 2024-06-11 06:00:00 | DIA | ETF | 387.78 | 387.78 | 387.69 | 387.69 | 973.0 |
> showing 50 of 19,610 rows — these rows as CSV