PREVIEW / etf_1hour / 2005-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-03.parquet
  size:    30 KB
  rows:    880

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-06-03 07:00:00	SPY	ETF	120.64	120.64	120.57	120.61	6400.0
2005-06-03 08:00:00	SPY	ETF	120.65	120.95	120.47	120.74	1324300.0
2005-06-03 09:00:00	SPY	ETF	120.74	120.89	120.46	120.74	7269200.0
2005-06-03 10:00:00	SPY	ETF	120.72	120.74	120.33	120.55	9609100.0
2005-06-03 11:00:00	SPY	ETF	120.55	120.62	119.82	119.96	11204800.0
2005-06-03 12:00:00	SPY	ETF	119.96	120.14	119.75	119.91	6961700.0
2005-06-03 13:00:00	SPY	ETF	119.91	120.07	119.83	120.0	4488700.0
2005-06-03 14:00:00	SPY	ETF	120.0	120.18	119.77	119.88	7095000.0
2005-06-03 15:00:00	SPY	ETF	119.89	120.09	119.73	119.94	8132300.0
2005-06-03 16:00:00	SPY	ETF	119.95	120.63	119.92	120.11	1969100.0
2005-06-03 17:00:00	SPY	ETF	120.14	120.15	120.05	120.1	14500.0
2005-06-03 18:00:00	SPY	ETF	120.1	120.15	120.07	120.15	25000.0
2005-06-03 19:00:00	SPY	ETF	120.15	120.15	120.15	120.15	1200.0
2005-06-03 09:00:00	QQQ	ETF	38.63	38.64	38.5	38.57	13717300.0
2005-06-03 10:00:00	QQQ	ETF	38.56	39.0	38.31	38.4	18450600.0
2005-06-03 11:00:00	QQQ	ETF	38.4	38.41	38.13	38.2	13438000.0
2005-06-03 12:00:00	QQQ	ETF	38.19	38.23	38.13	38.19	6925100.0
2005-06-03 13:00:00	QQQ	ETF	38.19	38.23	38.13	38.2	9144200.0
2005-06-03 14:00:00	QQQ	ETF	38.2	38.21	38.05	38.1	9828300.0
2005-06-03 15:00:00	QQQ	ETF	38.09	38.13	38.02	38.1	13940600.0
2005-06-03 08:00:00	IWM	ETF	62.195	62.355	62.175	62.25	38000.0
2005-06-03 09:00:00	IWM	ETF	62.16	62.415	62.07	62.36	2754800.0
2005-06-03 10:00:00	IWM	ETF	62.345	62.345	62.05	62.185	3467200.0
2005-06-03 11:00:00	IWM	ETF	62.185	62.215	61.625	61.69	4294400.0
2005-06-03 12:00:00	IWM	ETF	61.69	61.73	61.555	61.675	2333400.0
2005-06-03 13:00:00	IWM	ETF	61.675	61.86	61.665	61.81	1194400.0
2005-06-03 14:00:00	IWM	ETF	61.81	61.97	61.71	61.745	2884800.0
2005-06-03 15:00:00	IWM	ETF	61.745	61.95	61.675	61.675	3926200.0
2005-06-03 16:00:00	IWM	ETF	61.815	61.815	61.675	61.775	287600.0
2005-06-03 07:00:00	DIA	ETF	105.44	105.44	105.44	105.44	200.0
2005-06-03 08:00:00	DIA	ETF	105.52	105.61	105.33	105.43	79200.0
2005-06-03 09:00:00	DIA	ETF	105.43	105.44	105.14	105.28	326500.0
2005-06-03 10:00:00	DIA	ETF	105.28	105.29	105.01	105.2	654000.0
2005-06-03 11:00:00	DIA	ETF	105.2	105.25	104.6	104.69	956300.0
2005-06-03 12:00:00	DIA	ETF	104.68	104.71	104.42	104.55	585000.0
2005-06-03 13:00:00	DIA	ETF	104.5401	104.71	104.5	104.61	268200.0
2005-06-03 14:00:00	DIA	ETF	104.61	104.73	104.45	104.53	589200.0
2005-06-03 15:00:00	DIA	ETF	104.53	104.77	104.38	104.63	973000.0
2005-06-03 16:00:00	DIA	ETF	104.68	104.8	104.67	104.75	514200.0
2005-06-03 17:00:00	DIA	ETF	104.74	104.74	104.74	104.74	100.0
2005-06-03 19:00:00	DIA	ETF	104.72	104.72	104.72	104.72	200.0
2005-06-03 08:00:00	GLD	ETF	42.24	42.37	41.3	42.37	159300.0
2005-06-03 09:00:00	GLD	ETF	42.32	42.33	42.28	42.32	834800.0
2005-06-03 10:00:00	GLD	ETF	42.32	42.39	42.27	42.32	399900.0
2005-06-03 11:00:00	GLD	ETF	42.32	42.32	42.2	42.3	235900.0
2005-06-03 12:00:00	GLD	ETF	42.29	42.32	42.22	42.29	475200.0
2005-06-03 13:00:00	GLD	ETF	42.28	42.3	42.2001	42.27	162000.0
2005-06-03 14:00:00	GLD	ETF	42.27	42.28	42.17	42.19	525200.0
2005-06-03 15:00:00	GLD	ETF	42.19	42.21	42.18	42.18	378600.0
2005-06-03 16:00:00	GLD	ETF	42.19	42.19	42.17	42.17	18700.0

> showing 50 of 880 rows — these rows as CSV

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