PREVIEW / etf_30min / 2001-04-17
file: by_date/etf_30min/2001/2001-04-17.parquet size: 15 KB rows: 365
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-04-17 09:30:00 | SPY | ETF | 117.31 | 118.22 | 117.02 | 118.0 | 1428400.0 |
| 2001-04-17 10:00:00 | SPY | ETF | 118.0 | 119.66 | 117.94 | 119.41 | 1834800.0 |
| 2001-04-17 10:30:00 | SPY | ETF | 119.47 | 119.52 | 118.9 | 119.12 | 1298500.0 |
| 2001-04-17 11:00:00 | SPY | ETF | 119.1 | 119.17 | 118.65 | 118.65 | 611800.0 |
| 2001-04-17 11:30:00 | SPY | ETF | 118.64 | 118.98 | 118.55 | 118.57 | 399500.0 |
| 2001-04-17 12:00:00 | SPY | ETF | 118.65 | 118.9 | 118.3 | 118.9 | 286600.0 |
| 2001-04-17 12:30:00 | SPY | ETF | 118.9 | 118.98 | 118.54 | 118.74 | 349900.0 |
| 2001-04-17 13:00:00 | SPY | ETF | 118.74 | 119.12 | 118.21 | 118.25 | 286100.0 |
| 2001-04-17 13:30:00 | SPY | ETF | 118.3 | 118.58 | 118.15 | 118.54 | 379300.0 |
| 2001-04-17 14:00:00 | SPY | ETF | 118.56 | 118.82 | 118.35 | 118.35 | 338600.0 |
| 2001-04-17 14:30:00 | SPY | ETF | 118.35 | 118.54 | 118.06 | 118.39 | 531500.0 |
| 2001-04-17 15:00:00 | SPY | ETF | 118.42 | 119.07 | 118.27 | 118.74 | 821500.0 |
| 2001-04-17 15:30:00 | SPY | ETF | 118.74 | 119.45 | 118.65 | 119.42 | 1244700.0 |
| 2001-04-17 16:00:00 | SPY | ETF | 119.49 | 119.97 | 118.03 | 119.3 | 789200.0 |
| 2001-04-17 16:30:00 | SPY | ETF | 119.3 | 120.6 | 119.26 | 120.56 | 160800.0 |
| 2001-04-17 17:00:00 | SPY | ETF | 120.45 | 120.8 | 120.42 | 120.75 | 16000.0 |
| 2001-04-17 17:30:00 | SPY | ETF | 120.61 | 120.61 | 120.59 | 120.59 | 700.0 |
| 2001-04-17 18:00:00 | SPY | ETF | 120.7 | 120.9 | 120.7 | 120.78 | 2700.0 |
| 2001-04-17 09:30:00 | QQQ | ETF | 39.95 | 41.47 | 39.9 | 41.28 | 13363700.0 |
| 2001-04-17 10:00:00 | QQQ | ETF | 41.29 | 42.27 | 41.21 | 42.05 | 14867100.0 |
| 2001-04-17 10:30:00 | QQQ | ETF | 42.04 | 42.23 | 41.6 | 41.79 | 5635400.0 |
| 2001-04-17 11:00:00 | QQQ | ETF | 41.79 | 41.88 | 41.37 | 41.39 | 4023100.0 |
| 2001-04-17 11:30:00 | QQQ | ETF | 41.4 | 41.46 | 41.08 | 41.14 | 4922000.0 |
| 2001-04-17 12:00:00 | QQQ | ETF | 41.11 | 41.77 | 40.87 | 41.62 | 4102000.0 |
| 2001-04-17 12:30:00 | QQQ | ETF | 41.65 | 41.77 | 41.3 | 41.46 | 3431000.0 |
| 2001-04-17 13:00:00 | QQQ | ETF | 41.45 | 41.75 | 40.98 | 41.05 | 3590900.0 |
| 2001-04-17 13:30:00 | QQQ | ETF | 41.05 | 41.4 | 40.96 | 41.4 | 3146200.0 |
| 2001-04-17 14:00:00 | QQQ | ETF | 41.35 | 41.55 | 41.1 | 41.13 | 2955300.0 |
| 2001-04-17 14:30:00 | QQQ | ETF | 41.13 | 41.2 | 40.69 | 40.88 | 6562000.0 |
| 2001-04-17 15:00:00 | QQQ | ETF | 40.97 | 41.62 | 40.85 | 41.32 | 7236700.0 |
| 2001-04-17 15:30:00 | QQQ | ETF | 41.36 | 41.7 | 41.23 | 41.65 | 5433700.0 |
| 2001-04-17 16:00:00 | QQQ | ETF | 41.64 | 42.6 | 41.05 | 42.5 | 4069200.0 |
| 2001-04-17 16:30:00 | QQQ | ETF | 42.5 | 43.5 | 41.23 | 43.2 | 6356000.0 |
| 2001-04-17 17:00:00 | QQQ | ETF | 43.26 | 43.75 | 43.2 | 43.4 | 334400.0 |
| 2001-04-17 17:30:00 | QQQ | ETF | 43.46 | 43.6 | 42.53 | 43.49 | 565500.0 |
| 2001-04-17 18:00:00 | QQQ | ETF | 43.48 | 43.5 | 42.25 | 43.4 | 277500.0 |
| 2001-04-17 09:30:00 | IWM | ETF | 44.375 | 45.03 | 44.375 | 45.03 | 12600.0 |
| 2001-04-17 10:00:00 | IWM | ETF | 45.095 | 45.45 | 45.05 | 45.45 | 23000.0 |
| 2001-04-17 10:30:00 | IWM | ETF | 45.35 | 45.35 | 45.25 | 45.27 | 17200.0 |
| 2001-04-17 11:00:00 | IWM | ETF | 45.275 | 45.35 | 45.1 | 45.2 | 9200.0 |
| 2001-04-17 11:30:00 | IWM | ETF | 45.3 | 45.3 | 45.05 | 45.175 | 31800.0 |
| 2001-04-17 12:00:00 | IWM | ETF | 45.275 | 45.285 | 45.0 | 45.125 | 14600.0 |
| 2001-04-17 12:30:00 | IWM | ETF | 45.13 | 45.275 | 45.125 | 45.275 | 5600.0 |
| 2001-04-17 13:00:00 | IWM | ETF | 45.15 | 45.2 | 45.15 | 45.2 | 1000.0 |
| 2001-04-17 13:30:00 | IWM | ETF | 45.01 | 45.01 | 44.955 | 44.955 | 800.0 |
| 2001-04-17 14:00:00 | IWM | ETF | 45.025 | 45.3 | 45.025 | 45.3 | 7000.0 |
| 2001-04-17 14:30:00 | IWM | ETF | 45.145 | 45.145 | 44.875 | 45.075 | 57600.0 |
| 2001-04-17 15:00:00 | IWM | ETF | 45.1 | 45.4 | 45.1 | 45.4 | 17600.0 |
| 2001-04-17 15:30:00 | IWM | ETF | 45.325 | 45.545 | 45.32 | 45.525 | 77200.0 |
| 2001-04-17 16:00:00 | IWM | ETF | 45.55 | 45.55 | 45.3 | 45.35 | 20200.0 |
> showing 50 of 365 rows — these rows as CSV