PREVIEW / etf_1hour / 2024-08-06
file: by_date/etf_1hour/2024/2024-08-06.parquet size: 575 KB rows: 21,895
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-08-06 04:00:00 | SPY | ETF | 523.91 | 523.91 | 520.42 | 521.43 | 39219.0 |
| 2024-08-06 05:00:00 | SPY | ETF | 521.23 | 521.23 | 518.5 | 519.88 | 91340.0 |
| 2024-08-06 06:00:00 | SPY | ETF | 519.5 | 522.17 | 519.0 | 521.82 | 67443.0 |
| 2024-08-06 07:00:00 | SPY | ETF | 521.88 | 523.12 | 520.41 | 521.54 | 442694.0 |
| 2024-08-06 08:00:00 | SPY | ETF | 522.49 | 525.5 | 518.8096 | 519.45 | 531567.0 |
| 2024-08-06 09:00:00 | SPY | ETF | 519.46 | 522.44 | 517.87 | 521.8858 | 8570876.0 |
| 2024-08-06 10:00:00 | SPY | ETF | 521.89 | 526.51 | 521.18 | 525.39 | 8109397.0 |
| 2024-08-06 11:00:00 | SPY | ETF | 525.39 | 526.03 | 522.39 | 525.9 | 5299062.0 |
| 2024-08-06 12:00:00 | SPY | ETF | 525.9 | 528.05 | 525.51 | 527.63 | 3796600.0 |
| 2024-08-06 13:00:00 | SPY | ETF | 527.63 | 528.45 | 527.06 | 527.93 | 3784737.0 |
| 2024-08-06 14:00:00 | SPY | ETF | 527.92 | 529.75 | 526.9 | 527.47 | 5482815.0 |
| 2024-08-06 15:00:00 | SPY | ETF | 527.51 | 527.65 | 521.97 | 522.19 | 19336595.0 |
| 2024-08-06 16:00:00 | SPY | ETF | 522.19 | 523.68 | 519.6 | 520.57 | 5464154.0 |
| 2024-08-06 17:00:00 | SPY | ETF | 520.53 | 520.95 | 519.08 | 519.45 | 158170.0 |
| 2024-08-06 18:00:00 | SPY | ETF | 519.45 | 521.84 | 519.45 | 520.71 | 250297.0 |
| 2024-08-06 19:00:00 | SPY | ETF | 520.71 | 521.23 | 519.712 | 519.94 | 77060.0 |
| 2024-08-06 04:00:00 | QQQ | ETF | 442.7 | 442.7 | 438.6 | 439.61 | 155478.0 |
| 2024-08-06 05:00:00 | QQQ | ETF | 439.22 | 439.22 | 435.8 | 437.47 | 148756.0 |
| 2024-08-06 06:00:00 | QQQ | ETF | 437.75 | 439.84 | 436.68 | 439.46 | 121925.0 |
| 2024-08-06 07:00:00 | QQQ | ETF | 439.52 | 441.53 | 438.38 | 440.05 | 267765.0 |
| 2024-08-06 08:00:00 | QQQ | ETF | 440.48 | 445.25 | 435.044 | 437.42 | 515784.0 |
| 2024-08-06 09:00:00 | QQQ | ETF | 437.42 | 439.6 | 434.56 | 438.8 | 6825300.0 |
| 2024-08-06 10:00:00 | QQQ | ETF | 438.78 | 443.62 | 437.89 | 442.7099 | 7577468.0 |
| 2024-08-06 11:00:00 | QQQ | ETF | 442.7 | 443.84 | 439.83 | 443.68 | 4562564.0 |
| 2024-08-06 12:00:00 | QQQ | ETF | 443.69 | 446.17 | 443.0507 | 445.74 | 3990359.0 |
| 2024-08-06 13:00:00 | QQQ | ETF | 445.76 | 446.25 | 444.59 | 445.5302 | 3567970.0 |
| 2024-08-06 14:00:00 | QQQ | ETF | 445.6 | 447.07 | 444.725 | 444.8 | 2843836.0 |
| 2024-08-06 15:00:00 | QQQ | ETF | 444.83 | 444.88 | 439.42 | 439.6 | 10479901.0 |
| 2024-08-06 16:00:00 | QQQ | ETF | 439.59 | 442.0 | 437.13 | 437.9 | 3150304.0 |
| 2024-08-06 17:00:00 | QQQ | ETF | 437.84 | 439.53 | 435.34 | 435.9 | 249958.0 |
| 2024-08-06 18:00:00 | QQQ | ETF | 435.96 | 438.72 | 435.96 | 437.64 | 375472.0 |
| 2024-08-06 19:00:00 | QQQ | ETF | 437.84 | 438.38 | 436.49 | 436.65 | 168242.0 |
| 2024-08-06 04:00:00 | IWM | ETF | 205.34 | 205.34 | 203.69 | 204.03 | 35960.0 |
| 2024-08-06 05:00:00 | IWM | ETF | 203.72 | 203.75 | 202.2 | 202.55 | 28107.0 |
| 2024-08-06 06:00:00 | IWM | ETF | 202.61 | 204.26 | 202.13 | 203.76 | 51067.0 |
| 2024-08-06 07:00:00 | IWM | ETF | 203.84 | 204.65 | 203.37 | 203.93 | 154017.0 |
| 2024-08-06 08:00:00 | IWM | ETF | 203.79 | 206.24 | 202.4204 | 202.76 | 249290.0 |
| 2024-08-06 09:00:00 | IWM | ETF | 202.67 | 203.87 | 201.2 | 203.83 | 5794539.0 |
| 2024-08-06 10:00:00 | IWM | ETF | 203.79 | 206.515 | 203.2 | 205.5645 | 5204215.0 |
| 2024-08-06 11:00:00 | IWM | ETF | 205.55 | 205.75 | 203.27 | 204.74 | 3081964.0 |
| 2024-08-06 12:00:00 | IWM | ETF | 204.76 | 205.54 | 204.54 | 205.37 | 2166872.0 |
| 2024-08-06 13:00:00 | IWM | ETF | 205.41 | 206.33 | 205.08 | 206.01 | 1490816.0 |
| 2024-08-06 14:00:00 | IWM | ETF | 206.05 | 207.25 | 205.78 | 205.88 | 2361605.0 |
| 2024-08-06 15:00:00 | IWM | ETF | 205.88 | 206.14 | 204.4 | 204.45 | 5969768.0 |
| 2024-08-06 16:00:00 | IWM | ETF | 204.48 | 204.54 | 203.46 | 203.72 | 1379876.0 |
| 2024-08-06 17:00:00 | IWM | ETF | 203.878 | 203.88 | 202.75 | 202.95 | 36647.0 |
| 2024-08-06 18:00:00 | IWM | ETF | 203.25 | 204.1 | 202.99 | 203.74 | 89433.0 |
| 2024-08-06 19:00:00 | IWM | ETF | 203.78 | 203.8 | 202.57 | 202.83 | 52589.0 |
| 2024-08-06 04:00:00 | DIA | ETF | 390.0 | 390.0 | 388.5 | 388.85 | 4388.0 |
| 2024-08-06 05:00:00 | DIA | ETF | 388.69 | 388.69 | 387.77 | 388.08 | 2533.0 |
> showing 50 of 21,895 rows — these rows as CSV