PREVIEW / etf_30min / 2001-04-10
file: by_date/etf_30min/2001/2001-04-10.parquet size: 15 KB rows: 372
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-10 09:30:00 | SPY | ETF | 115.45 | 116.2 | 115.17 | 116.06 | 2913700.0 |
| 2001-04-10 10:00:00 | SPY | ETF | 116.09 | 116.67 | 116.03 | 116.3 | 1442200.0 |
| 2001-04-10 10:30:00 | SPY | ETF | 116.3 | 116.89 | 116.25 | 116.65 | 632600.0 |
| 2001-04-10 11:00:00 | SPY | ETF | 116.65 | 116.88 | 116.34 | 116.62 | 962000.0 |
| 2001-04-10 11:30:00 | SPY | ETF | 116.61 | 117.17 | 116.5 | 117.02 | 1565100.0 |
| 2001-04-10 12:00:00 | SPY | ETF | 116.99 | 117.5 | 116.99 | 117.45 | 779700.0 |
| 2001-04-10 12:30:00 | SPY | ETF | 117.51 | 117.75 | 117.4 | 117.5 | 909400.0 |
| 2001-04-10 13:00:00 | SPY | ETF | 117.54 | 117.69 | 117.26 | 117.36 | 360900.0 |
| 2001-04-10 13:30:00 | SPY | ETF | 117.34 | 117.55 | 117.08 | 117.26 | 539500.0 |
| 2001-04-10 14:00:00 | SPY | ETF | 117.23 | 117.55 | 116.9 | 116.9 | 936500.0 |
| 2001-04-10 14:30:00 | SPY | ETF | 116.88 | 117.15 | 116.5 | 116.87 | 1716000.0 |
| 2001-04-10 15:00:00 | SPY | ETF | 116.86 | 117.65 | 116.83 | 117.5 | 1566600.0 |
| 2001-04-10 15:30:00 | SPY | ETF | 117.51 | 117.66 | 116.9 | 117.09 | 1170300.0 |
| 2001-04-10 16:00:00 | SPY | ETF | 117.03 | 117.19 | 116.6 | 116.8 | 2284200.0 |
| 2001-04-10 16:30:00 | SPY | ETF | 116.8 | 116.8 | 116.62 | 116.65 | 2500.0 |
| 2001-04-10 17:00:00 | SPY | ETF | 117.15 | 117.15 | 117.15 | 117.15 | 200.0 |
| 2001-04-10 17:30:00 | SPY | ETF | 116.45 | 116.45 | 116.42 | 116.42 | 900.0 |
| 2001-04-10 18:00:00 | SPY | ETF | 116.5 | 116.5 | 116.21 | 116.47 | 3800.0 |
| 2001-04-10 09:30:00 | QQQ | ETF | 37.9 | 38.76 | 37.78 | 38.6 | 13864200.0 |
| 2001-04-10 10:00:00 | QQQ | ETF | 38.6 | 39.12 | 38.55 | 38.95 | 9130000.0 |
| 2001-04-10 10:30:00 | QQQ | ETF | 38.92 | 39.6 | 38.9 | 39.4 | 8222800.0 |
| 2001-04-10 11:00:00 | QQQ | ETF | 39.4 | 39.57 | 39.19 | 39.36 | 4841300.0 |
| 2001-04-10 11:30:00 | QQQ | ETF | 39.38 | 39.86 | 39.31 | 39.8 | 5518400.0 |
| 2001-04-10 12:00:00 | QQQ | ETF | 39.76 | 40.14 | 39.75 | 40.1 | 4891500.0 |
| 2001-04-10 12:30:00 | QQQ | ETF | 40.1 | 40.46 | 40.06 | 40.21 | 11203900.0 |
| 2001-04-10 13:00:00 | QQQ | ETF | 40.22 | 40.38 | 39.89 | 40.0 | 4496700.0 |
| 2001-04-10 13:30:00 | QQQ | ETF | 40.0 | 40.15 | 39.84 | 39.87 | 2949500.0 |
| 2001-04-10 14:00:00 | QQQ | ETF | 39.86 | 40.2 | 39.77 | 39.9 | 4021600.0 |
| 2001-04-10 14:30:00 | QQQ | ETF | 39.8 | 39.84 | 39.53 | 39.68 | 6370100.0 |
| 2001-04-10 15:00:00 | QQQ | ETF | 39.69 | 40.35 | 39.67 | 40.32 | 6520200.0 |
| 2001-04-10 15:30:00 | QQQ | ETF | 40.33 | 40.46 | 39.8 | 39.9 | 8941200.0 |
| 2001-04-10 16:00:00 | QQQ | ETF | 39.86 | 40.35 | 39.1 | 39.85 | 2054000.0 |
| 2001-04-10 16:30:00 | QQQ | ETF | 39.82 | 39.93 | 39.8 | 39.82 | 39200.0 |
| 2001-04-10 17:00:00 | QQQ | ETF | 39.82 | 40.0 | 39.81 | 39.85 | 211700.0 |
| 2001-04-10 17:30:00 | QQQ | ETF | 39.93 | 39.96 | 39.3 | 39.52 | 91400.0 |
| 2001-04-10 18:00:00 | QQQ | ETF | 39.52 | 39.65 | 39.25 | 39.62 | 98200.0 |
| 2001-04-10 09:30:00 | IWM | ETF | 44.375 | 44.525 | 44.35 | 44.525 | 261600.0 |
| 2001-04-10 10:00:00 | IWM | ETF | 44.545 | 44.925 | 44.545 | 44.8 | 25600.0 |
| 2001-04-10 10:30:00 | IWM | ETF | 44.7 | 45.0 | 44.7 | 44.975 | 64400.0 |
| 2001-04-10 11:00:00 | IWM | ETF | 44.88 | 44.9 | 44.805 | 44.805 | 26000.0 |
| 2001-04-10 11:30:00 | IWM | ETF | 44.92 | 45.12 | 44.92 | 45.12 | 4400.0 |
| 2001-04-10 12:00:00 | IWM | ETF | 45.015 | 45.12 | 45.015 | 45.12 | 26400.0 |
| 2001-04-10 12:30:00 | IWM | ETF | 45.25 | 45.365 | 45.195 | 45.195 | 10000.0 |
| 2001-04-10 13:00:00 | IWM | ETF | 45.295 | 45.295 | 45.1 | 45.1 | 4400.0 |
| 2001-04-10 13:30:00 | IWM | ETF | 45.19 | 45.225 | 45.05 | 45.05 | 5400.0 |
| 2001-04-10 14:00:00 | IWM | ETF | 45.08 | 45.215 | 45.05 | 45.075 | 12400.0 |
| 2001-04-10 14:30:00 | IWM | ETF | 45.05 | 45.205 | 44.915 | 44.925 | 55000.0 |
| 2001-04-10 15:00:00 | IWM | ETF | 45.05 | 45.32 | 45.025 | 45.25 | 49000.0 |
| 2001-04-10 15:30:00 | IWM | ETF | 45.32 | 45.375 | 45.15 | 45.195 | 215200.0 |
| 2001-04-10 16:00:00 | IWM | ETF | 45.2 | 45.2 | 45.2 | 45.2 | 2000.0 |
> showing 50 of 372 rows — these rows as CSV