PREVIEW / etf_1hour / 2006-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-19.parquet
  size:    54 KB
  rows:    1,718

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-10-19 07:00:00	SPY	ETF	136.45	136.68	136.41	136.63	41800.0
2006-10-19 08:00:00	SPY	ETF	136.6	136.68	136.45	136.56	637100.0
2006-10-19 09:00:00	SPY	ETF	136.54	136.59	136.23	136.52	8601300.0
2006-10-19 10:00:00	SPY	ETF	136.53	136.88	136.42	136.63	11695400.0
2006-10-19 11:00:00	SPY	ETF	136.62	136.63	136.43	136.54	5093100.0
2006-10-19 12:00:00	SPY	ETF	136.55	136.67	136.29	136.36	6473300.0
2006-10-19 13:00:00	SPY	ETF	136.37	136.68	136.26	136.57	12663500.0
2006-10-19 14:00:00	SPY	ETF	136.58	136.72	136.45	136.67	3192300.0
2006-10-19 15:00:00	SPY	ETF	136.68	136.79	136.42	136.7	9333600.0
2006-10-19 16:00:00	SPY	ETF	136.75	136.84	136.67	136.81	1150500.0
2006-10-19 17:00:00	SPY	ETF	136.81	136.85	136.76	136.8	3211500.0
2006-10-19 18:00:00	SPY	ETF	136.8	136.81	136.58	136.79	19000.0
2006-10-19 19:00:00	SPY	ETF	136.8	136.84	136.8	136.84	2400.0
2006-10-19 09:00:00	QQQ	ETF	41.69	41.9	41.59	41.89	14649500.0
2006-10-19 10:00:00	QQQ	ETF	41.88	42.11	41.79	41.96	22309000.0
2006-10-19 11:00:00	QQQ	ETF	41.96	41.96	41.82	41.86	12842400.0
2006-10-19 12:00:00	QQQ	ETF	41.86	41.94	41.6	41.67	16372900.0
2006-10-19 13:00:00	QQQ	ETF	41.68	41.84	41.62	41.78	8633200.0
2006-10-19 14:00:00	QQQ	ETF	41.78	41.92	41.71	41.91	11913900.0
2006-10-19 15:00:00	QQQ	ETF	41.9	41.93	41.79	41.91	11166600.0
2006-10-19 07:00:00	IWM	ETF	75.64	75.64	75.64	75.64	1300.0
2006-10-19 08:00:00	IWM	ETF	75.95	75.98	75.84	75.86	443300.0
2006-10-19 09:00:00	IWM	ETF	75.87	76.23	75.58	76.19	5621300.0
2006-10-19 10:00:00	IWM	ETF	76.19	76.4	76.11	76.31	8282200.0
2006-10-19 11:00:00	IWM	ETF	76.31	76.32	76.11	76.22	4417300.0
2006-10-19 12:00:00	IWM	ETF	76.22	76.36	75.95	76.07	6661400.0
2006-10-19 13:00:00	IWM	ETF	76.05	76.22	75.97	76.1	2894500.0
2006-10-19 14:00:00	IWM	ETF	76.09	76.27	76.02	76.24	3857600.0
2006-10-19 15:00:00	IWM	ETF	76.24	76.29	76.1	76.29	7281200.0
2006-10-19 16:00:00	IWM	ETF	76.29	76.39	76.22	76.34	173300.0
2006-10-19 17:00:00	IWM	ETF	76.34	76.4	76.34	76.38	1700.0
2006-10-19 18:00:00	IWM	ETF	76.31	76.34	76.25	76.25	2503500.0
2006-10-19 07:00:00	DIA	ETF	119.92	119.92	119.92	119.92	500.0
2006-10-19 08:00:00	DIA	ETF	119.9	120.04	119.9	119.96	9100.0
2006-10-19 09:00:00	DIA	ETF	119.95	120.03	119.67	119.94	507800.0
2006-10-19 10:00:00	DIA	ETF	119.95	120.31	119.91	120.16	1728900.0
2006-10-19 11:00:00	DIA	ETF	120.16	120.16	119.98	120.12	569500.0
2006-10-19 12:00:00	DIA	ETF	120.11	120.22	119.81	119.88	1282500.0
2006-10-19 13:00:00	DIA	ETF	119.87	120.18	119.81	120.08	753200.0
2006-10-19 14:00:00	DIA	ETF	120.07	120.19	119.98	120.11	649300.0
2006-10-19 15:00:00	DIA	ETF	120.11	120.19	119.93	120.15	891300.0
2006-10-19 16:00:00	DIA	ETF	120.16	120.16	120.07	120.15	109800.0
2006-10-19 17:00:00	DIA	ETF	120.25	120.3	120.25	120.3	300.0
2006-10-19 07:00:00	GLD	ETF	58.56	58.56	58.45	58.45	4000.0
2006-10-19 08:00:00	GLD	ETF	58.38	58.8	58.18	58.71	88600.0
2006-10-19 09:00:00	GLD	ETF	58.73	59.65	58.67	59.44	819300.0
2006-10-19 10:00:00	GLD	ETF	59.4	59.48	59.16	59.18	355600.0
2006-10-19 11:00:00	GLD	ETF	59.17	59.39	59.0546	59.2922	239800.0
2006-10-19 12:00:00	GLD	ETF	59.31	59.6	59.27	59.5	575400.0
2006-10-19 13:00:00	GLD	ETF	59.52	59.62	59.35	59.45	220000.0

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

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