PREVIEW / etf_1hour / 2005-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-20.parquet
  size:    32 KB
  rows:    957

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-07-20 05:00:00	SPY	ETF	122.87	122.89	122.87	122.89	2000.0
2005-07-20 06:00:00	SPY	ETF	122.8	122.8	122.8	122.8	400.0
2005-07-20 07:00:00	SPY	ETF	122.82	122.82	122.71	122.71	57800.0
2005-07-20 08:00:00	SPY	ETF	122.67	122.67	122.58	122.65	99400.0
2005-07-20 09:00:00	SPY	ETF	122.64	122.88	122.51	122.71	7572000.0
2005-07-20 10:00:00	SPY	ETF	122.71	122.74	122.3	122.5	14941600.0
2005-07-20 11:00:00	SPY	ETF	122.49	122.96	122.42	122.85	9102300.0
2005-07-20 12:00:00	SPY	ETF	122.85	122.88	122.68	122.82	2422500.0
2005-07-20 13:00:00	SPY	ETF	122.83	123.55	122.75	123.39	11379300.0
2005-07-20 14:00:00	SPY	ETF	123.39	123.57	123.1	123.21	7248100.0
2005-07-20 15:00:00	SPY	ETF	123.21	123.73	123.16	123.54	11868000.0
2005-07-20 16:00:00	SPY	ETF	123.49	123.61	122.99	123.46	1272600.0
2005-07-20 17:00:00	SPY	ETF	123.47	123.47	123.37	123.45	87100.0
2005-07-20 18:00:00	SPY	ETF	123.41	123.44	123.4	123.41	3900.0
2005-07-20 19:00:00	SPY	ETF	123.41	123.44	123.41	123.41	3800.0
2005-07-20 09:00:00	QQQ	ETF	38.93	39.06	38.9	39.03	13947100.0
2005-07-20 10:00:00	QQQ	ETF	39.03	39.07	38.9	39.03	14597700.0
2005-07-20 11:00:00	QQQ	ETF	39.03	39.19	39.02	39.15	10874200.0
2005-07-20 12:00:00	QQQ	ETF	39.15	39.16	39.08	39.13	4044200.0
2005-07-20 13:00:00	QQQ	ETF	39.13	39.4	39.1	39.3	14283700.0
2005-07-20 14:00:00	QQQ	ETF	39.3	39.4	39.27	39.32	9127700.0
2005-07-20 15:00:00	QQQ	ETF	39.32	39.57	39.29	39.47	17487500.0
2005-07-20 07:00:00	IWM	ETF	66.35	66.35	66.32	66.32	1200.0
2005-07-20 08:00:00	IWM	ETF	66.24	66.32	66.2	66.32	29800.0
2005-07-20 09:00:00	IWM	ETF	66.27	66.6	66.18	66.55	1600600.0
2005-07-20 10:00:00	IWM	ETF	66.54	66.54	66.19	66.5	4319700.0
2005-07-20 11:00:00	IWM	ETF	66.5	66.84	66.45	66.81	3311000.0
2005-07-20 12:00:00	IWM	ETF	66.81	66.87	66.68	66.84	1466100.0
2005-07-20 13:00:00	IWM	ETF	66.83	67.25	66.78	67.14	4232400.0
2005-07-20 14:00:00	IWM	ETF	67.14	67.35	66.97	67.09	4414600.0
2005-07-20 15:00:00	IWM	ETF	67.08	67.55	67.05	67.43	3903900.0
2005-07-20 16:00:00	IWM	ETF	67.43	67.43	67.3	67.4	138200.0
2005-07-20 17:00:00	IWM	ETF	67.41	67.41	67.39	67.39	9400.0
2005-07-20 07:00:00	DIA	ETF	106.2	106.23	106.1	106.1	2700.0
2005-07-20 08:00:00	DIA	ETF	106.05	106.05	105.91	105.96	5100.0
2005-07-20 09:00:00	DIA	ETF	105.89	106.14	105.84	106.05	921900.0
2005-07-20 10:00:00	DIA	ETF	106.04	106.07	105.75	105.88	626200.0
2005-07-20 11:00:00	DIA	ETF	105.88	106.23	105.86	106.13	800400.0
2005-07-20 12:00:00	DIA	ETF	106.15	106.16	106.03	106.11	128300.0
2005-07-20 13:00:00	DIA	ETF	106.11	106.7	106.04	106.59	653100.0
2005-07-20 14:00:00	DIA	ETF	106.6	106.74	106.35	106.44	714500.0
2005-07-20 15:00:00	DIA	ETF	106.45	106.89	106.41	106.76	1491800.0
2005-07-20 16:00:00	DIA	ETF	106.72	106.79	105.89	106.66	331600.0
2005-07-20 17:00:00	DIA	ETF	106.69	106.69	106.69	106.69	500.0
2005-07-20 18:00:00	DIA	ETF	106.64	106.64	106.64	106.64	800.0
2005-07-20 19:00:00	DIA	ETF	106.64	106.64	106.64	106.64	200.0
2005-07-20 08:00:00	GLD	ETF	41.94	42.12	41.94	42.12	15300.0
2005-07-20 09:00:00	GLD	ETF	42.16	42.24	42.16	42.21	454800.0
2005-07-20 10:00:00	GLD	ETF	42.21	42.21	42.07	42.11	394100.0
2005-07-20 11:00:00	GLD	ETF	42.1	42.17	42.05	42.14	174600.0

> showing 50 of 957 rows — these rows as CSV

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