PREVIEW / etf_1hour / 2005-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-03.parquet
  size:    29 KB
  rows:    852

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-03 07:00:00	SPY	ETF	116.21	116.21	116.08	116.08	48200.0
2005-05-03 08:00:00	SPY	ETF	116.11	116.16	116.06	116.09	61300.0
2005-05-03 09:00:00	SPY	ETF	116.08	116.34	116.02	116.32	5776600.0
2005-05-03 10:00:00	SPY	ETF	116.32	116.43	116.18	116.26	8169900.0
2005-05-03 11:00:00	SPY	ETF	116.26	116.41	116.24	116.27	2444500.0
2005-05-03 12:00:00	SPY	ETF	116.27	116.27	116.14	116.19	2694200.0
2005-05-03 13:00:00	SPY	ETF	116.2	116.27	116.14	116.26	3622600.0
2005-05-03 14:00:00	SPY	ETF	116.26	116.85	115.83	116.55	31305800.0
2005-05-03 15:00:00	SPY	ETF	116.55	116.58	115.69	116.25	21353300.0
2005-05-03 16:00:00	SPY	ETF	116.28	116.62	115.94	116.57	2850700.0
2005-05-03 17:00:00	SPY	ETF	116.58	116.68	116.58	116.58	243900.0
2005-05-03 18:00:00	SPY	ETF	116.58	116.68	116.55	116.62	64400.0
2005-05-03 19:00:00	SPY	ETF	116.65	116.65	116.57	116.57	89100.0
2005-05-03 09:00:00	QQQ	ETF	35.04	35.21	35.03	35.16	8360300.0
2005-05-03 10:00:00	QQQ	ETF	35.16	35.3	35.13	35.22	16761700.0
2005-05-03 11:00:00	QQQ	ETF	35.22	35.25	35.18	35.21	5180000.0
2005-05-03 12:00:00	QQQ	ETF	35.2	35.22	35.17	35.21	3296000.0
2005-05-03 13:00:00	QQQ	ETF	35.22	35.25	35.17	35.22	4832800.0
2005-05-03 14:00:00	QQQ	ETF	35.22	36.0	35.03	35.34	33336400.0
2005-05-03 15:00:00	QQQ	ETF	35.34	35.36	35.05	35.23	21584900.0
2005-05-03 08:00:00	IWM	ETF	58.12	58.12	58.12	58.12	800.0
2005-05-03 09:00:00	IWM	ETF	58.1	58.42	58.065	58.38	2328000.0
2005-05-03 10:00:00	IWM	ETF	58.38	58.48	58.18	58.335	3766600.0
2005-05-03 11:00:00	IWM	ETF	58.335	58.36	58.24	58.255	1188000.0
2005-05-03 12:00:00	IWM	ETF	58.25	58.295	58.18	58.28	2157400.0
2005-05-03 13:00:00	IWM	ETF	58.285	58.355	58.24	58.355	1684800.0
2005-05-03 14:00:00	IWM	ETF	58.37	58.65	58.0	58.42	7518400.0
2005-05-03 15:00:00	IWM	ETF	58.43	58.43	57.83	58.18	4680200.0
2005-05-03 16:00:00	IWM	ETF	58.225	58.5	58.15	58.5	975800.0
2005-05-03 17:00:00	IWM	ETF	58.495	58.505	58.495	58.5	7600.0
2005-05-03 18:00:00	IWM	ETF	58.515	58.515	58.515	58.515	200.0
2005-05-03 07:00:00	DIA	ETF	102.4	102.4	102.37	102.37	15700.0
2005-05-03 08:00:00	DIA	ETF	102.37	102.4	102.3	102.32	8000.0
2005-05-03 09:00:00	DIA	ETF	102.36	102.66	102.32	102.64	450500.0
2005-05-03 10:00:00	DIA	ETF	102.65	102.75	102.51	102.56	712000.0
2005-05-03 11:00:00	DIA	ETF	102.56	102.63	102.52	102.54	235600.0
2005-05-03 12:00:00	DIA	ETF	102.54	102.56	102.44	102.53	204100.0
2005-05-03 13:00:00	DIA	ETF	102.54	102.55	102.42	102.51	675400.0
2005-05-03 14:00:00	DIA	ETF	102.52	103.08	102.15	102.79	2150700.0
2005-05-03 15:00:00	DIA	ETF	102.82	102.85	102.05	102.57	2551600.0
2005-05-03 16:00:00	DIA	ETF	102.61	102.9	102.57	102.9	9100.0
2005-05-03 17:00:00	DIA	ETF	102.9	103.0	102.81	103.0	4100.0
2005-05-03 18:00:00	DIA	ETF	102.97	102.97	102.9	102.9	500.0
2005-05-03 19:00:00	DIA	ETF	102.9	102.9	102.9	102.9	100.0
2005-05-03 09:00:00	GLD	ETF	42.75	42.79	42.74	42.77	77200.0
2005-05-03 10:00:00	GLD	ETF	42.79	42.79	42.69	42.77	89000.0
2005-05-03 11:00:00	GLD	ETF	42.74	42.79	42.7	42.76	34600.0
2005-05-03 12:00:00	GLD	ETF	42.76	42.76	42.58	42.67	140400.0
2005-05-03 13:00:00	GLD	ETF	42.64	42.67	42.6	42.62	26300.0
2005-05-03 14:00:00	GLD	ETF	42.61	42.7	42.59	42.7	768500.0

> showing 50 of 852 rows — these rows as CSV

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