PREVIEW / etf_1hour / 2006-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-27.parquet
  size:    50 KB
  rows:    1,582

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
2006-07-27 05:00:00	SPY	ETF	127.25	127.3	127.25	127.3	1100.0
2006-07-27 06:00:00	SPY	ETF	127.25	127.25	127.25	127.25	2500.0
2006-07-27 07:00:00	SPY	ETF	127.21	127.26	127.19	127.22	91300.0
2006-07-27 08:00:00	SPY	ETF	127.21	127.42	127.19	127.25	1993100.0
2006-07-27 09:00:00	SPY	ETF	127.24	127.69	126.95	127.29	10906900.0
2006-07-27 10:00:00	SPY	ETF	127.3	127.47	126.94	127.24	20075600.0
2006-07-27 11:00:00	SPY	ETF	127.23	127.51	127.1	127.23	9942000.0
2006-07-27 12:00:00	SPY	ETF	127.22	127.43	127.12	127.28	3765500.0
2006-07-27 13:00:00	SPY	ETF	127.28	127.31	126.55	126.57	13694000.0
2006-07-27 14:00:00	SPY	ETF	126.56	126.73	126.38	126.64	10440300.0
2006-07-27 15:00:00	SPY	ETF	126.64	126.73	126.2	126.37	12602300.0
2006-07-27 16:00:00	SPY	ETF	126.37	127.23	126.36	126.64	1202300.0
2006-07-27 17:00:00	SPY	ETF	126.66	126.68	126.64	126.65	7600.0
2006-07-27 18:00:00	SPY	ETF	126.65	126.65	126.61	126.64	1100.0
2006-07-27 19:00:00	SPY	ETF	126.64	126.64	126.64	126.64	3700.0
2006-07-27 09:00:00	QQQ	ETF	36.74	37.04	36.73	36.87	18423200.0
2006-07-27 10:00:00	QQQ	ETF	36.87	37.0	36.66	36.76	17745100.0
2006-07-27 11:00:00	QQQ	ETF	36.76	36.89	36.71	36.78	8608400.0
2006-07-27 12:00:00	QQQ	ETF	36.78	36.88	36.75	36.76	4261600.0
2006-07-27 13:00:00	QQQ	ETF	36.76	36.77	36.33	36.33	17082800.0
2006-07-27 14:00:00	QQQ	ETF	36.34	36.43	36.25	36.41	13178900.0
2006-07-27 15:00:00	QQQ	ETF	36.41	36.45	36.28	36.35	15633100.0
2006-07-27 08:00:00	IWM	ETF	69.25	69.45	69.2	69.34	237500.0
2006-07-27 09:00:00	IWM	ETF	69.34	69.89	67.58	69.34	7133200.0
2006-07-27 10:00:00	IWM	ETF	69.33	69.41	68.85	69.11	10117000.0
2006-07-27 11:00:00	IWM	ETF	69.11	69.43	68.93	69.2	7522200.0
2006-07-27 12:00:00	IWM	ETF	69.2	69.44	69.12	69.17	3904100.0
2006-07-27 13:00:00	IWM	ETF	69.18	69.19	68.24	68.27	10381700.0
2006-07-27 14:00:00	IWM	ETF	68.27	68.44	68.04	68.42	6853600.0
2006-07-27 15:00:00	IWM	ETF	68.42	68.48	67.97	68.07	11661200.0
2006-07-27 16:00:00	IWM	ETF	68.1	68.26	68.07	68.25	397500.0
2006-07-27 17:00:00	IWM	ETF	68.25	68.25	68.16	68.16	8000.0
2006-07-27 18:00:00	IWM	ETF	68.19	68.19	68.19	68.19	1000.0
2006-07-27 07:00:00	DIA	ETF	111.17	111.22	111.17	111.22	200.0
2006-07-27 08:00:00	DIA	ETF	111.27	111.37	111.23	111.25	16800.0
2006-07-27 09:00:00	DIA	ETF	111.28	111.7	111.27	111.49	710300.0
2006-07-27 10:00:00	DIA	ETF	111.48	111.69	111.3	111.5	2955000.0
2006-07-27 11:00:00	DIA	ETF	111.52	111.78	111.4	111.56	1135200.0
2006-07-27 12:00:00	DIA	ETF	111.55	111.68	111.48	111.56	290200.0
2006-07-27 13:00:00	DIA	ETF	111.56	111.58	111.0	111.0	994100.0
2006-07-27 14:00:00	DIA	ETF	111.0	111.1	110.82	111.07	674900.0
2006-07-27 15:00:00	DIA	ETF	110.99	111.15	110.78	110.88	2085200.0
2006-07-27 16:00:00	DIA	ETF	110.89	111.27	110.89	111.23	215100.0
2006-07-27 17:00:00	DIA	ETF	111.28	111.3	111.28	111.28	1600.0
2006-07-27 18:00:00	DIA	ETF	111.28	111.33	111.28	111.33	600.0
2006-07-27 04:00:00	GLD	ETF	62.43	62.43	62.43	62.43	100.0
2006-07-27 08:00:00	GLD	ETF	62.88	63.3	62.72	63.3	335500.0
2006-07-27 09:00:00	GLD	ETF	63.3	63.74	63.3	63.55	963200.0
2006-07-27 10:00:00	GLD	ETF	63.5408	63.61	62.71	63.25	899600.0
2006-07-27 11:00:00	GLD	ETF	63.25	63.32	62.83	63.16	730700.0

> showing 50 of 1,582 rows — these rows as CSV

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