PREVIEW / etf_1hour / 2001-05-22
file: by_date/etf_1hour/2001/2001-05-22.parquet size: 11 KB rows: 228
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-22 09:00:00 | SPY | ETF | 131.83 | 131.86 | 131.07 | 131.28 | 1544900.0 |
| 2001-05-22 10:00:00 | SPY | ETF | 131.29 | 132.05 | 131.22 | 131.52 | 1252200.0 |
| 2001-05-22 11:00:00 | SPY | ETF | 131.58 | 131.68 | 131.18 | 131.34 | 838200.0 |
| 2001-05-22 12:00:00 | SPY | ETF | 131.29 | 131.93 | 131.27 | 131.7 | 760700.0 |
| 2001-05-22 13:00:00 | SPY | ETF | 131.72 | 132.09 | 131.38 | 131.38 | 908800.0 |
| 2001-05-22 14:00:00 | SPY | ETF | 131.4 | 131.73 | 131.28 | 131.68 | 514900.0 |
| 2001-05-22 15:00:00 | SPY | ETF | 131.65 | 131.9 | 131.11 | 131.37 | 1550400.0 |
| 2001-05-22 16:00:00 | SPY | ETF | 131.37 | 131.54 | 131.33 | 131.48 | 753700.0 |
| 2001-05-22 17:00:00 | SPY | ETF | 131.46 | 131.46 | 131.37 | 131.37 | 900.0 |
| 2001-05-22 09:00:00 | QQQ | ETF | 51.31 | 51.64 | 50.68 | 50.87 | 14190700.0 |
| 2001-05-22 10:00:00 | QQQ | ETF | 50.84 | 51.58 | 50.72 | 50.82 | 21005700.0 |
| 2001-05-22 11:00:00 | QQQ | ETF | 50.8 | 51.05 | 50.41 | 50.52 | 8400000.0 |
| 2001-05-22 12:00:00 | QQQ | ETF | 50.55 | 51.14 | 50.5 | 50.88 | 6167200.0 |
| 2001-05-22 13:00:00 | QQQ | ETF | 50.92 | 51.39 | 50.81 | 50.85 | 6741000.0 |
| 2001-05-22 14:00:00 | QQQ | ETF | 50.85 | 51.25 | 50.8 | 51.24 | 6346500.0 |
| 2001-05-22 15:00:00 | QQQ | ETF | 51.25 | 51.36 | 50.75 | 50.91 | 8931200.0 |
| 2001-05-22 16:00:00 | QQQ | ETF | 50.9 | 51.22 | 50.75 | 51.09 | 2623000.0 |
| 2001-05-22 17:00:00 | QQQ | ETF | 51.1 | 51.1 | 50.92 | 50.93 | 91700.0 |
| 2001-05-22 18:00:00 | QQQ | ETF | 50.94 | 51.07 | 50.92 | 51.07 | 10300.0 |
| 2001-05-22 09:00:00 | IWM | ETF | 51.6 | 51.6 | 51.15 | 51.15 | 224800.0 |
| 2001-05-22 10:00:00 | IWM | ETF | 51.25 | 51.61 | 51.225 | 51.375 | 301800.0 |
| 2001-05-22 11:00:00 | IWM | ETF | 51.375 | 51.475 | 51.25 | 51.275 | 76200.0 |
| 2001-05-22 12:00:00 | IWM | ETF | 51.4 | 51.575 | 51.35 | 51.55 | 59200.0 |
| 2001-05-22 13:00:00 | IWM | ETF | 51.55 | 51.675 | 51.45 | 51.525 | 54800.0 |
| 2001-05-22 14:00:00 | IWM | ETF | 51.545 | 51.75 | 51.49 | 51.75 | 37200.0 |
| 2001-05-22 15:00:00 | IWM | ETF | 51.75 | 51.9 | 51.625 | 51.7 | 81400.0 |
| 2001-05-22 09:00:00 | DIA | ETF | 113.45 | 113.45 | 112.7 | 112.9 | 482100.0 |
| 2001-05-22 10:00:00 | DIA | ETF | 112.96 | 113.4 | 112.76 | 113.0 | 551600.0 |
| 2001-05-22 11:00:00 | DIA | ETF | 113.02 | 113.07 | 112.75 | 112.77 | 226300.0 |
| 2001-05-22 12:00:00 | DIA | ETF | 112.81 | 113.21 | 112.81 | 113.09 | 313600.0 |
| 2001-05-22 13:00:00 | DIA | ETF | 113.1 | 113.3 | 112.75 | 112.81 | 279600.0 |
| 2001-05-22 14:00:00 | DIA | ETF | 112.79 | 112.96 | 112.53 | 112.86 | 673100.0 |
| 2001-05-22 15:00:00 | DIA | ETF | 112.85 | 113.05 | 112.47 | 112.55 | 1003800.0 |
| 2001-05-22 16:00:00 | DIA | ETF | 112.6 | 112.8 | 112.51 | 112.68 | 182100.0 |
| 2001-05-22 18:00:00 | DIA | ETF | 112.68 | 112.68 | 112.68 | 112.68 | 3000.0 |
> showing 35 of 228 rows — these rows as CSV