PREVIEW / etf_1hour / 2005-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-12.parquet
  size:    31 KB
  rows:    958

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
2005-09-12 07:00:00	SPY	ETF	124.34	124.5	124.34	124.5	10700.0
2005-09-12 08:00:00	SPY	ETF	124.45	124.85	124.37	124.49	215900.0
2005-09-12 09:00:00	SPY	ETF	124.49	124.67	124.37	124.6	4695900.0
2005-09-12 10:00:00	SPY	ETF	124.6	124.65	124.32	124.5	7085100.0
2005-09-12 11:00:00	SPY	ETF	124.5	124.56	124.37	124.38	3517900.0
2005-09-12 12:00:00	SPY	ETF	124.4	124.65	124.38	124.47	4627600.0
2005-09-12 13:00:00	SPY	ETF	124.47	124.56	124.31	124.31	1992300.0
2005-09-12 14:00:00	SPY	ETF	124.35	124.57	124.27	124.56	3355200.0
2005-09-12 15:00:00	SPY	ETF	124.55	124.66	124.41	124.43	4976100.0
2005-09-12 16:00:00	SPY	ETF	124.4	124.66	124.2	124.3	1415800.0
2005-09-12 17:00:00	SPY	ETF	124.28	124.34	124.26	124.31	13800.0
2005-09-12 18:00:00	SPY	ETF	124.33	124.34	124.25	124.25	8900.0
2005-09-12 19:00:00	SPY	ETF	124.27	124.27	124.25	124.27	1600.0
2005-09-12 09:00:00	QQQ	ETF	39.63	39.77	39.58	39.76	7720100.0
2005-09-12 10:00:00	QQQ	ETF	39.76	39.77	39.63	39.74	9194600.0
2005-09-12 11:00:00	QQQ	ETF	39.75	39.79	39.7	39.7	5259700.0
2005-09-12 12:00:00	QQQ	ETF	39.71	39.86	39.7	39.78	6599200.0
2005-09-12 13:00:00	QQQ	ETF	39.78	39.83	39.72	39.72	4000100.0
2005-09-12 14:00:00	QQQ	ETF	39.72	39.81	39.67	39.8	6496200.0
2005-09-12 15:00:00	QQQ	ETF	39.8	39.84	39.73	39.73	8224500.0
2005-09-12 08:00:00	IWM	ETF	67.36	67.44	67.35	67.44	13500.0
2005-09-12 09:00:00	IWM	ETF	67.425	67.61	67.28	67.53	1755400.0
2005-09-12 10:00:00	IWM	ETF	67.53	67.63	67.42	67.62	2102400.0
2005-09-12 11:00:00	IWM	ETF	67.62	67.75	67.61	67.68	2290300.0
2005-09-12 12:00:00	IWM	ETF	67.68	67.92	67.67	67.86	3308000.0
2005-09-12 13:00:00	IWM	ETF	67.86	67.9	67.72	67.72	1047800.0
2005-09-12 14:00:00	IWM	ETF	67.72	67.99	67.7	67.97	2105200.0
2005-09-12 15:00:00	IWM	ETF	67.98	68.08	67.75	67.76	3059100.0
2005-09-12 16:00:00	IWM	ETF	67.73	67.79	67.62	67.62	342000.0
2005-09-12 17:00:00	IWM	ETF	67.64	67.64	67.64	67.64	4200.0
2005-09-12 18:00:00	IWM	ETF	67.63	67.63	67.63	67.63	100.0
2005-09-12 07:00:00	DIA	ETF	106.67	106.67	106.67	106.67	4200.0
2005-09-12 08:00:00	DIA	ETF	106.76	106.76	106.75	106.75	300.0
2005-09-12 09:00:00	DIA	ETF	106.77	106.95	106.66	106.88	833700.0
2005-09-12 10:00:00	DIA	ETF	106.86	106.93	106.63	106.84	737000.0
2005-09-12 11:00:00	DIA	ETF	106.83	106.95	106.76	106.8	426700.0
2005-09-12 12:00:00	DIA	ETF	106.78	107.01	106.78	106.86	1331700.0
2005-09-12 13:00:00	DIA	ETF	106.86	106.95	106.73	106.73	380900.0
2005-09-12 14:00:00	DIA	ETF	106.73	106.92	106.68	106.91	493700.0
2005-09-12 15:00:00	DIA	ETF	106.9	106.95	106.79	106.79	583800.0
2005-09-12 16:00:00	DIA	ETF	106.8	106.84	106.67	106.67	157900.0
2005-09-12 17:00:00	DIA	ETF	106.76	106.76	106.76	106.76	100.0
2005-09-12 08:00:00	GLD	ETF	44.7	44.76	44.64	44.64	4000.0
2005-09-12 09:00:00	GLD	ETF	44.65	44.73	44.64	44.7	196700.0
2005-09-12 10:00:00	GLD	ETF	44.71	44.73	44.63	44.67	180400.0
2005-09-12 11:00:00	GLD	ETF	44.67	44.85	44.62	44.85	136400.0
2005-09-12 12:00:00	GLD	ETF	44.85	44.88	44.77	44.84	89900.0
2005-09-12 13:00:00	GLD	ETF	44.83	44.87	44.81	44.84	46800.0
2005-09-12 14:00:00	GLD	ETF	44.84	44.89	44.83	44.88	37200.0
2005-09-12 15:00:00	GLD	ETF	44.86	44.89	44.85	44.88	47400.0

> showing 50 of 958 rows — these rows as CSV

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