PREVIEW / etf_30min / 2004-10-08
file: by_date/etf_30min/2004/2004-10-08.parquet size: 38 KB rows: 1,246
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-08 08:00:00 | SPY | ETF | 113.7 | 113.83 | 113.7 | 113.8 | 98100.0 |
| 2004-10-08 08:30:00 | SPY | ETF | 113.83 | 113.83 | 113.04 | 113.1 | 924300.0 |
| 2004-10-08 09:00:00 | SPY | ETF | 113.07 | 113.16 | 113.02 | 113.12 | 84700.0 |
| 2004-10-08 09:30:00 | SPY | ETF | 113.34 | 113.69 | 113.14 | 113.68 | 7674300.0 |
| 2004-10-08 10:00:00 | SPY | ETF | 113.68 | 113.69 | 113.41 | 113.48 | 5885800.0 |
| 2004-10-08 10:30:00 | SPY | ETF | 113.48 | 113.5 | 113.05 | 113.13 | 4654300.0 |
| 2004-10-08 11:00:00 | SPY | ETF | 113.13 | 113.23 | 112.92 | 112.98 | 5106800.0 |
| 2004-10-08 11:30:00 | SPY | ETF | 112.96 | 113.09 | 112.87 | 113.06 | 2819600.0 |
| 2004-10-08 12:00:00 | SPY | ETF | 113.06 | 113.2 | 113.03 | 113.07 | 1383300.0 |
| 2004-10-08 12:30:00 | SPY | ETF | 113.07 | 113.19 | 112.98 | 113.17 | 1471900.0 |
| 2004-10-08 13:00:00 | SPY | ETF | 113.17 | 113.2 | 113.07 | 113.12 | 1322800.0 |
| 2004-10-08 13:30:00 | SPY | ETF | 113.12 | 113.13 | 112.87 | 112.9 | 1537500.0 |
| 2004-10-08 14:00:00 | SPY | ETF | 112.91 | 112.94 | 112.57 | 112.57 | 3875000.0 |
| 2004-10-08 14:30:00 | SPY | ETF | 112.6 | 112.69 | 112.38 | 112.4384 | 3722100.0 |
| 2004-10-08 15:00:00 | SPY | ETF | 112.45 | 112.59 | 112.35 | 112.51 | 2980500.0 |
| 2004-10-08 15:30:00 | SPY | ETF | 112.51 | 112.7 | 112.38 | 112.58 | 4598100.0 |
| 2004-10-08 16:00:00 | SPY | ETF | 112.58 | 112.62 | 112.45 | 112.5 | 1615900.0 |
| 2004-10-08 16:30:00 | SPY | ETF | 112.5 | 113.5 | 112.5 | 112.6 | 43400.0 |
| 2004-10-08 17:00:00 | SPY | ETF | 112.6 | 112.63 | 112.6 | 112.6 | 10200.0 |
| 2004-10-08 17:30:00 | SPY | ETF | 112.59 | 112.59 | 112.57 | 112.57 | 200.0 |
| 2004-10-08 18:00:00 | SPY | ETF | 112.62 | 112.64 | 112.62 | 112.64 | 1000.0 |
| 2004-10-08 19:00:00 | SPY | ETF | 112.63 | 112.63 | 112.63 | 112.63 | 700.0 |
| 2004-10-08 08:00:00 | QQQ | ETF | 36.34 | 36.39 | 36.34 | 36.39 | 154500.0 |
| 2004-10-08 08:30:00 | QQQ | ETF | 36.38 | 36.38 | 36.03 | 36.05 | 1499000.0 |
| 2004-10-08 09:00:00 | QQQ | ETF | 36.04 | 36.07 | 35.99 | 36.07 | 871900.0 |
| 2004-10-08 09:30:00 | QQQ | ETF | 36.08 | 36.24 | 36.02 | 36.209 | 16487700.0 |
| 2004-10-08 10:00:00 | QQQ | ETF | 36.21 | 36.22 | 36.04 | 36.07 | 9670800.0 |
| 2004-10-08 10:30:00 | QQQ | ETF | 36.06 | 36.1 | 35.86 | 35.91 | 11674300.0 |
| 2004-10-08 11:00:00 | QQQ | ETF | 35.91 | 35.97 | 35.86 | 35.89 | 8843600.0 |
| 2004-10-08 11:30:00 | QQQ | ETF | 35.88 | 35.901 | 35.829 | 35.85 | 7202300.0 |
| 2004-10-08 12:00:00 | QQQ | ETF | 35.852 | 35.9 | 35.83 | 35.869 | 6475700.0 |
| 2004-10-08 12:30:00 | QQQ | ETF | 35.862 | 35.9 | 35.8 | 35.897 | 4087300.0 |
| 2004-10-08 13:00:00 | QQQ | ETF | 35.9 | 35.93 | 35.87 | 35.88 | 3168800.0 |
| 2004-10-08 13:30:00 | QQQ | ETF | 35.88 | 35.891 | 35.78 | 35.794 | 3931400.0 |
| 2004-10-08 14:00:00 | QQQ | ETF | 35.8 | 35.8 | 35.59 | 35.61 | 8283900.0 |
| 2004-10-08 14:30:00 | QQQ | ETF | 35.6 | 35.65 | 35.52 | 35.562 | 9955200.0 |
| 2004-10-08 15:00:00 | QQQ | ETF | 35.57 | 35.62 | 35.53 | 35.58 | 6000400.0 |
| 2004-10-08 15:30:00 | QQQ | ETF | 35.587 | 35.68 | 35.5 | 35.616 | 10234400.0 |
| 2004-10-08 16:00:00 | QQQ | ETF | 35.616 | 35.63 | 35.55 | 35.6 | 2621200.0 |
| 2004-10-08 16:30:00 | QQQ | ETF | 35.58 | 35.61 | 35.58 | 35.61 | 34600.0 |
| 2004-10-08 17:00:00 | QQQ | ETF | 35.59 | 35.6 | 35.59 | 35.59 | 21100.0 |
| 2004-10-08 17:30:00 | QQQ | ETF | 35.59 | 35.59 | 35.58 | 35.58 | 11700.0 |
| 2004-10-08 18:00:00 | QQQ | ETF | 35.58 | 35.6 | 35.58 | 35.6 | 22000.0 |
| 2004-10-08 18:30:00 | QQQ | ETF | 35.59 | 35.59 | 35.59 | 35.59 | 100.0 |
| 2004-10-08 19:00:00 | QQQ | ETF | 35.59 | 35.59 | 35.59 | 35.59 | 1300.0 |
| 2004-10-08 19:30:00 | QQQ | ETF | 35.58 | 35.58 | 35.58 | 35.58 | 1300.0 |
| 2004-10-08 08:00:00 | IWM | ETF | 58.215 | 58.25 | 58.195 | 58.25 | 4000.0 |
| 2004-10-08 08:30:00 | IWM | ETF | 58.125 | 58.125 | 57.825 | 57.825 | 84200.0 |
| 2004-10-08 09:00:00 | IWM | ETF | 57.74 | 57.795 | 57.69 | 57.72 | 136600.0 |
| 2004-10-08 09:30:00 | IWM | ETF | 57.825 | 58.185 | 57.775 | 58.17 | 3044400.0 |
> showing 50 of 1,246 rows — these rows as CSV