PREVIEW / etf_30min / 2001-05-08
file: by_date/etf_30min/2001/2001-05-08.parquet size: 14 KB rows: 375
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-08 09:30:00 | SPY | ETF | 126.86 | 127.1 | 126.58 | 126.72 | 1219200.0 |
| 2001-05-08 10:00:00 | SPY | ETF | 126.77 | 126.79 | 125.72 | 125.86 | 995700.0 |
| 2001-05-08 10:30:00 | SPY | ETF | 125.86 | 126.18 | 125.56 | 126.13 | 636900.0 |
| 2001-05-08 11:00:00 | SPY | ETF | 126.03 | 126.36 | 125.96 | 126.22 | 217600.0 |
| 2001-05-08 11:30:00 | SPY | ETF | 126.23 | 126.31 | 125.71 | 125.75 | 646100.0 |
| 2001-05-08 12:00:00 | SPY | ETF | 125.76 | 126.06 | 125.6 | 125.94 | 231700.0 |
| 2001-05-08 12:30:00 | SPY | ETF | 125.88 | 126.08 | 125.71 | 126.06 | 197400.0 |
| 2001-05-08 13:00:00 | SPY | ETF | 126.09 | 126.37 | 125.98 | 126.03 | 275200.0 |
| 2001-05-08 13:30:00 | SPY | ETF | 125.94 | 126.35 | 125.91 | 126.22 | 275100.0 |
| 2001-05-08 14:00:00 | SPY | ETF | 126.21 | 126.24 | 125.81 | 125.96 | 220900.0 |
| 2001-05-08 14:30:00 | SPY | ETF | 125.98 | 126.5 | 125.95 | 126.22 | 378400.0 |
| 2001-05-08 15:00:00 | SPY | ETF | 126.27 | 126.61 | 126.17 | 126.31 | 332300.0 |
| 2001-05-08 15:30:00 | SPY | ETF | 126.33 | 126.57 | 126.2 | 126.52 | 709600.0 |
| 2001-05-08 16:00:00 | SPY | ETF | 126.45 | 127.3 | 126.02 | 126.02 | 353900.0 |
| 2001-05-08 16:30:00 | SPY | ETF | 126.15 | 126.45 | 126.07 | 126.07 | 1800.0 |
| 2001-05-08 17:00:00 | SPY | ETF | 126.0 | 126.0 | 125.78 | 125.78 | 2000.0 |
| 2001-05-08 17:30:00 | SPY | ETF | 125.71 | 125.78 | 125.71 | 125.78 | 300.0 |
| 2001-05-08 18:00:00 | SPY | ETF | 125.9 | 125.9 | 125.81 | 125.81 | 50300.0 |
| 2001-05-08 09:30:00 | QQQ | ETF | 48.3 | 48.35 | 47.85 | 47.96 | 10297000.0 |
| 2001-05-08 10:00:00 | QQQ | ETF | 48.02 | 48.02 | 47.2 | 47.47 | 7551700.0 |
| 2001-05-08 10:30:00 | QQQ | ETF | 47.45 | 47.72 | 47.21 | 47.6 | 3835800.0 |
| 2001-05-08 11:00:00 | QQQ | ETF | 47.6 | 47.82 | 47.45 | 47.75 | 4782300.0 |
| 2001-05-08 11:30:00 | QQQ | ETF | 47.76 | 47.84 | 47.11 | 47.25 | 4481700.0 |
| 2001-05-08 12:00:00 | QQQ | ETF | 47.19 | 47.36 | 46.99 | 47.35 | 3949300.0 |
| 2001-05-08 12:30:00 | QQQ | ETF | 47.35 | 47.5 | 47.12 | 47.49 | 1492300.0 |
| 2001-05-08 13:00:00 | QQQ | ETF | 47.49 | 47.65 | 47.3 | 47.32 | 2254900.0 |
| 2001-05-08 13:30:00 | QQQ | ETF | 47.32 | 47.62 | 47.3 | 47.55 | 1800300.0 |
| 2001-05-08 14:00:00 | QQQ | ETF | 47.54 | 47.54 | 47.21 | 47.25 | 1316200.0 |
| 2001-05-08 14:30:00 | QQQ | ETF | 47.29 | 47.88 | 47.25 | 47.73 | 4228300.0 |
| 2001-05-08 15:00:00 | QQQ | ETF | 47.73 | 48.04 | 47.68 | 47.81 | 3504400.0 |
| 2001-05-08 15:30:00 | QQQ | ETF | 47.81 | 48.18 | 47.71 | 48.15 | 3457500.0 |
| 2001-05-08 16:00:00 | QQQ | ETF | 48.15 | 48.75 | 47.0 | 48.0 | 1108900.0 |
| 2001-05-08 16:30:00 | QQQ | ETF | 47.98 | 48.3 | 47.75 | 48.0 | 795000.0 |
| 2001-05-08 17:00:00 | QQQ | ETF | 47.97 | 47.97 | 47.45 | 47.48 | 252500.0 |
| 2001-05-08 17:30:00 | QQQ | ETF | 47.48 | 47.65 | 47.3 | 47.55 | 258000.0 |
| 2001-05-08 18:00:00 | QQQ | ETF | 47.52 | 47.59 | 47.4 | 47.5 | 87000.0 |
| 2001-05-08 09:30:00 | IWM | ETF | 49.05 | 49.2 | 49.0 | 49.05 | 8800.0 |
| 2001-05-08 10:00:00 | IWM | ETF | 49.105 | 49.105 | 48.75 | 48.75 | 3600.0 |
| 2001-05-08 10:30:00 | IWM | ETF | 48.875 | 48.885 | 48.525 | 48.65 | 114200.0 |
| 2001-05-08 11:30:00 | IWM | ETF | 48.8 | 48.8 | 48.65 | 48.65 | 4400.0 |
| 2001-05-08 12:00:00 | IWM | ETF | 48.7 | 48.725 | 48.65 | 48.725 | 3200.0 |
| 2001-05-08 12:30:00 | IWM | ETF | 48.705 | 48.705 | 48.705 | 48.705 | 600.0 |
| 2001-05-08 13:00:00 | IWM | ETF | 48.71 | 48.855 | 48.71 | 48.855 | 21200.0 |
| 2001-05-08 13:30:00 | IWM | ETF | 48.83 | 48.855 | 48.83 | 48.85 | 1200.0 |
| 2001-05-08 14:00:00 | IWM | ETF | 48.83 | 48.855 | 48.8 | 48.8 | 6600.0 |
| 2001-05-08 14:30:00 | IWM | ETF | 48.85 | 48.945 | 48.825 | 48.825 | 2200.0 |
| 2001-05-08 15:00:00 | IWM | ETF | 48.945 | 49.25 | 48.945 | 49.15 | 114000.0 |
| 2001-05-08 15:30:00 | IWM | ETF | 49.125 | 49.225 | 48.99 | 49.225 | 124400.0 |
| 2001-05-08 16:00:00 | IWM | ETF | 49.225 | 49.225 | 49.0 | 49.0 | 13600.0 |
| 2001-05-08 09:30:00 | DIA | ETF | 109.64 | 109.64 | 109.06 | 109.07 | 500600.0 |
> showing 50 of 375 rows — these rows as CSV