PREVIEW / etf_1hour / 2005-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-12.parquet
  size:    31 KB
  rows:    895

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-05-12 04:00:00	SPY	ETF	117.42	117.42	117.42	117.42	6300.0
2005-05-12 06:00:00	SPY	ETF	117.29	117.29	117.29	117.29	4900.0
2005-05-12 07:00:00	SPY	ETF	117.31	117.31	117.11	117.2	179300.0
2005-05-12 08:00:00	SPY	ETF	117.19	117.43	117.17	117.38	557400.0
2005-05-12 09:00:00	SPY	ETF	117.38	117.48	116.99	117.09	7807000.0
2005-05-12 10:00:00	SPY	ETF	117.09	117.59	116.83	117.08	23539000.0
2005-05-12 11:00:00	SPY	ETF	117.05	117.41	116.86	117.35	9724600.0
2005-05-12 12:00:00	SPY	ETF	117.35	117.5	117.0	117.21	8575200.0
2005-05-12 13:00:00	SPY	ETF	117.2	117.29	116.72	116.84	6698600.0
2005-05-12 14:00:00	SPY	ETF	116.84	116.95	116.11	116.36	17309300.0
2005-05-12 15:00:00	SPY	ETF	116.36	116.41	115.95	116.1	14280600.0
2005-05-12 16:00:00	SPY	ETF	116.09	116.59	115.95	116.17	2870400.0
2005-05-12 17:00:00	SPY	ETF	116.14	116.21	115.96	116.15	478800.0
2005-05-12 18:00:00	SPY	ETF	116.18	116.21	116.18	116.2	7400.0
2005-05-12 19:00:00	SPY	ETF	116.17	116.24	116.17	116.24	300.0
2005-05-12 09:00:00	QQQ	ETF	36.01	36.08	35.9	35.94	17337200.0
2005-05-12 10:00:00	QQQ	ETF	35.94	36.2	35.84	36.01	25031700.0
2005-05-12 11:00:00	QQQ	ETF	36.01	36.15	35.95	36.13	10427200.0
2005-05-12 12:00:00	QQQ	ETF	36.1	36.18	35.05	36.07	10903400.0
2005-05-12 13:00:00	QQQ	ETF	36.07	36.11	35.94	35.99	7977100.0
2005-05-12 14:00:00	QQQ	ETF	35.98	36.03	35.68	35.82	18953400.0
2005-05-12 15:00:00	QQQ	ETF	35.81	35.84	35.66	35.84	19373800.0
2005-05-12 07:00:00	IWM	ETF	59.25	59.25	59.17	59.17	59800.0
2005-05-12 08:00:00	IWM	ETF	59.25	59.335	59.25	59.3	2400.0
2005-05-12 09:00:00	IWM	ETF	59.345	59.575	59.06	59.115	3128000.0
2005-05-12 10:00:00	IWM	ETF	59.12	59.485	58.955	59.075	6807000.0
2005-05-12 11:00:00	IWM	ETF	59.09	59.21	58.97	59.19	2658800.0
2005-05-12 12:00:00	IWM	ETF	59.1945	59.28	58.82	58.925	2529000.0
2005-05-12 13:00:00	IWM	ETF	58.91	58.99	58.565	58.615	3470600.0
2005-05-12 14:00:00	IWM	ETF	58.61	58.7	58.31	58.455	4121200.0
2005-05-12 15:00:00	IWM	ETF	58.46	58.495	58.185	58.315	5701400.0
2005-05-12 16:00:00	IWM	ETF	58.315	58.8795	58.28	58.425	459600.0
2005-05-12 17:00:00	IWM	ETF	58.425	58.425	58.425	58.425	4400.0
2005-05-12 18:00:00	IWM	ETF	58.465	58.465	58.465	58.465	2000.0
2005-05-12 07:00:00	DIA	ETF	103.05	103.05	102.9	102.92	10800.0
2005-05-12 08:00:00	DIA	ETF	102.94	103.09	102.91	103.09	13200.0
2005-05-12 09:00:00	DIA	ETF	103.06	103.23	102.84	102.9	409700.0
2005-05-12 10:00:00	DIA	ETF	102.9	103.34	102.81	102.99	1446500.0
2005-05-12 11:00:00	DIA	ETF	102.95	103.26	102.83	103.2	533500.0
2005-05-12 12:00:00	DIA	ETF	103.18	103.31	102.88	103.01	478100.0
2005-05-12 13:00:00	DIA	ETF	103.03	103.12	102.65	102.75	399100.0
2005-05-12 14:00:00	DIA	ETF	102.71	102.8	102.1	102.25	1186300.0
2005-05-12 15:00:00	DIA	ETF	102.27	102.31	101.93	102.04	987300.0
2005-05-12 16:00:00	DIA	ETF	102.05	102.07	101.94	102.0	30800.0
2005-05-12 17:00:00	DIA	ETF	102.02	102.1	101.95	101.95	32600.0
2005-05-12 18:00:00	DIA	ETF	102.09	102.09	102.09	102.09	500.0
2005-05-12 19:00:00	DIA	ETF	102.01	102.01	102.01	102.01	300.0
2005-05-12 08:00:00	GLD	ETF	42.46	42.5	42.41	42.5	39800.0
2005-05-12 09:00:00	GLD	ETF	42.4	42.48	42.3	42.37	375000.0
2005-05-12 10:00:00	GLD	ETF	42.37	42.38	42.3	42.35	294600.0

> showing 50 of 895 rows — these rows as CSV

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