PREVIEW / etf_30min / 2005-10-21
file: by_date/etf_30min/2005/2005-10-21.parquet size: 50 KB rows: 1,699
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-10-21 05:00:00 | SPY | ETF | 118.32 | 118.32 | 118.32 | 118.32 | 6600.0 |
| 2005-10-21 05:30:00 | SPY | ETF | 118.32 | 118.32 | 118.32 | 118.32 | 50000.0 |
| 2005-10-21 07:00:00 | SPY | ETF | 118.12 | 118.15 | 118.07 | 118.1 | 69300.0 |
| 2005-10-21 07:30:00 | SPY | ETF | 118.07 | 118.15 | 118.07 | 118.13 | 71200.0 |
| 2005-10-21 08:00:00 | SPY | ETF | 118.11 | 118.35 | 118.07 | 118.21 | 1406500.0 |
| 2005-10-21 08:30:00 | SPY | ETF | 118.23 | 118.29 | 118.14 | 118.14 | 1487200.0 |
| 2005-10-21 09:00:00 | SPY | ETF | 118.13 | 118.4 | 117.51 | 118.3 | 3100700.0 |
| 2005-10-21 09:30:00 | SPY | ETF | 118.29 | 118.66 | 118.1 | 118.28 | 12729100.0 |
| 2005-10-21 10:00:00 | SPY | ETF | 118.29 | 118.5 | 118.12 | 118.44 | 8867600.0 |
| 2005-10-21 10:30:00 | SPY | ETF | 118.45 | 118.5 | 117.8 | 117.96 | 6572700.0 |
| 2005-10-21 11:00:00 | SPY | ETF | 117.98 | 118.25 | 117.93 | 118.14 | 3627800.0 |
| 2005-10-21 11:30:00 | SPY | ETF | 118.13 | 118.17 | 117.64 | 117.76 | 5400100.0 |
| 2005-10-21 12:00:00 | SPY | ETF | 117.75 | 118.08 | 117.51 | 118.0 | 10400500.0 |
| 2005-10-21 12:30:00 | SPY | ETF | 118.0 | 118.54 | 117.89 | 118.54 | 8595000.0 |
| 2005-10-21 13:00:00 | SPY | ETF | 118.5 | 118.59 | 118.24 | 118.47 | 4319600.0 |
| 2005-10-21 13:30:00 | SPY | ETF | 118.45 | 118.78 | 118.4 | 118.58 | 4766800.0 |
| 2005-10-21 14:00:00 | SPY | ETF | 118.58 | 118.74 | 118.29 | 118.36 | 4766400.0 |
| 2005-10-21 14:30:00 | SPY | ETF | 118.36 | 118.51 | 118.15 | 118.34 | 3089900.0 |
| 2005-10-21 15:00:00 | SPY | ETF | 118.34 | 118.35 | 118.11 | 118.23 | 3754800.0 |
| 2005-10-21 15:30:00 | SPY | ETF | 118.23 | 118.26 | 117.95 | 118.02 | 6647100.0 |
| 2005-10-21 16:00:00 | SPY | ETF | 118.0 | 118.2 | 117.68 | 118.17 | 1803800.0 |
| 2005-10-21 16:30:00 | SPY | ETF | 118.2 | 118.22 | 118.11 | 118.17 | 137900.0 |
| 2005-10-21 17:00:00 | SPY | ETF | 118.2 | 118.21 | 118.15 | 118.21 | 255700.0 |
| 2005-10-21 17:30:00 | SPY | ETF | 118.21 | 118.21 | 118.15 | 118.15 | 13700.0 |
| 2005-10-21 18:30:00 | SPY | ETF | 118.2 | 118.2 | 118.15 | 118.15 | 300.0 |
| 2005-10-21 09:30:00 | QQQ | ETF | 38.7 | 38.86 | 38.54 | 38.6 | 17541800.0 |
| 2005-10-21 10:00:00 | QQQ | ETF | 38.6 | 38.75 | 38.52 | 38.74 | 11685900.0 |
| 2005-10-21 10:30:00 | QQQ | ETF | 38.74 | 38.75 | 38.49 | 38.54 | 7885500.0 |
| 2005-10-21 11:00:00 | QQQ | ETF | 38.54 | 38.66 | 38.51 | 38.6 | 5439000.0 |
| 2005-10-21 11:30:00 | QQQ | ETF | 38.6 | 38.61 | 38.44 | 38.5 | 7046300.0 |
| 2005-10-21 12:00:00 | QQQ | ETF | 38.5 | 38.59 | 38.38 | 38.58 | 7080100.0 |
| 2005-10-21 12:30:00 | QQQ | ETF | 38.58 | 38.72 | 38.47 | 38.71 | 12931600.0 |
| 2005-10-21 13:00:00 | QQQ | ETF | 38.72 | 38.73 | 38.62 | 38.67 | 4022300.0 |
| 2005-10-21 13:30:00 | QQQ | ETF | 38.67 | 38.75 | 38.6 | 38.67 | 5309400.0 |
| 2005-10-21 14:00:00 | QQQ | ETF | 38.68 | 38.73 | 38.61 | 38.65 | 5309200.0 |
| 2005-10-21 14:30:00 | QQQ | ETF | 38.65 | 38.69 | 38.56 | 38.63 | 3300600.0 |
| 2005-10-21 15:00:00 | QQQ | ETF | 38.63 | 38.64 | 38.55 | 38.61 | 4144600.0 |
| 2005-10-21 15:30:00 | QQQ | ETF | 38.6 | 38.65 | 38.53 | 38.55 | 7220500.0 |
| 2005-10-21 08:00:00 | IWM | ETF | 62.63 | 62.72 | 62.55 | 62.63 | 33300.0 |
| 2005-10-21 08:30:00 | IWM | ETF | 62.62 | 62.68 | 62.57 | 62.68 | 369600.0 |
| 2005-10-21 09:00:00 | IWM | ETF | 62.64 | 62.72 | 62.47 | 62.67 | 815200.0 |
| 2005-10-21 09:30:00 | IWM | ETF | 62.63 | 62.97 | 62.53 | 62.9 | 8033400.0 |
| 2005-10-21 10:00:00 | IWM | ETF | 62.9 | 63.28 | 62.83 | 63.24 | 7204600.0 |
| 2005-10-21 10:30:00 | IWM | ETF | 63.24 | 63.31 | 62.7 | 62.9 | 3211600.0 |
| 2005-10-21 11:00:00 | IWM | ETF | 62.9 | 63.11 | 62.8 | 63.02 | 1983200.0 |
| 2005-10-21 11:30:00 | IWM | ETF | 63.01 | 63.03 | 62.71 | 62.8 | 1508100.0 |
| 2005-10-21 12:00:00 | IWM | ETF | 62.8 | 63.0 | 62.62 | 62.92 | 1556700.0 |
| 2005-10-21 12:30:00 | IWM | ETF | 62.93 | 63.22 | 62.83 | 63.22 | 2502500.0 |
| 2005-10-21 13:00:00 | IWM | ETF | 63.2 | 63.25 | 63.06 | 63.15 | 1287700.0 |
| 2005-10-21 13:30:00 | IWM | ETF | 63.17 | 63.38 | 63.13 | 63.26 | 1564400.0 |
> showing 50 of 1,699 rows — these rows as CSV