PREVIEW / etf_1hour / 2005-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-16.parquet
  size:    31 KB
  rows:    948

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-16 07:00:00	SPY	ETF	123.61	123.65	123.6	123.63	263800.0
2005-08-16 08:00:00	SPY	ETF	123.61	123.74	123.49	123.51	894100.0
2005-08-16 09:00:00	SPY	ETF	123.51	123.61	123.16	123.26	5665600.0
2005-08-16 10:00:00	SPY	ETF	123.26	123.44	122.73	122.82	13244700.0
2005-08-16 11:00:00	SPY	ETF	122.83	123.02	122.74	122.78	10248600.0
2005-08-16 12:00:00	SPY	ETF	122.77	122.89	122.6	122.78	9950300.0
2005-08-16 13:00:00	SPY	ETF	122.8	122.94	122.64	122.65	2716800.0
2005-08-16 14:00:00	SPY	ETF	122.66	122.82	122.49	122.7	6316700.0
2005-08-16 15:00:00	SPY	ETF	122.71	122.84	122.11	122.12	16025200.0
2005-08-16 16:00:00	SPY	ETF	122.1	122.26	122.09	122.25	988400.0
2005-08-16 17:00:00	SPY	ETF	122.25	122.3	122.18	122.3	135800.0
2005-08-16 18:00:00	SPY	ETF	122.3	122.33	122.29	122.3	26300.0
2005-08-16 19:00:00	SPY	ETF	122.32	122.32	122.27	122.28	7600.0
2005-08-16 09:00:00	QQQ	ETF	39.3	39.33	39.2	39.27	8697800.0
2005-08-16 10:00:00	QQQ	ETF	39.27	39.3	38.99	39.06	17994900.0
2005-08-16 11:00:00	QQQ	ETF	39.05	39.15	39.01	39.05	10226000.0
2005-08-16 12:00:00	QQQ	ETF	39.05	39.14	39.01	39.09	5390500.0
2005-08-16 13:00:00	QQQ	ETF	39.09	39.15	38.94	38.95	8924900.0
2005-08-16 14:00:00	QQQ	ETF	38.95	39.29	38.87	38.95	9689300.0
2005-08-16 15:00:00	QQQ	ETF	38.95	38.99	38.74	38.82	22605400.0
2005-08-16 08:00:00	IWM	ETF	66.12	66.2	66.12	66.13	3200.0
2005-08-16 09:00:00	IWM	ETF	66.13	66.13	65.61	65.69	2763900.0
2005-08-16 10:00:00	IWM	ETF	65.7	65.82	65.34	65.42	2816900.0
2005-08-16 11:00:00	IWM	ETF	65.43	65.59	65.39	65.4	1638800.0
2005-08-16 12:00:00	IWM	ETF	65.41	65.52	65.35	65.46	2087300.0
2005-08-16 13:00:00	IWM	ETF	65.45	65.58	65.42	65.47	1481200.0
2005-08-16 14:00:00	IWM	ETF	65.47	65.56	65.29	65.52	2711100.0
2005-08-16 15:00:00	IWM	ETF	65.53	65.6	65.12	65.12	4777000.0
2005-08-16 16:00:00	IWM	ETF	65.11	65.18	65.08	65.18	119300.0
2005-08-16 17:00:00	IWM	ETF	65.1	65.18	65.1	65.18	80400.0
2005-08-16 18:00:00	IWM	ETF	65.16	65.16	65.16	65.16	400.0
2005-08-16 08:00:00	DIA	ETF	106.45	106.55	106.31	106.31	41200.0
2005-08-16 09:00:00	DIA	ETF	106.31	106.4	106.1	106.17	511300.0
2005-08-16 10:00:00	DIA	ETF	106.17	106.34	105.71	105.76	1044000.0
2005-08-16 11:00:00	DIA	ETF	105.75	105.88	105.68	105.73	632800.0
2005-08-16 12:00:00	DIA	ETF	105.72	105.79	105.57	105.75	1114100.0
2005-08-16 13:00:00	DIA	ETF	105.75	105.86	105.6	105.62	337000.0
2005-08-16 14:00:00	DIA	ETF	105.62	105.8	105.48	105.8	1477100.0
2005-08-16 15:00:00	DIA	ETF	105.8	105.84	105.23	105.28	1366600.0
2005-08-16 16:00:00	DIA	ETF	105.25	105.49	105.25	105.48	257200.0
2005-08-16 17:00:00	DIA	ETF	105.57	105.57	105.57	105.57	100.0
2005-08-16 18:00:00	DIA	ETF	105.57	105.57	105.47	105.47	200.0
2005-08-16 19:00:00	DIA	ETF	105.5	105.5	105.5	105.5	200.0
2005-08-16 09:00:00	GLD	ETF	44.08	44.26	44.05	44.26	376900.0
2005-08-16 10:00:00	GLD	ETF	44.26	44.26	44.2	44.22	137000.0
2005-08-16 11:00:00	GLD	ETF	44.25	44.37	44.23	44.34	155100.0
2005-08-16 12:00:00	GLD	ETF	44.35	44.5	44.31	44.49	353700.0
2005-08-16 13:00:00	GLD	ETF	44.5	44.55	44.46	44.53	173000.0
2005-08-16 14:00:00	GLD	ETF	44.53	44.57	44.47	44.5	258300.0
2005-08-16 15:00:00	GLD	ETF	44.47	44.52	44.47	44.49	270000.0

> showing 50 of 948 rows — these rows as CSV

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