PREVIEW / etf_30min / 2001-03-12
file: by_date/etf_30min/2001/2001-03-12.parquet size: 15 KB rows: 368
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-03-12 09:30:00 | SPY | ETF | 122.34 | 122.5 | 120.8 | 121.7 | 1854700.0 |
| 2001-03-12 10:00:00 | SPY | ETF | 121.84 | 121.84 | 120.8 | 121.35 | 520000.0 |
| 2001-03-12 10:30:00 | SPY | ETF | 121.25 | 121.42 | 120.82 | 121.02 | 643300.0 |
| 2001-03-12 11:00:00 | SPY | ETF | 121.0 | 121.02 | 120.31 | 120.68 | 468200.0 |
| 2001-03-12 11:30:00 | SPY | ETF | 120.64 | 120.98 | 120.43 | 120.57 | 666300.0 |
| 2001-03-12 12:00:00 | SPY | ETF | 120.45 | 120.58 | 120.3 | 120.56 | 354800.0 |
| 2001-03-12 12:30:00 | SPY | ETF | 120.59 | 121.02 | 120.43 | 120.83 | 443100.0 |
| 2001-03-12 13:00:00 | SPY | ETF | 121.07 | 121.4 | 120.77 | 121.1 | 573200.0 |
| 2001-03-12 13:30:00 | SPY | ETF | 121.1 | 121.13 | 120.05 | 120.09 | 448300.0 |
| 2001-03-12 14:00:00 | SPY | ETF | 120.17 | 120.83 | 120.05 | 120.83 | 537500.0 |
| 2001-03-12 14:30:00 | SPY | ETF | 120.67 | 120.7 | 119.71 | 120.04 | 576000.0 |
| 2001-03-12 15:00:00 | SPY | ETF | 120.0 | 120.45 | 119.61 | 119.69 | 938000.0 |
| 2001-03-12 15:30:00 | SPY | ETF | 119.65 | 119.75 | 117.75 | 118.44 | 3245600.0 |
| 2001-03-12 16:00:00 | SPY | ETF | 118.44 | 118.44 | 117.82 | 118.08 | 954100.0 |
| 2001-03-12 16:30:00 | SPY | ETF | 117.75 | 121.0 | 117.55 | 118.0 | 2900.0 |
| 2001-03-12 17:00:00 | SPY | ETF | 119.34 | 119.34 | 118.0 | 118.0 | 1151100.0 |
| 2001-03-12 17:30:00 | SPY | ETF | 118.18 | 118.18 | 118.0 | 118.18 | 1900.0 |
| 2001-03-12 18:00:00 | SPY | ETF | 118.43 | 118.43 | 118.43 | 118.43 | 200.0 |
| 2001-03-12 09:30:00 | QQQ | ETF | 44.0 | 44.95 | 43.2 | 43.83 | 11719600.0 |
| 2001-03-12 10:00:00 | QQQ | ETF | 43.84 | 43.9 | 43.38 | 43.62 | 4445700.0 |
| 2001-03-12 10:30:00 | QQQ | ETF | 43.63 | 43.7 | 42.83 | 42.99 | 5809200.0 |
| 2001-03-12 11:00:00 | QQQ | ETF | 42.99 | 43.1 | 42.28 | 42.65 | 7479500.0 |
| 2001-03-12 11:30:00 | QQQ | ETF | 42.7 | 43.03 | 42.55 | 42.75 | 3232200.0 |
| 2001-03-12 12:00:00 | QQQ | ETF | 42.66 | 42.8 | 42.47 | 42.76 | 2260700.0 |
| 2001-03-12 12:30:00 | QQQ | ETF | 42.73 | 43.29 | 42.72 | 43.28 | 3345500.0 |
| 2001-03-12 13:00:00 | QQQ | ETF | 43.22 | 43.81 | 43.2 | 43.6 | 7313000.0 |
| 2001-03-12 13:30:00 | QQQ | ETF | 43.59 | 43.67 | 42.75 | 42.75 | 4673800.0 |
| 2001-03-12 14:00:00 | QQQ | ETF | 42.82 | 43.7 | 42.68 | 43.65 | 4993800.0 |
| 2001-03-12 14:30:00 | QQQ | ETF | 43.64 | 43.72 | 42.7 | 43.04 | 4503600.0 |
| 2001-03-12 15:00:00 | QQQ | ETF | 43.0 | 43.36 | 42.58 | 42.61 | 3209100.0 |
| 2001-03-12 15:30:00 | QQQ | ETF | 42.6 | 42.7 | 41.8 | 41.95 | 11395100.0 |
| 2001-03-12 16:00:00 | QQQ | ETF | 41.85 | 42.3 | 41.8 | 42.19 | 2725500.0 |
| 2001-03-12 16:30:00 | QQQ | ETF | 42.16 | 42.5 | 42.11 | 42.15 | 46100.0 |
| 2001-03-12 17:00:00 | QQQ | ETF | 42.11 | 42.3 | 42.07 | 42.15 | 37900.0 |
| 2001-03-12 17:30:00 | QQQ | ETF | 42.07 | 42.1 | 42.0 | 42.05 | 36000.0 |
| 2001-03-12 18:00:00 | QQQ | ETF | 42.09 | 42.1 | 42.0 | 42.05 | 26700.0 |
| 2001-03-12 09:30:00 | IWM | ETF | 46.625 | 46.625 | 46.205 | 46.4 | 119200.0 |
| 2001-03-12 10:00:00 | IWM | ETF | 46.5 | 46.55 | 46.25 | 46.25 | 65800.0 |
| 2001-03-12 10:30:00 | IWM | ETF | 46.3 | 46.5 | 46.175 | 46.175 | 34400.0 |
| 2001-03-12 11:00:00 | IWM | ETF | 46.345 | 46.37 | 46.175 | 46.3 | 46000.0 |
| 2001-03-12 11:30:00 | IWM | ETF | 46.395 | 46.395 | 46.175 | 46.185 | 51200.0 |
| 2001-03-12 12:00:00 | IWM | ETF | 46.245 | 46.275 | 45.975 | 45.975 | 27600.0 |
| 2001-03-12 12:30:00 | IWM | ETF | 46.005 | 46.29 | 45.98 | 46.29 | 13000.0 |
| 2001-03-12 13:00:00 | IWM | ETF | 46.37 | 46.6 | 46.37 | 46.6 | 21400.0 |
| 2001-03-12 13:30:00 | IWM | ETF | 46.29 | 46.475 | 46.25 | 46.25 | 34600.0 |
| 2001-03-12 14:00:00 | IWM | ETF | 46.22 | 46.255 | 46.125 | 46.255 | 225400.0 |
| 2001-03-12 14:30:00 | IWM | ETF | 46.165 | 46.165 | 46.0 | 46.0 | 4400.0 |
| 2001-03-12 15:00:00 | IWM | ETF | 46.025 | 46.075 | 45.85 | 45.85 | 47000.0 |
| 2001-03-12 15:30:00 | IWM | ETF | 45.905 | 45.905 | 45.33 | 45.5 | 305800.0 |
| 2001-03-12 16:00:00 | IWM | ETF | 45.525 | 45.625 | 45.525 | 45.625 | 1200.0 |
> showing 50 of 368 rows — these rows as CSV