PREVIEW / etf_1hour / 2005-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-30.parquet
  size:    31 KB
  rows:    941

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-08-30 07:00:00	SPY	ETF	121.39	121.39	121.3	121.39	174500.0
2005-08-30 08:00:00	SPY	ETF	121.34	121.62	121.27	121.32	1027700.0
2005-08-30 09:00:00	SPY	ETF	121.33	121.35	120.96	120.99	7108200.0
2005-08-30 10:00:00	SPY	ETF	121.0	121.3	120.59	120.83	12695100.0
2005-08-30 11:00:00	SPY	ETF	120.84	120.85	120.5	120.62	9909000.0
2005-08-30 12:00:00	SPY	ETF	120.64	121.04	120.57	120.93	9142100.0
2005-08-30 13:00:00	SPY	ETF	120.93	121.19	120.7915	121.02	5096900.0
2005-08-30 14:00:00	SPY	ETF	121.02	121.05	120.45	120.46	9531100.0
2005-08-30 15:00:00	SPY	ETF	120.47	121.24	120.39	121.18	16772300.0
2005-08-30 16:00:00	SPY	ETF	121.2	121.23	121.03	121.07	1242100.0
2005-08-30 17:00:00	SPY	ETF	121.09	121.09	120.93	120.96	163200.0
2005-08-30 18:00:00	SPY	ETF	120.94	120.95	120.83	120.85	156400.0
2005-08-30 19:00:00	SPY	ETF	120.85	120.89	120.85	120.89	7400.0
2005-08-30 09:00:00	QQQ	ETF	38.56	38.59	38.49	38.53	9855600.0
2005-08-30 10:00:00	QQQ	ETF	38.53	38.62	38.34	38.42	19630100.0
2005-08-30 11:00:00	QQQ	ETF	38.42	38.45	38.32	38.35	12311500.0
2005-08-30 12:00:00	QQQ	ETF	38.35	38.52	38.33	38.47	8474400.0
2005-08-30 13:00:00	QQQ	ETF	38.47	38.57	38.4	38.51	6855800.0
2005-08-30 14:00:00	QQQ	ETF	38.52	38.52	38.34	38.35	10512400.0
2005-08-30 15:00:00	QQQ	ETF	38.35	38.64	38.33	38.64	15219900.0
2005-08-30 07:00:00	IWM	ETF	65.23	65.23	65.18	65.18	2200.0
2005-08-30 08:00:00	IWM	ETF	65.22	65.22	65.14	65.18	113200.0
2005-08-30 09:00:00	IWM	ETF	65.14	65.2	64.83	65.03	2382800.0
2005-08-30 10:00:00	IWM	ETF	65.03	65.27	64.85	65.04	4889800.0
2005-08-30 11:00:00	IWM	ETF	65.04	65.04	64.73	64.92	2662100.0
2005-08-30 12:00:00	IWM	ETF	64.91	65.13	64.88	65.0	1447800.0
2005-08-30 13:00:00	IWM	ETF	65.0	65.22	64.91	65.18	1523100.0
2005-08-30 14:00:00	IWM	ETF	65.18	65.2	64.73	64.74	3318000.0
2005-08-30 15:00:00	IWM	ETF	64.74	65.24	64.7	65.18	4290200.0
2005-08-30 16:00:00	IWM	ETF	65.12	65.26	65.04	65.05	281500.0
2005-08-30 17:00:00	IWM	ETF	65.04	65.04	64.91	64.97	6800.0
2005-08-30 18:00:00	IWM	ETF	64.96	64.96	64.94	64.94	1200.0
2005-08-30 07:00:00	DIA	ETF	104.4	104.4	104.4	104.4	500.0
2005-08-30 08:00:00	DIA	ETF	104.48	104.5	104.32	104.36	6600.0
2005-08-30 09:00:00	DIA	ETF	104.34	104.34	103.97	103.97	871900.0
2005-08-30 10:00:00	DIA	ETF	103.98	104.2	103.69	103.84	1705200.0
2005-08-30 11:00:00	DIA	ETF	103.84	103.85	103.54	103.59	1584100.0
2005-08-30 12:00:00	DIA	ETF	103.58	104.03	103.55	103.9	1018100.0
2005-08-30 13:00:00	DIA	ETF	103.92	104.15	103.78	104.02	737800.0
2005-08-30 14:00:00	DIA	ETF	104.01	104.01	103.48	103.49	914200.0
2005-08-30 15:00:00	DIA	ETF	103.5	104.1	103.45	104.08	1601300.0
2005-08-30 16:00:00	DIA	ETF	104.1	104.1	104.0	104.0	6000.0
2005-08-30 17:00:00	DIA	ETF	104.01	104.01	103.94	104.0	1000.0
2005-08-30 18:00:00	DIA	ETF	103.96	103.96	103.9	103.9	3800.0
2005-08-30 08:00:00	GLD	ETF	43.4	43.99	43.02	43.02	4200.0
2005-08-30 09:00:00	GLD	ETF	43.02	43.05	42.88	42.96	261800.0
2005-08-30 10:00:00	GLD	ETF	42.94	43.0	42.81	42.87	978000.0
2005-08-30 11:00:00	GLD	ETF	42.86	43.02	42.85	42.92	258300.0
2005-08-30 12:00:00	GLD	ETF	42.93	42.96	42.88	42.924	283700.0
2005-08-30 13:00:00	GLD	ETF	42.94	43.01	42.92	43.01	67700.0

> showing 50 of 941 rows — these rows as CSV

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