PREVIEW / etf_1hour / 2024-08-13
file: by_date/etf_1hour/2024/2024-08-13.parquet size: 553 KB rows: 20,369
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-13 04:00:00 | SPY | ETF | 535.12 | 535.73 | 534.9 | 535.18 | 11998.0 |
| 2024-08-13 05:00:00 | SPY | ETF | 535.06 | 535.6 | 534.9 | 535.39 | 7703.0 |
| 2024-08-13 06:00:00 | SPY | ETF | 535.28 | 535.28 | 533.29 | 533.45 | 65982.0 |
| 2024-08-13 07:00:00 | SPY | ETF | 533.32 | 534.53 | 533.32 | 534.53 | 215622.0 |
| 2024-08-13 08:00:00 | SPY | ETF | 533.69 | 537.02 | 533.43 | 536.49 | 1142693.0 |
| 2024-08-13 09:00:00 | SPY | ETF | 536.58 | 538.45 | 535.6 | 537.78 | 4743018.0 |
| 2024-08-13 10:00:00 | SPY | ETF | 537.79 | 538.54 | 536.33 | 538.33 | 3768423.0 |
| 2024-08-13 11:00:00 | SPY | ETF | 538.35 | 539.2894 | 538.17 | 539.0 | 2157868.0 |
| 2024-08-13 12:00:00 | SPY | ETF | 539.01 | 541.12 | 538.73 | 541.03 | 3471416.0 |
| 2024-08-13 13:00:00 | SPY | ETF | 541.04 | 541.04 | 539.48 | 540.72 | 2836938.0 |
| 2024-08-13 14:00:00 | SPY | ETF | 540.73 | 541.48 | 540.28 | 541.42 | 2624544.0 |
| 2024-08-13 15:00:00 | SPY | ETF | 541.41 | 542.28 | 540.61 | 542.0 | 10248301.0 |
| 2024-08-13 16:00:00 | SPY | ETF | 542.0 | 542.08 | 541.47 | 541.7 | 4121082.0 |
| 2024-08-13 17:00:00 | SPY | ETF | 541.7 | 542.0 | 541.38 | 541.87 | 99787.0 |
| 2024-08-13 18:00:00 | SPY | ETF | 541.86 | 542.04 | 541.41 | 541.65 | 95174.0 |
| 2024-08-13 19:00:00 | SPY | ETF | 541.65 | 542.0081 | 541.59 | 541.94 | 38132.0 |
| 2024-08-13 04:00:00 | QQQ | ETF | 453.12 | 454.79 | 453.12 | 453.93 | 91016.0 |
| 2024-08-13 05:00:00 | QQQ | ETF | 453.87 | 454.34 | 453.6 | 453.96 | 13484.0 |
| 2024-08-13 06:00:00 | QQQ | ETF | 453.87 | 453.87 | 451.63 | 451.86 | 154498.0 |
| 2024-08-13 07:00:00 | QQQ | ETF | 451.77 | 453.15 | 451.6 | 453.15 | 102839.0 |
| 2024-08-13 08:00:00 | QQQ | ETF | 451.85 | 455.91 | 451.042 | 455.7 | 872751.0 |
| 2024-08-13 09:00:00 | QQQ | ETF | 455.72 | 457.979 | 455.1 | 457.66 | 4098347.0 |
| 2024-08-13 10:00:00 | QQQ | ETF | 457.67 | 458.9 | 456.633 | 458.675 | 3257853.0 |
| 2024-08-13 11:00:00 | QQQ | ETF | 458.71 | 460.05 | 458.51 | 459.626 | 2605613.0 |
| 2024-08-13 12:00:00 | QQQ | ETF | 459.65 | 461.88 | 459.27 | 461.85 | 3166394.0 |
| 2024-08-13 13:00:00 | QQQ | ETF | 461.88 | 462.18 | 460.22 | 461.46 | 2918009.0 |
| 2024-08-13 14:00:00 | QQQ | ETF | 461.46 | 462.13 | 460.9514 | 462.08 | 2343582.0 |
| 2024-08-13 15:00:00 | QQQ | ETF | 462.08 | 462.85 | 460.89 | 462.6 | 5966095.0 |
| 2024-08-13 16:00:00 | QQQ | ETF | 462.58 | 463.04 | 462.12 | 462.52 | 2317121.0 |
| 2024-08-13 17:00:00 | QQQ | ETF | 462.55 | 462.9 | 462.31 | 462.52 | 37725.0 |
| 2024-08-13 18:00:00 | QQQ | ETF | 462.5 | 463.05 | 462.24 | 462.5 | 51228.0 |
| 2024-08-13 19:00:00 | QQQ | ETF | 462.45 | 463.04 | 462.4 | 462.95 | 58618.0 |
| 2024-08-13 04:00:00 | IWM | ETF | 205.43 | 205.48 | 204.69 | 204.9 | 12775.0 |
| 2024-08-13 05:00:00 | IWM | ETF | 204.54 | 204.73 | 204.16 | 204.6 | 15834.0 |
| 2024-08-13 06:00:00 | IWM | ETF | 204.51 | 204.51 | 203.78 | 203.92 | 22257.0 |
| 2024-08-13 07:00:00 | IWM | ETF | 203.89 | 204.54 | 203.8 | 204.54 | 47682.0 |
| 2024-08-13 08:00:00 | IWM | ETF | 203.9699 | 206.74 | 203.87 | 206.22 | 546359.0 |
| 2024-08-13 09:00:00 | IWM | ETF | 206.2 | 206.83 | 205.31 | 206.03 | 2879734.0 |
| 2024-08-13 10:00:00 | IWM | ETF | 206.03 | 206.2 | 204.86 | 206.2 | 2793544.0 |
| 2024-08-13 11:00:00 | IWM | ETF | 206.2 | 206.405 | 205.82 | 206.28 | 1068062.0 |
| 2024-08-13 12:00:00 | IWM | ETF | 206.285 | 207.57 | 206.06 | 207.51 | 1734683.0 |
| 2024-08-13 13:00:00 | IWM | ETF | 207.51 | 207.56 | 206.6 | 207.23 | 1516311.0 |
| 2024-08-13 14:00:00 | IWM | ETF | 207.23 | 207.66 | 206.91 | 207.3528 | 1298030.0 |
| 2024-08-13 15:00:00 | IWM | ETF | 207.35 | 208.38 | 206.9995 | 207.9 | 4556936.0 |
| 2024-08-13 16:00:00 | IWM | ETF | 207.97 | 208.0 | 207.56 | 207.74 | 2516930.0 |
| 2024-08-13 17:00:00 | IWM | ETF | 207.6609 | 207.8 | 207.6176 | 207.69 | 15124.0 |
| 2024-08-13 18:00:00 | IWM | ETF | 207.81 | 207.97 | 207.7 | 207.75 | 16049.0 |
| 2024-08-13 19:00:00 | IWM | ETF | 207.75 | 207.9 | 207.7499 | 207.9 | 29622.0 |
| 2024-08-13 04:00:00 | DIA | ETF | 395.18 | 395.2 | 395.09 | 395.09 | 1900.0 |
| 2024-08-13 05:00:00 | DIA | ETF | 394.73 | 394.73 | 394.73 | 394.73 | 280.0 |
> showing 50 of 20,369 rows — these rows as CSV