PREVIEW / etf_30min / 2005-09-06
file: by_date/etf_30min/2005/2005-09-06.parquet size: 47 KB rows: 1,684
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-09-06 06:00:00 | SPY | ETF | 122.83 | 122.83 | 122.83 | 122.83 | 1500.0 |
| 2005-09-06 06:30:00 | SPY | ETF | 122.8 | 122.8 | 122.79 | 122.79 | 3500.0 |
| 2005-09-06 07:00:00 | SPY | ETF | 122.77 | 122.87 | 122.77 | 122.87 | 12500.0 |
| 2005-09-06 07:30:00 | SPY | ETF | 122.82 | 122.82 | 122.74 | 122.75 | 3800.0 |
| 2005-09-06 08:00:00 | SPY | ETF | 122.47 | 122.86 | 122.47 | 122.71 | 624900.0 |
| 2005-09-06 08:30:00 | SPY | ETF | 122.69 | 122.75 | 122.6 | 122.65 | 905300.0 |
| 2005-09-06 09:00:00 | SPY | ETF | 122.65 | 122.73 | 122.27 | 122.67 | 315800.0 |
| 2005-09-06 09:30:00 | SPY | ETF | 122.66 | 122.98 | 122.65 | 122.82 | 9898100.0 |
| 2005-09-06 10:00:00 | SPY | ETF | 122.83 | 123.35 | 122.83 | 123.27 | 10253300.0 |
| 2005-09-06 10:30:00 | SPY | ETF | 123.26 | 123.42 | 123.2 | 123.23 | 3645200.0 |
| 2005-09-06 11:00:00 | SPY | ETF | 123.23 | 123.36 | 123.15 | 123.3 | 3887100.0 |
| 2005-09-06 11:30:00 | SPY | ETF | 123.3 | 123.34 | 123.15 | 123.21 | 1024000.0 |
| 2005-09-06 12:00:00 | SPY | ETF | 123.2 | 123.41 | 123.2 | 123.32 | 975600.0 |
| 2005-09-06 12:30:00 | SPY | ETF | 123.3 | 123.42 | 123.25 | 123.4 | 997500.0 |
| 2005-09-06 13:00:00 | SPY | ETF | 123.4 | 123.5 | 123.24 | 123.29 | 1970500.0 |
| 2005-09-06 13:30:00 | SPY | ETF | 123.3 | 123.51 | 123.22 | 123.5 | 1901600.0 |
| 2005-09-06 14:00:00 | SPY | ETF | 123.49 | 123.57 | 123.32 | 123.39 | 3950500.0 |
| 2005-09-06 14:30:00 | SPY | ETF | 123.39 | 123.49 | 123.34 | 123.47 | 1170200.0 |
| 2005-09-06 15:00:00 | SPY | ETF | 123.47 | 123.64 | 123.34 | 123.59 | 6675500.0 |
| 2005-09-06 15:30:00 | SPY | ETF | 123.59 | 123.76 | 123.57 | 123.75 | 4497200.0 |
| 2005-09-06 16:00:00 | SPY | ETF | 123.79 | 123.79 | 123.71 | 123.75 | 455500.0 |
| 2005-09-06 16:30:00 | SPY | ETF | 123.73 | 123.76 | 123.44 | 123.73 | 1496100.0 |
| 2005-09-06 17:00:00 | SPY | ETF | 123.72 | 123.73 | 123.72 | 123.73 | 89300.0 |
| 2005-09-06 17:30:00 | SPY | ETF | 123.77 | 123.79 | 123.77 | 123.79 | 4700.0 |
| 2005-09-06 18:00:00 | SPY | ETF | 123.77 | 123.79 | 123.72 | 123.77 | 8700.0 |
| 2005-09-06 18:30:00 | SPY | ETF | 123.75 | 123.75 | 123.74 | 123.74 | 4800.0 |
| 2005-09-06 09:30:00 | QQQ | ETF | 38.93 | 39.04 | 38.91 | 38.99 | 9304100.0 |
| 2005-09-06 10:00:00 | QQQ | ETF | 38.99 | 39.29 | 38.98 | 39.26 | 14432800.0 |
| 2005-09-06 10:30:00 | QQQ | ETF | 39.26 | 39.35 | 39.23 | 39.25 | 7232000.0 |
| 2005-09-06 11:00:00 | QQQ | ETF | 39.25 | 39.3 | 39.25 | 39.27 | 3493600.0 |
| 2005-09-06 11:30:00 | QQQ | ETF | 39.28 | 39.29 | 39.22 | 39.27 | 2530900.0 |
| 2005-09-06 12:00:00 | QQQ | ETF | 39.26 | 39.35 | 39.25 | 39.31 | 3307400.0 |
| 2005-09-06 12:30:00 | QQQ | ETF | 39.3 | 39.32 | 39.27 | 39.31 | 1400000.0 |
| 2005-09-06 13:00:00 | QQQ | ETF | 39.31 | 39.34 | 39.23 | 39.25 | 2268000.0 |
| 2005-09-06 13:30:00 | QQQ | ETF | 39.25 | 39.31 | 39.21 | 39.3 | 3072100.0 |
| 2005-09-06 14:00:00 | QQQ | ETF | 39.3 | 39.34 | 39.26 | 39.29 | 4072800.0 |
| 2005-09-06 14:30:00 | QQQ | ETF | 39.29 | 39.31 | 39.27 | 39.3 | 2042800.0 |
| 2005-09-06 15:00:00 | QQQ | ETF | 39.3 | 39.37 | 39.26 | 39.34 | 5184500.0 |
| 2005-09-06 15:30:00 | QQQ | ETF | 39.35 | 39.41 | 39.33 | 39.37 | 7775200.0 |
| 2005-09-06 08:00:00 | IWM | ETF | 66.22 | 66.49 | 66.22 | 66.49 | 1003000.0 |
| 2005-09-06 08:30:00 | IWM | ETF | 66.41 | 66.41 | 66.37 | 66.41 | 519000.0 |
| 2005-09-06 09:00:00 | IWM | ETF | 66.39 | 66.4 | 66.17 | 66.36 | 26700.0 |
| 2005-09-06 09:30:00 | IWM | ETF | 66.37 | 66.69 | 66.27 | 66.52 | 4629700.0 |
| 2005-09-06 10:00:00 | IWM | ETF | 66.51 | 66.82 | 66.44 | 66.8 | 4194100.0 |
| 2005-09-06 10:30:00 | IWM | ETF | 66.81 | 67.05 | 66.71 | 66.93 | 3471500.0 |
| 2005-09-06 11:00:00 | IWM | ETF | 66.93 | 66.94 | 66.82 | 66.86 | 786400.0 |
| 2005-09-06 11:30:00 | IWM | ETF | 66.85 | 66.87 | 66.74 | 66.79 | 675200.0 |
| 2005-09-06 12:00:00 | IWM | ETF | 66.782 | 66.88 | 66.78 | 66.84 | 597900.0 |
| 2005-09-06 12:30:00 | IWM | ETF | 66.84 | 66.99 | 66.83 | 66.99 | 507700.0 |
| 2005-09-06 13:00:00 | IWM | ETF | 66.99 | 67.01 | 66.85 | 66.88 | 1482900.0 |
> showing 50 of 1,684 rows — these rows as CSV