PREVIEW / etf_1hour / 2024-03-22
file: by_date/etf_1hour/2024/2024-03-22.parquet size: 528 KB rows: 19,448
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-22 04:00:00 | SPY | ETF | 522.22 | 522.87 | 522.11 | 522.84 | 17830.0 |
| 2024-03-22 05:00:00 | SPY | ETF | 522.88 | 523.09 | 522.7 | 522.79 | 9961.0 |
| 2024-03-22 06:00:00 | SPY | ETF | 522.92 | 523.09 | 522.76 | 522.78 | 16745.0 |
| 2024-03-22 07:00:00 | SPY | ETF | 522.81 | 523.08 | 521.39 | 521.51 | 134014.0 |
| 2024-03-22 08:00:00 | SPY | ETF | 521.52 | 523.09 | 521.25 | 521.81 | 218914.0 |
| 2024-03-22 09:00:00 | SPY | ETF | 521.86 | 522.44 | 521.42 | 521.77 | 3612717.0 |
| 2024-03-22 10:00:00 | SPY | ETF | 521.78 | 522.305 | 521.02 | 521.06 | 5505630.0 |
| 2024-03-22 11:00:00 | SPY | ETF | 521.06 | 521.835 | 521.03 | 521.68 | 4017470.0 |
| 2024-03-22 12:00:00 | SPY | ETF | 521.68 | 521.88 | 520.97 | 521.84 | 4256496.0 |
| 2024-03-22 13:00:00 | SPY | ETF | 521.83 | 522.59 | 521.76 | 522.545 | 4268398.0 |
| 2024-03-22 14:00:00 | SPY | ETF | 522.54 | 522.605 | 521.95 | 522.17 | 3855232.0 |
| 2024-03-22 15:00:00 | SPY | ETF | 522.17 | 522.36 | 521.12 | 521.27 | 15434658.0 |
| 2024-03-22 16:00:00 | SPY | ETF | 521.27 | 522.1424 | 520.82 | 520.95 | 10795559.0 |
| 2024-03-22 17:00:00 | SPY | ETF | 520.97 | 521.05 | 520.87 | 520.9 | 161462.0 |
| 2024-03-22 18:00:00 | SPY | ETF | 520.91 | 520.91 | 520.77 | 520.8 | 19526.0 |
| 2024-03-22 19:00:00 | SPY | ETF | 520.82 | 520.94 | 520.75 | 520.75 | 17619.0 |
| 2024-03-22 04:00:00 | QQQ | ETF | 446.11 | 446.74 | 445.91 | 446.74 | 58723.0 |
| 2024-03-22 05:00:00 | QQQ | ETF | 446.73 | 446.99 | 446.3 | 446.7 | 25268.0 |
| 2024-03-22 06:00:00 | QQQ | ETF | 446.6 | 446.68 | 446.17 | 446.23 | 34336.0 |
| 2024-03-22 07:00:00 | QQQ | ETF | 446.27 | 446.42 | 444.6 | 444.74 | 171154.0 |
| 2024-03-22 08:00:00 | QQQ | ETF | 446.35 | 446.8904 | 444.3 | 445.2 | 244300.0 |
| 2024-03-22 09:00:00 | QQQ | ETF | 445.199 | 445.58 | 444.49 | 445.2 | 2493338.0 |
| 2024-03-22 10:00:00 | QQQ | ETF | 445.2 | 446.04 | 444.56 | 444.78 | 2824888.0 |
| 2024-03-22 11:00:00 | QQQ | ETF | 444.75 | 445.9629 | 444.72 | 445.89 | 2287353.0 |
| 2024-03-22 12:00:00 | QQQ | ETF | 445.91 | 446.44 | 445.17 | 446.41 | 2246871.0 |
| 2024-03-22 13:00:00 | QQQ | ETF | 446.4 | 447.49 | 446.3499 | 447.3995 | 2744322.0 |
| 2024-03-22 14:00:00 | QQQ | ETF | 447.39 | 447.46 | 446.395 | 446.74 | 2380427.0 |
| 2024-03-22 15:00:00 | QQQ | ETF | 446.736 | 446.99 | 445.6 | 446.2 | 4889789.0 |
| 2024-03-22 16:00:00 | QQQ | ETF | 446.2 | 446.38 | 445.7455 | 446.02 | 1009196.0 |
| 2024-03-22 17:00:00 | QQQ | ETF | 446.05 | 446.07 | 445.92 | 446.0 | 30912.0 |
| 2024-03-22 18:00:00 | QQQ | ETF | 445.94 | 445.94 | 445.7 | 445.79 | 7845.0 |
| 2024-03-22 19:00:00 | QQQ | ETF | 445.78 | 445.84 | 445.65 | 445.65 | 10149.0 |
| 2024-03-22 04:00:00 | IWM | ETF | 208.05 | 208.28 | 207.93 | 208.28 | 18455.0 |
| 2024-03-22 05:00:00 | IWM | ETF | 208.25 | 208.6 | 208.14 | 208.2 | 14121.0 |
| 2024-03-22 06:00:00 | IWM | ETF | 208.23 | 208.67 | 208.15 | 208.49 | 11977.0 |
| 2024-03-22 07:00:00 | IWM | ETF | 208.5 | 208.62 | 207.42 | 207.56 | 95739.0 |
| 2024-03-22 08:00:00 | IWM | ETF | 208.4991 | 208.5996 | 207.27 | 207.67 | 102602.0 |
| 2024-03-22 09:00:00 | IWM | ETF | 207.7096 | 208.24 | 206.84 | 206.8899 | 2745875.0 |
| 2024-03-22 10:00:00 | IWM | ETF | 206.89 | 207.25 | 205.48 | 205.655 | 3722385.0 |
| 2024-03-22 11:00:00 | IWM | ETF | 205.65 | 206.2 | 205.54 | 205.83 | 3058568.0 |
| 2024-03-22 12:00:00 | IWM | ETF | 205.84 | 205.9704 | 205.46 | 205.8701 | 1645332.0 |
| 2024-03-22 13:00:00 | IWM | ETF | 205.87 | 206.14 | 205.78 | 206.13 | 1225710.0 |
| 2024-03-22 14:00:00 | IWM | ETF | 206.13 | 206.159 | 205.74 | 205.9 | 1511270.0 |
| 2024-03-22 15:00:00 | IWM | ETF | 205.9 | 205.905 | 205.11 | 205.13 | 4927648.0 |
| 2024-03-22 16:00:00 | IWM | ETF | 205.07 | 205.3214 | 204.99 | 205.14 | 1440330.0 |
| 2024-03-22 17:00:00 | IWM | ETF | 205.1399 | 205.34 | 205.09 | 205.16 | 18748.0 |
| 2024-03-22 18:00:00 | IWM | ETF | 205.18 | 205.18 | 205.04 | 205.0517 | 8763.0 |
| 2024-03-22 19:00:00 | IWM | ETF | 205.1395 | 205.15 | 205.05 | 205.11 | 3670.0 |
| 2024-03-22 05:00:00 | DIA | ETF | 398.04 | 398.07 | 398.04 | 398.05 | 3650.0 |
| 2024-03-22 06:00:00 | DIA | ETF | 398.19 | 398.33 | 398.19 | 398.22 | 1900.0 |
> showing 50 of 19,448 rows — these rows as CSV