PREVIEW / etf_1hour / 2006-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-30.parquet
  size:    41 KB
  rows:    1,256

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-03-30 06:00:00	SPY	ETF	130.05	130.05	130.05	130.05	4000.0
2006-03-30 07:00:00	SPY	ETF	130.13	130.17	130.1	130.14	33300.0
2006-03-30 08:00:00	SPY	ETF	130.14	130.29	129.97	130.05	381300.0
2006-03-30 09:00:00	SPY	ETF	130.05	130.74	130.04	130.66	9713500.0
2006-03-30 10:00:00	SPY	ETF	130.66	130.98	130.17	130.25	14132000.0
2006-03-30 11:00:00	SPY	ETF	130.27	130.34	129.81	130.18	13185300.0
2006-03-30 12:00:00	SPY	ETF	130.17	130.33	129.87	130.08	4744900.0
2006-03-30 13:00:00	SPY	ETF	130.09	130.1	129.55	129.8	7599400.0
2006-03-30 14:00:00	SPY	ETF	129.8	130.15	129.79	129.84	5491400.0
2006-03-30 15:00:00	SPY	ETF	129.84	130.17	129.82	129.95	8908100.0
2006-03-30 16:00:00	SPY	ETF	129.96	130.0	129.7	129.8	1337800.0
2006-03-30 17:00:00	SPY	ETF	129.94	129.94	129.79	129.88	277300.0
2006-03-30 18:00:00	SPY	ETF	129.87	129.87	129.87	129.87	1000.0
2006-03-30 19:00:00	SPY	ETF	129.86	129.86	129.86	129.86	1000.0
2006-03-30 09:00:00	QQQ	ETF	41.99	42.2	41.98	42.09	18531500.0
2006-03-30 10:00:00	QQQ	ETF	42.09	42.3	41.9	41.94	29905900.0
2006-03-30 11:00:00	QQQ	ETF	41.94	42.08	41.81	41.99	17381700.0
2006-03-30 12:00:00	QQQ	ETF	41.98	42.08	41.89	41.98	8350800.0
2006-03-30 13:00:00	QQQ	ETF	41.97	41.98	41.79	41.94	12211900.0
2006-03-30 14:00:00	QQQ	ETF	41.94	42.05	41.9	41.98	8964200.0
2006-03-30 15:00:00	QQQ	ETF	41.98	42.08	41.96	42.04	10476700.0
2006-03-30 07:00:00	IWM	ETF	76.01	76.03	76.01	76.03	200.0
2006-03-30 08:00:00	IWM	ETF	76.03	76.04	75.94	75.94	4300.0
2006-03-30 09:00:00	IWM	ETF	75.97	76.2	75.94	76.09	3208900.0
2006-03-30 10:00:00	IWM	ETF	76.1	76.24	75.63	75.69	6317700.0
2006-03-30 11:00:00	IWM	ETF	75.68	75.89	75.33	75.78	3942400.0
2006-03-30 12:00:00	IWM	ETF	75.79	75.9	75.62	75.75	2831100.0
2006-03-30 13:00:00	IWM	ETF	75.75	75.8826	75.27	75.51	4429500.0
2006-03-30 14:00:00	IWM	ETF	75.51	75.8826	75.38	75.52	3758700.0
2006-03-30 15:00:00	IWM	ETF	75.53	75.79	75.45	75.65	3981500.0
2006-03-30 16:00:00	IWM	ETF	75.65	75.81	75.65	75.75	357600.0
2006-03-30 17:00:00	IWM	ETF	75.75	75.76	75.75	75.76	1600.0
2006-03-30 18:00:00	IWM	ETF	75.76	75.77	75.76	75.77	1900.0
2006-03-30 19:00:00	IWM	ETF	75.77	75.77	75.77	75.77	500.0
2006-03-30 07:00:00	DIA	ETF	112.0	112.05	112.0	112.05	5100.0
2006-03-30 08:00:00	DIA	ETF	112.0	112.12	111.95	111.95	7800.0
2006-03-30 09:00:00	DIA	ETF	111.94	112.35	111.86	112.24	1078900.0
2006-03-30 10:00:00	DIA	ETF	112.23	112.5	111.78	111.8	1469800.0
2006-03-30 11:00:00	DIA	ETF	111.82	111.84	111.37	111.585	2218700.0
2006-03-30 12:00:00	DIA	ETF	111.62	111.7	111.35	111.51	591300.0
2006-03-30 13:00:00	DIA	ETF	111.51	111.51	111.06	111.31	1215300.0
2006-03-30 14:00:00	DIA	ETF	111.31	111.54	111.27	111.32	769700.0
2006-03-30 15:00:00	DIA	ETF	111.33	111.65	111.29	111.46	1446500.0
2006-03-30 16:00:00	DIA	ETF	111.47	111.49	111.37	111.39	22900.0
2006-03-30 17:00:00	DIA	ETF	111.4	111.4	111.4	111.4	900.0
2006-03-30 19:00:00	DIA	ETF	111.33	111.33	111.33	111.33	100.0
2006-03-30 07:00:00	GLD	ETF	57.62	57.62	57.59	57.59	7400.0
2006-03-30 08:00:00	GLD	ETF	57.64	57.75	57.48	57.65	132400.0
2006-03-30 09:00:00	GLD	ETF	57.72	58.35	57.7	58.15	1715900.0
2006-03-30 10:00:00	GLD	ETF	58.17	58.39	57.93	58.0	1208000.0

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

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