PREVIEW / etf_1hour / 2009-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-30.parquet
  size:    144 KB
  rows:    4,514

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
2009-12-30 04:00:00	SPY	ETF	112.29	112.29	111.92	112.03	5356.0
2009-12-30 05:00:00	SPY	ETF	111.99	112.0	111.9	112.0	4400.0
2009-12-30 06:00:00	SPY	ETF	111.75	111.91	111.75	111.88	3300.0
2009-12-30 07:00:00	SPY	ETF	111.87	112.19	111.87	112.12	371137.0
2009-12-30 08:00:00	SPY	ETF	112.11	112.21	112.09	112.2	611907.0
2009-12-30 09:00:00	SPY	ETF	112.21	112.65	112.11	112.54	15766697.0
2009-12-30 10:00:00	SPY	ETF	112.55	112.64	112.25	112.34	11298110.0
2009-12-30 11:00:00	SPY	ETF	112.34	112.51	112.21	112.4701	8193750.0
2009-12-30 12:00:00	SPY	ETF	112.48	112.56	112.2	112.39	6547559.0
2009-12-30 13:00:00	SPY	ETF	112.4	112.5	112.27	112.37	5630612.0
2009-12-30 14:00:00	SPY	ETF	112.37	112.54	112.36	112.502	4504538.0
2009-12-30 15:00:00	SPY	ETF	112.5	112.62	112.37	112.55	11439644.0
2009-12-30 16:00:00	SPY	ETF	112.52	112.67	112.23	112.67	6346393.0
2009-12-30 17:00:00	SPY	ETF	112.67	112.69	112.45	112.66	861944.0
2009-12-30 18:00:00	SPY	ETF	112.66	112.69	112.6	112.6	126870.0
2009-12-30 19:00:00	SPY	ETF	112.61	112.71	112.57	112.7	41511.0
2009-12-30 05:00:00	QQQ	ETF	45.86	45.86	45.86	45.86	300.0
2009-12-30 06:00:00	QQQ	ETF	45.87	45.9	45.84	45.84	24718.0
2009-12-30 07:00:00	QQQ	ETF	45.89	45.98	45.89	45.94	19687.0
2009-12-30 08:00:00	QQQ	ETF	45.94	45.97	45.88	45.95	231343.0
2009-12-30 09:00:00	QQQ	ETF	45.95	46.26	45.94	46.19	13697647.0
2009-12-30 10:00:00	QQQ	ETF	46.2	46.23	45.97	46.0101	8310592.0
2009-12-30 11:00:00	QQQ	ETF	46.01	46.12	45.96	46.0899	6527101.0
2009-12-30 12:00:00	QQQ	ETF	46.09	46.14	46.06	46.09	3871420.0
2009-12-30 13:00:00	QQQ	ETF	46.08	46.13	46.0	46.08	8137150.0
2009-12-30 14:00:00	QQQ	ETF	46.09	46.15	46.05	46.12	3872042.0
2009-12-30 15:00:00	QQQ	ETF	46.12	46.2	46.07	46.17	6119726.0
2009-12-30 16:00:00	QQQ	ETF	46.16	46.2	46.0261	46.19	2189581.0
2009-12-30 17:00:00	QQQ	ETF	46.19	46.2	46.18	46.18	13000.0
2009-12-30 18:00:00	QQQ	ETF	46.19	46.22	46.17	46.2	44476.0
2009-12-30 19:00:00	QQQ	ETF	46.2	46.22	46.2	46.22	27750.0
2009-12-30 07:00:00	IWM	ETF	62.89	62.98	62.86	62.97	20100.0
2009-12-30 08:00:00	IWM	ETF	62.86	63.09	62.71	63.05	116657.0
2009-12-30 09:00:00	IWM	ETF	63.04	63.49	62.97	63.309	5536564.0
2009-12-30 10:00:00	IWM	ETF	63.29	63.33	62.69	62.8201	5769192.0
2009-12-30 11:00:00	IWM	ETF	62.82	63.17	62.78	63.16	4379984.0
2009-12-30 12:00:00	IWM	ETF	63.1509	63.31	62.93	63.0	3872271.0
2009-12-30 13:00:00	IWM	ETF	62.99	63.07	62.65	62.79	3590822.0
2009-12-30 14:00:00	IWM	ETF	62.79	63.07	62.78	62.939	2221376.0
2009-12-30 15:00:00	IWM	ETF	62.939	63.3	62.8	63.22	6898833.0
2009-12-30 16:00:00	IWM	ETF	63.22	63.31	63.1222	63.3	1773019.0
2009-12-30 17:00:00	IWM	ETF	63.26	63.31	63.26	63.31	7102.0
2009-12-30 18:00:00	IWM	ETF	63.28	63.28	63.28	63.28	100.0
2009-12-30 08:00:00	DIA	ETF	104.86	104.95	104.85	104.94	8200.0
2009-12-30 09:00:00	DIA	ETF	104.93	105.3	104.87	105.26	908648.0
2009-12-30 10:00:00	DIA	ETF	105.25	105.33	105.06	105.135	508376.0
2009-12-30 11:00:00	DIA	ETF	105.16	105.27	105.02	105.255	445048.0
2009-12-30 12:00:00	DIA	ETF	105.26	105.32	105.12	105.15	161242.0
2009-12-30 13:00:00	DIA	ETF	105.16	105.25	105.07	105.15	143717.0
2009-12-30 14:00:00	DIA	ETF	105.145	105.24	105.14	105.205	148784.0

> showing 50 of 4,514 rows — these rows as CSV

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