PREVIEW / etf_1hour / 2006-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-27.parquet
  size:    38 KB
  rows:    1,219

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-27 06:00:00	SPY	ETF	130.29	130.29	130.29	130.29	2000.0
2006-03-27 07:00:00	SPY	ETF	130.32	130.39	130.31	130.36	8500.0
2006-03-27 08:00:00	SPY	ETF	130.37	130.41	130.22	130.23	233400.0
2006-03-27 09:00:00	SPY	ETF	130.21	130.21	129.91	130.14	4942800.0
2006-03-27 10:00:00	SPY	ETF	130.14	130.18	129.86	129.93	5323800.0
2006-03-27 11:00:00	SPY	ETF	129.92	130.0	129.78	129.88	4029500.0
2006-03-27 12:00:00	SPY	ETF	129.88	130.06	129.74	129.98	2533100.0
2006-03-27 13:00:00	SPY	ETF	129.98	130.2	129.96	130.09	4444200.0
2006-03-27 14:00:00	SPY	ETF	130.09	130.28	129.99	130.22	3395100.0
2006-03-27 15:00:00	SPY	ETF	130.23	130.26	130.04	130.08	5123300.0
2006-03-27 16:00:00	SPY	ETF	130.11	130.11	130.0054	130.03	1238200.0
2006-03-27 17:00:00	SPY	ETF	130.04	130.08	130.03	130.08	53000.0
2006-03-27 18:00:00	SPY	ETF	130.05	130.05	130.05	130.05	100.0
2006-03-27 19:00:00	SPY	ETF	130.01	130.01	129.97	129.97	6200.0
2006-03-27 09:00:00	QQQ	ETF	41.28	41.51	41.25	41.44	7404700.0
2006-03-27 10:00:00	QQQ	ETF	41.44	41.47	41.32	41.33	10874200.0
2006-03-27 11:00:00	QQQ	ETF	41.34	41.38	41.24	41.33	10322800.0
2006-03-27 12:00:00	QQQ	ETF	41.33	41.45	41.27	41.37	5513200.0
2006-03-27 13:00:00	QQQ	ETF	41.36	41.44	41.32	41.4	5196000.0
2006-03-27 14:00:00	QQQ	ETF	41.4	41.43	41.34	41.41	3521800.0
2006-03-27 15:00:00	QQQ	ETF	41.4	41.42	41.29	41.33	7606500.0
2006-03-27 08:00:00	IWM	ETF	75.01	75.01	74.88	74.88	19500.0
2006-03-27 09:00:00	IWM	ETF	74.86	74.88	74.66	74.74	3495000.0
2006-03-27 10:00:00	IWM	ETF	74.75	74.81	74.51	74.6	4662500.0
2006-03-27 11:00:00	IWM	ETF	74.59	74.69	74.42	74.65	3242600.0
2006-03-27 12:00:00	IWM	ETF	74.6499	74.8	74.56	74.75	2112200.0
2006-03-27 13:00:00	IWM	ETF	74.75	74.88	74.73	74.85	2724900.0
2006-03-27 14:00:00	IWM	ETF	74.85	74.88	74.66	74.82	2027500.0
2006-03-27 15:00:00	IWM	ETF	74.82	74.88	74.71	74.87	4680300.0
2006-03-27 16:00:00	IWM	ETF	74.87	74.94	74.85	74.91	88600.0
2006-03-27 18:00:00	IWM	ETF	74.9	74.9	74.9	74.9	200.0
2006-03-27 19:00:00	IWM	ETF	74.91	74.91	74.91	74.91	200.0
2006-03-27 07:00:00	DIA	ETF	112.85	112.85	112.85	112.85	400.0
2006-03-27 08:00:00	DIA	ETF	112.86	112.86	112.85	112.85	1500.0
2006-03-27 09:00:00	DIA	ETF	112.75	112.75	112.45	112.62	416200.0
2006-03-27 10:00:00	DIA	ETF	112.6	112.65	112.33	112.36	1119000.0
2006-03-27 11:00:00	DIA	ETF	112.36	112.44	112.29	112.33	396300.0
2006-03-27 12:00:00	DIA	ETF	112.33	112.42	112.2	112.36	279700.0
2006-03-27 13:00:00	DIA	ETF	112.38	112.49	112.3	112.38	290900.0
2006-03-27 14:00:00	DIA	ETF	112.39	112.63	112.32	112.57	299900.0
2006-03-27 15:00:00	DIA	ETF	112.57	112.58	112.4	112.43	559700.0
2006-03-27 16:00:00	DIA	ETF	112.46	112.5	112.41	112.41	12400.0
2006-03-27 17:00:00	DIA	ETF	112.5	112.5	112.5	112.5	100.0
2006-03-27 18:00:00	DIA	ETF	112.5	112.5	112.5	112.5	500.0
2006-03-27 19:00:00	DIA	ETF	112.38	112.38	112.38	112.38	200.0
2006-03-27 06:00:00	GLD	ETF	55.71	55.71	55.71	55.71	100.0
2006-03-27 07:00:00	GLD	ETF	56.0	56.0	56.0	56.0	800.0
2006-03-27 08:00:00	GLD	ETF	56.08	56.25	56.0	56.25	65900.0
2006-03-27 09:00:00	GLD	ETF	56.26	56.33	56.16	56.3	645600.0
2006-03-27 10:00:00	GLD	ETF	56.29	56.55	56.29	56.43	1182100.0

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

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