PREVIEW / etf_1hour / 2006-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-12.parquet
  size:    49 KB
  rows:    1,528

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-12 07:00:00	SPY	ETF	127.36	127.36	127.35	127.36	59000.0
2006-07-12 08:00:00	SPY	ETF	127.32	127.37	127.22	127.22	719900.0
2006-07-12 09:00:00	SPY	ETF	127.21	127.4	127.11	127.21	5494100.0
2006-07-12 10:00:00	SPY	ETF	127.19	127.2	126.56	126.66	14766300.0
2006-07-12 11:00:00	SPY	ETF	126.66	126.95	126.56	126.89	8557000.0
2006-07-12 12:00:00	SPY	ETF	126.9	126.93	126.34	126.5	9623800.0
2006-07-12 13:00:00	SPY	ETF	126.5	126.51	125.91	126.1	12835000.0
2006-07-12 14:00:00	SPY	ETF	126.08	126.25	125.72	125.82	14138600.0
2006-07-12 15:00:00	SPY	ETF	125.83	126.22	125.73	125.96	13819800.0
2006-07-12 16:00:00	SPY	ETF	125.95	126.14	125.95	126.05	917900.0
2006-07-12 17:00:00	SPY	ETF	126.08	126.1	126.05	126.05	188900.0
2006-07-12 18:00:00	SPY	ETF	126.05	126.1	126.03	126.03	70200.0
2006-07-12 19:00:00	SPY	ETF	126.04	126.06	126.04	126.06	700.0
2006-07-12 09:00:00	QQQ	ETF	37.56	37.64	37.44	37.46	14273000.0
2006-07-12 10:00:00	QQQ	ETF	37.44	37.49	37.22	37.27	30148700.0
2006-07-12 11:00:00	QQQ	ETF	37.26	37.38	37.21	37.35	12335800.0
2006-07-12 12:00:00	QQQ	ETF	37.35	37.36	37.1	37.16	11460800.0
2006-07-12 13:00:00	QQQ	ETF	37.17	37.17	36.86	36.97	27316400.0
2006-07-12 14:00:00	QQQ	ETF	36.96	37.06	36.84	36.89	21808200.0
2006-07-12 15:00:00	QQQ	ETF	36.88	37.05	36.84	36.92	22557000.0
2006-07-12 08:00:00	IWM	ETF	70.95	71.03	70.68	70.7	898400.0
2006-07-12 09:00:00	IWM	ETF	70.7	71.08	70.65	70.91	4156200.0
2006-07-12 10:00:00	IWM	ETF	70.89	70.93	70.24	70.28	10704700.0
2006-07-12 11:00:00	IWM	ETF	70.28	70.57	70.22	70.52	4066800.0
2006-07-12 12:00:00	IWM	ETF	70.52	70.56	70.14	70.28	3678300.0
2006-07-12 13:00:00	IWM	ETF	70.29	70.29	69.88	69.98	6633100.0
2006-07-12 14:00:00	IWM	ETF	69.97	70.08	69.65	69.75	6409900.0
2006-07-12 15:00:00	IWM	ETF	69.75	70.0	69.59	69.63	12946700.0
2006-07-12 16:00:00	IWM	ETF	69.63	69.75	69.62	69.68	430700.0
2006-07-12 08:00:00	DIA	ETF	111.45	111.47	111.37	111.37	4100.0
2006-07-12 09:00:00	DIA	ETF	111.33	111.52	111.2	111.27	352500.0
2006-07-12 10:00:00	DIA	ETF	111.26	111.33	110.8	110.89	807900.0
2006-07-12 11:00:00	DIA	ETF	110.88	111.06	110.83	111.04	337600.0
2006-07-12 12:00:00	DIA	ETF	111.05	111.066	110.56	110.7	488800.0
2006-07-12 13:00:00	DIA	ETF	110.7	110.71	110.1	110.24	1039300.0
2006-07-12 14:00:00	DIA	ETF	110.24	110.37	109.98	110.05	708300.0
2006-07-12 15:00:00	DIA	ETF	110.04	110.38	109.98	110.19	630200.0
2006-07-12 16:00:00	DIA	ETF	110.21	110.34	110.21	110.27	11800.0
2006-07-12 17:00:00	DIA	ETF	110.3	110.35	110.14	110.35	200700.0
2006-07-12 18:00:00	DIA	ETF	110.35	110.35	110.35	110.35	100.0
2006-07-12 07:00:00	GLD	ETF	64.17	64.2	64.17	64.2	2500.0
2006-07-12 08:00:00	GLD	ETF	64.21	64.66	64.18	64.6	246500.0
2006-07-12 09:00:00	GLD	ETF	64.59	64.8	64.43	64.49	1069900.0
2006-07-12 10:00:00	GLD	ETF	64.49	65.12	64.45	64.96	1750800.0
2006-07-12 11:00:00	GLD	ETF	64.97	65.19	64.79	64.83	1646800.0
2006-07-12 12:00:00	GLD	ETF	64.83	64.83	63.01	64.29	2063900.0
2006-07-12 13:00:00	GLD	ETF	64.29	64.63	64.25	64.43	792000.0
2006-07-12 14:00:00	GLD	ETF	64.42	64.69	64.4	64.65	613400.0
2006-07-12 15:00:00	GLD	ETF	64.66	64.94	64.6	64.9	1147700.0
2006-07-12 16:00:00	GLD	ETF	64.9	64.94	64.8	64.81	52300.0

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

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