PREVIEW / etf_30min / 2004-11-09
file: by_date/etf_30min/2004/2004-11-09.parquet size: 37 KB rows: 1,283
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-11-09 08:00:00 | SPY | ETF | 116.92 | 116.96 | 116.9 | 116.96 | 35300.0 |
| 2004-11-09 08:30:00 | SPY | ETF | 116.91 | 116.91 | 116.87 | 116.88 | 11700.0 |
| 2004-11-09 09:00:00 | SPY | ETF | 116.92 | 117.18 | 116.9 | 117.05 | 437700.0 |
| 2004-11-09 09:30:00 | SPY | ETF | 117.08 | 117.48 | 117.03 | 117.46 | 5603700.0 |
| 2004-11-09 10:00:00 | SPY | ETF | 117.47 | 117.5 | 117.12 | 117.21 | 3405800.0 |
| 2004-11-09 10:30:00 | SPY | ETF | 117.2 | 117.2 | 116.97 | 117.04 | 2864900.0 |
| 2004-11-09 11:00:00 | SPY | ETF | 117.04 | 117.1 | 116.88 | 116.94 | 2626100.0 |
| 2004-11-09 11:30:00 | SPY | ETF | 116.94 | 116.98 | 116.76 | 116.88 | 3831200.0 |
| 2004-11-09 12:00:00 | SPY | ETF | 116.89 | 116.93 | 116.84 | 116.91 | 1502400.0 |
| 2004-11-09 12:30:00 | SPY | ETF | 116.91 | 117.02 | 116.81 | 116.97 | 2233500.0 |
| 2004-11-09 13:00:00 | SPY | ETF | 116.97 | 117.08 | 116.96 | 117.04 | 2494300.0 |
| 2004-11-09 13:30:00 | SPY | ETF | 117.05 | 117.15 | 116.96 | 117.15 | 1570000.0 |
| 2004-11-09 14:00:00 | SPY | ETF | 117.14 | 117.44 | 117.12 | 117.23 | 5255100.0 |
| 2004-11-09 14:30:00 | SPY | ETF | 117.23 | 117.42 | 117.22 | 117.25 | 2278300.0 |
| 2004-11-09 15:00:00 | SPY | ETF | 117.25 | 117.26 | 117.0 | 117.08 | 3564100.0 |
| 2004-11-09 15:30:00 | SPY | ETF | 117.08 | 117.13 | 116.88 | 117.0 | 2591900.0 |
| 2004-11-09 16:00:00 | SPY | ETF | 116.99 | 117.05 | 116.82 | 116.93 | 1108800.0 |
| 2004-11-09 16:30:00 | SPY | ETF | 116.93 | 117.04 | 116.92 | 117.04 | 421600.0 |
| 2004-11-09 17:00:00 | SPY | ETF | 117.02 | 117.08 | 116.91 | 117.04 | 43400.0 |
| 2004-11-09 17:30:00 | SPY | ETF | 117.02 | 117.04 | 116.93 | 117.0 | 9900.0 |
| 2004-11-09 18:00:00 | SPY | ETF | 117.03 | 117.03 | 116.96 | 117.02 | 27000.0 |
| 2004-11-09 18:30:00 | SPY | ETF | 116.96 | 116.96 | 116.91 | 116.91 | 800.0 |
| 2004-11-09 19:00:00 | SPY | ETF | 116.98 | 116.98 | 116.98 | 116.98 | 600.0 |
| 2004-11-09 19:30:00 | SPY | ETF | 117.03 | 117.03 | 117.02 | 117.02 | 7000.0 |
| 2004-11-09 08:00:00 | QQQ | ETF | 37.93 | 37.94 | 37.92 | 37.92 | 49300.0 |
| 2004-11-09 08:30:00 | QQQ | ETF | 37.93 | 37.93 | 37.92 | 37.92 | 27400.0 |
| 2004-11-09 09:00:00 | QQQ | ETF | 37.93 | 38.0 | 37.92 | 37.93 | 110000.0 |
| 2004-11-09 09:30:00 | QQQ | ETF | 37.93 | 38.13 | 37.9 | 38.089 | 16285000.0 |
| 2004-11-09 10:00:00 | QQQ | ETF | 38.08 | 38.083 | 37.94 | 37.99 | 7270800.0 |
| 2004-11-09 10:30:00 | QQQ | ETF | 37.985 | 37.99 | 37.88 | 37.9 | 5759500.0 |
| 2004-11-09 11:00:00 | QQQ | ETF | 37.904 | 37.94 | 37.81 | 37.851 | 6509000.0 |
| 2004-11-09 11:30:00 | QQQ | ETF | 37.851 | 37.87 | 37.82 | 37.867 | 3945500.0 |
| 2004-11-09 12:00:00 | QQQ | ETF | 37.86 | 37.93 | 37.85 | 37.9 | 2753200.0 |
| 2004-11-09 12:30:00 | QQQ | ETF | 37.9 | 37.98 | 37.87 | 37.949 | 2297300.0 |
| 2004-11-09 13:00:00 | QQQ | ETF | 37.949 | 37.98 | 37.92 | 37.96 | 1849400.0 |
| 2004-11-09 13:30:00 | QQQ | ETF | 37.969 | 38.02 | 37.92 | 38.01 | 2064000.0 |
| 2004-11-09 14:00:00 | QQQ | ETF | 38.01 | 38.14 | 38.007 | 38.08 | 8459900.0 |
| 2004-11-09 14:30:00 | QQQ | ETF | 38.08 | 38.15 | 38.07 | 38.09 | 5697100.0 |
| 2004-11-09 15:00:00 | QQQ | ETF | 38.09 | 38.12 | 38.0 | 38.032 | 5888300.0 |
| 2004-11-09 15:30:00 | QQQ | ETF | 38.03 | 38.06 | 37.93 | 37.997 | 10561700.0 |
| 2004-11-09 16:00:00 | QQQ | ETF | 38.0 | 38.02 | 37.86 | 37.89 | 4027700.0 |
| 2004-11-09 16:30:00 | QQQ | ETF | 37.89 | 37.935 | 37.88 | 37.93 | 459000.0 |
| 2004-11-09 17:00:00 | QQQ | ETF | 37.91 | 37.99 | 37.856 | 37.9 | 642900.0 |
| 2004-11-09 17:30:00 | QQQ | ETF | 37.93 | 37.94 | 37.88 | 37.9 | 33700.0 |
| 2004-11-09 18:00:00 | QQQ | ETF | 37.9 | 37.9 | 37.88 | 37.89 | 18000.0 |
| 2004-11-09 18:30:00 | QQQ | ETF | 37.89 | 37.89 | 37.89 | 37.89 | 7600.0 |
| 2004-11-09 19:00:00 | QQQ | ETF | 37.89 | 37.95 | 37.89 | 37.95 | 19500.0 |
| 2004-11-09 19:30:00 | QQQ | ETF | 37.91 | 37.95 | 37.91 | 37.95 | 3500.0 |
| 2004-11-09 09:30:00 | IWM | ETF | 60.075 | 60.34 | 60.0 | 60.33 | 1364400.0 |
| 2004-11-09 10:00:00 | IWM | ETF | 60.315 | 60.315 | 60.115 | 60.2 | 661600.0 |
> showing 50 of 1,283 rows — these rows as CSV