PREVIEW / etf_1hour / 2006-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-20.parquet
  size:    53 KB
  rows:    1,704

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-20 06:00:00	SPY	ETF	136.98	136.98	136.98	136.98	2000.0
2006-10-20 07:00:00	SPY	ETF	136.99	137.02	136.62	136.69	250400.0
2006-10-20 08:00:00	SPY	ETF	136.7	136.96	136.61	136.64	685000.0
2006-10-20 09:00:00	SPY	ETF	136.64	136.89	136.33	136.49	8904400.0
2006-10-20 10:00:00	SPY	ETF	136.48	136.6	136.38	136.55	8683100.0
2006-10-20 11:00:00	SPY	ETF	136.55	136.7	136.52	136.58	5762100.0
2006-10-20 12:00:00	SPY	ETF	136.58	136.8	136.5	136.73	5624500.0
2006-10-20 13:00:00	SPY	ETF	136.73	136.77	136.59	136.6	2260800.0
2006-10-20 14:00:00	SPY	ETF	136.6	136.73	136.58	136.68	2294400.0
2006-10-20 15:00:00	SPY	ETF	136.6889	136.95	136.66	136.85	7995000.0
2006-10-20 16:00:00	SPY	ETF	136.87	136.88	136.77	136.77	714000.0
2006-10-20 17:00:00	SPY	ETF	136.77	136.87	136.77	136.83	1515900.0
2006-10-20 19:00:00	SPY	ETF	136.83	136.83	136.83	136.83	200.0
2006-10-20 09:00:00	QQQ	ETF	42.06	42.06	41.64	41.76	28610000.0
2006-10-20 10:00:00	QQQ	ETF	41.76	41.9	41.68	41.84	15899400.0
2006-10-20 11:00:00	QQQ	ETF	41.84	41.89	41.78	41.86	4169200.0
2006-10-20 12:00:00	QQQ	ETF	41.86	41.99	41.8	41.93	10749500.0
2006-10-20 13:00:00	QQQ	ETF	41.93	41.98	41.85	41.86	6480400.0
2006-10-20 14:00:00	QQQ	ETF	41.86	41.92	41.83	41.9	7766700.0
2006-10-20 15:00:00	QQQ	ETF	41.9	42.01	41.87	41.99	20369700.0
2006-10-20 07:00:00	IWM	ETF	76.15	76.3	76.15	76.3	1300.0
2006-10-20 08:00:00	IWM	ETF	76.22	76.31	76.21	76.21	12800.0
2006-10-20 09:00:00	IWM	ETF	76.23	76.41	75.57	75.69	6929200.0
2006-10-20 10:00:00	IWM	ETF	75.69	75.85	75.48	75.76	5416100.0
2006-10-20 11:00:00	IWM	ETF	75.76	75.91	75.64	75.85	2546900.0
2006-10-20 12:00:00	IWM	ETF	75.84	75.98	75.76	75.92	3606800.0
2006-10-20 13:00:00	IWM	ETF	75.93	75.95	75.76	75.77	5583400.0
2006-10-20 14:00:00	IWM	ETF	75.77	75.9	75.63	75.71	5004400.0
2006-10-20 15:00:00	IWM	ETF	75.71	75.93	75.66	75.67	5794800.0
2006-10-20 16:00:00	IWM	ETF	75.65	75.82	75.57	75.68	379400.0
2006-10-20 17:00:00	IWM	ETF	75.62	75.62	75.62	75.62	2500000.0
2006-10-20 07:00:00	DIA	ETF	120.12	120.12	119.49	119.57	134200.0
2006-10-20 08:00:00	DIA	ETF	119.62	120.04	119.49	119.54	289300.0
2006-10-20 09:00:00	DIA	ETF	119.59	119.8	119.38	119.52	1605600.0
2006-10-20 10:00:00	DIA	ETF	119.52	119.7	119.44	119.6601	1328700.0
2006-10-20 11:00:00	DIA	ETF	119.67	119.8	119.64	119.66	732300.0
2006-10-20 12:00:00	DIA	ETF	119.67	119.87	119.63	119.8	465900.0
2006-10-20 13:00:00	DIA	ETF	119.8	119.88	119.71	119.74	636800.0
2006-10-20 14:00:00	DIA	ETF	119.73	119.89	119.7	119.88	570900.0
2006-10-20 15:00:00	DIA	ETF	119.88	120.01	119.86	119.89	1759200.0
2006-10-20 16:00:00	DIA	ETF	119.9	119.96	119.88	119.96	284200.0
2006-10-20 17:00:00	DIA	ETF	119.94	119.94	119.94	119.94	500.0
2006-10-20 18:00:00	DIA	ETF	119.95	119.95	119.9	119.9	1100.0
2006-10-20 08:00:00	GLD	ETF	59.42	59.46	59.19	59.19	17000.0
2006-10-20 09:00:00	GLD	ETF	59.33	59.48	59.29	59.32	285000.0
2006-10-20 10:00:00	GLD	ETF	59.32	59.34	58.83	59.01	1038300.0
2006-10-20 11:00:00	GLD	ETF	59.0	59.12	58.78	58.93	623000.0
2006-10-20 12:00:00	GLD	ETF	58.94	59.01	58.72	58.86	232900.0
2006-10-20 13:00:00	GLD	ETF	58.87	58.97	58.83	58.86	220800.0
2006-10-20 14:00:00	GLD	ETF	58.83	58.86	58.72	58.76	191400.0

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

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