PREVIEW / etf_30min / 2005-11-17
file: by_date/etf_30min/2005/2005-11-17.parquet size: 52 KB rows: 1,834
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-17 06:00:00 | SPY | ETF | 123.77 | 123.77 | 123.77 | 123.77 | 100.0 |
| 2005-11-17 06:30:00 | SPY | ETF | 123.8 | 123.8 | 123.8 | 123.8 | 600.0 |
| 2005-11-17 07:00:00 | SPY | ETF | 123.8 | 123.85 | 123.79 | 123.85 | 32200.0 |
| 2005-11-17 07:30:00 | SPY | ETF | 123.85 | 123.92 | 123.82 | 123.85 | 104300.0 |
| 2005-11-17 08:00:00 | SPY | ETF | 123.85 | 123.95 | 123.77 | 123.89 | 642300.0 |
| 2005-11-17 08:30:00 | SPY | ETF | 123.9 | 123.9 | 123.8 | 123.85 | 86300.0 |
| 2005-11-17 09:00:00 | SPY | ETF | 123.83 | 123.84 | 123.73 | 123.76 | 169400.0 |
| 2005-11-17 09:30:00 | SPY | ETF | 123.75 | 123.9 | 123.68 | 123.76 | 6316400.0 |
| 2005-11-17 10:00:00 | SPY | ETF | 123.78 | 124.04 | 123.62 | 123.93 | 4713900.0 |
| 2005-11-17 10:30:00 | SPY | ETF | 123.93 | 124.03 | 123.71 | 123.74 | 5010500.0 |
| 2005-11-17 11:00:00 | SPY | ETF | 123.75 | 123.8 | 123.59 | 123.76 | 2467400.0 |
| 2005-11-17 11:30:00 | SPY | ETF | 123.76 | 123.91 | 123.73 | 123.85 | 1442200.0 |
| 2005-11-17 12:00:00 | SPY | ETF | 123.84 | 124.0 | 123.77 | 123.98 | 1504300.0 |
| 2005-11-17 12:30:00 | SPY | ETF | 123.97 | 124.0 | 123.89 | 123.95 | 2802900.0 |
| 2005-11-17 13:00:00 | SPY | ETF | 123.95 | 123.99 | 123.82 | 123.93 | 1185600.0 |
| 2005-11-17 13:30:00 | SPY | ETF | 123.95 | 124.07 | 123.9 | 124.0 | 2058700.0 |
| 2005-11-17 14:00:00 | SPY | ETF | 124.0 | 124.35 | 123.94 | 124.33 | 7864900.0 |
| 2005-11-17 14:30:00 | SPY | ETF | 124.33 | 124.35 | 124.15 | 124.2 | 4239100.0 |
| 2005-11-17 15:00:00 | SPY | ETF | 124.19 | 124.49 | 124.17 | 124.4 | 5512300.0 |
| 2005-11-17 15:30:00 | SPY | ETF | 124.39 | 124.62 | 124.33 | 124.54 | 7332500.0 |
| 2005-11-17 16:00:00 | SPY | ETF | 124.53 | 124.68 | 124.46 | 124.58 | 923100.0 |
| 2005-11-17 16:30:00 | SPY | ETF | 124.57 | 124.58 | 124.52 | 124.55 | 137600.0 |
| 2005-11-17 17:00:00 | SPY | ETF | 124.55 | 124.59 | 124.54 | 124.59 | 37700.0 |
| 2005-11-17 17:30:00 | SPY | ETF | 124.59 | 124.59 | 124.59 | 124.59 | 400.0 |
| 2005-11-17 18:00:00 | SPY | ETF | 124.59 | 124.65 | 124.59 | 124.65 | 75600.0 |
| 2005-11-17 18:30:00 | SPY | ETF | 124.65 | 124.65 | 124.65 | 124.65 | 300.0 |
| 2005-11-17 19:00:00 | SPY | ETF | 124.63 | 124.63 | 124.63 | 124.63 | 200.0 |
| 2005-11-17 19:30:00 | SPY | ETF | 124.64 | 124.64 | 124.64 | 124.64 | 2000.0 |
| 2005-11-17 09:30:00 | QQQ | ETF | 40.91 | 40.94 | 40.88 | 40.9 | 7639900.0 |
| 2005-11-17 10:00:00 | QQQ | ETF | 40.9 | 41.06 | 40.85 | 41.0 | 10872600.0 |
| 2005-11-17 10:30:00 | QQQ | ETF | 41.0 | 41.02 | 40.89 | 40.9 | 3890400.0 |
| 2005-11-17 11:00:00 | QQQ | ETF | 40.9 | 40.98 | 40.85 | 40.97 | 6838400.0 |
| 2005-11-17 11:30:00 | QQQ | ETF | 40.96 | 40.98 | 40.93 | 40.93 | 2414200.0 |
| 2005-11-17 12:00:00 | QQQ | ETF | 40.93 | 41.0 | 40.91 | 41.0 | 3810700.0 |
| 2005-11-17 12:30:00 | QQQ | ETF | 41.0 | 41.02 | 40.96 | 40.98 | 3568000.0 |
| 2005-11-17 13:00:00 | QQQ | ETF | 40.98 | 40.99 | 40.92 | 40.96 | 3838600.0 |
| 2005-11-17 13:30:00 | QQQ | ETF | 40.96 | 41.02 | 40.94 | 41.0 | 2968200.0 |
| 2005-11-17 14:00:00 | QQQ | ETF | 41.0 | 41.05 | 40.97 | 41.01 | 8790500.0 |
| 2005-11-17 14:30:00 | QQQ | ETF | 41.01 | 41.04 | 40.96 | 41.0 | 3866000.0 |
| 2005-11-17 15:00:00 | QQQ | ETF | 41.0 | 41.21 | 41.0 | 41.17 | 14083800.0 |
| 2005-11-17 15:30:00 | QQQ | ETF | 41.17 | 41.32 | 41.14 | 41.31 | 12961600.0 |
| 2005-11-17 08:00:00 | IWM | ETF | 65.5 | 65.55 | 65.48 | 65.54 | 224500.0 |
| 2005-11-17 08:30:00 | IWM | ETF | 65.48 | 65.56 | 65.45 | 65.48 | 8200.0 |
| 2005-11-17 09:00:00 | IWM | ETF | 65.52 | 65.52 | 65.31 | 65.42 | 9200.0 |
| 2005-11-17 09:30:00 | IWM | ETF | 65.43 | 65.8 | 65.42 | 65.78 | 3685800.0 |
| 2005-11-17 10:00:00 | IWM | ETF | 65.79 | 65.83 | 65.49 | 65.69 | 2041700.0 |
| 2005-11-17 10:30:00 | IWM | ETF | 65.7 | 65.72 | 65.55 | 65.61 | 690500.0 |
| 2005-11-17 11:00:00 | IWM | ETF | 65.61 | 65.76 | 65.51 | 65.73 | 741500.0 |
| 2005-11-17 11:30:00 | IWM | ETF | 65.73 | 65.85 | 65.67 | 65.75 | 718400.0 |
| 2005-11-17 12:00:00 | IWM | ETF | 65.75 | 65.84 | 65.69 | 65.84 | 455500.0 |
> showing 50 of 1,834 rows — these rows as CSV