PREVIEW / etf_1hour / 2005-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-18.parquet
  size:    30 KB
  rows:    865

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-03-18 08:00:00	SPY	ETF	119.1	119.1	119.0	119.01	129100.0
2005-03-18 09:00:00	SPY	ETF	119.04	119.16	118.76	118.87	6588200.0
2005-03-18 10:00:00	SPY	ETF	118.86	119.03	118.47	118.64	8410400.0
2005-03-18 11:00:00	SPY	ETF	118.62	118.95	118.59	118.73	7663800.0
2005-03-18 12:00:00	SPY	ETF	118.74	118.91	118.54	118.58	2798300.0
2005-03-18 13:00:00	SPY	ETF	118.58	118.984	118.15	118.41	10321300.0
2005-03-18 14:00:00	SPY	ETF	118.4	118.69	118.28	118.39	8334700.0
2005-03-18 15:00:00	SPY	ETF	118.391	119.53	118.16	118.81	10688400.0
2005-03-18 16:00:00	SPY	ETF	118.72	118.88	118.46	118.61	3247900.0
2005-03-18 17:00:00	SPY	ETF	118.62	118.82	118.5874	118.59	1278300.0
2005-03-18 18:00:00	SPY	ETF	118.6	118.61	118.54	118.58	3200.0
2005-03-18 19:00:00	SPY	ETF	118.58	118.6	118.58	118.6	700.0
2005-03-18 09:00:00	QQQ	ETF	36.75	36.78	36.55	36.59	11862000.0
2005-03-18 10:00:00	QQQ	ETF	36.59	36.69	36.52	36.58	16647200.0
2005-03-18 11:00:00	QQQ	ETF	36.58	36.67	36.56	36.6	9169200.0
2005-03-18 12:00:00	QQQ	ETF	36.6	36.64	36.49	36.51	8450000.0
2005-03-18 13:00:00	QQQ	ETF	36.5	36.53	36.37	36.48	15470300.0
2005-03-18 14:00:00	QQQ	ETF	36.47	36.52	36.4	36.42	12119800.0
2005-03-18 15:00:00	QQQ	ETF	36.43	36.66	36.35	36.52	22197400.0
2005-03-18 09:00:00	IWM	ETF	62.375	62.375	61.975	62.125	4517200.0
2005-03-18 10:00:00	IWM	ETF	62.11	62.205	61.975	62.005	2817400.0
2005-03-18 11:00:00	IWM	ETF	62.005	62.13	61.985	62.05	1133000.0
2005-03-18 12:00:00	IWM	ETF	62.05	62.085	61.97	61.97	1019000.0
2005-03-18 13:00:00	IWM	ETF	61.98	61.98	61.74	61.925	3073400.0
2005-03-18 14:00:00	IWM	ETF	61.925	62.135	61.845	61.995	2864200.0
2005-03-18 15:00:00	IWM	ETF	61.995	62.265	61.895	62.035	5330200.0
2005-03-18 16:00:00	IWM	ETF	61.98	62.075	61.875	62.075	2363200.0
2005-03-18 17:00:00	IWM	ETF	61.92	61.92	61.92	61.92	2000.0
2005-03-18 08:00:00	DIA	ETF	106.32	106.34	106.25	106.25	2700.0
2005-03-18 09:00:00	DIA	ETF	106.26	106.44	106.19	106.29	1231800.0
2005-03-18 10:00:00	DIA	ETF	106.281	106.38	105.9	106.04	1708200.0
2005-03-18 11:00:00	DIA	ETF	106.03	106.28	105.98	106.1	527800.0
2005-03-18 12:00:00	DIA	ETF	106.12	106.15	105.91	105.96	230400.0
2005-03-18 13:00:00	DIA	ETF	105.96	105.96	105.44	105.65	3918700.0
2005-03-18 14:00:00	DIA	ETF	105.64	105.89	105.6	105.67	992900.0
2005-03-18 15:00:00	DIA	ETF	105.68	106.25	105.52	106.18	1100500.0
2005-03-18 16:00:00	DIA	ETF	106.2	106.22	105.87	106.01	744700.0
2005-03-18 17:00:00	DIA	ETF	105.98	105.98	105.98	105.98	6100.0
2005-03-18 18:00:00	DIA	ETF	105.95	105.95	105.95	105.95	800.0
2005-03-18 19:00:00	DIA	ETF	105.95	105.95	105.95	105.95	200.0
2005-03-18 08:00:00	GLD	ETF	43.57	43.57	43.56	43.56	21000.0
2005-03-18 09:00:00	GLD	ETF	43.61	43.66	43.6	43.61	181500.0
2005-03-18 10:00:00	GLD	ETF	43.62	43.83	43.62	43.77	305500.0
2005-03-18 11:00:00	GLD	ETF	43.79	43.92	43.76	43.88	154700.0
2005-03-18 12:00:00	GLD	ETF	43.88	43.95	43.87	43.88	137400.0
2005-03-18 13:00:00	GLD	ETF	43.89	43.93	43.81	43.91	134600.0
2005-03-18 14:00:00	GLD	ETF	43.91	43.93	43.87	43.9	128500.0
2005-03-18 15:00:00	GLD	ETF	43.91	43.92	43.88	43.89	138700.0
2005-03-18 16:00:00	GLD	ETF	43.91	43.95	43.91	43.95	2000.0
2005-03-18 08:00:00	TLT	ETF	88.81	88.81	88.76	88.76	14600.0

> showing 50 of 865 rows — these rows as CSV

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