PREVIEW / etf_1hour / 2006-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-21.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-21 04:00:00	SPY	ETF	125.21	125.21	125.21	125.21	300.0
2006-07-21 05:00:00	SPY	ETF	125.25	125.25	125.25	125.25	6000.0
2006-07-21 06:00:00	SPY	ETF	125.3	125.3	125.19	125.19	112000.0
2006-07-21 07:00:00	SPY	ETF	125.21	125.22	124.87	124.87	388500.0
2006-07-21 08:00:00	SPY	ETF	124.87	125.29	124.84	125.06	3676000.0
2006-07-21 09:00:00	SPY	ETF	125.07	125.34	124.14	124.43	14980000.0
2006-07-21 10:00:00	SPY	ETF	124.43	124.86	124.02	124.65	22358900.0
2006-07-21 11:00:00	SPY	ETF	124.65	125.19	124.29	124.57	9179300.0
2006-07-21 12:00:00	SPY	ETF	124.57	124.58	123.87	124.08	15369100.0
2006-07-21 13:00:00	SPY	ETF	124.08	124.49	123.91	124.32	9766500.0
2006-07-21 14:00:00	SPY	ETF	124.31	124.32	123.99	124.06	8466600.0
2006-07-21 15:00:00	SPY	ETF	124.06	124.4	123.95	124.09	11979000.0
2006-07-21 16:00:00	SPY	ETF	124.08	124.11	123.1896	123.92	3032700.0
2006-07-21 17:00:00	SPY	ETF	123.9	123.98	123.85	123.9	66600.0
2006-07-21 18:00:00	SPY	ETF	123.94	123.94	123.9	123.92	3900.0
2006-07-21 19:00:00	SPY	ETF	123.91	123.91	123.86	123.86	1100.0
2006-07-21 09:00:00	QQQ	ETF	35.88	35.89	35.66	35.76	23102700.0
2006-07-21 10:00:00	QQQ	ETF	35.76	35.96	35.62	35.89	26074300.0
2006-07-21 11:00:00	QQQ	ETF	35.89	35.95	35.73	35.87	11536300.0
2006-07-21 12:00:00	QQQ	ETF	35.87	35.89	35.65	35.73	9015300.0
2006-07-21 13:00:00	QQQ	ETF	35.73	35.86	35.66	35.8	8500600.0
2006-07-21 14:00:00	QQQ	ETF	35.81	35.81	35.66	35.67	8172400.0
2006-07-21 15:00:00	QQQ	ETF	35.67	35.77	35.63	35.7	15975300.0
2006-07-21 07:00:00	IWM	ETF	67.85	67.85	67.85	67.85	1000.0
2006-07-21 08:00:00	IWM	ETF	67.72	67.88	67.47	67.55	1676900.0
2006-07-21 09:00:00	IWM	ETF	67.55	67.82	66.56	66.68	19912200.0
2006-07-21 10:00:00	IWM	ETF	66.69	67.3	66.35	67.17	28983000.0
2006-07-21 11:00:00	IWM	ETF	67.16	67.21	66.78	67.03	6636800.0
2006-07-21 12:00:00	IWM	ETF	67.03	67.06	66.41	66.5	9844000.0
2006-07-21 13:00:00	IWM	ETF	66.5	66.93	66.4	66.83	12161600.0
2006-07-21 14:00:00	IWM	ETF	66.81	66.92	66.56	66.63	7296800.0
2006-07-21 15:00:00	IWM	ETF	66.62	67.05	66.59	66.76	12493800.0
2006-07-21 16:00:00	IWM	ETF	66.76	66.77	66.45	66.46	1120200.0
2006-07-21 17:00:00	IWM	ETF	66.4	66.81	66.38	66.75	5868400.0
2006-07-21 18:00:00	IWM	ETF	66.75	66.75	66.75	66.75	200.0
2006-07-21 19:00:00	IWM	ETF	66.75	66.75	66.75	66.75	400.0
2006-07-21 07:00:00	DIA	ETF	109.33	109.35	109.26	109.26	43000.0
2006-07-21 08:00:00	DIA	ETF	109.22	109.45	109.22	109.45	673800.0
2006-07-21 09:00:00	DIA	ETF	109.47	109.7	108.6	108.86	1699700.0
2006-07-21 10:00:00	DIA	ETF	108.85	109.07	108.42	108.93	2037100.0
2006-07-21 11:00:00	DIA	ETF	108.92	108.97	108.6	108.82	735800.0
2006-07-21 12:00:00	DIA	ETF	108.83	108.83	108.29	108.47	535800.0
2006-07-21 13:00:00	DIA	ETF	108.47	108.91	108.35	108.81	1089300.0
2006-07-21 14:00:00	DIA	ETF	108.79	108.83	108.5	108.56	648700.0
2006-07-21 15:00:00	DIA	ETF	108.57	108.75	108.46	108.64	1581300.0
2006-07-21 16:00:00	DIA	ETF	108.6	108.6	108.5	108.57	75700.0
2006-07-21 17:00:00	DIA	ETF	108.53	108.55	108.53	108.55	3000.0
2006-07-21 19:00:00	DIA	ETF	108.58	108.58	108.58	108.58	2000.0
2006-07-21 07:00:00	GLD	ETF	62.52	62.52	62.52	62.52	500.0
2006-07-21 08:00:00	GLD	ETF	62.65	63.19	62.5	63.1	161900.0

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

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