PREVIEW / etf_1hour / 2005-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-13.parquet
  size:    31 KB
  rows:    945

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-13 07:00:00	SPY	ETF	124.0	124.05	123.95	124.05	63400.0
2005-09-13 08:00:00	SPY	ETF	123.95	124.18	123.95	124.15	1576400.0
2005-09-13 09:00:00	SPY	ETF	124.17	124.17	123.88	123.95	7244600.0
2005-09-13 10:00:00	SPY	ETF	123.96	124.15	123.66	123.74	8272900.0
2005-09-13 11:00:00	SPY	ETF	123.74	124.06	123.59	123.65	6685400.0
2005-09-13 12:00:00	SPY	ETF	123.67	123.85	123.56	123.84	4085900.0
2005-09-13 13:00:00	SPY	ETF	123.85	123.98	123.77	123.82	4558800.0
2005-09-13 14:00:00	SPY	ETF	123.82	124.42	123.71	124.06	10458400.0
2005-09-13 15:00:00	SPY	ETF	124.07	124.09	123.52	123.57	11408200.0
2005-09-13 16:00:00	SPY	ETF	123.55	123.67	123.55	123.67	422600.0
2005-09-13 17:00:00	SPY	ETF	123.5151	123.68	123.5151	123.63	818700.0
2005-09-13 18:00:00	SPY	ETF	123.68	123.7	123.68	123.7	51500.0
2005-09-13 19:00:00	SPY	ETF	123.71	123.71	123.71	123.71	400.0
2005-09-13 09:00:00	QQQ	ETF	39.68	39.73	39.6	39.66	7511200.0
2005-09-13 10:00:00	QQQ	ETF	39.66	39.71	39.56	39.57	9515600.0
2005-09-13 11:00:00	QQQ	ETF	39.58	39.63	39.54	39.6	6746000.0
2005-09-13 12:00:00	QQQ	ETF	39.59	39.68	39.56	39.68	4365700.0
2005-09-13 13:00:00	QQQ	ETF	39.68	39.72	39.65	39.69	5284800.0
2005-09-13 14:00:00	QQQ	ETF	39.69	39.91	39.66	39.81	15317500.0
2005-09-13 15:00:00	QQQ	ETF	39.8	39.81	39.61	39.63	12796900.0
2005-09-13 08:00:00	IWM	ETF	67.58	67.59	67.49	67.49	10800.0
2005-09-13 09:00:00	IWM	ETF	67.57	67.57	67.2	67.26	2925400.0
2005-09-13 10:00:00	IWM	ETF	67.25	67.31	67.07	67.12	3974300.0
2005-09-13 11:00:00	IWM	ETF	67.12	67.16	66.91	67.08	3005300.0
2005-09-13 12:00:00	IWM	ETF	67.08	67.28	67.01	67.26	1883500.0
2005-09-13 13:00:00	IWM	ETF	67.26	67.33	67.15	67.2	2124400.0
2005-09-13 14:00:00	IWM	ETF	67.21	67.55	67.16	67.27	3544900.0
2005-09-13 15:00:00	IWM	ETF	67.27	67.28	66.99	67.0	2561600.0
2005-09-13 16:00:00	IWM	ETF	67.0	67.18	67.0	67.17	1599600.0
2005-09-13 18:00:00	IWM	ETF	67.06	67.06	67.06	67.06	200000.0
2005-09-13 08:00:00	DIA	ETF	106.53	106.57	106.47	106.57	40500.0
2005-09-13 09:00:00	DIA	ETF	106.57	106.6	106.35	106.45	909200.0
2005-09-13 10:00:00	DIA	ETF	106.47	106.56	106.19	106.25	756700.0
2005-09-13 11:00:00	DIA	ETF	106.25	106.3	106.12	106.16	482600.0
2005-09-13 12:00:00	DIA	ETF	106.15	106.29	106.06	106.29	343900.0
2005-09-13 13:00:00	DIA	ETF	106.32	106.43	106.26	106.34	511300.0
2005-09-13 14:00:00	DIA	ETF	106.31	106.81	106.24	106.49	1339500.0
2005-09-13 15:00:00	DIA	ETF	106.49	106.51	106.01	106.08	1562300.0
2005-09-13 16:00:00	DIA	ETF	106.11	106.17	106.11	106.17	2800.0
2005-09-13 08:00:00	GLD	ETF	44.76	44.82	44.75	44.82	2600.0
2005-09-13 09:00:00	GLD	ETF	44.55	44.62	44.37	44.48	230500.0
2005-09-13 10:00:00	GLD	ETF	44.46	44.47	44.36	44.42	137000.0
2005-09-13 11:00:00	GLD	ETF	44.42	44.55	44.39	44.53	106100.0
2005-09-13 12:00:00	GLD	ETF	44.53	44.54	44.47	44.52	45000.0
2005-09-13 13:00:00	GLD	ETF	44.54	44.54	44.43	44.5	35500.0
2005-09-13 14:00:00	GLD	ETF	44.49	44.56	44.49	44.56	251500.0
2005-09-13 15:00:00	GLD	ETF	44.55	44.56	44.5	44.55	113300.0
2005-09-13 08:00:00	TLT	ETF	93.68	93.77	93.68	93.77	4800.0
2005-09-13 09:00:00	TLT	ETF	93.8	93.88	93.76	93.87	52200.0
2005-09-13 10:00:00	TLT	ETF	93.9	94.12	93.9	93.95	143600.0

> showing 50 of 945 rows — these rows as CSV

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