PREVIEW / etf_1hour / 2006-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-07.parquet
  size:    41 KB
  rows:    1,249

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-04-07 07:00:00	SPY	ETF	130.87	130.89	130.85	130.87	15500.0
2006-04-07 08:00:00	SPY	ETF	130.91	131.56	130.8	131.39	4153400.0
2006-04-07 09:00:00	SPY	ETF	131.4	131.46	130.85	130.85	13292300.0
2006-04-07 10:00:00	SPY	ETF	130.85	130.95	130.02	130.19	18642600.0
2006-04-07 11:00:00	SPY	ETF	130.19	130.41	129.61	129.74	9705300.0
2006-04-07 12:00:00	SPY	ETF	129.73	129.94	129.57	129.69	6430600.0
2006-04-07 13:00:00	SPY	ETF	129.69	129.92	129.48	129.62	7666900.0
2006-04-07 14:00:00	SPY	ETF	129.62	130.4	129.58	129.9	7024000.0
2006-04-07 15:00:00	SPY	ETF	129.91	129.982	129.35	129.49	10806600.0
2006-04-07 16:00:00	SPY	ETF	129.47	129.59	129.47	129.54	837100.0
2006-04-07 17:00:00	SPY	ETF	129.57	129.665	129.49	129.49	17400.0
2006-04-07 18:00:00	SPY	ETF	129.5	129.5	129.49	129.49	2700.0
2006-04-07 19:00:00	SPY	ETF	129.49	129.54	129.47	129.54	5400.0
2006-04-07 09:00:00	QQQ	ETF	42.89	43.05	42.83	42.83	22395600.0
2006-04-07 10:00:00	QQQ	ETF	42.83	42.85	42.48	42.55	31106300.0
2006-04-07 11:00:00	QQQ	ETF	42.54	42.66	42.3	42.38	16064500.0
2006-04-07 12:00:00	QQQ	ETF	42.38	42.53	42.36	42.44	8930200.0
2006-04-07 13:00:00	QQQ	ETF	42.44	42.56	42.37	42.4	9669900.0
2006-04-07 14:00:00	QQQ	ETF	42.4	42.53	42.21	42.48	7408600.0
2006-04-07 15:00:00	QQQ	ETF	42.48	42.49	42.3	42.33	11838200.0
2006-04-07 08:00:00	IWM	ETF	76.28	76.98	76.21	76.63	485100.0
2006-04-07 09:00:00	IWM	ETF	76.63	76.69	76.24	76.24	5193900.0
2006-04-07 10:00:00	IWM	ETF	76.23	76.32	75.41	75.5	8047900.0
2006-04-07 11:00:00	IWM	ETF	75.51	76.1017	75.09	75.211	7177000.0
2006-04-07 12:00:00	IWM	ETF	75.21	75.26	74.95	74.96	7278500.0
2006-04-07 13:00:00	IWM	ETF	74.95	76.1016	74.86	74.95	7931500.0
2006-04-07 14:00:00	IWM	ETF	74.95	75.23	74.94	75.1	4002800.0
2006-04-07 15:00:00	IWM	ETF	75.09	76.1016	74.98	75.04	9667300.0
2006-04-07 16:00:00	IWM	ETF	75.03	75.06	74.95	75.01	221500.0
2006-04-07 17:00:00	IWM	ETF	75.04	75.04	75.04	75.04	1300.0
2006-04-07 18:00:00	IWM	ETF	75.04	75.05	75.0	75.0	2000.0
2006-04-07 08:00:00	DIA	ETF	112.26	112.7	112.23	112.56	42500.0
2006-04-07 09:00:00	DIA	ETF	112.6	112.7	112.26	112.26	877300.0
2006-04-07 10:00:00	DIA	ETF	112.28	112.35	111.39	111.48	1941100.0
2006-04-07 11:00:00	DIA	ETF	111.49	111.69	111.15	111.29	1259300.0
2006-04-07 12:00:00	DIA	ETF	111.28	111.51	111.2	111.32	551200.0
2006-04-07 13:00:00	DIA	ETF	111.31	111.54	111.21	111.33	742900.0
2006-04-07 14:00:00	DIA	ETF	111.34	111.67	111.3	111.51	648700.0
2006-04-07 15:00:00	DIA	ETF	111.54	111.564	111.09	111.23	938600.0
2006-04-07 16:00:00	DIA	ETF	111.23	111.3	111.23	111.26	21000.0
2006-04-07 17:00:00	DIA	ETF	111.25	111.25	111.24	111.24	400.0
2006-04-07 18:00:00	DIA	ETF	111.24	111.24	111.24	111.24	1000.0
2006-04-07 19:00:00	DIA	ETF	111.25	111.28	111.25	111.28	800.0
2006-04-07 08:00:00	GLD	ETF	59.1	59.28	58.79	58.8	99100.0
2006-04-07 09:00:00	GLD	ETF	58.8	58.86	58.42	58.75	988900.0
2006-04-07 10:00:00	GLD	ETF	58.75	58.76	58.22	58.43	1243200.0
2006-04-07 11:00:00	GLD	ETF	58.43	58.72	58.41	58.59	323700.0
2006-04-07 12:00:00	GLD	ETF	58.5999	58.61	58.4	58.46	162800.0
2006-04-07 13:00:00	GLD	ETF	58.45	58.67	58.45	58.53	133200.0
2006-04-07 14:00:00	GLD	ETF	58.549	58.63	58.5224	58.63	200600.0

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

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