PREVIEW / etf_30min / 2001-02-16
file: by_date/etf_30min/2001/2001-02-16.parquet size: 14 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-16 09:30:00 | SPY | ETF | 131.0 | 131.13 | 130.5 | 131.0 | 1186200.0 |
| 2001-02-16 10:00:00 | SPY | ETF | 131.05 | 131.29 | 130.74 | 130.75 | 369400.0 |
| 2001-02-16 10:30:00 | SPY | ETF | 130.8 | 131.0 | 130.5 | 130.84 | 201600.0 |
| 2001-02-16 11:00:00 | SPY | ETF | 130.84 | 131.15 | 130.66 | 131.05 | 356000.0 |
| 2001-02-16 11:30:00 | SPY | ETF | 131.15 | 131.21 | 130.84 | 130.92 | 138300.0 |
| 2001-02-16 12:00:00 | SPY | ETF | 130.83 | 131.08 | 130.73 | 130.87 | 219500.0 |
| 2001-02-16 12:30:00 | SPY | ETF | 130.84 | 130.9 | 130.61 | 130.76 | 85100.0 |
| 2001-02-16 13:00:00 | SPY | ETF | 130.6 | 130.71 | 130.45 | 130.5 | 311900.0 |
| 2001-02-16 13:30:00 | SPY | ETF | 130.5 | 130.59 | 130.02 | 130.18 | 744100.0 |
| 2001-02-16 14:00:00 | SPY | ETF | 130.15 | 130.17 | 129.51 | 129.88 | 488500.0 |
| 2001-02-16 14:30:00 | SPY | ETF | 129.88 | 130.68 | 129.86 | 130.52 | 561600.0 |
| 2001-02-16 15:00:00 | SPY | ETF | 130.39 | 130.62 | 130.02 | 130.11 | 374600.0 |
| 2001-02-16 15:30:00 | SPY | ETF | 130.07 | 130.99 | 130.0 | 130.46 | 916400.0 |
| 2001-02-16 16:00:00 | SPY | ETF | 130.46 | 130.6 | 130.31 | 130.5 | 249000.0 |
| 2001-02-16 16:30:00 | SPY | ETF | 130.4 | 130.4 | 130.4 | 130.4 | 100.0 |
| 2001-02-16 09:30:00 | QQQ | ETF | 55.96 | 56.58 | 55.0 | 56.45 | 13637900.0 |
| 2001-02-16 10:00:00 | QQQ | ETF | 56.47 | 56.54 | 55.79 | 55.83 | 5628200.0 |
| 2001-02-16 10:30:00 | QQQ | ETF | 55.82 | 56.1 | 55.52 | 55.83 | 4515100.0 |
| 2001-02-16 11:00:00 | QQQ | ETF | 55.9 | 56.19 | 55.75 | 56.1 | 2241400.0 |
| 2001-02-16 11:30:00 | QQQ | ETF | 56.07 | 56.37 | 55.79 | 55.8 | 2783000.0 |
| 2001-02-16 12:00:00 | QQQ | ETF | 55.9 | 56.02 | 55.76 | 55.86 | 1150400.0 |
| 2001-02-16 12:30:00 | QQQ | ETF | 55.85 | 56.06 | 55.49 | 55.64 | 2368500.0 |
| 2001-02-16 13:00:00 | QQQ | ETF | 55.6 | 55.64 | 55.23 | 55.25 | 2887000.0 |
| 2001-02-16 13:30:00 | QQQ | ETF | 55.25 | 55.44 | 54.77 | 54.98 | 5351000.0 |
| 2001-02-16 14:00:00 | QQQ | ETF | 54.95 | 55.07 | 54.53 | 55.03 | 3729200.0 |
| 2001-02-16 14:30:00 | QQQ | ETF | 55.03 | 55.75 | 54.95 | 55.57 | 6768200.0 |
| 2001-02-16 15:00:00 | QQQ | ETF | 55.53 | 55.75 | 55.2 | 55.2 | 3289700.0 |
| 2001-02-16 15:30:00 | QQQ | ETF | 55.25 | 55.97 | 55.18 | 55.26 | 5973700.0 |
| 2001-02-16 16:00:00 | QQQ | ETF | 55.26 | 55.8 | 55.04 | 55.1 | 1629000.0 |
| 2001-02-16 16:30:00 | QQQ | ETF | 55.15 | 55.3 | 54.9 | 55.0 | 135400.0 |
| 2001-02-16 17:00:00 | QQQ | ETF | 55.0 | 55.4 | 55.0 | 55.3 | 9600.0 |
| 2001-02-16 17:30:00 | QQQ | ETF | 55.4 | 55.4 | 55.18 | 55.29 | 10300.0 |
| 2001-02-16 18:00:00 | QQQ | ETF | 55.27 | 55.45 | 55.2 | 55.25 | 23600.0 |
| 2001-02-16 09:30:00 | IWM | ETF | 49.55 | 50.015 | 49.525 | 50.015 | 240200.0 |
| 2001-02-16 10:00:00 | IWM | ETF | 50.2 | 50.2 | 49.75 | 49.75 | 149400.0 |
| 2001-02-16 10:30:00 | IWM | ETF | 49.925 | 49.925 | 49.895 | 49.895 | 2400.0 |
| 2001-02-16 11:00:00 | IWM | ETF | 49.8 | 49.9 | 49.8 | 49.9 | 600.0 |
| 2001-02-16 11:30:00 | IWM | ETF | 49.875 | 49.925 | 49.775 | 49.875 | 17000.0 |
| 2001-02-16 12:00:00 | IWM | ETF | 49.75 | 49.775 | 49.75 | 49.775 | 600.0 |
| 2001-02-16 12:30:00 | IWM | ETF | 49.875 | 49.875 | 49.875 | 49.875 | 400.0 |
| 2001-02-16 13:00:00 | IWM | ETF | 49.875 | 49.875 | 49.8 | 49.8 | 4800.0 |
| 2001-02-16 13:30:00 | IWM | ETF | 49.55 | 49.725 | 49.525 | 49.575 | 11000.0 |
| 2001-02-16 14:00:00 | IWM | ETF | 49.6 | 49.6 | 49.45 | 49.59 | 177800.0 |
| 2001-02-16 14:30:00 | IWM | ETF | 49.575 | 49.9 | 49.5 | 49.9 | 28200.0 |
| 2001-02-16 15:00:00 | IWM | ETF | 49.65 | 49.85 | 49.65 | 49.7 | 8600.0 |
| 2001-02-16 15:30:00 | IWM | ETF | 49.63 | 50.0 | 49.63 | 49.755 | 30400.0 |
| 2001-02-16 16:00:00 | IWM | ETF | 49.75 | 49.75 | 49.605 | 49.605 | 2800.0 |
| 2001-02-16 09:30:00 | DIA | ETF | 107.78 | 108.38 | 107.51 | 108.29 | 293600.0 |
| 2001-02-16 10:00:00 | DIA | ETF | 108.2 | 108.54 | 108.06 | 108.2 | 150200.0 |
| 2001-02-16 10:30:00 | DIA | ETF | 108.16 | 108.4 | 108.01 | 108.4 | 103600.0 |
> showing 50 of 326 rows — these rows as CSV