PREVIEW / etf_30min / 2002-11-01
file: by_date/etf_30min/2002/2002-11-01.parquet size: 21 KB rows: 605
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-01 08:00:00 | SPY | ETF | 88.35 | 88.4 | 88.17 | 88.25 | 4600.0 |
| 2002-11-01 08:30:00 | SPY | ETF | 88.12 | 88.84 | 88.12 | 88.36 | 43800.0 |
| 2002-11-01 09:00:00 | SPY | ETF | 88.28 | 88.43 | 88.28 | 88.43 | 4000.0 |
| 2002-11-01 09:30:00 | SPY | ETF | 88.35 | 88.63 | 88.09 | 88.33 | 3123000.0 |
| 2002-11-01 10:00:00 | SPY | ETF | 88.33 | 88.7 | 88.05 | 88.22 | 3711700.0 |
| 2002-11-01 10:30:00 | SPY | ETF | 88.18 | 89.56 | 88.17 | 89.22 | 5245900.0 |
| 2002-11-01 11:00:00 | SPY | ETF | 89.23 | 89.8 | 89.2 | 89.4 | 3517900.0 |
| 2002-11-01 11:30:00 | SPY | ETF | 89.41 | 89.76 | 89.3 | 89.51 | 3663400.0 |
| 2002-11-01 12:00:00 | SPY | ETF | 89.51 | 89.77 | 89.4 | 89.73 | 1985400.0 |
| 2002-11-01 12:30:00 | SPY | ETF | 89.7 | 90.2 | 89.69 | 90.01 | 3376700.0 |
| 2002-11-01 13:00:00 | SPY | ETF | 90.01 | 90.07 | 89.58 | 89.91 | 1585600.0 |
| 2002-11-01 13:30:00 | SPY | ETF | 89.93 | 89.95 | 89.45 | 89.7 | 1189900.0 |
| 2002-11-01 14:00:00 | SPY | ETF | 89.73 | 90.13 | 89.71 | 90.0 | 2288900.0 |
| 2002-11-01 14:30:00 | SPY | ETF | 90.01 | 90.1 | 89.66 | 89.81 | 1806400.0 |
| 2002-11-01 15:00:00 | SPY | ETF | 89.8 | 90.5 | 89.8 | 90.39 | 5735700.0 |
| 2002-11-01 15:30:00 | SPY | ETF | 90.42 | 90.82 | 90.28 | 90.55 | 4079400.0 |
| 2002-11-01 16:00:00 | SPY | ETF | 90.58 | 90.66 | 90.22 | 90.53 | 3576400.0 |
| 2002-11-01 16:30:00 | SPY | ETF | 90.55 | 90.75 | 90.5 | 90.74 | 103800.0 |
| 2002-11-01 17:00:00 | SPY | ETF | 90.71 | 90.85 | 90.7 | 90.85 | 78500.0 |
| 2002-11-01 17:30:00 | SPY | ETF | 90.85 | 91.03 | 90.85 | 90.95 | 34000.0 |
| 2002-11-01 18:00:00 | SPY | ETF | 90.99 | 91.15 | 90.99 | 91.15 | 22500.0 |
| 2002-11-01 18:30:00 | SPY | ETF | 91.14 | 91.14 | 91.14 | 91.14 | 200.0 |
| 2002-11-01 08:00:00 | QQQ | ETF | 24.34 | 24.36 | 24.32 | 24.35 | 6400.0 |
| 2002-11-01 08:30:00 | QQQ | ETF | 24.42 | 24.56 | 24.36 | 24.36 | 51300.0 |
| 2002-11-01 09:00:00 | QQQ | ETF | 24.33 | 24.33 | 24.33 | 24.33 | 2000.0 |
| 2002-11-01 09:30:00 | QQQ | ETF | 24.37 | 24.43 | 24.2 | 24.33 | 6301400.0 |
| 2002-11-01 10:00:00 | QQQ | ETF | 24.33 | 24.58 | 24.14 | 24.48 | 9299900.0 |
| 2002-11-01 10:30:00 | QQQ | ETF | 24.49 | 24.93 | 24.45 | 24.83 | 10184700.0 |
| 2002-11-01 11:00:00 | QQQ | ETF | 24.83 | 25.01 | 24.79 | 24.86 | 7905900.0 |
| 2002-11-01 11:30:00 | QQQ | ETF | 24.86 | 24.99 | 24.81 | 24.9 | 5106500.0 |
| 2002-11-01 12:00:00 | QQQ | ETF | 24.9 | 25.08 | 24.85 | 25.07 | 4406100.0 |
| 2002-11-01 12:30:00 | QQQ | ETF | 25.05 | 25.19 | 24.96 | 25.04 | 5893100.0 |
| 2002-11-01 13:00:00 | QQQ | ETF | 25.06 | 25.11 | 24.93 | 25.09 | 3679900.0 |
| 2002-11-01 13:30:00 | QQQ | ETF | 25.09 | 25.1 | 24.88 | 24.95 | 3395200.0 |
| 2002-11-01 14:00:00 | QQQ | ETF | 24.97 | 25.12 | 24.97 | 25.04 | 3095100.0 |
| 2002-11-01 14:30:00 | QQQ | ETF | 25.07 | 25.15 | 24.96 | 25.04 | 3711700.0 |
| 2002-11-01 15:00:00 | QQQ | ETF | 25.05 | 25.29 | 25.02 | 25.26 | 5347500.0 |
| 2002-11-01 15:30:00 | QQQ | ETF | 25.27 | 25.4 | 25.23 | 25.3 | 7331300.0 |
| 2002-11-01 16:00:00 | QQQ | ETF | 25.3 | 25.58 | 24.89 | 25.47 | 4135100.0 |
| 2002-11-01 16:30:00 | QQQ | ETF | 25.47 | 25.72 | 25.14 | 25.68 | 938600.0 |
| 2002-11-01 17:00:00 | QQQ | ETF | 25.68 | 25.77 | 25.65 | 25.72 | 285900.0 |
| 2002-11-01 17:30:00 | QQQ | ETF | 25.71 | 25.77 | 25.65 | 25.74 | 177900.0 |
| 2002-11-01 18:00:00 | QQQ | ETF | 25.74 | 25.74 | 25.66 | 25.71 | 35600.0 |
| 2002-11-01 18:30:00 | QQQ | ETF | 25.74 | 25.74 | 25.72 | 25.72 | 2400.0 |
| 2002-11-01 19:00:00 | QQQ | ETF | 25.73 | 25.74 | 25.73 | 25.73 | 2900.0 |
| 2002-11-01 19:30:00 | QQQ | ETF | 25.75 | 25.75 | 25.75 | 25.75 | 200.0 |
| 2002-11-01 09:30:00 | IWM | ETF | 37.135 | 37.35 | 36.975 | 37.175 | 235600.0 |
| 2002-11-01 10:00:00 | IWM | ETF | 37.105 | 37.3 | 37.105 | 37.21 | 79800.0 |
| 2002-11-01 10:30:00 | IWM | ETF | 37.145 | 37.615 | 37.145 | 37.615 | 273400.0 |
| 2002-11-01 11:00:00 | IWM | ETF | 37.595 | 37.7 | 37.535 | 37.565 | 206600.0 |
> showing 50 of 605 rows — these rows as CSV