PREVIEW / etf_1hour / 2006-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-19.parquet
  size:    42 KB
  rows:    1,283

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-19 06:00:00	SPY	ETF	131.14	131.14	131.12	131.12	18400.0
2006-04-19 07:00:00	SPY	ETF	131.08	131.21	131.08	131.18	153800.0
2006-04-19 08:00:00	SPY	ETF	131.16	131.29	130.87	130.89	2122100.0
2006-04-19 09:00:00	SPY	ETF	130.87	130.99	130.62	130.83	16111500.0
2006-04-19 10:00:00	SPY	ETF	130.84	130.98	130.24	130.6	27432600.0
2006-04-19 11:00:00	SPY	ETF	130.6	130.93	130.58	130.77	8450400.0
2006-04-19 12:00:00	SPY	ETF	130.77	131.06	130.64	130.69	6761600.0
2006-04-19 13:00:00	SPY	ETF	130.69	130.9	130.55	130.76	9468200.0
2006-04-19 14:00:00	SPY	ETF	130.76	131.05	130.53	130.94	6352900.0
2006-04-19 15:00:00	SPY	ETF	130.95	131.07	130.92	131.01	6678000.0
2006-04-19 16:00:00	SPY	ETF	130.99	131.05	130.75	131.04	1748600.0
2006-04-19 17:00:00	SPY	ETF	131.02	131.02	130.9	130.9	74000.0
2006-04-19 18:00:00	SPY	ETF	130.94	130.94	130.9	130.9	4300.0
2006-04-19 19:00:00	SPY	ETF	130.93	130.93	130.87	130.88	2300.0
2006-04-19 09:00:00	QQQ	ETF	42.54	42.65	42.47	42.53	9829200.0
2006-04-19 10:00:00	QQQ	ETF	42.52	42.59	42.3	42.39	16294500.0
2006-04-19 11:00:00	QQQ	ETF	42.39	42.52	42.39	42.47	7752200.0
2006-04-19 12:00:00	QQQ	ETF	42.46	42.55	42.43	42.45	6840700.0
2006-04-19 13:00:00	QQQ	ETF	42.45	42.52	42.37	42.51	7743900.0
2006-04-19 14:00:00	QQQ	ETF	42.51	42.58	42.41	42.54	8375200.0
2006-04-19 15:00:00	QQQ	ETF	42.54	42.64	42.53	42.64	13286200.0
2006-04-19 07:00:00	IWM	ETF	76.98	76.99	76.98	76.99	2100.0
2006-04-19 08:00:00	IWM	ETF	76.1	77.01	76.1	76.76	117900.0
2006-04-19 09:00:00	IWM	ETF	76.73	76.885	76.53	76.79	7285800.0
2006-04-19 10:00:00	IWM	ETF	76.79	76.94	76.27	76.6	10241800.0
2006-04-19 11:00:00	IWM	ETF	76.6	76.97	76.6	76.86	3295600.0
2006-04-19 12:00:00	IWM	ETF	76.87	77.19	76.85	76.92	2886800.0
2006-04-19 13:00:00	IWM	ETF	76.92	77.06	76.74	76.99	4428400.0
2006-04-19 14:00:00	IWM	ETF	76.99	77.23	76.75	77.21	6799900.0
2006-04-19 15:00:00	IWM	ETF	77.21	77.31	77.11	77.3	5849000.0
2006-04-19 16:00:00	IWM	ETF	77.3	77.34	77.1	77.3	472700.0
2006-04-19 17:00:00	IWM	ETF	77.26	77.3	77.26	77.3	2100.0
2006-04-19 18:00:00	IWM	ETF	77.32	77.33	77.32	77.33	30900.0
2006-04-19 07:00:00	DIA	ETF	113.07	113.15	113.07	113.15	7000.0
2006-04-19 08:00:00	DIA	ETF	113.15	113.23	112.88	112.88	151000.0
2006-04-19 09:00:00	DIA	ETF	112.87	113.03	112.73	112.93	1200300.0
2006-04-19 10:00:00	DIA	ETF	112.93	113.04	112.35	112.64	1844200.0
2006-04-19 11:00:00	DIA	ETF	112.61	112.9	112.61	112.8026	654000.0
2006-04-19 12:00:00	DIA	ETF	112.8001	112.99	112.66	112.71	520200.0
2006-04-19 13:00:00	DIA	ETF	112.72	112.83	112.54	112.73	469100.0
2006-04-19 14:00:00	DIA	ETF	112.75	112.91	112.56	112.84	579300.0
2006-04-19 15:00:00	DIA	ETF	112.84	112.94	112.77	112.83	508500.0
2006-04-19 16:00:00	DIA	ETF	112.83	112.9	112.05	112.9	32000.0
2006-04-19 17:00:00	DIA	ETF	112.86	112.94	112.86	112.94	3700.0
2006-04-19 18:00:00	DIA	ETF	112.88	112.88	112.88	112.88	1000.0
2006-04-19 07:00:00	GLD	ETF	62.22	62.24	62.15	62.15	5000.0
2006-04-19 08:00:00	GLD	ETF	62.15	62.26	61.8	61.97	1577000.0
2006-04-19 09:00:00	GLD	ETF	61.97	62.17	61.85	62.04	1047400.0
2006-04-19 10:00:00	GLD	ETF	62.03	62.6	62.01	62.47	1233400.0
2006-04-19 11:00:00	GLD	ETF	62.47	62.58	62.371	62.45	512600.0

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

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