PREVIEW / etf_1hour / 2005-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-15.parquet
  size:    30 KB
  rows:    909

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-15 07:00:00	SPY	ETF	122.89	122.89	122.79	122.8	2800.0
2005-07-15 08:00:00	SPY	ETF	122.81	122.98	122.72	122.74	982600.0
2005-07-15 09:00:00	SPY	ETF	122.79	122.85	122.52	122.57	13667200.0
2005-07-15 10:00:00	SPY	ETF	122.57	122.64	122.42	122.5	6229800.0
2005-07-15 11:00:00	SPY	ETF	122.52	122.69	122.44	122.54	4647700.0
2005-07-15 12:00:00	SPY	ETF	122.53	122.57	122.36	122.47	6299700.0
2005-07-15 13:00:00	SPY	ETF	122.46	122.63	122.46	122.58	4994700.0
2005-07-15 14:00:00	SPY	ETF	122.58	123.04	122.55	122.96	7976900.0
2005-07-15 15:00:00	SPY	ETF	122.95	122.99	122.7	122.78	8132900.0
2005-07-15 16:00:00	SPY	ETF	122.77	122.88	122.77	122.79	1392200.0
2005-07-15 17:00:00	SPY	ETF	122.8	122.82	122.76	122.82	43300.0
2005-07-15 18:00:00	SPY	ETF	122.8	122.8	122.79	122.79	400.0
2005-07-15 09:00:00	QQQ	ETF	38.84	38.86	38.69	38.72	10559800.0
2005-07-15 10:00:00	QQQ	ETF	38.71	38.75	38.65	38.69	11446600.0
2005-07-15 11:00:00	QQQ	ETF	38.69	38.79	38.69	38.74	7294000.0
2005-07-15 12:00:00	QQQ	ETF	38.75	38.76	38.69	38.72	4467200.0
2005-07-15 13:00:00	QQQ	ETF	38.72	38.79	38.71	38.77	3979000.0
2005-07-15 14:00:00	QQQ	ETF	38.77	38.99	38.75	38.99	13974000.0
2005-07-15 15:00:00	QQQ	ETF	38.99	39.0	38.85	38.88	12345300.0
2005-07-15 08:00:00	IWM	ETF	65.97	65.97	65.9	65.9	6000.0
2005-07-15 09:00:00	IWM	ETF	65.91	65.95	65.53	65.68	2074700.0
2005-07-15 10:00:00	IWM	ETF	65.69	65.7	65.42	65.52	3877200.0
2005-07-15 11:00:00	IWM	ETF	65.53	65.79	65.53	65.6	2247200.0
2005-07-15 12:00:00	IWM	ETF	65.6	65.67	65.49	65.66	689100.0
2005-07-15 13:00:00	IWM	ETF	65.66	65.78	65.64	65.74	788300.0
2005-07-15 14:00:00	IWM	ETF	65.74	66.16	65.71	66.14	3206200.0
2005-07-15 15:00:00	IWM	ETF	66.14	66.2	65.96	66.05	2629800.0
2005-07-15 16:00:00	IWM	ETF	66.06	66.06	65.97	66.05	74100.0
2005-07-15 19:00:00	IWM	ETF	66.02	66.02	66.02	66.02	100.0
2005-07-15 07:00:00	DIA	ETF	106.45	106.45	106.35	106.35	700.0
2005-07-15 08:00:00	DIA	ETF	106.5	106.53	106.3	106.35	59600.0
2005-07-15 09:00:00	DIA	ETF	106.41	106.41	106.11	106.17	970200.0
2005-07-15 10:00:00	DIA	ETF	106.17	106.23	106.01	106.11	644300.0
2005-07-15 11:00:00	DIA	ETF	106.12	106.27	106.02	106.06	340100.0
2005-07-15 12:00:00	DIA	ETF	106.07	106.092	105.91	106.0	495600.0
2005-07-15 13:00:00	DIA	ETF	105.99	106.11	105.99	106.06	246100.0
2005-07-15 14:00:00	DIA	ETF	106.06	106.46	106.06	106.44	1381700.0
2005-07-15 15:00:00	DIA	ETF	106.44	106.45	106.22	106.28	633900.0
2005-07-15 16:00:00	DIA	ETF	106.32	106.33	106.27	106.32	112500.0
2005-07-15 18:00:00	DIA	ETF	106.29	106.29	106.29	106.29	1800.0
2005-07-15 08:00:00	GLD	ETF	41.77	41.81	41.77	41.81	20000.0
2005-07-15 09:00:00	GLD	ETF	41.8	41.8	41.7	41.79	291400.0
2005-07-15 10:00:00	GLD	ETF	41.79	41.95	41.73	41.93	288800.0
2005-07-15 11:00:00	GLD	ETF	41.94	41.96	41.91	41.94	126300.0
2005-07-15 12:00:00	GLD	ETF	41.93	42.0	41.92	41.9802	148600.0
2005-07-15 13:00:00	GLD	ETF	41.98	42.03	41.98	42.0	31400.0
2005-07-15 14:00:00	GLD	ETF	42.0	42.07	42.0	42.07	98300.0
2005-07-15 15:00:00	GLD	ETF	42.06	42.06	41.98	42.05	92800.0
2005-07-15 16:00:00	GLD	ETF	42.04	42.04	42.04	42.04	1800.0
2005-07-15 08:00:00	TLT	ETF	93.71	93.78	93.71	93.78	9600.0

> showing 50 of 909 rows — these rows as CSV

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