PREVIEW / etf_1hour / 2005-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-21.parquet
  size:    28 KB
  rows:    804

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-01-21 08:00:00	SPY	ETF	117.77	117.84	117.77	117.84	58200.0
2005-01-21 09:00:00	SPY	ETF	117.84	117.85	117.47	117.7	6421400.0
2005-01-21 10:00:00	SPY	ETF	117.71	118.0	117.43	117.76	9256600.0
2005-01-21 11:00:00	SPY	ETF	117.75	117.91	117.65	117.69	3430900.0
2005-01-21 12:00:00	SPY	ETF	117.69	117.81	117.59	117.71	2879100.0
2005-01-21 13:00:00	SPY	ETF	117.71	117.73	117.05	117.28	12154000.0
2005-01-21 14:00:00	SPY	ETF	117.28	117.42	116.89	116.98	10683300.0
2005-01-21 15:00:00	SPY	ETF	116.98	117.86	116.74	116.76	14439800.0
2005-01-21 16:00:00	SPY	ETF	116.77	116.91	116.65	116.68	1985100.0
2005-01-21 17:00:00	SPY	ETF	116.68	116.79	116.68	116.75	97900.0
2005-01-21 18:00:00	SPY	ETF	116.8	116.8	116.74	116.74	10000.0
2005-01-21 19:00:00	SPY	ETF	116.8	116.82	116.8	116.82	300.0
2005-01-21 09:00:00	QQQ	ETF	37.49	37.51	37.3	37.41	15763100.0
2005-01-21 10:00:00	QQQ	ETF	37.41	38.0	37.32	37.44	20408500.0
2005-01-21 11:00:00	QQQ	ETF	37.44	37.51	37.37	37.42	10009500.0
2005-01-21 12:00:00	QQQ	ETF	37.42	37.45	37.38	37.43	6827100.0
2005-01-21 13:00:00	QQQ	ETF	37.43	37.43	37.11	37.18	17115600.0
2005-01-21 14:00:00	QQQ	ETF	37.19	37.28	37.05	37.08	16107600.0
2005-01-21 15:00:00	QQQ	ETF	37.08	37.19	36.99	37.04	22620100.0
2005-01-21 08:00:00	IWM	ETF	61.025	61.09	61.025	61.09	13800.0
2005-01-21 09:00:00	IWM	ETF	61.035	61.15	60.91	61.15	1446000.0
2005-01-21 10:00:00	IWM	ETF	61.15	61.37	60.975	61.22	3739200.0
2005-01-21 11:00:00	IWM	ETF	61.22	61.49	61.185	61.325	2052200.0
2005-01-21 12:00:00	IWM	ETF	61.325	61.385	61.25	61.33	1217600.0
2005-01-21 13:00:00	IWM	ETF	61.335	61.355	60.86	61.0	2856400.0
2005-01-21 14:00:00	IWM	ETF	61.0	61.2	60.755	60.76	4405600.0
2005-01-21 15:00:00	IWM	ETF	60.755	61.075	60.575	60.805	6005400.0
2005-01-21 16:00:00	IWM	ETF	60.84	61.055	60.735	60.775	332200.0
2005-01-21 17:00:00	IWM	ETF	60.775	60.775	60.775	60.775	800.0
2005-01-21 08:00:00	DIA	ETF	104.94	104.94	104.87	104.92	4200.0
2005-01-21 09:00:00	DIA	ETF	104.94	104.96	104.62	104.81	1149200.0
2005-01-21 10:00:00	DIA	ETF	104.81	105.03	104.54	104.85	1450000.0
2005-01-21 11:00:00	DIA	ETF	104.84	104.94	104.72	104.73	418900.0
2005-01-21 12:00:00	DIA	ETF	104.73	104.76	104.63	104.72	314300.0
2005-01-21 13:00:00	DIA	ETF	104.73	104.73	104.13	104.33	1315000.0
2005-01-21 14:00:00	DIA	ETF	104.33	104.4	103.94	104.0	1123100.0
2005-01-21 15:00:00	DIA	ETF	104.0	104.16	103.81	103.86	1737100.0
2005-01-21 16:00:00	DIA	ETF	103.86	104.49	103.78	103.83	279100.0
2005-01-21 17:00:00	DIA	ETF	103.8	103.88	103.8	103.86	79600.0
2005-01-21 18:00:00	DIA	ETF	103.9	103.9	103.86	103.86	1600.0
2005-01-21 09:00:00	GLD	ETF	42.32	42.37	42.31	42.34	75100.0
2005-01-21 10:00:00	GLD	ETF	42.36	42.4	42.29	42.32	139300.0
2005-01-21 11:00:00	GLD	ETF	42.31	42.6	42.31	42.57	110800.0
2005-01-21 12:00:00	GLD	ETF	42.59	42.82	42.59	42.73	216900.0
2005-01-21 13:00:00	GLD	ETF	42.75	42.76	42.65	42.7	84800.0
2005-01-21 14:00:00	GLD	ETF	42.7	42.8	42.7	42.77	100200.0
2005-01-21 15:00:00	GLD	ETF	42.76	42.77	42.7	42.74	161900.0
2005-01-21 16:00:00	GLD	ETF	42.76	42.76	42.76	42.76	600.0
2005-01-21 08:00:00	TLT	ETF	90.61	90.65	90.61	90.65	6400.0
2005-01-21 09:00:00	TLT	ETF	90.59	90.61	90.52	90.582	90200.0

> showing 50 of 804 rows — these rows as CSV

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