PREVIEW / etf_1hour / 2005-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-01.parquet
  size:    30 KB
  rows:    867

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-04-01 08:00:00	SPY	ETF	118.4	118.82	118.03	118.7	1897700.0
2005-04-01 09:00:00	SPY	ETF	118.7	118.99	118.52	118.8	10126000.0
2005-04-01 10:00:00	SPY	ETF	118.8	118.88	117.67	117.76	26112000.0
2005-04-01 11:00:00	SPY	ETF	117.75	118.05	117.63	117.92	12157500.0
2005-04-01 12:00:00	SPY	ETF	117.92	117.97	117.21	117.21	9034200.0
2005-04-01 13:00:00	SPY	ETF	117.21	117.45	116.95	117.05	12691700.0
2005-04-01 14:00:00	SPY	ETF	117.06	117.65	116.91	117.01	7068900.0
2005-04-01 15:00:00	SPY	ETF	116.98	117.47	116.94	117.24	10682200.0
2005-04-01 16:00:00	SPY	ETF	117.24	118.0	117.2	117.3	2855500.0
2005-04-01 17:00:00	SPY	ETF	117.31	117.35	117.27	117.27	7100.0
2005-04-01 18:00:00	SPY	ETF	117.3	117.37	117.3	117.35	8000.0
2005-04-01 19:00:00	SPY	ETF	117.35	117.35	117.33	117.33	1900.0
2005-04-01 09:00:00	QQQ	ETF	36.82	36.88	36.74	36.81	12150400.0
2005-04-01 10:00:00	QQQ	ETF	36.8	36.85	36.22	36.25	42941200.0
2005-04-01 11:00:00	QQQ	ETF	36.25	36.43	36.21	36.37	15184500.0
2005-04-01 12:00:00	QQQ	ETF	36.37	36.4	36.23	36.24	13536700.0
2005-04-01 13:00:00	QQQ	ETF	36.24	36.37	36.13	36.19	15927200.0
2005-04-01 14:00:00	QQQ	ETF	36.2	36.28	36.16	36.19	14142600.0
2005-04-01 15:00:00	QQQ	ETF	36.18	36.3	36.16	36.18	17274200.0
2005-04-01 08:00:00	IWM	ETF	61.26	61.51	61.105	61.42	107200.0
2005-04-01 09:00:00	IWM	ETF	61.44	61.72	61.3	61.61	3258800.0
2005-04-01 10:00:00	IWM	ETF	61.61	61.675	60.58	60.595	8577600.0
2005-04-01 11:00:00	IWM	ETF	60.585	60.845	60.48	60.745	2669000.0
2005-04-01 12:00:00	IWM	ETF	60.745	60.75	60.45	60.47	1914200.0
2005-04-01 13:00:00	IWM	ETF	60.47	60.6	60.41	60.475	2279000.0
2005-04-01 14:00:00	IWM	ETF	60.46	60.65	60.445	60.555	1831800.0
2005-04-01 15:00:00	IWM	ETF	60.565	60.83	60.53	60.75	2981400.0
2005-04-01 16:00:00	IWM	ETF	60.77	60.82	60.625	60.68	188400.0
2005-04-01 17:00:00	IWM	ETF	60.82	60.82	60.68	60.68	2200.0
2005-04-01 08:00:00	DIA	ETF	105.26	105.58	105.02	105.49	43900.0
2005-04-01 09:00:00	DIA	ETF	105.5	105.62	105.35	105.52	980600.0
2005-04-01 10:00:00	DIA	ETF	105.51	105.59	104.49	104.5	2023500.0
2005-04-01 11:00:00	DIA	ETF	104.57	104.77	104.47	104.65	617900.0
2005-04-01 12:00:00	DIA	ETF	104.65	104.7	104.04	104.06	1046000.0
2005-04-01 13:00:00	DIA	ETF	104.05	104.2	103.75	103.84	734600.0
2005-04-01 14:00:00	DIA	ETF	103.84	104.04	103.74	103.8	852700.0
2005-04-01 15:00:00	DIA	ETF	103.83	104.16	103.78	103.92	1323300.0
2005-04-01 16:00:00	DIA	ETF	103.92	104.07	103.92	103.96	15500.0
2005-04-01 17:00:00	DIA	ETF	103.96	103.96	103.96	103.96	300.0
2005-04-01 08:00:00	GLD	ETF	42.68	43.0	42.66	42.85	36500.0
2005-04-01 09:00:00	GLD	ETF	42.7	42.7	42.51	42.54	561700.0
2005-04-01 10:00:00	GLD	ETF	42.55	42.59	42.45	42.51	706900.0
2005-04-01 11:00:00	GLD	ETF	42.53	42.59	42.52	42.58	259000.0
2005-04-01 12:00:00	GLD	ETF	42.57	42.59	42.54	42.57	229300.0
2005-04-01 13:00:00	GLD	ETF	42.59	42.59	42.54	42.59	415800.0
2005-04-01 14:00:00	GLD	ETF	42.57	42.62	42.56	42.61	175800.0
2005-04-01 15:00:00	GLD	ETF	42.61	42.62	42.58	42.62	61500.0
2005-04-01 08:00:00	TLT	ETF	88.99	89.81	88.99	89.69	42700.0
2005-04-01 09:00:00	TLT	ETF	89.65	89.66	89.42	89.52	210300.0
2005-04-01 10:00:00	TLT	ETF	89.45	89.53	88.5	88.78	927100.0

> showing 50 of 867 rows — these rows as CSV

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