PREVIEW / etf_30min / 2002-03-08
file: by_date/etf_30min/2002/2002-03-08.parquet size: 19 KB rows: 525
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-08 09:30:00 | SPY | ETF | 117.38 | 117.75 | 117.15 | 117.52 | 4255300.0 |
| 2002-03-08 10:00:00 | SPY | ETF | 117.53 | 117.9 | 117.31 | 117.66 | 2350000.0 |
| 2002-03-08 10:30:00 | SPY | ETF | 117.65 | 117.84 | 117.3 | 117.38 | 1328300.0 |
| 2002-03-08 11:00:00 | SPY | ETF | 117.38 | 117.46 | 117.0 | 117.21 | 1428300.0 |
| 2002-03-08 11:30:00 | SPY | ETF | 117.11 | 117.39 | 117.05 | 117.26 | 1354400.0 |
| 2002-03-08 12:00:00 | SPY | ETF | 117.3 | 117.67 | 117.25 | 117.3 | 1020900.0 |
| 2002-03-08 12:30:00 | SPY | ETF | 117.29 | 117.35 | 116.94 | 117.0 | 557900.0 |
| 2002-03-08 13:00:00 | SPY | ETF | 116.95 | 117.27 | 116.89 | 117.2 | 791200.0 |
| 2002-03-08 13:30:00 | SPY | ETF | 117.2 | 117.26 | 116.94 | 117.14 | 412300.0 |
| 2002-03-08 14:00:00 | SPY | ETF | 117.15 | 117.5 | 117.07 | 117.45 | 1164300.0 |
| 2002-03-08 14:30:00 | SPY | ETF | 117.42 | 117.48 | 116.71 | 116.75 | 1400700.0 |
| 2002-03-08 15:00:00 | SPY | ETF | 116.79 | 116.85 | 116.48 | 116.63 | 1289900.0 |
| 2002-03-08 15:30:00 | SPY | ETF | 116.65 | 116.97 | 116.63 | 116.93 | 912200.0 |
| 2002-03-08 16:00:00 | SPY | ETF | 116.88 | 117.15 | 116.8 | 117.04 | 672000.0 |
| 2002-03-08 16:30:00 | SPY | ETF | 117.0 | 117.05 | 116.89 | 117.02 | 49200.0 |
| 2002-03-08 17:00:00 | SPY | ETF | 117.09 | 117.09 | 117.09 | 117.09 | 1000.0 |
| 2002-03-08 17:30:00 | SPY | ETF | 117.09 | 117.09 | 117.07 | 117.07 | 200.0 |
| 2002-03-08 18:00:00 | SPY | ETF | 117.09 | 117.09 | 117.09 | 117.09 | 500.0 |
| 2002-03-08 09:30:00 | QQQ | ETF | 38.23 | 38.48 | 38.13 | 38.4 | 13153100.0 |
| 2002-03-08 10:00:00 | QQQ | ETF | 38.38 | 39.03 | 38.34 | 38.78 | 17695500.0 |
| 2002-03-08 10:30:00 | QQQ | ETF | 38.78 | 38.9 | 38.66 | 38.72 | 6540800.0 |
| 2002-03-08 11:00:00 | QQQ | ETF | 38.7 | 38.77 | 38.55 | 38.69 | 6744100.0 |
| 2002-03-08 11:30:00 | QQQ | ETF | 38.69 | 38.8 | 38.63 | 38.74 | 3071000.0 |
| 2002-03-08 12:00:00 | QQQ | ETF | 38.73 | 38.9 | 38.69 | 38.77 | 3202700.0 |
| 2002-03-08 12:30:00 | QQQ | ETF | 38.79 | 38.8 | 38.52 | 38.54 | 2163000.0 |
| 2002-03-08 13:00:00 | QQQ | ETF | 38.52 | 38.77 | 38.5 | 38.73 | 2955700.0 |
| 2002-03-08 13:30:00 | QQQ | ETF | 38.73 | 38.8 | 38.59 | 38.72 | 1683800.0 |
| 2002-03-08 14:00:00 | QQQ | ETF | 38.71 | 38.92 | 38.67 | 38.87 | 3070300.0 |
| 2002-03-08 14:30:00 | QQQ | ETF | 38.89 | 38.91 | 38.51 | 38.53 | 4703200.0 |
| 2002-03-08 15:00:00 | QQQ | ETF | 38.53 | 38.55 | 38.26 | 38.41 | 6895800.0 |
| 2002-03-08 15:30:00 | QQQ | ETF | 38.4 | 38.68 | 38.39 | 38.67 | 6514700.0 |
| 2002-03-08 16:00:00 | QQQ | ETF | 38.62 | 39.0 | 38.35 | 38.7 | 1301000.0 |
| 2002-03-08 16:30:00 | QQQ | ETF | 38.69 | 38.71 | 38.59 | 38.7 | 44500.0 |
| 2002-03-08 17:00:00 | QQQ | ETF | 38.7 | 38.71 | 38.68 | 38.69 | 22300.0 |
| 2002-03-08 17:30:00 | QQQ | ETF | 38.67 | 38.71 | 38.66 | 38.7 | 6800.0 |
| 2002-03-08 18:00:00 | QQQ | ETF | 38.7 | 38.71 | 38.67 | 38.71 | 5800.0 |
| 2002-03-08 09:30:00 | IWM | ETF | 49.85 | 49.875 | 49.58 | 49.725 | 267200.0 |
| 2002-03-08 10:00:00 | IWM | ETF | 49.65 | 49.88 | 49.61 | 49.86 | 131400.0 |
| 2002-03-08 10:30:00 | IWM | ETF | 49.85 | 49.85 | 49.71 | 49.73 | 45200.0 |
| 2002-03-08 11:00:00 | IWM | ETF | 49.705 | 49.705 | 49.47 | 49.54 | 98600.0 |
| 2002-03-08 11:30:00 | IWM | ETF | 49.54 | 49.62 | 49.53 | 49.6 | 108000.0 |
| 2002-03-08 12:00:00 | IWM | ETF | 49.54 | 49.72 | 49.53 | 49.685 | 18800.0 |
| 2002-03-08 12:30:00 | IWM | ETF | 49.675 | 49.675 | 49.54 | 49.595 | 12400.0 |
| 2002-03-08 13:00:00 | IWM | ETF | 49.535 | 49.575 | 49.52 | 49.525 | 53400.0 |
| 2002-03-08 13:30:00 | IWM | ETF | 49.645 | 49.65 | 49.51 | 49.6 | 64200.0 |
| 2002-03-08 14:00:00 | IWM | ETF | 49.59 | 49.66 | 49.525 | 49.65 | 37400.0 |
| 2002-03-08 14:30:00 | IWM | ETF | 49.65 | 49.72 | 49.5 | 49.5 | 151200.0 |
| 2002-03-08 15:00:00 | IWM | ETF | 49.49 | 49.5 | 49.345 | 49.445 | 58400.0 |
| 2002-03-08 15:30:00 | IWM | ETF | 49.44 | 49.63 | 49.355 | 49.63 | 58200.0 |
| 2002-03-08 16:00:00 | IWM | ETF | 49.69 | 49.69 | 49.69 | 49.69 | 20000.0 |
> showing 50 of 525 rows — these rows as CSV