PREVIEW / etf_1hour / 2005-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-14.parquet
  size:    28 KB
  rows:    830

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-14 08:00:00	SPY	ETF	120.71	120.78	120.7	120.75	101400.0
2005-02-14 09:00:00	SPY	ETF	120.74	120.79	120.58	120.64	4432800.0
2005-02-14 10:00:00	SPY	ETF	120.64	120.77	120.5	120.53	6919700.0
2005-02-14 11:00:00	SPY	ETF	120.55	120.71	120.48	120.63	4140200.0
2005-02-14 12:00:00	SPY	ETF	120.63	120.75	120.52	120.67	3376100.0
2005-02-14 13:00:00	SPY	ETF	120.69	120.76	120.59	120.62	2067100.0
2005-02-14 14:00:00	SPY	ETF	120.62	120.76	120.53	120.72	3279500.0
2005-02-14 15:00:00	SPY	ETF	120.73	120.86	120.63	120.78	4759600.0
2005-02-14 16:00:00	SPY	ETF	120.79	120.85	120.66	120.68	2687600.0
2005-02-14 17:00:00	SPY	ETF	120.55	120.78	120.55	120.78	116600.0
2005-02-14 18:00:00	SPY	ETF	120.72	120.72	120.72	120.72	200.0
2005-02-14 19:00:00	SPY	ETF	120.71	120.71	120.69	120.71	5000.0
2005-02-14 09:00:00	QQQ	ETF	37.71	37.88	37.68	37.82	11147800.0
2005-02-14 10:00:00	QQQ	ETF	37.83	37.94	37.74	37.8	11179600.0
2005-02-14 11:00:00	QQQ	ETF	37.8	37.87	37.74	37.84	6515500.0
2005-02-14 12:00:00	QQQ	ETF	37.84	37.88	37.79	37.83	3350400.0
2005-02-14 13:00:00	QQQ	ETF	37.84	37.87	37.77	37.8	3416700.0
2005-02-14 14:00:00	QQQ	ETF	37.8	37.87	37.75	37.87	5075800.0
2005-02-14 15:00:00	QQQ	ETF	37.87	37.93	37.82	37.88	8413600.0
2005-02-14 08:00:00	IWM	ETF	63.3	63.3	63.3	63.3	4000.0
2005-02-14 09:00:00	IWM	ETF	63.3	63.5	63.195	63.275	1214800.0
2005-02-14 10:00:00	IWM	ETF	63.275	63.39	63.145	63.185	1387200.0
2005-02-14 11:00:00	IWM	ETF	63.185	63.33	63.165	63.305	603400.0
2005-02-14 12:00:00	IWM	ETF	63.28	63.325	63.23	63.2696	410000.0
2005-02-14 13:00:00	IWM	ETF	63.27	63.27	62.995	63.0	1619800.0
2005-02-14 14:00:00	IWM	ETF	63.0	63.18	62.86	63.16	2020400.0
2005-02-14 15:00:00	IWM	ETF	63.165	63.31	63.1	63.305	1300600.0
2005-02-14 16:00:00	IWM	ETF	63.325	63.39	63.225	63.235	296400.0
2005-02-14 08:00:00	DIA	ETF	108.1	108.1	108.1	108.1	100.0
2005-02-14 09:00:00	DIA	ETF	108.04	108.1	107.93	107.96	634200.0
2005-02-14 10:00:00	DIA	ETF	107.97	108.05	107.85	107.89	1060900.0
2005-02-14 11:00:00	DIA	ETF	107.9	108.01	107.84	107.95	567900.0
2005-02-14 12:00:00	DIA	ETF	107.93	108.04	107.89	107.9815	227500.0
2005-02-14 13:00:00	DIA	ETF	107.98	108.03	107.9	107.91	303000.0
2005-02-14 14:00:00	DIA	ETF	107.9	108.01	107.85	108.0	246600.0
2005-02-14 15:00:00	DIA	ETF	108.0	108.12	107.93	108.04	595500.0
2005-02-14 16:00:00	DIA	ETF	108.06	108.06	107.98	107.98	3500.0
2005-02-14 09:00:00	GLD	ETF	42.37	42.43	42.37	42.39	729300.0
2005-02-14 10:00:00	GLD	ETF	42.4	42.4	42.32	42.39	814100.0
2005-02-14 11:00:00	GLD	ETF	42.38	42.51	42.37	42.42	242000.0
2005-02-14 12:00:00	GLD	ETF	42.44	42.52	42.39	42.51	218100.0
2005-02-14 13:00:00	GLD	ETF	42.5	42.62	42.47	42.62	88900.0
2005-02-14 14:00:00	GLD	ETF	42.62	42.63	42.51	42.56	183600.0
2005-02-14 15:00:00	GLD	ETF	42.56	42.58	42.52	42.55	74600.0
2005-02-14 16:00:00	GLD	ETF	42.55	42.55	42.55	42.55	1200.0
2005-02-14 08:00:00	TLT	ETF	92.65	92.65	92.65	92.65	5000.0
2005-02-14 09:00:00	TLT	ETF	92.9	92.95	92.81	92.89	24000.0
2005-02-14 10:00:00	TLT	ETF	92.82	92.9	92.73	92.88	42700.0
2005-02-14 11:00:00	TLT	ETF	92.9	92.98	92.8	92.98	47400.0
2005-02-14 12:00:00	TLT	ETF	92.99	93.03	92.93	93.03	26600.0

> showing 50 of 830 rows — these rows as CSV

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