PREVIEW / etf_30min / 2001-10-01
file: by_date/etf_30min/2001/2001-10-01.parquet size: 16 KB rows: 430
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-01 09:30:00 | SPY | ETF | 103.9 | 104.1 | 103.52 | 103.7 | 4106000.0 |
| 2001-10-01 10:00:00 | SPY | ETF | 103.7 | 103.73 | 103.07 | 103.25 | 2416400.0 |
| 2001-10-01 10:30:00 | SPY | ETF | 103.28 | 103.43 | 102.83 | 103.08 | 1533800.0 |
| 2001-10-01 11:00:00 | SPY | ETF | 103.04 | 103.3 | 102.97 | 103.09 | 1482600.0 |
| 2001-10-01 11:30:00 | SPY | ETF | 103.13 | 103.45 | 103.11 | 103.39 | 860200.0 |
| 2001-10-01 12:00:00 | SPY | ETF | 103.43 | 103.62 | 103.21 | 103.57 | 1186400.0 |
| 2001-10-01 12:30:00 | SPY | ETF | 103.57 | 103.95 | 103.41 | 103.95 | 688200.0 |
| 2001-10-01 13:00:00 | SPY | ETF | 103.95 | 103.98 | 103.7 | 103.82 | 947300.0 |
| 2001-10-01 13:30:00 | SPY | ETF | 103.84 | 104.32 | 103.82 | 104.0 | 1250300.0 |
| 2001-10-01 14:00:00 | SPY | ETF | 103.99 | 104.04 | 103.79 | 103.82 | 958000.0 |
| 2001-10-01 14:30:00 | SPY | ETF | 103.82 | 104.04 | 103.69 | 103.9 | 867400.0 |
| 2001-10-01 15:00:00 | SPY | ETF | 103.92 | 103.95 | 103.6 | 103.82 | 1489400.0 |
| 2001-10-01 15:30:00 | SPY | ETF | 103.76 | 104.12 | 103.51 | 104.0 | 1600500.0 |
| 2001-10-01 16:00:00 | SPY | ETF | 104.05 | 104.3 | 103.63 | 104.2 | 540100.0 |
| 2001-10-01 16:30:00 | SPY | ETF | 104.27 | 104.27 | 103.98 | 104.19 | 23200.0 |
| 2001-10-01 17:00:00 | SPY | ETF | 104.18 | 104.23 | 104.18 | 104.23 | 10600.0 |
| 2001-10-01 17:30:00 | SPY | ETF | 104.27 | 104.27 | 104.27 | 104.27 | 100.0 |
| 2001-10-01 18:00:00 | SPY | ETF | 104.58 | 104.58 | 104.58 | 104.58 | 400.0 |
| 2001-10-01 09:30:00 | QQQ | ETF | 28.85 | 28.98 | 28.54 | 28.62 | 9904800.0 |
| 2001-10-01 10:00:00 | QQQ | ETF | 28.6 | 28.67 | 28.28 | 28.37 | 6523300.0 |
| 2001-10-01 10:30:00 | QQQ | ETF | 28.39 | 28.52 | 28.16 | 28.25 | 5238000.0 |
| 2001-10-01 11:00:00 | QQQ | ETF | 28.25 | 28.42 | 28.17 | 28.24 | 3232300.0 |
| 2001-10-01 11:30:00 | QQQ | ETF | 28.25 | 28.44 | 28.22 | 28.4 | 2543800.0 |
| 2001-10-01 12:00:00 | QQQ | ETF | 28.39 | 28.49 | 28.23 | 28.45 | 1727800.0 |
| 2001-10-01 12:30:00 | QQQ | ETF | 28.45 | 28.75 | 28.4 | 28.72 | 2186000.0 |
| 2001-10-01 13:00:00 | QQQ | ETF | 28.72 | 28.74 | 28.56 | 28.63 | 2445200.0 |
| 2001-10-01 13:30:00 | QQQ | ETF | 28.62 | 28.97 | 28.62 | 28.75 | 4125900.0 |
| 2001-10-01 14:00:00 | QQQ | ETF | 28.75 | 28.83 | 28.63 | 28.68 | 3009500.0 |
| 2001-10-01 14:30:00 | QQQ | ETF | 28.67 | 28.74 | 28.53 | 28.65 | 1952600.0 |
| 2001-10-01 15:00:00 | QQQ | ETF | 28.66 | 28.68 | 28.4 | 28.51 | 3860400.0 |
| 2001-10-01 15:30:00 | QQQ | ETF | 28.51 | 28.66 | 28.37 | 28.61 | 4181500.0 |
| 2001-10-01 16:00:00 | QQQ | ETF | 28.64 | 28.74 | 28.51 | 28.69 | 719200.0 |
| 2001-10-01 16:30:00 | QQQ | ETF | 28.6 | 28.7 | 28.56 | 28.67 | 71500.0 |
| 2001-10-01 17:00:00 | QQQ | ETF | 28.75 | 28.81 | 28.65 | 28.67 | 7700.0 |
| 2001-10-01 17:30:00 | QQQ | ETF | 28.67 | 28.71 | 28.6 | 28.69 | 4600.0 |
| 2001-10-01 18:00:00 | QQQ | ETF | 28.68 | 28.68 | 28.58 | 28.63 | 15000.0 |
| 2001-10-01 09:30:00 | IWM | ETF | 40.1 | 40.145 | 39.605 | 39.605 | 26000.0 |
| 2001-10-01 10:00:00 | IWM | ETF | 39.575 | 39.625 | 39.29 | 39.295 | 57600.0 |
| 2001-10-01 10:30:00 | IWM | ETF | 39.295 | 39.325 | 39.025 | 39.12 | 444000.0 |
| 2001-10-01 11:00:00 | IWM | ETF | 39.16 | 39.32 | 39.06 | 39.26 | 109000.0 |
| 2001-10-01 11:30:00 | IWM | ETF | 39.235 | 39.37 | 39.235 | 39.345 | 4800.0 |
| 2001-10-01 12:00:00 | IWM | ETF | 39.35 | 39.35 | 39.325 | 39.345 | 14400.0 |
| 2001-10-01 12:30:00 | IWM | ETF | 39.345 | 39.45 | 39.335 | 39.45 | 17800.0 |
| 2001-10-01 13:00:00 | IWM | ETF | 39.475 | 39.475 | 39.45 | 39.45 | 14400.0 |
| 2001-10-01 13:30:00 | IWM | ETF | 39.555 | 39.73 | 39.555 | 39.685 | 2800.0 |
| 2001-10-01 14:00:00 | IWM | ETF | 39.57 | 39.6 | 39.535 | 39.555 | 2800.0 |
| 2001-10-01 14:30:00 | IWM | ETF | 39.525 | 39.555 | 39.35 | 39.475 | 17000.0 |
| 2001-10-01 15:00:00 | IWM | ETF | 39.45 | 39.49 | 39.425 | 39.47 | 69000.0 |
| 2001-10-01 15:30:00 | IWM | ETF | 39.405 | 39.645 | 39.375 | 39.625 | 45600.0 |
| 2001-10-01 16:00:00 | IWM | ETF | 39.725 | 39.75 | 39.6 | 39.6 | 64000.0 |
> showing 50 of 430 rows — these rows as CSV