PREVIEW / etf_1hour / 2010-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-22.parquet
  size:    161 KB
  rows:    4,931

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
2010-06-22 04:00:00	SPY	ETF	111.73	111.73	111.57	111.66	3244.0
2010-06-22 05:00:00	SPY	ETF	111.55	111.55	111.01	111.1	39350.0
2010-06-22 06:00:00	SPY	ETF	110.91	111.64	110.91	111.05	28318.0
2010-06-22 07:00:00	SPY	ETF	111.05	111.31	111.03	111.13	1258964.0
2010-06-22 08:00:00	SPY	ETF	111.14	111.45	110.83	111.45	2322081.0
2010-06-22 09:00:00	SPY	ETF	111.45	111.9	111.33	111.51	21770775.0
2010-06-22 10:00:00	SPY	ETF	111.51	111.62	110.91	111.31	37988779.0
2010-06-22 11:00:00	SPY	ETF	111.32	111.71	110.99	111.4522	24634650.0
2010-06-22 12:00:00	SPY	ETF	111.46	111.53	111.13	111.28	11164601.0
2010-06-22 13:00:00	SPY	ETF	111.28	111.41	110.94	111.07	19983500.0
2010-06-22 14:00:00	SPY	ETF	111.07	111.08	109.76	110.0	43028168.0
2010-06-22 15:00:00	SPY	ETF	110.0001	111.0	109.41	109.57	54948429.0
2010-06-22 16:00:00	SPY	ETF	109.59	111.79	109.42	109.65	11547949.0
2010-06-22 17:00:00	SPY	ETF	109.67	111.3346	109.58	109.62	581104.0
2010-06-22 18:00:00	SPY	ETF	109.62	109.7	109.57	109.67	214835.0
2010-06-22 19:00:00	SPY	ETF	109.65	109.77	109.61	109.64	85766.0
2010-06-22 05:00:00	QQQ	ETF	46.56	46.56	46.56	46.56	400.0
2010-06-22 06:00:00	QQQ	ETF	46.47	46.6	46.47	46.6	18395.0
2010-06-22 07:00:00	QQQ	ETF	46.59	46.7	46.58	46.61	279180.0
2010-06-22 08:00:00	QQQ	ETF	46.66	46.76	46.56	46.76	1007396.0
2010-06-22 09:00:00	QQQ	ETF	46.76	47.14	46.73	46.91	12813382.0
2010-06-22 10:00:00	QQQ	ETF	46.91	46.99	46.63	46.93	18780585.0
2010-06-22 11:00:00	QQQ	ETF	46.93	47.1	46.74	46.9704	10322667.0
2010-06-22 12:00:00	QQQ	ETF	46.97	47.03	46.87	46.92	5298101.0
2010-06-22 13:00:00	QQQ	ETF	46.92	47.0	46.75	46.82	5694709.0
2010-06-22 14:00:00	QQQ	ETF	46.81	46.82	46.29	46.3798	16032590.0
2010-06-22 15:00:00	QQQ	ETF	46.38	46.49	46.15	46.24	15909211.0
2010-06-22 16:00:00	QQQ	ETF	46.24	46.6002	46.19	46.27	3429377.0
2010-06-22 17:00:00	QQQ	ETF	46.27	46.31	46.25	46.28	44869.0
2010-06-22 18:00:00	QQQ	ETF	46.28	46.28	46.25	46.25	39095.0
2010-06-22 19:00:00	QQQ	ETF	46.26	46.3	46.25	46.27	8907.0
2010-06-22 04:00:00	IWM	ETF	66.41	66.41	66.41	66.41	200.0
2010-06-22 05:00:00	IWM	ETF	66.11	66.11	66.11	66.11	200.0
2010-06-22 06:00:00	IWM	ETF	66.01	66.01	66.01	66.01	200.0
2010-06-22 07:00:00	IWM	ETF	66.02	66.15	65.97	66.08	250092.0
2010-06-22 08:00:00	IWM	ETF	66.09	66.39	66.04	66.39	387707.0
2010-06-22 09:00:00	IWM	ETF	66.41	67.1	66.35	66.54	7523181.0
2010-06-22 10:00:00	IWM	ETF	66.6	66.6	66.0	66.44	13494652.0
2010-06-22 11:00:00	IWM	ETF	66.44	66.7699	66.14	66.48	7651114.0
2010-06-22 12:00:00	IWM	ETF	66.48	66.58	66.17	66.26	4007760.0
2010-06-22 13:00:00	IWM	ETF	66.24	66.43	65.93	66.12	4857718.0
2010-06-22 14:00:00	IWM	ETF	66.11	66.11	65.02	65.1	11079014.0
2010-06-22 15:00:00	IWM	ETF	65.11	65.25	64.67	64.77	14175073.0
2010-06-22 16:00:00	IWM	ETF	64.78	66.6	64.59	64.72	1905557.0
2010-06-22 17:00:00	IWM	ETF	64.72	64.75	64.59	64.59	14050.0
2010-06-22 18:00:00	IWM	ETF	64.59	64.72	64.59	64.72	5318.0
2010-06-22 19:00:00	IWM	ETF	64.6	64.76	64.58	64.61	5921.0
2010-06-22 06:00:00	DIA	ETF	104.29	104.29	104.18	104.18	400.0
2010-06-22 07:00:00	DIA	ETF	104.29	104.41	104.27	104.27	800.0
2010-06-22 08:00:00	DIA	ETF	104.26	104.55	104.26	104.53	3200.0

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

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