PREVIEW / etf_1hour / 2005-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-21.parquet
  size:    29 KB
  rows:    862

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-21 08:00:00	SPY	ETF	118.61	118.72	118.61	118.63	103600.0
2005-03-21 09:00:00	SPY	ETF	118.64	118.78	118.56	118.66	5177300.0
2005-03-21 10:00:00	SPY	ETF	118.65	118.69	117.85	118.03	13242400.0
2005-03-21 11:00:00	SPY	ETF	118.02	118.15	117.76	118.12	10310200.0
2005-03-21 12:00:00	SPY	ETF	118.08	118.57	118.07	118.32	8024500.0
2005-03-21 13:00:00	SPY	ETF	118.32	118.43	118.2	118.31	6404600.0
2005-03-21 14:00:00	SPY	ETF	118.31	118.46	118.05	118.4	8176300.0
2005-03-21 15:00:00	SPY	ETF	118.4	118.64	118.25	118.26	7805700.0
2005-03-21 16:00:00	SPY	ETF	118.23	118.3	118.04	118.1	810500.0
2005-03-21 17:00:00	SPY	ETF	118.08	118.3	118.06	118.09	64100.0
2005-03-21 18:00:00	SPY	ETF	118.15	118.15	118.11	118.11	3500.0
2005-03-21 09:00:00	QQQ	ETF	36.59	36.65	36.53	36.58	9494900.0
2005-03-21 10:00:00	QQQ	ETF	36.58	36.59	36.26	36.35	19015900.0
2005-03-21 11:00:00	QQQ	ETF	36.36	36.5	36.25	36.5	13048100.0
2005-03-21 12:00:00	QQQ	ETF	36.5	37.67	36.47	36.61	15930500.0
2005-03-21 13:00:00	QQQ	ETF	36.61	38.58	36.55	36.56	7523900.0
2005-03-21 14:00:00	QQQ	ETF	36.56	36.63	36.47	36.6	10528600.0
2005-03-21 15:00:00	QQQ	ETF	36.62	36.72	36.56	36.57	12894500.0
2005-03-21 09:00:00	IWM	ETF	62.06	62.135	62.0	62.015	1577800.0
2005-03-21 10:00:00	IWM	ETF	62.015	62.02	61.67	61.79	2881800.0
2005-03-21 11:00:00	IWM	ETF	61.78	61.815	61.575	61.785	1673000.0
2005-03-21 12:00:00	IWM	ETF	61.78	61.955	61.755	61.86	2435800.0
2005-03-21 13:00:00	IWM	ETF	61.86	61.95	61.825	61.8708	1749200.0
2005-03-21 14:00:00	IWM	ETF	61.855	61.94	61.73	61.94	1253000.0
2005-03-21 15:00:00	IWM	ETF	61.935	62.1	61.92	61.95	3995000.0
2005-03-21 16:00:00	IWM	ETF	61.96	61.995	61.9	61.98	705800.0
2005-03-21 08:00:00	DIA	ETF	106.05	106.06	106.05	106.05	2000.0
2005-03-21 09:00:00	DIA	ETF	106.06	106.12	105.89	105.96	699900.0
2005-03-21 10:00:00	DIA	ETF	105.97	105.97	105.26	105.47	2051400.0
2005-03-21 11:00:00	DIA	ETF	105.47	105.55	105.23	105.54	725700.0
2005-03-21 12:00:00	DIA	ETF	105.54	105.9	105.51	105.71	1038100.0
2005-03-21 13:00:00	DIA	ETF	105.69	105.8	105.6	105.67	419900.0
2005-03-21 14:00:00	DIA	ETF	105.66	105.8	105.45	105.74	603900.0
2005-03-21 15:00:00	DIA	ETF	105.74	105.97	105.54	105.55	1634300.0
2005-03-21 16:00:00	DIA	ETF	105.53	105.56	105.41	105.44	73300.0
2005-03-21 18:00:00	DIA	ETF	105.41	105.41	105.41	105.41	800.0
2005-03-21 08:00:00	GLD	ETF	43.35	43.35	43.13	43.13	71300.0
2005-03-21 09:00:00	GLD	ETF	43.22	43.24	43.16	43.17	635900.0
2005-03-21 10:00:00	GLD	ETF	43.19	43.25	43.13	43.14	398500.0
2005-03-21 11:00:00	GLD	ETF	43.16	43.16	42.97	43.02	540800.0
2005-03-21 12:00:00	GLD	ETF	43.02	43.08	42.87	43.01	636500.0
2005-03-21 13:00:00	GLD	ETF	43.02	43.1	43.0	43.1	377200.0
2005-03-21 14:00:00	GLD	ETF	43.1	43.11	43.05	43.1	250600.0
2005-03-21 15:00:00	GLD	ETF	43.1	43.1	43.01	43.09	403600.0
2005-03-21 08:00:00	TLT	ETF	88.55	88.55	88.48	88.48	1500.0
2005-03-21 09:00:00	TLT	ETF	88.55	88.67	88.5	88.5	28200.0
2005-03-21 10:00:00	TLT	ETF	88.51	88.58	88.48	88.54	76900.0
2005-03-21 11:00:00	TLT	ETF	88.55	88.67	88.51	88.55	127300.0
2005-03-21 12:00:00	TLT	ETF	88.51	88.59	88.46	88.56	47600.0
2005-03-21 13:00:00	TLT	ETF	88.62	88.63	88.42	88.5	26200.0

> showing 50 of 862 rows — these rows as CSV

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