PREVIEW / etf_1hour / 2007-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-23.parquet
  size:    66 KB
  rows:    2,155

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
2007-03-23 06:00:00	SPY	ETF	143.24	143.24	143.24	143.24	500.0
2007-03-23 07:00:00	SPY	ETF	143.25	143.5	143.24	143.5	35200.0
2007-03-23 08:00:00	SPY	ETF	143.43	143.5	143.19	143.25	1669600.0
2007-03-23 09:00:00	SPY	ETF	143.25	143.45	143.14	143.23	9514899.0
2007-03-23 10:00:00	SPY	ETF	143.23	143.81	143.19	143.53	21901349.0
2007-03-23 11:00:00	SPY	ETF	143.52	143.67	143.43	143.55	8484727.0
2007-03-23 12:00:00	SPY	ETF	143.56	143.74	143.41	143.5	6006436.0
2007-03-23 13:00:00	SPY	ETF	143.51	143.56	143.27	143.4	8273500.0
2007-03-23 14:00:00	SPY	ETF	143.4	143.52	143.19	143.51	7567004.0
2007-03-23 15:00:00	SPY	ETF	143.51	143.66	143.43	143.49	9145120.0
2007-03-23 16:00:00	SPY	ETF	143.51	143.52	143.38	143.45	962800.0
2007-03-23 17:00:00	SPY	ETF	143.4	143.42	143.36	143.42	23700.0
2007-03-23 18:00:00	SPY	ETF	143.4	143.45	143.36	143.45	6400.0
2007-03-23 19:00:00	SPY	ETF	143.45	143.45	143.44	143.45	4400.0
2007-03-23 07:00:00	QQQ	ETF	44.26	44.3	44.26	44.3	5231.0
2007-03-23 08:00:00	QQQ	ETF	44.3	44.34	44.19	44.22	948754.0
2007-03-23 09:00:00	QQQ	ETF	44.22	44.34	44.17	44.2	8895161.0
2007-03-23 10:00:00	QQQ	ETF	44.21	44.37	44.15	44.22	17581900.0
2007-03-23 11:00:00	QQQ	ETF	44.22	44.26	44.17	44.21	6972200.0
2007-03-23 12:00:00	QQQ	ETF	44.21	44.29	44.17	44.22	5613000.0
2007-03-23 13:00:00	QQQ	ETF	44.22	44.25	44.13	44.17	7244500.0
2007-03-23 14:00:00	QQQ	ETF	44.17	44.19	44.07	44.17	8360000.0
2007-03-23 15:00:00	QQQ	ETF	44.16	44.23	44.1	44.12	9278600.0
2007-03-23 16:00:00	QQQ	ETF	44.11	44.11	44.04	44.08	3353027.0
2007-03-23 17:00:00	QQQ	ETF	44.09	44.09	44.06	44.07	7890.0
2007-03-23 18:00:00	QQQ	ETF	44.07	44.16	44.07	44.13	78726.0
2007-03-23 19:00:00	QQQ	ETF	44.13	44.14	44.08	44.09	12706.0
2007-03-23 07:00:00	IWM	ETF	80.35	80.38	80.35	80.36	9000.0
2007-03-23 08:00:00	IWM	ETF	80.38	80.4	80.18	80.2	75000.0
2007-03-23 09:00:00	IWM	ETF	80.18	80.38	80.06	80.15	4150200.0
2007-03-23 10:00:00	IWM	ETF	80.16	80.4244	80.05	80.19	7844800.0
2007-03-23 11:00:00	IWM	ETF	80.18	80.28	80.11	80.17	3072563.0
2007-03-23 12:00:00	IWM	ETF	80.16	80.28	80.16	80.2099	2395000.0
2007-03-23 13:00:00	IWM	ETF	80.2	80.24	80.05	80.12	2876100.0
2007-03-23 14:00:00	IWM	ETF	80.12	80.35	80.06	80.29	5803829.0
2007-03-23 15:00:00	IWM	ETF	80.29	80.4	80.24	80.2801	3669584.0
2007-03-23 16:00:00	IWM	ETF	80.28	80.29	80.05	80.05	182800.0
2007-03-23 17:00:00	IWM	ETF	80.147	80.147	80.147	80.147	3331700.0
2007-03-23 08:00:00	DIA	ETF	124.66	124.7	124.46	124.48	8700.0
2007-03-23 09:00:00	DIA	ETF	124.46	124.62	124.37	124.47	572000.0
2007-03-23 10:00:00	DIA	ETF	124.5	125.01	124.47	124.71	2025200.0
2007-03-23 11:00:00	DIA	ETF	124.7	124.83	124.63	124.75	469700.0
2007-03-23 12:00:00	DIA	ETF	124.76	124.89	124.67	124.74	431100.0
2007-03-23 13:00:00	DIA	ETF	124.75	124.8	124.58	124.65	547250.0
2007-03-23 14:00:00	DIA	ETF	124.66	124.79	124.49	124.75	468100.0
2007-03-23 15:00:00	DIA	ETF	124.75	124.85	124.65	124.7	615500.0
2007-03-23 16:00:00	DIA	ETF	124.71	124.74	124.64	124.67	62700.0
2007-03-23 17:00:00	DIA	ETF	124.75	124.79	124.75	124.79	400.0
2007-03-23 18:00:00	DIA	ETF	124.75	124.75	124.75	124.75	200.0
2007-03-23 08:00:00	GLD	ETF	65.74	65.92	65.64	65.74	185500.0

> showing 50 of 2,155 rows — these rows as CSV

> unlock the full archive -- $79 one-time