PREVIEW / etf_1hour / 2006-04-20

all etf 1-hour files

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

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-20 05:00:00	SPY	ETF	131.02	131.04	131.02	131.02	25100.0
2006-04-20 06:00:00	SPY	ETF	131.04	131.07	131.04	131.07	200.0
2006-04-20 07:00:00	SPY	ETF	131.1	131.13	131.02	131.09	98100.0
2006-04-20 08:00:00	SPY	ETF	131.11	131.12	130.95	131.09	1169800.0
2006-04-20 09:00:00	SPY	ETF	131.08	131.08	130.86	131.0	6041500.0
2006-04-20 10:00:00	SPY	ETF	131.0	131.86	130.97	131.13	31598800.0
2006-04-20 11:00:00	SPY	ETF	131.13	131.25	130.6	131.18	12453700.0
2006-04-20 12:00:00	SPY	ETF	131.18	131.43	130.97	131.43	7266000.0
2006-04-20 13:00:00	SPY	ETF	131.41	131.48	131.08	131.26	7259700.0
2006-04-20 14:00:00	SPY	ETF	131.24	131.39	131.0058	131.22	9285600.0
2006-04-20 15:00:00	SPY	ETF	131.23	131.4	131.13	131.15	5242500.0
2006-04-20 16:00:00	SPY	ETF	131.15	131.26	131.08	131.25	1229600.0
2006-04-20 17:00:00	SPY	ETF	131.26	131.35	131.2	131.29	44200.0
2006-04-20 18:00:00	SPY	ETF	131.25	131.25	131.22	131.25	1500.0
2006-04-20 19:00:00	SPY	ETF	131.24	131.24	131.2	131.23	1300.0
2006-04-20 09:00:00	QQQ	ETF	42.62	42.64	42.49	42.55	6674200.0
2006-04-20 10:00:00	QQQ	ETF	42.54	42.82	42.0	42.54	24560900.0
2006-04-20 11:00:00	QQQ	ETF	42.54	42.61	42.38	42.53	12021700.0
2006-04-20 12:00:00	QQQ	ETF	42.53	42.6	42.44	42.6	8614500.0
2006-04-20 13:00:00	QQQ	ETF	42.6	42.61	42.5	42.52	7602200.0
2006-04-20 14:00:00	QQQ	ETF	42.52	42.55	42.44	42.54	5628500.0
2006-04-20 15:00:00	QQQ	ETF	42.54	42.58	42.46	42.5	9195500.0
2006-04-20 07:00:00	IWM	ETF	77.1	77.2	77.1	77.2	200.0
2006-04-20 08:00:00	IWM	ETF	77.3	77.45	77.26	77.44	136100.0
2006-04-20 09:00:00	IWM	ETF	77.43	77.43	76.93	77.08	2542600.0
2006-04-20 10:00:00	IWM	ETF	77.08	77.32	76.44	76.52	9912000.0
2006-04-20 11:00:00	IWM	ETF	76.52	76.69	76.23	76.55	7739200.0
2006-04-20 12:00:00	IWM	ETF	76.56	76.94	76.48	76.94	4374200.0
2006-04-20 13:00:00	IWM	ETF	76.94	76.97	76.76	76.89	3824900.0
2006-04-20 14:00:00	IWM	ETF	76.9	76.94	76.71	76.84	4132000.0
2006-04-20 15:00:00	IWM	ETF	76.84	77.12	76.78	76.92	5177900.0
2006-04-20 16:00:00	IWM	ETF	76.9	76.94	76.79	76.92	4254500.0
2006-04-20 17:00:00	IWM	ETF	76.93	76.95	76.93	76.95	6000.0
2006-04-20 18:00:00	IWM	ETF	76.95	76.95	76.94	76.94	600.0
2006-04-20 19:00:00	IWM	ETF	76.9	76.9	76.9	76.9	500.0
2006-04-20 08:00:00	DIA	ETF	112.91	113.01	112.91	112.96	5000.0
2006-04-20 09:00:00	DIA	ETF	112.96	113.1	112.84	113.05	444300.0
2006-04-20 10:00:00	DIA	ETF	113.07	113.88	113.04	113.41	4220700.0
2006-04-20 11:00:00	DIA	ETF	113.41	113.49	113.0	113.48	1732900.0
2006-04-20 12:00:00	DIA	ETF	113.465	113.68	113.34	113.68	963400.0
2006-04-20 13:00:00	DIA	ETF	113.66	113.74	113.36	113.49	625400.0
2006-04-20 14:00:00	DIA	ETF	113.492	113.64	113.39	113.49	1026900.0
2006-04-20 15:00:00	DIA	ETF	113.53	113.67	113.42	113.46	982600.0
2006-04-20 16:00:00	DIA	ETF	113.45	113.55	113.41	113.55	52000.0
2006-04-20 17:00:00	DIA	ETF	113.6	113.62	113.6	113.62	200.0
2006-04-20 19:00:00	DIA	ETF	113.57	113.58	113.57	113.58	600.0
2006-04-20 07:00:00	GLD	ETF	63.7	63.96	63.7	63.83	9800.0
2006-04-20 08:00:00	GLD	ETF	63.73	63.96	63.3	63.5	148300.0
2006-04-20 09:00:00	GLD	ETF	63.55	63.66	62.65	62.67	1576800.0
2006-04-20 10:00:00	GLD	ETF	62.67	62.67	60.52	61.34	5081700.0

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

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