PREVIEW / etf_30min / 2001-08-16
file: by_date/etf_30min/2001/2001-08-16.parquet size: 15 KB rows: 364
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-08-16 09:30:00 | SPY | ETF | 117.8 | 117.88 | 117.25 | 117.5 | 1402100.0 |
| 2001-08-16 10:00:00 | SPY | ETF | 117.52 | 117.96 | 117.32 | 117.44 | 958100.0 |
| 2001-08-16 10:30:00 | SPY | ETF | 117.44 | 117.46 | 117.02 | 117.28 | 966100.0 |
| 2001-08-16 11:00:00 | SPY | ETF | 117.24 | 117.79 | 117.24 | 117.49 | 572800.0 |
| 2001-08-16 11:30:00 | SPY | ETF | 117.49 | 117.59 | 117.28 | 117.58 | 373900.0 |
| 2001-08-16 12:00:00 | SPY | ETF | 117.56 | 117.58 | 117.04 | 117.21 | 695900.0 |
| 2001-08-16 12:30:00 | SPY | ETF | 117.17 | 117.42 | 117.17 | 117.27 | 108600.0 |
| 2001-08-16 13:00:00 | SPY | ETF | 117.24 | 117.59 | 117.01 | 117.56 | 520500.0 |
| 2001-08-16 13:30:00 | SPY | ETF | 117.55 | 117.7 | 117.37 | 117.61 | 495900.0 |
| 2001-08-16 14:00:00 | SPY | ETF | 117.61 | 118.06 | 117.56 | 117.91 | 646500.0 |
| 2001-08-16 14:30:00 | SPY | ETF | 117.9 | 118.31 | 117.77 | 118.28 | 1158700.0 |
| 2001-08-16 15:00:00 | SPY | ETF | 118.29 | 118.29 | 117.93 | 118.07 | 491300.0 |
| 2001-08-16 15:30:00 | SPY | ETF | 118.07 | 118.75 | 118.05 | 118.62 | 1283300.0 |
| 2001-08-16 16:00:00 | SPY | ETF | 118.62 | 118.7 | 118.45 | 118.65 | 440700.0 |
| 2001-08-16 16:30:00 | SPY | ETF | 118.52 | 118.55 | 118.52 | 118.55 | 50100.0 |
| 2001-08-16 17:00:00 | SPY | ETF | 118.6 | 118.66 | 118.51 | 118.51 | 300.0 |
| 2001-08-16 18:00:00 | SPY | ETF | 118.42 | 118.42 | 118.41 | 118.41 | 1100.0 |
| 2001-08-16 09:30:00 | QQQ | ETF | 38.64 | 39.0 | 38.04 | 38.25 | 12981500.0 |
| 2001-08-16 10:00:00 | QQQ | ETF | 38.24 | 38.61 | 38.15 | 38.29 | 7038600.0 |
| 2001-08-16 10:30:00 | QQQ | ETF | 38.29 | 38.49 | 38.12 | 38.25 | 4438100.0 |
| 2001-08-16 11:00:00 | QQQ | ETF | 38.25 | 38.52 | 38.25 | 38.35 | 2928500.0 |
| 2001-08-16 11:30:00 | QQQ | ETF | 38.35 | 38.48 | 38.25 | 38.45 | 2016400.0 |
| 2001-08-16 12:00:00 | QQQ | ETF | 38.48 | 38.48 | 38.14 | 38.23 | 3176100.0 |
| 2001-08-16 12:30:00 | QQQ | ETF | 38.24 | 38.36 | 38.23 | 38.29 | 2014300.0 |
| 2001-08-16 13:00:00 | QQQ | ETF | 38.26 | 38.5 | 38.14 | 38.43 | 2467000.0 |
| 2001-08-16 13:30:00 | QQQ | ETF | 38.41 | 38.59 | 38.36 | 38.56 | 3653500.0 |
| 2001-08-16 14:00:00 | QQQ | ETF | 38.56 | 38.95 | 38.5 | 38.89 | 5322200.0 |
| 2001-08-16 14:30:00 | QQQ | ETF | 38.87 | 39.14 | 38.83 | 39.02 | 5209000.0 |
| 2001-08-16 15:00:00 | QQQ | ETF | 39.04 | 39.14 | 38.8 | 38.97 | 4855400.0 |
| 2001-08-16 15:30:00 | QQQ | ETF | 38.95 | 39.39 | 38.88 | 39.37 | 6719700.0 |
| 2001-08-16 16:00:00 | QQQ | ETF | 39.37 | 39.65 | 39.3 | 39.53 | 2432200.0 |
| 2001-08-16 16:30:00 | QQQ | ETF | 39.55 | 39.64 | 39.25 | 39.4 | 91400.0 |
| 2001-08-16 17:00:00 | QQQ | ETF | 39.41 | 39.49 | 39.36 | 39.43 | 37900.0 |
| 2001-08-16 17:30:00 | QQQ | ETF | 39.5 | 39.5 | 39.38 | 39.38 | 29900.0 |
| 2001-08-16 18:00:00 | QQQ | ETF | 39.41 | 39.5 | 39.3 | 39.42 | 28900.0 |
| 2001-08-16 09:30:00 | IWM | ETF | 47.625 | 47.625 | 47.33 | 47.335 | 19600.0 |
| 2001-08-16 10:00:00 | IWM | ETF | 47.37 | 47.56 | 47.37 | 47.535 | 18600.0 |
| 2001-08-16 10:30:00 | IWM | ETF | 47.425 | 47.445 | 47.25 | 47.445 | 108600.0 |
| 2001-08-16 11:00:00 | IWM | ETF | 47.495 | 47.525 | 47.325 | 47.48 | 183600.0 |
| 2001-08-16 11:30:00 | IWM | ETF | 47.425 | 47.45 | 47.335 | 47.41 | 149400.0 |
| 2001-08-16 12:00:00 | IWM | ETF | 47.4 | 47.475 | 47.4 | 47.4 | 121200.0 |
| 2001-08-16 12:30:00 | IWM | ETF | 47.4 | 47.47 | 47.4 | 47.42 | 101200.0 |
| 2001-08-16 13:00:00 | IWM | ETF | 47.38 | 47.475 | 47.38 | 47.475 | 104400.0 |
| 2001-08-16 13:30:00 | IWM | ETF | 47.5 | 47.54 | 47.425 | 47.54 | 232200.0 |
| 2001-08-16 14:00:00 | IWM | ETF | 47.525 | 47.6 | 47.525 | 47.595 | 102400.0 |
| 2001-08-16 14:30:00 | IWM | ETF | 47.6 | 47.8 | 47.6 | 47.75 | 117600.0 |
| 2001-08-16 15:00:00 | IWM | ETF | 47.705 | 47.81 | 47.635 | 47.75 | 156600.0 |
| 2001-08-16 15:30:00 | IWM | ETF | 47.75 | 48.2 | 47.75 | 48.13 | 116400.0 |
| 2001-08-16 16:00:00 | IWM | ETF | 48.145 | 48.25 | 48.1 | 48.1 | 46400.0 |
| 2001-08-16 09:30:00 | DIA | ETF | 103.32 | 103.5 | 103.08 | 103.26 | 658900.0 |
> showing 50 of 364 rows — these rows as CSV