PREVIEW / etf_1hour / 2005-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-17.parquet
  size:    28 KB
  rows:    815

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-02-17 08:00:00	SPY	ETF	121.26	121.32	121.24	121.25	33200.0
2005-02-17 09:00:00	SPY	ETF	121.25	121.33	121.16	121.19	4661500.0
2005-02-17 10:00:00	SPY	ETF	121.2	121.32	120.44	120.63	17193900.0
2005-02-17 11:00:00	SPY	ETF	120.64	120.75	120.51	120.65	6028300.0
2005-02-17 12:00:00	SPY	ETF	120.64	120.88	120.64	120.85	3918900.0
2005-02-17 13:00:00	SPY	ETF	120.82	120.93	120.6	120.63	3231700.0
2005-02-17 14:00:00	SPY	ETF	120.64	120.73	120.31	120.37	8677800.0
2005-02-17 15:00:00	SPY	ETF	120.36	120.6	120.24	120.28	10839500.0
2005-02-17 16:00:00	SPY	ETF	120.25	120.31	120.2	120.23	2191500.0
2005-02-17 17:00:00	SPY	ETF	120.23	120.24	120.18	120.18	16400.0
2005-02-17 18:00:00	SPY	ETF	120.23	120.26	120.23	120.26	13300.0
2005-02-17 19:00:00	SPY	ETF	120.27	120.27	120.27	120.27	300.0
2005-02-17 09:00:00	QQQ	ETF	38.06	38.14	37.98	38.03	6492100.0
2005-02-17 10:00:00	QQQ	ETF	38.04	38.06	37.56	37.69	28294000.0
2005-02-17 11:00:00	QQQ	ETF	37.69	37.78	37.62	37.75	9473000.0
2005-02-17 12:00:00	QQQ	ETF	37.75	37.81	37.7	37.75	6244700.0
2005-02-17 13:00:00	QQQ	ETF	37.75	37.81	37.63	37.65	9827300.0
2005-02-17 14:00:00	QQQ	ETF	37.64	37.71	37.43	37.47	14212800.0
2005-02-17 15:00:00	QQQ	ETF	37.47	37.61	37.44	37.45	18269900.0
2005-02-17 08:00:00	IWM	ETF	63.55	63.565	63.545	63.565	4000.0
2005-02-17 09:00:00	IWM	ETF	63.7	63.835	63.6	63.775	2201800.0
2005-02-17 10:00:00	IWM	ETF	63.755	63.785	62.99	63.205	4620200.0
2005-02-17 11:00:00	IWM	ETF	63.215	63.315	63.055	63.22	2600400.0
2005-02-17 12:00:00	IWM	ETF	63.215	63.48	63.215	63.48	1755000.0
2005-02-17 13:00:00	IWM	ETF	63.475	63.52	63.22	63.275	1093800.0
2005-02-17 14:00:00	IWM	ETF	63.265	63.41	63.025	63.03	1474400.0
2005-02-17 15:00:00	IWM	ETF	63.025	63.08	62.875	62.93	2901200.0
2005-02-17 16:00:00	IWM	ETF	62.905	62.975	62.895	62.895	223800.0
2005-02-17 18:00:00	IWM	ETF	62.915	62.915	62.915	62.915	1000.0
2005-02-17 08:00:00	DIA	ETF	108.5	108.5	108.45	108.5	1500.0
2005-02-17 09:00:00	DIA	ETF	108.5	108.56	108.4	108.45	588800.0
2005-02-17 10:00:00	DIA	ETF	108.45	108.52	107.9	108.02	1444900.0
2005-02-17 11:00:00	DIA	ETF	108.03	108.14	107.94	108.07	494900.0
2005-02-17 12:00:00	DIA	ETF	108.05	108.2	108.05	108.18	440500.0
2005-02-17 13:00:00	DIA	ETF	108.18	108.23	107.97	108.03	514900.0
2005-02-17 14:00:00	DIA	ETF	108.03	108.1	107.74	107.79	1039700.0
2005-02-17 15:00:00	DIA	ETF	107.79	107.97	107.69	107.7	1140600.0
2005-02-17 16:00:00	DIA	ETF	107.72	107.73	107.68	107.7	36300.0
2005-02-17 17:00:00	DIA	ETF	107.7	107.7	107.7	107.7	300.0
2005-02-17 09:00:00	GLD	ETF	42.52	42.67	42.51	42.56	196100.0
2005-02-17 10:00:00	GLD	ETF	42.55	42.69	42.55	42.67	606600.0
2005-02-17 11:00:00	GLD	ETF	42.66	42.75	42.63	42.69	1167600.0
2005-02-17 12:00:00	GLD	ETF	42.69	42.72	42.65	42.72	229400.0
2005-02-17 13:00:00	GLD	ETF	42.72	42.81	42.7	42.75	449000.0
2005-02-17 14:00:00	GLD	ETF	42.75	42.75	42.7	42.73	166700.0
2005-02-17 15:00:00	GLD	ETF	42.73	42.76	42.69	42.75	237100.0
2005-02-17 08:00:00	TLT	ETF	91.92	91.95	91.67	91.74	77000.0
2005-02-17 09:00:00	TLT	ETF	91.79	91.8	91.66	91.66	440900.0
2005-02-17 10:00:00	TLT	ETF	91.66	91.99	91.65	91.97	211700.0
2005-02-17 11:00:00	TLT	ETF	91.98	92.14	91.95	92.01	42400.0

> showing 50 of 815 rows — these rows as CSV

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