PREVIEW / etf_1hour / 2005-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-04.parquet
  size:    30 KB
  rows:    863

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-04 08:00:00	SPY	ETF	121.38	122.16	121.38	122.08	1656700.0
2005-03-04 09:00:00	SPY	ETF	122.06	122.18	121.8	122.06	6945000.0
2005-03-04 10:00:00	SPY	ETF	122.06	122.55	122.0	122.16	15690300.0
2005-03-04 11:00:00	SPY	ETF	122.16	122.43	122.04	122.29	4429800.0
2005-03-04 12:00:00	SPY	ETF	122.28	122.55	122.24	122.46	5134000.0
2005-03-04 13:00:00	SPY	ETF	122.46	122.74	122.34	122.7	4908900.0
2005-03-04 14:00:00	SPY	ETF	122.72	122.83	122.51	122.65	7049900.0
2005-03-04 15:00:00	SPY	ETF	122.62	122.76	122.47	122.55	6216600.0
2005-03-04 16:00:00	SPY	ETF	122.56	122.9	121.58	122.77	1998800.0
2005-03-04 17:00:00	SPY	ETF	122.8	122.83	122.77	122.8	3700.0
2005-03-04 18:00:00	SPY	ETF	122.8	122.84	122.8	122.8	7400.0
2005-03-04 19:00:00	SPY	ETF	122.84	122.84	122.75	122.8	1300.0
2005-03-04 09:00:00	QQQ	ETF	37.6	37.65	37.4	37.59	17466900.0
2005-03-04 10:00:00	QQQ	ETF	37.58	37.75	37.51	37.53	21914100.0
2005-03-04 11:00:00	QQQ	ETF	37.53	37.59	37.46	37.53	7889700.0
2005-03-04 12:00:00	QQQ	ETF	37.52	37.62	37.46	37.57	5646000.0
2005-03-04 13:00:00	QQQ	ETF	37.57	37.66	37.48	37.65	6536200.0
2005-03-04 14:00:00	QQQ	ETF	37.65	37.68	37.56	37.59	6766300.0
2005-03-04 15:00:00	QQQ	ETF	37.59	37.65	37.49	37.52	7583000.0
2005-03-04 08:00:00	IWM	ETF	63.75	64.15	63.65	64.15	58800.0
2005-03-04 09:00:00	IWM	ETF	64.095	64.175	63.76	63.99	3231400.0
2005-03-04 10:00:00	IWM	ETF	64.0	64.255	63.865	63.915	4443800.0
2005-03-04 11:00:00	IWM	ETF	63.925	64.17	63.88	64.075	1347200.0
2005-03-04 12:00:00	IWM	ETF	64.09	64.285	64.04	64.24	889600.0
2005-03-04 13:00:00	IWM	ETF	64.235	64.425	64.185	64.41	2145600.0
2005-03-04 14:00:00	IWM	ETF	64.41	64.455	64.23	64.335	1620800.0
2005-03-04 15:00:00	IWM	ETF	64.345	64.435	64.265	64.32	1695600.0
2005-03-04 16:00:00	IWM	ETF	64.305	64.4	64.225	64.285	391000.0
2005-03-04 17:00:00	IWM	ETF	64.315	64.3714	64.315	64.3714	249600.0
2005-03-04 08:00:00	DIA	ETF	108.45	108.96	108.4	108.96	14700.0
2005-03-04 09:00:00	DIA	ETF	108.88	108.92	108.65	108.82	563500.0
2005-03-04 10:00:00	DIA	ETF	108.83	109.27	108.82	109.02	1643900.0
2005-03-04 11:00:00	DIA	ETF	109.02	109.19	108.9	109.06	680300.0
2005-03-04 12:00:00	DIA	ETF	109.08	109.32	109.03	109.27	1037700.0
2005-03-04 13:00:00	DIA	ETF	109.29	109.51	109.2	109.5	883700.0
2005-03-04 14:00:00	DIA	ETF	109.5	109.61	109.41	109.49	497600.0
2005-03-04 15:00:00	DIA	ETF	109.47	109.61	109.31	109.41	747600.0
2005-03-04 16:00:00	DIA	ETF	109.4	109.64	109.4	109.64	20500.0
2005-03-04 17:00:00	DIA	ETF	109.72	109.78	109.72	109.78	800.0
2005-03-04 18:00:00	DIA	ETF	109.72	109.75	109.65	109.75	900.0
2005-03-04 19:00:00	DIA	ETF	109.72	109.72	109.71	109.71	600.0
2005-03-04 08:00:00	GLD	ETF	42.97	43.18	42.97	43.18	1500.0
2005-03-04 09:00:00	GLD	ETF	43.2	43.4	43.2	43.37	256500.0
2005-03-04 10:00:00	GLD	ETF	43.35	43.44	43.31	43.4	144200.0
2005-03-04 11:00:00	GLD	ETF	43.38	43.42	43.35	43.4	79800.0
2005-03-04 12:00:00	GLD	ETF	43.39	43.52	43.37	43.45	88400.0
2005-03-04 13:00:00	GLD	ETF	43.46	43.47	43.34	43.37	96300.0
2005-03-04 14:00:00	GLD	ETF	43.37	43.42	43.35	43.41	89500.0
2005-03-04 15:00:00	GLD	ETF	43.42	43.43	43.37	43.41	101800.0
2005-03-04 16:00:00	GLD	ETF	43.3	43.3	43.3	43.3	50000.0

> showing 50 of 863 rows — these rows as CSV

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