PREVIEW / etf_30min / 2001-10-03
file: by_date/etf_30min/2001/2001-10-03.parquet size: 17 KB rows: 425
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-10-03 09:30:00 | SPY | ETF | 104.6 | 104.78 | 104.35 | 104.45 | 3329400.0 |
| 2001-10-03 10:00:00 | SPY | ETF | 104.47 | 105.48 | 104.35 | 105.1 | 4368700.0 |
| 2001-10-03 10:30:00 | SPY | ETF | 105.12 | 105.58 | 105.06 | 105.29 | 2140500.0 |
| 2001-10-03 11:00:00 | SPY | ETF | 105.26 | 105.67 | 105.22 | 105.67 | 1248700.0 |
| 2001-10-03 11:30:00 | SPY | ETF | 105.67 | 106.98 | 105.65 | 106.65 | 2846200.0 |
| 2001-10-03 12:00:00 | SPY | ETF | 106.68 | 106.7 | 106.12 | 106.18 | 2184000.0 |
| 2001-10-03 12:30:00 | SPY | ETF | 106.19 | 106.91 | 106.17 | 106.8 | 1858900.0 |
| 2001-10-03 13:00:00 | SPY | ETF | 106.8 | 107.08 | 106.45 | 107.0 | 1629800.0 |
| 2001-10-03 13:30:00 | SPY | ETF | 106.93 | 107.44 | 106.72 | 107.27 | 2241000.0 |
| 2001-10-03 14:00:00 | SPY | ETF | 107.25 | 107.48 | 106.82 | 107.23 | 1550800.0 |
| 2001-10-03 14:30:00 | SPY | ETF | 107.22 | 107.65 | 107.1 | 107.52 | 1245200.0 |
| 2001-10-03 15:00:00 | SPY | ETF | 107.5 | 107.87 | 107.48 | 107.5 | 1290200.0 |
| 2001-10-03 15:30:00 | SPY | ETF | 107.56 | 107.88 | 107.25 | 107.34 | 3301500.0 |
| 2001-10-03 16:00:00 | SPY | ETF | 107.46 | 107.7 | 107.0 | 107.25 | 1725600.0 |
| 2001-10-03 16:30:00 | SPY | ETF | 107.3 | 107.35 | 107.25 | 107.3 | 24500.0 |
| 2001-10-03 17:00:00 | SPY | ETF | 107.3 | 107.4 | 107.3 | 107.4 | 4100.0 |
| 2001-10-03 17:30:00 | SPY | ETF | 107.36 | 107.4 | 107.35 | 107.36 | 1400.0 |
| 2001-10-03 18:00:00 | SPY | ETF | 107.35 | 107.39 | 107.2 | 107.39 | 700.0 |
| 2001-10-03 09:30:00 | QQQ | ETF | 28.42 | 28.69 | 28.33 | 28.48 | 7587100.0 |
| 2001-10-03 10:00:00 | QQQ | ETF | 28.47 | 29.1 | 28.38 | 28.89 | 10595700.0 |
| 2001-10-03 10:30:00 | QQQ | ETF | 28.91 | 29.46 | 28.85 | 29.31 | 12786700.0 |
| 2001-10-03 11:00:00 | QQQ | ETF | 29.32 | 29.78 | 29.27 | 29.77 | 8266500.0 |
| 2001-10-03 11:30:00 | QQQ | ETF | 29.8 | 30.64 | 29.66 | 30.4 | 11556100.0 |
| 2001-10-03 12:00:00 | QQQ | ETF | 30.4 | 30.55 | 29.95 | 30.01 | 8593000.0 |
| 2001-10-03 12:30:00 | QQQ | ETF | 30.02 | 31.0 | 30.0 | 30.9 | 9006500.0 |
| 2001-10-03 13:00:00 | QQQ | ETF | 30.88 | 31.23 | 30.71 | 31.14 | 10541400.0 |
| 2001-10-03 13:30:00 | QQQ | ETF | 31.14 | 31.41 | 30.9 | 31.32 | 6696700.0 |
| 2001-10-03 14:00:00 | QQQ | ETF | 31.35 | 31.45 | 30.87 | 31.15 | 8249400.0 |
| 2001-10-03 14:30:00 | QQQ | ETF | 31.11 | 31.5 | 31.01 | 31.41 | 8148900.0 |
| 2001-10-03 15:00:00 | QQQ | ETF | 31.4 | 31.61 | 31.33 | 31.44 | 9183100.0 |
| 2001-10-03 15:30:00 | QQQ | ETF | 31.44 | 31.6 | 30.85 | 31.05 | 13283500.0 |
| 2001-10-03 16:00:00 | QQQ | ETF | 31.09 | 31.32 | 30.22 | 31.0 | 4950300.0 |
| 2001-10-03 16:30:00 | QQQ | ETF | 31.0 | 31.04 | 30.22 | 31.0 | 145000.0 |
| 2001-10-03 17:00:00 | QQQ | ETF | 31.03 | 31.06 | 30.97 | 31.02 | 46300.0 |
| 2001-10-03 17:30:00 | QQQ | ETF | 31.03 | 31.07 | 30.95 | 31.0 | 41700.0 |
| 2001-10-03 18:00:00 | QQQ | ETF | 30.97 | 31.07 | 30.9 | 30.91 | 22400.0 |
| 2001-10-03 09:30:00 | IWM | ETF | 39.5 | 39.87 | 39.5 | 39.87 | 17400.0 |
| 2001-10-03 10:00:00 | IWM | ETF | 39.925 | 40.275 | 39.925 | 40.08 | 263400.0 |
| 2001-10-03 10:30:00 | IWM | ETF | 40.115 | 40.285 | 40.115 | 40.285 | 59200.0 |
| 2001-10-03 11:00:00 | IWM | ETF | 40.35 | 40.475 | 40.34 | 40.475 | 206400.0 |
| 2001-10-03 11:30:00 | IWM | ETF | 40.495 | 40.725 | 40.48 | 40.725 | 219600.0 |
| 2001-10-03 12:00:00 | IWM | ETF | 40.745 | 40.745 | 40.6 | 40.665 | 215400.0 |
| 2001-10-03 12:30:00 | IWM | ETF | 40.64 | 40.725 | 40.615 | 40.68 | 27400.0 |
| 2001-10-03 13:00:00 | IWM | ETF | 40.725 | 40.95 | 40.635 | 40.95 | 147800.0 |
| 2001-10-03 13:30:00 | IWM | ETF | 40.95 | 41.0 | 40.83 | 40.99 | 55800.0 |
| 2001-10-03 14:00:00 | IWM | ETF | 40.995 | 41.025 | 40.935 | 40.97 | 12600.0 |
| 2001-10-03 14:30:00 | IWM | ETF | 40.97 | 41.15 | 40.97 | 41.15 | 41200.0 |
| 2001-10-03 15:00:00 | IWM | ETF | 41.145 | 41.375 | 41.125 | 41.125 | 16000.0 |
| 2001-10-03 15:30:00 | IWM | ETF | 41.125 | 41.295 | 40.95 | 41.0 | 12400.0 |
| 2001-10-03 16:00:00 | IWM | ETF | 41.125 | 41.125 | 41.1 | 41.1 | 22000.0 |
> showing 50 of 425 rows — these rows as CSV