PREVIEW / etf_1hour / 2024-08-14
file: by_date/etf_1hour/2024/2024-08-14.parquet size: 540 KB rows: 20,189
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-14 04:00:00 | SPY | ETF | 542.04 | 542.15 | 541.64 | 542.13 | 18876.0 |
| 2024-08-14 05:00:00 | SPY | ETF | 542.15 | 542.3 | 542.05 | 542.12 | 17117.0 |
| 2024-08-14 06:00:00 | SPY | ETF | 542.15 | 542.5 | 542.09 | 542.2 | 16397.0 |
| 2024-08-14 07:00:00 | SPY | ETF | 542.28 | 542.43 | 541.99 | 542.28 | 151156.0 |
| 2024-08-14 08:00:00 | SPY | ETF | 542.25 | 543.54 | 541.0 | 542.9182 | 1200926.0 |
| 2024-08-14 09:00:00 | SPY | ETF | 542.93 | 543.27 | 541.29 | 541.49 | 3984998.0 |
| 2024-08-14 10:00:00 | SPY | ETF | 541.495 | 542.42 | 540.12 | 542.36 | 3876795.0 |
| 2024-08-14 11:00:00 | SPY | ETF | 542.364 | 544.78 | 542.25 | 544.68 | 3364700.0 |
| 2024-08-14 12:00:00 | SPY | ETF | 544.67 | 544.96 | 541.8 | 543.08 | 3706382.0 |
| 2024-08-14 13:00:00 | SPY | ETF | 543.07 | 543.62 | 542.4803 | 543.28 | 1823153.0 |
| 2024-08-14 14:00:00 | SPY | ETF | 543.23 | 544.35 | 542.63 | 544.28 | 2539724.0 |
| 2024-08-14 15:00:00 | SPY | ETF | 544.27 | 544.69 | 542.75 | 543.78 | 8616217.0 |
| 2024-08-14 16:00:00 | SPY | ETF | 543.78 | 544.75 | 543.72 | 544.301 | 2344770.0 |
| 2024-08-14 17:00:00 | SPY | ETF | 544.44 | 544.67 | 544.31 | 544.5 | 53952.0 |
| 2024-08-14 18:00:00 | SPY | ETF | 544.4 | 544.43 | 543.88 | 544.1 | 34237.0 |
| 2024-08-14 19:00:00 | SPY | ETF | 544.12 | 544.34 | 543.51 | 543.73 | 30695.0 |
| 2024-08-14 04:00:00 | QQQ | ETF | 462.55 | 462.91 | 461.71 | 462.34 | 55773.0 |
| 2024-08-14 05:00:00 | QQQ | ETF | 462.29 | 462.62 | 462.03 | 462.53 | 70765.0 |
| 2024-08-14 06:00:00 | QQQ | ETF | 462.6 | 463.11 | 462.6 | 462.71 | 25978.0 |
| 2024-08-14 07:00:00 | QQQ | ETF | 462.85 | 463.07 | 462.45 | 462.81 | 90874.0 |
| 2024-08-14 08:00:00 | QQQ | ETF | 462.81 | 464.21 | 460.26 | 463.37 | 1212178.0 |
| 2024-08-14 09:00:00 | QQQ | ETF | 463.4 | 464.43 | 460.48 | 460.89 | 4720897.0 |
| 2024-08-14 10:00:00 | QQQ | ETF | 460.91 | 461.95 | 458.4 | 461.805 | 5191539.0 |
| 2024-08-14 11:00:00 | QQQ | ETF | 461.84 | 465.1093 | 461.49 | 464.95 | 3260742.0 |
| 2024-08-14 12:00:00 | QQQ | ETF | 464.94 | 464.98 | 460.65 | 461.93 | 2923624.0 |
| 2024-08-14 13:00:00 | QQQ | ETF | 461.91 | 462.67 | 461.5 | 461.94 | 1605641.0 |
| 2024-08-14 14:00:00 | QQQ | ETF | 461.94 | 462.91 | 461.3 | 462.84 | 1782855.0 |
| 2024-08-14 15:00:00 | QQQ | ETF | 462.82 | 463.63 | 461.15 | 462.81 | 4315635.0 |
| 2024-08-14 16:00:00 | QQQ | ETF | 462.79 | 464.1 | 462.69 | 463.7 | 685590.0 |
| 2024-08-14 17:00:00 | QQQ | ETF | 463.77 | 464.08 | 463.2 | 463.92 | 79857.0 |
| 2024-08-14 18:00:00 | QQQ | ETF | 463.88 | 463.88 | 463.16 | 463.3 | 57050.0 |
| 2024-08-14 19:00:00 | QQQ | ETF | 463.37 | 463.69 | 462.66 | 462.81 | 129062.0 |
| 2024-08-14 04:00:00 | IWM | ETF | 208.09 | 208.31 | 208.01 | 208.2 | 12785.0 |
| 2024-08-14 05:00:00 | IWM | ETF | 208.12 | 208.6 | 208.12 | 208.45 | 3852.0 |
| 2024-08-14 06:00:00 | IWM | ETF | 208.52 | 209.08 | 208.4 | 209.08 | 97520.0 |
| 2024-08-14 07:00:00 | IWM | ETF | 209.07 | 209.49 | 208.62 | 209.36 | 240690.0 |
| 2024-08-14 08:00:00 | IWM | ETF | 208.8219 | 211.46 | 207.29 | 208.85 | 1408292.0 |
| 2024-08-14 09:00:00 | IWM | ETF | 208.8 | 209.3 | 206.45 | 206.6101 | 3565038.0 |
| 2024-08-14 10:00:00 | IWM | ETF | 206.65 | 206.95 | 205.83 | 206.46 | 3229696.0 |
| 2024-08-14 11:00:00 | IWM | ETF | 206.47 | 207.57 | 206.2661 | 207.55 | 1852809.0 |
| 2024-08-14 12:00:00 | IWM | ETF | 207.55 | 207.64 | 205.74 | 206.35 | 2070864.0 |
| 2024-08-14 13:00:00 | IWM | ETF | 206.33 | 206.8 | 205.8 | 206.69 | 1137963.0 |
| 2024-08-14 14:00:00 | IWM | ETF | 206.69 | 206.88 | 206.01 | 206.82 | 1582557.0 |
| 2024-08-14 15:00:00 | IWM | ETF | 206.81 | 207.02 | 206.3495 | 206.66 | 3047306.0 |
| 2024-08-14 16:00:00 | IWM | ETF | 206.68 | 206.91 | 206.65 | 206.71 | 844335.0 |
| 2024-08-14 17:00:00 | IWM | ETF | 206.71 | 206.91 | 206.68 | 206.8 | 32666.0 |
| 2024-08-14 18:00:00 | IWM | ETF | 206.81 | 206.82 | 206.52 | 206.66 | 17831.0 |
| 2024-08-14 19:00:00 | IWM | ETF | 206.63 | 206.78 | 206.37 | 206.45 | 37299.0 |
| 2024-08-14 04:00:00 | DIA | ETF | 398.02 | 398.44 | 398.02 | 398.44 | 503.0 |
| 2024-08-14 05:00:00 | DIA | ETF | 398.4 | 398.4 | 398.38 | 398.38 | 250.0 |
> showing 50 of 20,189 rows — these rows as CSV