PREVIEW / etf_30min / 2001-11-20
file: by_date/etf_30min/2001/2001-11-20.parquet size: 17 KB rows: 431
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-11-20 09:30:00 | SPY | ETF | 115.37 | 115.5 | 115.08 | 115.38 | 2394100.0 |
| 2001-11-20 10:00:00 | SPY | ETF | 115.43 | 115.66 | 115.24 | 115.35 | 1459200.0 |
| 2001-11-20 10:30:00 | SPY | ETF | 115.29 | 115.4 | 114.87 | 114.99 | 1009600.0 |
| 2001-11-20 11:00:00 | SPY | ETF | 114.95 | 115.19 | 114.91 | 115.16 | 671100.0 |
| 2001-11-20 11:30:00 | SPY | ETF | 115.19 | 115.27 | 115.02 | 115.13 | 316600.0 |
| 2001-11-20 12:00:00 | SPY | ETF | 115.12 | 115.24 | 114.88 | 115.22 | 919300.0 |
| 2001-11-20 12:30:00 | SPY | ETF | 115.2 | 115.27 | 115.04 | 115.22 | 504500.0 |
| 2001-11-20 13:00:00 | SPY | ETF | 115.21 | 115.4 | 115.15 | 115.38 | 554400.0 |
| 2001-11-20 13:30:00 | SPY | ETF | 115.38 | 115.62 | 115.2 | 115.6 | 638300.0 |
| 2001-11-20 14:00:00 | SPY | ETF | 115.55 | 115.8 | 115.31 | 115.39 | 2225400.0 |
| 2001-11-20 14:30:00 | SPY | ETF | 115.38 | 115.45 | 114.98 | 115.02 | 1318600.0 |
| 2001-11-20 15:00:00 | SPY | ETF | 115.05 | 115.05 | 114.64 | 114.94 | 1555500.0 |
| 2001-11-20 15:30:00 | SPY | ETF | 114.95 | 115.03 | 114.65 | 114.81 | 1468200.0 |
| 2001-11-20 16:00:00 | SPY | ETF | 114.76 | 114.91 | 114.7 | 114.8 | 1009800.0 |
| 2001-11-20 16:30:00 | SPY | ETF | 114.83 | 114.83 | 114.75 | 114.75 | 48500.0 |
| 2001-11-20 17:00:00 | SPY | ETF | 114.8 | 114.85 | 114.71 | 114.71 | 1900.0 |
| 2001-11-20 17:30:00 | SPY | ETF | 114.65 | 114.65 | 114.5 | 114.5 | 1400.0 |
| 2001-11-20 09:30:00 | QQQ | ETF | 40.08 | 40.23 | 39.83 | 40.0 | 13335000.0 |
| 2001-11-20 10:00:00 | QQQ | ETF | 40.0 | 40.11 | 39.81 | 39.85 | 8755500.0 |
| 2001-11-20 10:30:00 | QQQ | ETF | 39.85 | 39.9 | 39.38 | 39.5 | 7501000.0 |
| 2001-11-20 11:00:00 | QQQ | ETF | 39.5 | 39.73 | 39.45 | 39.64 | 5326400.0 |
| 2001-11-20 11:30:00 | QQQ | ETF | 39.64 | 39.64 | 39.42 | 39.45 | 2814200.0 |
| 2001-11-20 12:00:00 | QQQ | ETF | 39.44 | 39.45 | 39.17 | 39.37 | 5190300.0 |
| 2001-11-20 12:30:00 | QQQ | ETF | 39.38 | 39.42 | 39.23 | 39.35 | 2401400.0 |
| 2001-11-20 13:00:00 | QQQ | ETF | 39.33 | 39.49 | 39.3 | 39.45 | 2363400.0 |
| 2001-11-20 13:30:00 | QQQ | ETF | 39.45 | 39.58 | 39.33 | 39.57 | 3754400.0 |
| 2001-11-20 14:00:00 | QQQ | ETF | 39.57 | 39.59 | 39.24 | 39.26 | 4606600.0 |
| 2001-11-20 14:30:00 | QQQ | ETF | 39.26 | 39.33 | 38.96 | 39.03 | 6305200.0 |
| 2001-11-20 15:00:00 | QQQ | ETF | 39.02 | 39.04 | 38.65 | 38.8 | 9268900.0 |
| 2001-11-20 15:30:00 | QQQ | ETF | 38.8 | 38.88 | 38.48 | 38.63 | 10779300.0 |
| 2001-11-20 16:00:00 | QQQ | ETF | 38.63 | 39.38 | 38.5 | 38.59 | 2114400.0 |
| 2001-11-20 16:30:00 | QQQ | ETF | 38.6 | 38.66 | 38.6 | 38.62 | 54600.0 |
| 2001-11-20 17:00:00 | QQQ | ETF | 38.65 | 38.69 | 38.58 | 38.61 | 66600.0 |
| 2001-11-20 17:30:00 | QQQ | ETF | 38.6 | 38.61 | 38.5 | 38.5 | 34600.0 |
| 2001-11-20 18:00:00 | QQQ | ETF | 38.5 | 38.55 | 38.47 | 38.55 | 10900.0 |
| 2001-11-20 09:30:00 | IWM | ETF | 45.5 | 45.66 | 45.36 | 45.45 | 48400.0 |
| 2001-11-20 10:00:00 | IWM | ETF | 45.625 | 45.67 | 45.5 | 45.575 | 56000.0 |
| 2001-11-20 10:30:00 | IWM | ETF | 45.575 | 45.585 | 45.3 | 45.3 | 17400.0 |
| 2001-11-20 11:00:00 | IWM | ETF | 45.465 | 45.52 | 45.305 | 45.335 | 11400.0 |
| 2001-11-20 11:30:00 | IWM | ETF | 45.545 | 45.575 | 45.33 | 45.525 | 17000.0 |
| 2001-11-20 12:00:00 | IWM | ETF | 45.465 | 45.575 | 45.31 | 45.39 | 41400.0 |
| 2001-11-20 12:30:00 | IWM | ETF | 45.385 | 45.575 | 45.385 | 45.575 | 7400.0 |
| 2001-11-20 13:00:00 | IWM | ETF | 45.625 | 45.64 | 45.455 | 45.64 | 4000.0 |
| 2001-11-20 13:30:00 | IWM | ETF | 45.455 | 45.745 | 45.455 | 45.745 | 17400.0 |
| 2001-11-20 14:00:00 | IWM | ETF | 45.575 | 45.825 | 45.575 | 45.575 | 5000.0 |
| 2001-11-20 14:30:00 | IWM | ETF | 45.505 | 45.69 | 45.45 | 45.59 | 14200.0 |
| 2001-11-20 15:00:00 | IWM | ETF | 45.59 | 45.59 | 45.25 | 45.5 | 30800.0 |
| 2001-11-20 15:30:00 | IWM | ETF | 45.3 | 45.495 | 45.05 | 45.24 | 183800.0 |
| 2001-11-20 09:30:00 | DIA | ETF | 99.7 | 99.7 | 99.35 | 99.62 | 505400.0 |
| 2001-11-20 10:00:00 | DIA | ETF | 99.62 | 99.75 | 99.36 | 99.48 | 189900.0 |
> showing 50 of 431 rows — these rows as CSV