PREVIEW / etf_1hour / 2005-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-29.parquet
  size:    30 KB
  rows:    918

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-29 07:00:00	SPY	ETF	120.12	120.27	120.11	120.18	165400.0
2005-06-29 08:00:00	SPY	ETF	120.17	120.36	120.15	120.34	234700.0
2005-06-29 09:00:00	SPY	ETF	120.35	120.41	120.08	120.11	4885900.0
2005-06-29 10:00:00	SPY	ETF	120.11	120.36	120.02	120.25	9727600.0
2005-06-29 11:00:00	SPY	ETF	120.22	120.29	120.11	120.21	2349600.0
2005-06-29 12:00:00	SPY	ETF	120.21	120.29	120.14	120.24	1631400.0
2005-06-29 13:00:00	SPY	ETF	120.24	120.27	119.86	119.91	6797000.0
2005-06-29 14:00:00	SPY	ETF	119.91	120.18	119.81	119.86	5732100.0
2005-06-29 15:00:00	SPY	ETF	119.85	120.13	119.81	119.94	8129800.0
2005-06-29 16:00:00	SPY	ETF	119.95	119.96	119.77	119.87	1409000.0
2005-06-29 17:00:00	SPY	ETF	119.85	119.95	119.85	119.85	667200.0
2005-06-29 18:00:00	SPY	ETF	119.84	119.84	119.8	119.82	49800.0
2005-06-29 19:00:00	SPY	ETF	119.87	119.87	119.86	119.86	500.0
2005-06-29 09:00:00	QQQ	ETF	37.25	37.26	37.07	37.09	10625000.0
2005-06-29 10:00:00	QQQ	ETF	37.1	37.21	37.01	37.16	18700700.0
2005-06-29 11:00:00	QQQ	ETF	37.15	37.17	37.08	37.14	5225800.0
2005-06-29 12:00:00	QQQ	ETF	37.14	37.19	37.12	37.15	2301100.0
2005-06-29 13:00:00	QQQ	ETF	37.16	37.16	36.99	37.01	7049900.0
2005-06-29 14:00:00	QQQ	ETF	37.01	37.16	36.97	37.04	10576300.0
2005-06-29 15:00:00	QQQ	ETF	37.04	37.09	36.98	37.06	9155700.0
2005-06-29 08:00:00	IWM	ETF	63.74	63.83	63.74	63.83	2200.0
2005-06-29 09:00:00	IWM	ETF	63.91	63.95	63.71	63.74	2463200.0
2005-06-29 10:00:00	IWM	ETF	63.76	64.06	63.69	63.91	4386100.0
2005-06-29 11:00:00	IWM	ETF	63.9	64.04	63.88	63.94	805300.0
2005-06-29 12:00:00	IWM	ETF	63.922	63.99	63.82	63.89	1546900.0
2005-06-29 13:00:00	IWM	ETF	63.89	63.94	63.63	63.69	2021500.0
2005-06-29 14:00:00	IWM	ETF	63.68	63.96	63.63	63.7	2325600.0
2005-06-29 15:00:00	IWM	ETF	63.71	63.91	63.7	63.84	2895200.0
2005-06-29 16:00:00	IWM	ETF	63.81	63.93	63.81	63.86	346400.0
2005-06-29 17:00:00	IWM	ETF	63.825	63.825	63.825	63.825	65600.0
2005-06-29 08:00:00	DIA	ETF	104.16	104.21	104.15	104.19	44800.0
2005-06-29 09:00:00	DIA	ETF	104.19	104.25	103.86	103.89	811800.0
2005-06-29 10:00:00	DIA	ETF	103.9	104.18	103.8	104.06	1039700.0
2005-06-29 11:00:00	DIA	ETF	104.07	104.16	103.92	104.13	716600.0
2005-06-29 12:00:00	DIA	ETF	104.12	104.14	103.9	103.93	349400.0
2005-06-29 13:00:00	DIA	ETF	103.93	103.95	103.57	103.62	792300.0
2005-06-29 14:00:00	DIA	ETF	103.6	103.9	103.56	103.59	611000.0
2005-06-29 15:00:00	DIA	ETF	103.59	103.84	103.57	103.67	669300.0
2005-06-29 16:00:00	DIA	ETF	103.65	103.66	103.55	103.62	30200.0
2005-06-29 17:00:00	DIA	ETF	103.66	103.66	103.66	103.66	100.0
2005-06-29 19:00:00	DIA	ETF	103.66	103.66	103.66	103.66	300.0
2005-06-29 07:00:00	GLD	ETF	43.35	43.35	43.35	43.35	1000.0
2005-06-29 09:00:00	GLD	ETF	43.49	43.49	43.46	43.49	164100.0
2005-06-29 10:00:00	GLD	ETF	43.48	43.63	43.47	43.58	260100.0
2005-06-29 11:00:00	GLD	ETF	43.58	43.7	43.58	43.66	231400.0
2005-06-29 12:00:00	GLD	ETF	43.68	43.68	43.6	43.65	242600.0
2005-06-29 13:00:00	GLD	ETF	43.64	43.69	43.59	43.6	116800.0
2005-06-29 14:00:00	GLD	ETF	43.6	43.65	43.53	43.61	90200.0
2005-06-29 15:00:00	GLD	ETF	43.61	43.63	43.59	43.62	87200.0
2005-06-29 16:00:00	GLD	ETF	43.64	43.64	43.64	43.64	100.0

> showing 50 of 918 rows — these rows as CSV

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