PREVIEW / etf_1hour / 2005-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-13.parquet
  size:    28 KB
  rows:    808

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-13 08:00:00	SPY	ETF	118.52	118.63	118.48	118.63	94500.0
2005-01-13 09:00:00	SPY	ETF	118.62	118.73	118.38	118.57	5847500.0
2005-01-13 10:00:00	SPY	ETF	118.57	118.73	118.4	118.451	8541800.0
2005-01-13 11:00:00	SPY	ETF	118.45	118.63	118.25	118.36	7662100.0
2005-01-13 12:00:00	SPY	ETF	118.36	118.54	118.31	118.5	3086000.0
2005-01-13 13:00:00	SPY	ETF	118.5	118.65	118.36	118.65	3205200.0
2005-01-13 14:00:00	SPY	ETF	118.64	118.7	118.4	118.43	4664300.0
2005-01-13 15:00:00	SPY	ETF	118.43	118.56	117.5	117.69	17774800.0
2005-01-13 16:00:00	SPY	ETF	117.7	117.74	117.61	117.66	2022000.0
2005-01-13 17:00:00	SPY	ETF	117.66	117.67	117.52	117.54	225600.0
2005-01-13 18:00:00	SPY	ETF	117.54	117.66	117.54	117.66	16800.0
2005-01-13 19:00:00	SPY	ETF	117.63	117.66	117.61	117.61	5800.0
2005-01-13 09:00:00	QQQ	ETF	38.59	38.62	38.41	38.51	10980200.0
2005-01-13 10:00:00	QQQ	ETF	38.5	38.62	37.58	38.43	15429700.0
2005-01-13 11:00:00	QQQ	ETF	38.43	38.51	38.31	38.38	11869800.0
2005-01-13 12:00:00	QQQ	ETF	38.37	38.46	38.36	38.44	4766200.0
2005-01-13 13:00:00	QQQ	ETF	38.44	38.52	38.38	38.51	7244800.0
2005-01-13 14:00:00	QQQ	ETF	38.51	38.56	38.39	38.4	8902000.0
2005-01-13 15:00:00	QQQ	ETF	38.4	38.42	38.01	38.07	30878200.0
2005-01-13 08:00:00	IWM	ETF	61.025	61.025	61.025	61.025	400.0
2005-01-13 09:00:00	IWM	ETF	61.09	61.27	60.755	60.96	2214200.0
2005-01-13 10:00:00	IWM	ETF	60.96	61.15	60.855	60.965	3230000.0
2005-01-13 11:00:00	IWM	ETF	60.985	61.17	60.875	60.94	2334200.0
2005-01-13 12:00:00	IWM	ETF	60.935	61.14	60.895	61.075	581400.0
2005-01-13 13:00:00	IWM	ETF	61.085	61.4	61.035	61.4	1374200.0
2005-01-13 14:00:00	IWM	ETF	61.4	61.435	61.095	61.17	2490400.0
2005-01-13 15:00:00	IWM	ETF	61.175	61.225	60.575	60.81	5923800.0
2005-01-13 16:00:00	IWM	ETF	60.84	60.885	60.77	60.805	364800.0
2005-01-13 08:00:00	DIA	ETF	105.95	106.0	105.91	105.97	14000.0
2005-01-13 09:00:00	DIA	ETF	105.95	106.1	105.77	105.9	1101700.0
2005-01-13 10:00:00	DIA	ETF	105.88	106.02	105.7	105.75	902100.0
2005-01-13 11:00:00	DIA	ETF	105.77	105.9	105.56	105.62	471400.0
2005-01-13 12:00:00	DIA	ETF	105.62	105.77	105.58	105.72	303500.0
2005-01-13 13:00:00	DIA	ETF	105.72	105.87	105.64	105.86	696200.0
2005-01-13 14:00:00	DIA	ETF	105.87	105.87	105.61	105.63	498000.0
2005-01-13 15:00:00	DIA	ETF	105.63	105.66	104.81	105.0	3426400.0
2005-01-13 16:00:00	DIA	ETF	105.0	105.07	104.91	105.0	60700.0
2005-01-13 17:00:00	DIA	ETF	105.0	105.0	104.98	104.98	1600.0
2005-01-13 18:00:00	DIA	ETF	104.97	104.97	104.97	104.97	100.0
2005-01-13 19:00:00	DIA	ETF	104.91	104.91	104.91	104.91	200.0
2005-01-13 09:00:00	GLD	ETF	42.39	42.44	42.36	42.382	232900.0
2005-01-13 10:00:00	GLD	ETF	42.39	42.44	42.34	42.37	167200.0
2005-01-13 11:00:00	GLD	ETF	42.37	42.5	42.37	42.44	80900.0
2005-01-13 12:00:00	GLD	ETF	42.46	42.49	42.43	42.45	68800.0
2005-01-13 13:00:00	GLD	ETF	42.45	42.5	42.45	42.47	38900.0
2005-01-13 14:00:00	GLD	ETF	42.48	42.51	42.47	42.51	26700.0
2005-01-13 15:00:00	GLD	ETF	42.47	42.57	42.47	42.56	89900.0
2005-01-13 08:00:00	TLT	ETF	89.38	89.68	89.38	89.64	31700.0
2005-01-13 09:00:00	TLT	ETF	89.65	89.86	89.65	89.85	324100.0
2005-01-13 10:00:00	TLT	ETF	89.85	89.96	89.73	89.95	338700.0

> showing 50 of 808 rows — these rows as CSV

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