PREVIEW / etf_1hour / 2024-03-11
file: by_date/etf_1hour/2024/2024-03-11.parquet size: 531 KB rows: 20,069
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-03-11 04:00:00 | SPY | ETF | 511.3 | 511.55 | 509.72 | 510.67 | 18181.0 |
| 2024-03-11 05:00:00 | SPY | ETF | 510.99 | 511.41 | 510.82 | 511.16 | 50197.0 |
| 2024-03-11 06:00:00 | SPY | ETF | 511.23 | 511.66 | 510.52 | 511.35 | 20097.0 |
| 2024-03-11 07:00:00 | SPY | ETF | 511.46 | 511.5 | 510.34 | 510.6 | 40803.0 |
| 2024-03-11 08:00:00 | SPY | ETF | 510.9393 | 511.71 | 509.35 | 509.9 | 259422.0 |
| 2024-03-11 09:00:00 | SPY | ETF | 509.89 | 510.94 | 509.4299 | 509.4299 | 6278307.0 |
| 2024-03-11 10:00:00 | SPY | ETF | 509.43 | 510.73 | 508.5 | 510.59 | 7879049.0 |
| 2024-03-11 11:00:00 | SPY | ETF | 510.59 | 510.895 | 509.2 | 510.8399 | 5605842.0 |
| 2024-03-11 12:00:00 | SPY | ETF | 510.83 | 511.16 | 509.98 | 511.0 | 4877404.0 |
| 2024-03-11 13:00:00 | SPY | ETF | 511.0 | 511.57 | 510.2 | 511.05 | 4325020.0 |
| 2024-03-11 14:00:00 | SPY | ETF | 511.05 | 511.88 | 510.695 | 511.61 | 3478813.0 |
| 2024-03-11 15:00:00 | SPY | ETF | 511.6 | 511.6199 | 510.54 | 511.26 | 8927054.0 |
| 2024-03-11 16:00:00 | SPY | ETF | 511.26 | 511.85 | 511.13 | 511.76 | 3023567.0 |
| 2024-03-11 17:00:00 | SPY | ETF | 511.73 | 511.79 | 511.28 | 511.7 | 90525.0 |
| 2024-03-11 18:00:00 | SPY | ETF | 511.8 | 512.6 | 511.8 | 512.4 | 89404.0 |
| 2024-03-11 19:00:00 | SPY | ETF | 512.38 | 512.69 | 512.31 | 512.69 | 39082.0 |
| 2024-03-11 04:00:00 | QQQ | ETF | 438.68 | 439.02 | 436.65 | 438.09 | 95480.0 |
| 2024-03-11 05:00:00 | QQQ | ETF | 438.47 | 439.36 | 438.47 | 438.72 | 113728.0 |
| 2024-03-11 06:00:00 | QQQ | ETF | 438.89 | 439.3 | 437.86 | 438.88 | 85363.0 |
| 2024-03-11 07:00:00 | QQQ | ETF | 438.92 | 439.09 | 437.45 | 437.7 | 130921.0 |
| 2024-03-11 08:00:00 | QQQ | ETF | 437.67 | 439.349 | 436.22 | 436.96 | 661290.0 |
| 2024-03-11 09:00:00 | QQQ | ETF | 436.87 | 438.13 | 435.66 | 435.69 | 5561710.0 |
| 2024-03-11 10:00:00 | QQQ | ETF | 435.69 | 438.63 | 435.44 | 438.13 | 6074722.0 |
| 2024-03-11 11:00:00 | QQQ | ETF | 438.1 | 438.52 | 436.12 | 438.06 | 4501927.0 |
| 2024-03-11 12:00:00 | QQQ | ETF | 438.05 | 438.0889 | 436.8 | 437.84 | 3139574.0 |
| 2024-03-11 13:00:00 | QQQ | ETF | 437.85 | 438.27 | 436.65 | 437.46 | 3367145.0 |
| 2024-03-11 14:00:00 | QQQ | ETF | 437.47 | 438.66 | 437.09 | 438.11 | 3090065.0 |
| 2024-03-11 15:00:00 | QQQ | ETF | 438.1 | 438.11 | 436.8 | 437.35 | 6067885.0 |
| 2024-03-11 16:00:00 | QQQ | ETF | 437.37 | 438.38 | 437.28 | 438.06 | 1081744.0 |
| 2024-03-11 17:00:00 | QQQ | ETF | 438.04 | 438.1 | 437.9 | 438.1 | 59504.0 |
| 2024-03-11 18:00:00 | QQQ | ETF | 438.2 | 439.17 | 438.08 | 438.88 | 119601.0 |
| 2024-03-11 19:00:00 | QQQ | ETF | 438.82 | 439.28 | 438.81 | 439.27 | 56020.0 |
| 2024-03-11 04:00:00 | IWM | ETF | 206.99 | 207.02 | 206.31 | 206.65 | 16402.0 |
| 2024-03-11 05:00:00 | IWM | ETF | 206.77 | 207.2 | 206.77 | 207.1 | 11011.0 |
| 2024-03-11 06:00:00 | IWM | ETF | 207.12 | 207.14 | 206.62 | 206.84 | 12146.0 |
| 2024-03-11 07:00:00 | IWM | ETF | 206.92 | 207.15 | 206.6 | 206.73 | 18665.0 |
| 2024-03-11 08:00:00 | IWM | ETF | 206.9085 | 207.1496 | 206.04 | 206.24 | 103288.0 |
| 2024-03-11 09:00:00 | IWM | ETF | 206.17 | 206.84 | 205.16 | 205.16 | 2967251.0 |
| 2024-03-11 10:00:00 | IWM | ETF | 205.16 | 205.54 | 204.75 | 205.435 | 3589487.0 |
| 2024-03-11 11:00:00 | IWM | ETF | 205.43 | 205.69 | 204.87 | 205.67 | 2574869.0 |
| 2024-03-11 12:00:00 | IWM | ETF | 205.67 | 205.9101 | 205.22 | 205.75 | 1577390.0 |
| 2024-03-11 13:00:00 | IWM | ETF | 205.75 | 205.91 | 205.12 | 205.415 | 1866110.0 |
| 2024-03-11 14:00:00 | IWM | ETF | 205.405 | 205.58 | 205.165 | 205.54 | 1359409.0 |
| 2024-03-11 15:00:00 | IWM | ETF | 205.54 | 205.5701 | 204.78 | 205.21 | 3892875.0 |
| 2024-03-11 16:00:00 | IWM | ETF | 205.19 | 205.49 | 205.13 | 205.47 | 924565.0 |
| 2024-03-11 17:00:00 | IWM | ETF | 205.45 | 205.45 | 205.25 | 205.39 | 28505.0 |
| 2024-03-11 18:00:00 | IWM | ETF | 205.4 | 205.76 | 205.38 | 205.71 | 32515.0 |
| 2024-03-11 19:00:00 | IWM | ETF | 205.67 | 205.82 | 205.65 | 205.8 | 41088.0 |
| 2024-03-11 04:00:00 | DIA | ETF | 387.17 | 387.17 | 386.67 | 386.67 | 200.0 |
| 2024-03-11 05:00:00 | DIA | ETF | 386.71 | 386.71 | 386.57 | 386.62 | 2327.0 |
> showing 50 of 20,069 rows — these rows as CSV