PREVIEW / etf_1hour / 2005-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-22.parquet
  size:    29 KB
  rows:    870

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-06-22 07:00:00	SPY	ETF	121.76	121.83	121.76	121.79	31100.0
2005-06-22 08:00:00	SPY	ETF	121.79	121.8	121.74	121.8	54900.0
2005-06-22 09:00:00	SPY	ETF	121.79	121.94	121.59	121.62	5872900.0
2005-06-22 10:00:00	SPY	ETF	121.63	121.85	121.16	121.23	7478400.0
2005-06-22 11:00:00	SPY	ETF	121.25	121.36	121.1	121.19	4790900.0
2005-06-22 12:00:00	SPY	ETF	121.19	121.47	121.16	121.44	3694000.0
2005-06-22 13:00:00	SPY	ETF	121.44	121.54	121.27	121.3	3015400.0
2005-06-22 14:00:00	SPY	ETF	121.28	121.41	121.07	121.4	5744100.0
2005-06-22 15:00:00	SPY	ETF	121.4	121.51	121.24	121.38	6141400.0
2005-06-22 16:00:00	SPY	ETF	121.39	121.7	121.27	121.52	2578400.0
2005-06-22 17:00:00	SPY	ETF	121.52	121.57	121.51	121.57	307600.0
2005-06-22 18:00:00	SPY	ETF	121.53	121.57	121.53	121.57	8700.0
2005-06-22 19:00:00	SPY	ETF	121.53	121.54	121.53	121.54	3700.0
2005-06-22 09:00:00	QQQ	ETF	38.0	38.1	37.94	37.94	10661700.0
2005-06-22 10:00:00	QQQ	ETF	37.94	38.02	37.71	37.74	16526200.0
2005-06-22 11:00:00	QQQ	ETF	37.75	37.76	37.63	37.69	17345800.0
2005-06-22 12:00:00	QQQ	ETF	37.69	37.87	37.69	37.86	4735800.0
2005-06-22 13:00:00	QQQ	ETF	37.86	37.91	37.8	37.82	6460000.0
2005-06-22 14:00:00	QQQ	ETF	37.81	37.84	37.74	37.81	8884000.0
2005-06-22 15:00:00	QQQ	ETF	37.81	37.87	37.76	37.83	7924700.0
2005-06-22 08:00:00	IWM	ETF	64.02	64.11	64.02	64.11	14000.0
2005-06-22 09:00:00	IWM	ETF	64.07	64.22	63.93	63.93	2542800.0
2005-06-22 10:00:00	IWM	ETF	63.93	64.0	63.65	63.69	3442400.0
2005-06-22 11:00:00	IWM	ETF	63.68	63.76	63.49	63.55	1826100.0
2005-06-22 12:00:00	IWM	ETF	63.56	63.81	63.55	63.78	480000.0
2005-06-22 13:00:00	IWM	ETF	63.79	63.96	63.71	63.72	2254200.0
2005-06-22 14:00:00	IWM	ETF	63.71	63.83	63.63	63.77	1263400.0
2005-06-22 15:00:00	IWM	ETF	63.77	64.05	63.75	64.04	3157000.0
2005-06-22 16:00:00	IWM	ETF	64.06	64.08	64.01	64.02	515200.0
2005-06-22 17:00:00	IWM	ETF	63.82	63.82	63.82	63.82	50000.0
2005-06-22 08:00:00	DIA	ETF	106.28	106.3	106.28	106.3	700.0
2005-06-22 09:00:00	DIA	ETF	106.25	106.33	106.09	106.12	405700.0
2005-06-22 10:00:00	DIA	ETF	106.1	106.33	105.84	105.89	1183300.0
2005-06-22 11:00:00	DIA	ETF	105.87	105.97	105.75	105.87	602500.0
2005-06-22 12:00:00	DIA	ETF	105.88	106.07	105.86	106.06	230700.0
2005-06-22 13:00:00	DIA	ETF	106.05	106.11	105.9	105.91	192000.0
2005-06-22 14:00:00	DIA	ETF	105.9	105.9	105.67	105.85	378800.0
2005-06-22 15:00:00	DIA	ETF	105.85	106.0	105.75	105.86	404400.0
2005-06-22 16:00:00	DIA	ETF	105.9	106.03	105.9	106.02	12700.0
2005-06-22 08:00:00	GLD	ETF	43.57	43.57	43.54	43.54	5100.0
2005-06-22 09:00:00	GLD	ETF	43.66	43.68	43.59	43.6	135000.0
2005-06-22 10:00:00	GLD	ETF	43.6	43.65	43.53	43.63	581200.0
2005-06-22 11:00:00	GLD	ETF	43.62	43.68	43.6	43.65	259500.0
2005-06-22 12:00:00	GLD	ETF	43.66	43.66	43.59	43.61	26500.0
2005-06-22 13:00:00	GLD	ETF	43.6	43.69	43.6	43.68	122200.0
2005-06-22 14:00:00	GLD	ETF	43.67	43.71	43.66	43.7	38700.0
2005-06-22 15:00:00	GLD	ETF	43.71	43.76	43.7	43.74	57700.0
2005-06-22 16:00:00	GLD	ETF	43.74	43.74	43.74	43.74	400.0
2005-06-22 08:00:00	TLT	ETF	95.45	95.45	95.4	95.43	21000.0
2005-06-22 09:00:00	TLT	ETF	95.48	95.59	95.3	95.34	99000.0

> showing 50 of 870 rows — these rows as CSV

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