PREVIEW / etf_1hour / 2006-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-10.parquet
  size:    49 KB
  rows:    1,545

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-07-10 06:00:00	SPY	ETF	126.92	126.94	126.87	126.94	35100.0
2006-07-10 07:00:00	SPY	ETF	126.9	127.12	126.9	127.08	66700.0
2006-07-10 08:00:00	SPY	ETF	127.08	127.17	126.7	126.9375	3058400.0
2006-07-10 09:00:00	SPY	ETF	126.9	127.22	126.61	127.02	10244200.0
2006-07-10 10:00:00	SPY	ETF	127.01	127.4	127.01	127.37	10277500.0
2006-07-10 11:00:00	SPY	ETF	127.37	127.43	127.0	127.15	7274600.0
2006-07-10 12:00:00	SPY	ETF	127.15	127.17	126.9	126.96	4843600.0
2006-07-10 13:00:00	SPY	ETF	126.96	127.14	126.7	126.83	6370600.0
2006-07-10 14:00:00	SPY	ETF	126.83	126.97	126.41	126.51	8009800.0
2006-07-10 15:00:00	SPY	ETF	126.5	126.85	126.43	126.73	8708300.0
2006-07-10 16:00:00	SPY	ETF	126.74	126.89	126.47	126.79	670500.0
2006-07-10 17:00:00	SPY	ETF	126.78	126.78	126.75	126.75	38900.0
2006-07-10 18:00:00	SPY	ETF	126.75	126.78	126.71	126.73	20200.0
2006-07-10 19:00:00	SPY	ETF	126.74	126.75	126.74	126.75	3700.0
2006-07-10 09:00:00	QQQ	ETF	37.79	37.93	37.76	37.79	12128300.0
2006-07-10 10:00:00	QQQ	ETF	37.79	37.93	37.69	37.78	16027200.0
2006-07-10 11:00:00	QQQ	ETF	37.79	37.79	37.6	37.64	10457800.0
2006-07-10 12:00:00	QQQ	ETF	37.63	37.69	37.54	37.56	9958500.0
2006-07-10 13:00:00	QQQ	ETF	37.56	37.56	37.36	37.4	11167500.0
2006-07-10 14:00:00	QQQ	ETF	37.4	37.44	37.2	37.21	14429200.0
2006-07-10 15:00:00	QQQ	ETF	37.21	37.38	37.17	37.37	25766800.0
2006-07-10 08:00:00	IWM	ETF	70.87	70.95	70.72	70.75	82700.0
2006-07-10 09:00:00	IWM	ETF	70.72	70.9	70.5	70.82	4478900.0
2006-07-10 10:00:00	IWM	ETF	70.81	71.21	70.69	71.17	5902500.0
2006-07-10 11:00:00	IWM	ETF	71.17	71.24	70.88	71.0	2744200.0
2006-07-10 12:00:00	IWM	ETF	71.0	71.0	70.72	70.81	5395200.0
2006-07-10 13:00:00	IWM	ETF	70.8	70.8	70.53	70.67	5659700.0
2006-07-10 14:00:00	IWM	ETF	70.67	70.76	70.22	70.24	5717000.0
2006-07-10 15:00:00	IWM	ETF	70.24	70.55	70.18	70.43	5079300.0
2006-07-10 16:00:00	IWM	ETF	70.43	70.6	70.38	70.42	3999200.0
2006-07-10 17:00:00	IWM	ETF	70.45	70.47	70.37	70.37	53000.0
2006-07-10 05:00:00	DIA	ETF	111.23	111.23	111.23	111.23	100.0
2006-07-10 07:00:00	DIA	ETF	111.32	111.32	111.32	111.32	500.0
2006-07-10 08:00:00	DIA	ETF	111.34	111.45	111.3	111.3	17800.0
2006-07-10 09:00:00	DIA	ETF	111.3	111.54	111.3	111.39	433600.0
2006-07-10 10:00:00	DIA	ETF	111.38	111.74	111.36	111.74	646500.0
2006-07-10 11:00:00	DIA	ETF	111.72	111.78	111.49	111.62	316700.0
2006-07-10 12:00:00	DIA	ETF	111.62	111.62	111.42	111.44	319300.0
2006-07-10 13:00:00	DIA	ETF	111.42	111.43	111.2	111.25	475400.0
2006-07-10 14:00:00	DIA	ETF	111.26	111.31	110.9	110.95	539000.0
2006-07-10 15:00:00	DIA	ETF	110.94	111.24	110.91	111.08	584200.0
2006-07-10 16:00:00	DIA	ETF	111.096	111.18	111.03	111.09	1022200.0
2006-07-10 17:00:00	DIA	ETF	111.04	111.04	111.04	111.04	600.0
2006-07-10 19:00:00	DIA	ETF	111.06	111.06	111.06	111.06	1000.0
2006-07-10 04:00:00	GLD	ETF	62.25	62.25	62.25	62.25	100.0
2006-07-10 05:00:00	GLD	ETF	62.25	62.25	62.25	62.25	100.0
2006-07-10 06:00:00	GLD	ETF	62.25	62.25	62.25	62.25	100.0
2006-07-10 07:00:00	GLD	ETF	61.85	61.85	61.85	61.85	100.0
2006-07-10 08:00:00	GLD	ETF	61.9	62.2	61.7	61.81	118400.0
2006-07-10 09:00:00	GLD	ETF	61.85	62.22	61.85	62.18	822700.0

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

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