PREVIEW / etf_30min / 2001-05-22
file: by_date/etf_30min/2001/2001-05-22.parquet size: 15 KB rows: 390
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:30: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.25 | 131.75 | 750100.0 |
| 2001-05-22 10:30:00 | SPY | ETF | 131.82 | 131.82 | 131.22 | 131.52 | 502100.0 |
| 2001-05-22 11:00:00 | SPY | ETF | 131.58 | 131.68 | 131.26 | 131.37 | 402100.0 |
| 2001-05-22 11:30:00 | SPY | ETF | 131.35 | 131.57 | 131.18 | 131.34 | 436100.0 |
| 2001-05-22 12:00:00 | SPY | ETF | 131.29 | 131.69 | 131.27 | 131.59 | 426400.0 |
| 2001-05-22 12:30:00 | SPY | ETF | 131.63 | 131.93 | 131.62 | 131.7 | 334300.0 |
| 2001-05-22 13:00:00 | SPY | ETF | 131.72 | 132.09 | 131.71 | 131.91 | 500000.0 |
| 2001-05-22 13:30:00 | SPY | ETF | 131.94 | 132.04 | 131.38 | 131.38 | 408800.0 |
| 2001-05-22 14:00:00 | SPY | ETF | 131.4 | 131.73 | 131.32 | 131.51 | 258300.0 |
| 2001-05-22 14:30:00 | SPY | ETF | 131.52 | 131.7 | 131.28 | 131.68 | 256600.0 |
| 2001-05-22 15:00:00 | SPY | ETF | 131.65 | 131.9 | 131.52 | 131.84 | 408300.0 |
| 2001-05-22 15:30:00 | SPY | ETF | 131.82 | 131.88 | 131.11 | 131.37 | 1142100.0 |
| 2001-05-22 16:00:00 | SPY | ETF | 131.37 | 131.54 | 131.33 | 131.48 | 753200.0 |
| 2001-05-22 16:30:00 | SPY | ETF | 131.48 | 131.48 | 131.48 | 131.48 | 500.0 |
| 2001-05-22 17:00:00 | SPY | ETF | 131.46 | 131.46 | 131.46 | 131.46 | 100.0 |
| 2001-05-22 17:30:00 | SPY | ETF | 131.41 | 131.41 | 131.37 | 131.37 | 800.0 |
| 2001-05-22 09:30: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 | 51.33 | 13696800.0 |
| 2001-05-22 10:30:00 | QQQ | ETF | 51.29 | 51.39 | 50.79 | 50.82 | 7308900.0 |
| 2001-05-22 11:00:00 | QQQ | ETF | 50.8 | 51.05 | 50.6 | 50.8 | 4679100.0 |
| 2001-05-22 11:30:00 | QQQ | ETF | 50.79 | 50.86 | 50.41 | 50.52 | 3720900.0 |
| 2001-05-22 12:00:00 | QQQ | ETF | 50.55 | 50.97 | 50.5 | 50.92 | 2944900.0 |
| 2001-05-22 12:30:00 | QQQ | ETF | 50.85 | 51.14 | 50.78 | 50.88 | 3222300.0 |
| 2001-05-22 13:00:00 | QQQ | ETF | 50.92 | 51.39 | 50.9 | 51.22 | 3470800.0 |
| 2001-05-22 13:30:00 | QQQ | ETF | 51.21 | 51.36 | 50.81 | 50.85 | 3270200.0 |
| 2001-05-22 14:00:00 | QQQ | ETF | 50.85 | 51.19 | 50.8 | 51.0 | 3021800.0 |
| 2001-05-22 14:30:00 | QQQ | ETF | 51.0 | 51.25 | 50.86 | 51.24 | 3324700.0 |
| 2001-05-22 15:00:00 | QQQ | ETF | 51.25 | 51.36 | 51.04 | 51.33 | 3102200.0 |
| 2001-05-22 15:30:00 | QQQ | ETF | 51.34 | 51.35 | 50.75 | 50.91 | 5829000.0 |
| 2001-05-22 16:00:00 | QQQ | ETF | 50.9 | 51.22 | 50.75 | 51.09 | 2512200.0 |
| 2001-05-22 16:30:00 | QQQ | ETF | 51.09 | 51.12 | 50.85 | 51.09 | 110800.0 |
| 2001-05-22 17:00:00 | QQQ | ETF | 51.1 | 51.1 | 51.0 | 51.0 | 78000.0 |
| 2001-05-22 17:30:00 | QQQ | ETF | 51.0 | 51.05 | 50.92 | 50.93 | 13700.0 |
| 2001-05-22 18:00:00 | QQQ | ETF | 50.94 | 51.07 | 50.92 | 51.07 | 10200.0 |
| 2001-05-22 18:30:00 | QQQ | ETF | 51.07 | 51.07 | 51.07 | 51.07 | 100.0 |
| 2001-05-22 09:30:00 | IWM | ETF | 51.6 | 51.6 | 51.15 | 51.15 | 224800.0 |
| 2001-05-22 10:00:00 | IWM | ETF | 51.25 | 51.525 | 51.225 | 51.5 | 265800.0 |
| 2001-05-22 10:30:00 | IWM | ETF | 51.61 | 51.61 | 51.375 | 51.375 | 36000.0 |
| 2001-05-22 11:00:00 | IWM | ETF | 51.375 | 51.47 | 51.375 | 51.47 | 1600.0 |
| 2001-05-22 11:30:00 | IWM | ETF | 51.375 | 51.475 | 51.25 | 51.275 | 74600.0 |
| 2001-05-22 12:00:00 | IWM | ETF | 51.4 | 51.475 | 51.35 | 51.375 | 23400.0 |
| 2001-05-22 12:30:00 | IWM | ETF | 51.475 | 51.575 | 51.425 | 51.55 | 35800.0 |
| 2001-05-22 13:00:00 | IWM | ETF | 51.55 | 51.575 | 51.45 | 51.55 | 23200.0 |
| 2001-05-22 13:30:00 | IWM | ETF | 51.55 | 51.675 | 51.525 | 51.525 | 31600.0 |
| 2001-05-22 14:00:00 | IWM | ETF | 51.545 | 51.625 | 51.49 | 51.515 | 23600.0 |
| 2001-05-22 14:30:00 | IWM | ETF | 51.595 | 51.75 | 51.59 | 51.75 | 13600.0 |
| 2001-05-22 15:00:00 | IWM | ETF | 51.75 | 51.875 | 51.675 | 51.75 | 53400.0 |
| 2001-05-22 15:30:00 | IWM | ETF | 51.875 | 51.9 | 51.625 | 51.7 | 28000.0 |
| 2001-05-22 09:30:00 | DIA | ETF | 113.45 | 113.45 | 112.7 | 112.9 | 482100.0 |
> showing 50 of 390 rows — these rows as CSV