PREVIEW / etf_1hour / 2006-03-21

all etf 1-hour files

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

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-21 07:00:00	SPY	ETF	130.3	130.3	130.17	130.19	112000.0
2006-03-21 08:00:00	SPY	ETF	130.2	130.29	130.11	130.24	1070700.0
2006-03-21 09:00:00	SPY	ETF	130.27	130.48	130.08	130.22	8539900.0
2006-03-21 10:00:00	SPY	ETF	130.22	130.39	129.94	130.14	11051500.0
2006-03-21 11:00:00	SPY	ETF	130.13	130.91	130.12	130.78	10599700.0
2006-03-21 12:00:00	SPY	ETF	130.78	130.99	130.66	130.72	6786300.0
2006-03-21 13:00:00	SPY	ETF	130.72	130.81	130.17	130.28	10561400.0
2006-03-21 14:00:00	SPY	ETF	130.28	130.34	129.53	129.64	18140300.0
2006-03-21 15:00:00	SPY	ETF	129.62	129.71	129.45	129.59	15899200.0
2006-03-21 16:00:00	SPY	ETF	129.59	129.66	129.54	129.66	1590200.0
2006-03-21 17:00:00	SPY	ETF	129.66	129.68	129.48	129.59	188500.0
2006-03-21 18:00:00	SPY	ETF	129.59	129.59	129.43	129.49	194800.0
2006-03-21 19:00:00	SPY	ETF	129.5	129.54	129.49	129.54	10900.0
2006-03-21 09:00:00	QQQ	ETF	41.51	41.54	41.28	41.4	12195200.0
2006-03-21 10:00:00	QQQ	ETF	41.4	41.48	41.23	41.4	12822600.0
2006-03-21 11:00:00	QQQ	ETF	41.4	42.01	41.4	41.93	29319500.0
2006-03-21 12:00:00	QQQ	ETF	41.93	41.99	41.85	41.87	13860300.0
2006-03-21 13:00:00	QQQ	ETF	41.87	41.88	41.62	41.67	12173400.0
2006-03-21 14:00:00	QQQ	ETF	41.66	41.85	41.25	41.27	27414700.0
2006-03-21 15:00:00	QQQ	ETF	41.27	41.29	41.08	41.11	22194900.0
2006-03-21 07:00:00	IWM	ETF	73.91	73.91	73.91	73.91	100.0
2006-03-21 08:00:00	IWM	ETF	73.97	73.97	73.88	73.96	201800.0
2006-03-21 09:00:00	IWM	ETF	73.95	74.08	73.71	73.87	2779600.0
2006-03-21 10:00:00	IWM	ETF	73.87	73.89	73.53	73.75	5127400.0
2006-03-21 11:00:00	IWM	ETF	73.75	74.6	73.74	74.49	7459900.0
2006-03-21 12:00:00	IWM	ETF	74.49	74.6	74.4	74.44	2226100.0
2006-03-21 13:00:00	IWM	ETF	74.44	74.48	74.06	74.09	4251900.0
2006-03-21 14:00:00	IWM	ETF	74.1	74.2	73.62	73.66	7107700.0
2006-03-21 15:00:00	IWM	ETF	73.66	73.85	73.1	73.15	12761800.0
2006-03-21 16:00:00	IWM	ETF	73.15	73.24	72.85	73.16	309200.0
2006-03-21 17:00:00	IWM	ETF	73.1	73.14	73.0	73.0	13900.0
2006-03-21 18:00:00	IWM	ETF	73.0	73.06	72.9	72.98	62100.0
2006-03-21 19:00:00	IWM	ETF	73.0	73.0	73.0	73.0	100.0
2006-03-21 07:00:00	DIA	ETF	112.63	112.63	112.54	112.54	1200.0
2006-03-21 08:00:00	DIA	ETF	112.5	112.63	112.5	112.6	243700.0
2006-03-21 09:00:00	DIA	ETF	112.68	112.91	112.6	112.72	629700.0
2006-03-21 10:00:00	DIA	ETF	112.72	112.85	112.53	112.63	616900.0
2006-03-21 11:00:00	DIA	ETF	112.63	113.22	112.63	113.1	1550300.0
2006-03-21 12:00:00	DIA	ETF	113.1	113.27	113.01	113.08	678800.0
2006-03-21 13:00:00	DIA	ETF	113.08	113.09	112.69	112.76	984800.0
2006-03-21 14:00:00	DIA	ETF	112.77	112.8	112.16	112.23	2246700.0
2006-03-21 15:00:00	DIA	ETF	112.22	112.3	112.09	112.27	1639500.0
2006-03-21 16:00:00	DIA	ETF	112.26	112.4	112.26	112.4	183900.0
2006-03-21 17:00:00	DIA	ETF	112.4	112.4	112.2	112.25	3300.0
2006-03-21 18:00:00	DIA	ETF	112.21	112.21	112.18	112.18	800.0
2006-03-21 19:00:00	DIA	ETF	112.25	112.3	112.23	112.23	2100.0
2006-03-21 07:00:00	GLD	ETF	54.98	55.04	54.96	54.98	6000.0
2006-03-21 08:00:00	GLD	ETF	54.98	55.01	54.61	54.66	55800.0
2006-03-21 09:00:00	GLD	ETF	54.68	54.88	54.51	54.52	1130000.0
2006-03-21 10:00:00	GLD	ETF	54.5301	54.82	54.4	54.7	1210900.0

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

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