PREVIEW / etf_30min / 2001-02-01
file: by_date/etf_30min/2001/2001-02-01.parquet size: 13 KB rows: 326
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-02-01 09:30:00 | SPY | ETF | 137.1 | 137.18 | 136.75 | 136.95 | 1372800.0 |
| 2001-02-01 10:00:00 | SPY | ETF | 136.98 | 137.05 | 136.26 | 136.45 | 871300.0 |
| 2001-02-01 10:30:00 | SPY | ETF | 136.45 | 136.99 | 136.3 | 136.59 | 552500.0 |
| 2001-02-01 11:00:00 | SPY | ETF | 136.59 | 137.4 | 136.59 | 137.34 | 563600.0 |
| 2001-02-01 11:30:00 | SPY | ETF | 137.34 | 137.5 | 137.15 | 137.48 | 1080300.0 |
| 2001-02-01 12:00:00 | SPY | ETF | 137.48 | 137.48 | 137.1 | 137.15 | 175000.0 |
| 2001-02-01 12:30:00 | SPY | ETF | 137.15 | 137.15 | 136.73 | 136.92 | 246100.0 |
| 2001-02-01 13:00:00 | SPY | ETF | 136.94 | 137.13 | 136.64 | 136.69 | 153700.0 |
| 2001-02-01 13:30:00 | SPY | ETF | 136.68 | 136.75 | 136.25 | 136.48 | 194500.0 |
| 2001-02-01 14:00:00 | SPY | ETF | 136.35 | 136.9 | 136.3 | 136.69 | 364500.0 |
| 2001-02-01 14:30:00 | SPY | ETF | 136.69 | 136.95 | 136.4 | 136.7 | 215600.0 |
| 2001-02-01 15:00:00 | SPY | ETF | 136.84 | 137.2 | 136.65 | 137.1 | 786700.0 |
| 2001-02-01 15:30:00 | SPY | ETF | 137.15 | 137.56 | 137.07 | 137.48 | 985500.0 |
| 2001-02-01 16:00:00 | SPY | ETF | 137.32 | 137.95 | 137.2 | 137.32 | 457800.0 |
| 2001-02-01 16:30:00 | SPY | ETF | 138.0 | 138.0 | 138.0 | 138.0 | 700.0 |
| 2001-02-01 09:30:00 | QQQ | ETF | 64.55 | 64.9 | 64.02 | 64.53 | 6911500.0 |
| 2001-02-01 10:00:00 | QQQ | ETF | 64.49 | 64.69 | 63.6 | 63.9 | 5247700.0 |
| 2001-02-01 10:30:00 | QQQ | ETF | 63.88 | 64.52 | 63.85 | 64.2 | 2539300.0 |
| 2001-02-01 11:00:00 | QQQ | ETF | 64.2 | 65.28 | 64.1 | 65.25 | 4042500.0 |
| 2001-02-01 11:30:00 | QQQ | ETF | 65.25 | 65.61 | 65.05 | 65.43 | 4911800.0 |
| 2001-02-01 12:00:00 | QQQ | ETF | 65.46 | 65.5 | 64.9 | 64.96 | 2495700.0 |
| 2001-02-01 12:30:00 | QQQ | ETF | 64.95 | 65.0 | 64.5 | 64.65 | 1811000.0 |
| 2001-02-01 13:00:00 | QQQ | ETF | 64.64 | 64.9 | 64.38 | 64.47 | 1701000.0 |
| 2001-02-01 13:30:00 | QQQ | ETF | 64.45 | 64.5 | 63.9 | 64.0 | 1940800.0 |
| 2001-02-01 14:00:00 | QQQ | ETF | 63.99 | 64.73 | 63.95 | 64.5 | 1871300.0 |
| 2001-02-01 14:30:00 | QQQ | ETF | 64.51 | 64.76 | 64.15 | 64.62 | 2172000.0 |
| 2001-02-01 15:00:00 | QQQ | ETF | 64.58 | 64.98 | 64.4 | 64.94 | 2545500.0 |
| 2001-02-01 15:30:00 | QQQ | ETF | 64.94 | 65.2 | 64.77 | 65.0 | 3763800.0 |
| 2001-02-01 16:00:00 | QQQ | ETF | 65.0 | 65.24 | 64.85 | 65.2 | 985700.0 |
| 2001-02-01 16:30:00 | QQQ | ETF | 65.25 | 65.5 | 65.1 | 65.2 | 12400.0 |
| 2001-02-01 17:00:00 | QQQ | ETF | 65.25 | 65.28 | 65.1 | 65.1 | 7300.0 |
| 2001-02-01 17:30:00 | QQQ | ETF | 65.1 | 65.3 | 65.1 | 65.18 | 6300.0 |
| 2001-02-01 18:00:00 | QQQ | ETF | 65.17 | 65.18 | 65.17 | 65.18 | 1200.0 |
| 2001-02-01 09:30:00 | IWM | ETF | 50.475 | 50.625 | 50.475 | 50.475 | 34600.0 |
| 2001-02-01 10:00:00 | IWM | ETF | 50.465 | 50.465 | 50.25 | 50.425 | 75400.0 |
| 2001-02-01 10:30:00 | IWM | ETF | 50.375 | 50.375 | 50.28 | 50.37 | 5400.0 |
| 2001-02-01 11:00:00 | IWM | ETF | 50.37 | 50.55 | 50.34 | 50.55 | 46400.0 |
| 2001-02-01 11:30:00 | IWM | ETF | 50.675 | 50.7 | 50.5 | 50.685 | 14400.0 |
| 2001-02-01 12:00:00 | IWM | ETF | 50.75 | 50.75 | 50.655 | 50.655 | 1800.0 |
| 2001-02-01 12:30:00 | IWM | ETF | 50.505 | 50.675 | 50.5 | 50.585 | 7400.0 |
| 2001-02-01 13:00:00 | IWM | ETF | 50.625 | 50.63 | 50.5 | 50.5 | 16400.0 |
| 2001-02-01 13:30:00 | IWM | ETF | 50.41 | 50.49 | 50.3 | 50.33 | 17800.0 |
| 2001-02-01 14:00:00 | IWM | ETF | 50.4 | 50.49 | 50.4 | 50.49 | 3400.0 |
| 2001-02-01 14:30:00 | IWM | ETF | 50.49 | 50.6 | 50.4 | 50.45 | 38400.0 |
| 2001-02-01 15:00:00 | IWM | ETF | 50.65 | 50.7 | 50.505 | 50.505 | 24800.0 |
| 2001-02-01 15:30:00 | IWM | ETF | 50.725 | 50.8 | 50.6 | 50.8 | 411400.0 |
| 2001-02-01 16:00:00 | IWM | ETF | 50.82 | 50.82 | 50.82 | 50.82 | 3200.0 |
| 2001-02-01 09:30:00 | DIA | ETF | 108.72 | 109.21 | 108.4 | 109.09 | 189900.0 |
| 2001-02-01 10:00:00 | DIA | ETF | 109.13 | 109.2 | 108.65 | 108.7 | 186600.0 |
| 2001-02-01 10:30:00 | DIA | ETF | 108.74 | 109.2 | 108.7 | 108.9 | 71200.0 |
> showing 50 of 326 rows — these rows as CSV