PREVIEW / etf_30min / 2005-06-10
file: by_date/etf_30min/2005/2005-06-10.parquet size: 42 KB rows: 1,489
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-06-10 05:00:00 | SPY | ETF | 120.55 | 120.57 | 120.55 | 120.57 | 4200.0 |
| 2005-06-10 07:00:00 | SPY | ETF | 120.65 | 120.65 | 120.65 | 120.65 | 100.0 |
| 2005-06-10 07:30:00 | SPY | ETF | 120.58 | 120.64 | 120.58 | 120.64 | 1100.0 |
| 2005-06-10 08:00:00 | SPY | ETF | 120.63 | 120.63 | 120.58 | 120.61 | 6700.0 |
| 2005-06-10 08:30:00 | SPY | ETF | 120.64 | 120.7 | 120.61 | 120.66 | 146900.0 |
| 2005-06-10 09:00:00 | SPY | ETF | 120.67 | 120.67 | 120.57 | 120.57 | 3100.0 |
| 2005-06-10 09:30:00 | SPY | ETF | 120.56 | 120.65 | 120.38 | 120.41 | 3438100.0 |
| 2005-06-10 10:00:00 | SPY | ETF | 120.42 | 120.61 | 120.13 | 120.13 | 5028600.0 |
| 2005-06-10 10:30:00 | SPY | ETF | 120.13 | 120.27 | 120.05 | 120.19 | 3978700.0 |
| 2005-06-10 11:00:00 | SPY | ETF | 120.2 | 120.26 | 120.11 | 120.22 | 1557500.0 |
| 2005-06-10 11:30:00 | SPY | ETF | 120.22 | 120.24 | 119.91 | 119.94 | 2116900.0 |
| 2005-06-10 12:00:00 | SPY | ETF | 119.94 | 120.02 | 119.67 | 119.73 | 4804800.0 |
| 2005-06-10 12:30:00 | SPY | ETF | 119.74 | 119.82 | 119.72 | 119.77 | 1321700.0 |
| 2005-06-10 13:00:00 | SPY | ETF | 119.77 | 119.9 | 119.72 | 119.79 | 1177600.0 |
| 2005-06-10 13:30:00 | SPY | ETF | 119.8 | 120.01 | 119.78 | 119.87 | 1498800.0 |
| 2005-06-10 14:00:00 | SPY | ETF | 119.86 | 119.93 | 119.76 | 119.8 | 1267200.0 |
| 2005-06-10 14:30:00 | SPY | ETF | 119.79 | 119.84 | 119.6 | 119.75 | 2916800.0 |
| 2005-06-10 15:00:00 | SPY | ETF | 119.75 | 120.12 | 119.71 | 120.07 | 3050200.0 |
| 2005-06-10 15:30:00 | SPY | ETF | 120.08 | 120.25 | 120.06 | 120.21 | 2943100.0 |
| 2005-06-10 16:00:00 | SPY | ETF | 120.22 | 120.26 | 120.16 | 120.21 | 437600.0 |
| 2005-06-10 16:30:00 | SPY | ETF | 120.21 | 120.25 | 120.15 | 120.15 | 39500.0 |
| 2005-06-10 17:00:00 | SPY | ETF | 120.15 | 120.15 | 120.15 | 120.15 | 1200.0 |
| 2005-06-10 17:30:00 | SPY | ETF | 120.13 | 120.13 | 120.13 | 120.13 | 1000.0 |
| 2005-06-10 19:30:00 | SPY | ETF | 120.15 | 120.15 | 120.15 | 120.15 | 300.0 |
| 2005-06-10 09:30:00 | QQQ | ETF | 37.9 | 37.9 | 37.66 | 37.68 | 13989500.0 |
| 2005-06-10 10:00:00 | QQQ | ETF | 37.68 | 37.68 | 37.56 | 37.58 | 10003000.0 |
| 2005-06-10 10:30:00 | QQQ | ETF | 37.58 | 37.61 | 37.53 | 37.58 | 8502200.0 |
| 2005-06-10 11:00:00 | QQQ | ETF | 37.58 | 37.61 | 37.55 | 37.6 | 3671300.0 |
| 2005-06-10 11:30:00 | QQQ | ETF | 37.6 | 37.6 | 37.45 | 37.46 | 6690300.0 |
| 2005-06-10 12:00:00 | QQQ | ETF | 37.45 | 37.48 | 37.38 | 37.4 | 7640500.0 |
| 2005-06-10 12:30:00 | QQQ | ETF | 37.4 | 37.48 | 37.4 | 37.43 | 3061000.0 |
| 2005-06-10 13:00:00 | QQQ | ETF | 37.43 | 37.47 | 37.41 | 37.43 | 1936400.0 |
| 2005-06-10 13:30:00 | QQQ | ETF | 37.43 | 37.51 | 37.41 | 37.46 | 3042100.0 |
| 2005-06-10 14:00:00 | QQQ | ETF | 37.45 | 37.48 | 37.41 | 37.44 | 2604300.0 |
| 2005-06-10 14:30:00 | QQQ | ETF | 37.44 | 37.5 | 37.39 | 37.45 | 4211800.0 |
| 2005-06-10 15:00:00 | QQQ | ETF | 37.45 | 37.58 | 37.45 | 37.54 | 6496000.0 |
| 2005-06-10 15:30:00 | QQQ | ETF | 37.55 | 37.57 | 37.48 | 37.55 | 9285000.0 |
| 2005-06-10 07:30:00 | IWM | ETF | 62.33 | 62.33 | 62.33 | 62.33 | 100.0 |
| 2005-06-10 08:30:00 | IWM | ETF | 62.5 | 62.57 | 62.49 | 62.49 | 5800.0 |
| 2005-06-10 09:00:00 | IWM | ETF | 62.44 | 62.48 | 62.43 | 62.43 | 6000.0 |
| 2005-06-10 09:30:00 | IWM | ETF | 62.45 | 62.55 | 62.24 | 62.34 | 2020400.0 |
| 2005-06-10 10:00:00 | IWM | ETF | 62.35 | 62.36 | 62.2 | 62.29 | 2323500.0 |
| 2005-06-10 10:30:00 | IWM | ETF | 62.29 | 62.39 | 62.15 | 62.33 | 1295900.0 |
| 2005-06-10 11:00:00 | IWM | ETF | 62.33 | 62.46 | 62.25 | 62.43 | 858800.0 |
| 2005-06-10 11:30:00 | IWM | ETF | 62.43 | 62.43 | 62.26 | 62.26 | 520100.0 |
| 2005-06-10 12:00:00 | IWM | ETF | 62.26 | 62.28 | 62.08 | 62.11 | 2093200.0 |
| 2005-06-10 12:30:00 | IWM | ETF | 62.11 | 62.24 | 62.09 | 62.17 | 640500.0 |
| 2005-06-10 13:00:00 | IWM | ETF | 62.16 | 62.23 | 62.15 | 62.19 | 1043700.0 |
| 2005-06-10 13:30:00 | IWM | ETF | 62.19 | 62.34 | 62.18 | 62.22 | 495100.0 |
| 2005-06-10 14:00:00 | IWM | ETF | 62.22 | 62.29 | 62.15 | 62.17 | 871100.0 |
> showing 50 of 1,489 rows — these rows as CSV