PREVIEW / etf_1hour / 2010-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-18.parquet
  size:    171 KB
  rows:    5,239

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-10-18 04:00:00	SPY	ETF	117.55	117.55	116.97	117.32	32960.0
2010-10-18 05:00:00	SPY	ETF	117.29	117.55	117.29	117.53	11300.0
2010-10-18 06:00:00	SPY	ETF	117.5	117.64	117.42	117.56	33475.0
2010-10-18 07:00:00	SPY	ETF	117.57	117.59	117.41	117.43	411350.0
2010-10-18 08:00:00	SPY	ETF	117.47	117.82	117.26	117.81	1033793.0
2010-10-18 09:00:00	SPY	ETF	117.81	118.1	117.51	117.99	19589310.0
2010-10-18 10:00:00	SPY	ETF	117.99	118.28	117.86	118.21	29009442.0
2010-10-18 11:00:00	SPY	ETF	118.22	118.25	117.31	118.01	15231201.0
2010-10-18 12:00:00	SPY	ETF	118.02	118.1	117.92	117.98	10196196.0
2010-10-18 13:00:00	SPY	ETF	117.97	118.13	117.97	118.06	8504001.0
2010-10-18 14:00:00	SPY	ETF	118.0575	118.35	117.99	118.32	12671598.0
2010-10-18 15:00:00	SPY	ETF	118.3141	118.67	118.31	118.55	28042077.0
2010-10-18 16:00:00	SPY	ETF	118.54	118.66	117.6	117.65	11500154.0
2010-10-18 17:00:00	SPY	ETF	117.65	117.91	117.63	117.8	3367685.0
2010-10-18 18:00:00	SPY	ETF	117.77	117.8	117.61	117.72	371989.0
2010-10-18 19:00:00	SPY	ETF	117.73	117.87	117.73	117.84	70246.0
2010-10-18 04:00:00	QQQ	ETF	51.37	51.37	51.21	51.27	1000.0
2010-10-18 05:00:00	QQQ	ETF	51.37	51.37	51.37	51.37	100.0
2010-10-18 07:00:00	QQQ	ETF	51.38	51.43	51.35	51.36	270851.0
2010-10-18 08:00:00	QQQ	ETF	51.38	51.57	51.32	51.53	561452.0
2010-10-18 09:00:00	QQQ	ETF	51.53	51.61	51.33	51.5599	8439619.0
2010-10-18 10:00:00	QQQ	ETF	51.55	51.63	51.45	51.55	10700839.0
2010-10-18 11:00:00	QQQ	ETF	51.55	51.56	51.35	51.43	7362245.0
2010-10-18 12:00:00	QQQ	ETF	51.44	51.47	51.35	51.36	3809332.0
2010-10-18 13:00:00	QQQ	ETF	51.37	51.45	51.36	51.39	4931245.0
2010-10-18 14:00:00	QQQ	ETF	51.39	51.54	51.38	51.5	5884316.0
2010-10-18 15:00:00	QQQ	ETF	51.51	51.69	51.505	51.68	11266645.0
2010-10-18 16:00:00	QQQ	ETF	51.68	51.73	50.56	50.65	15433924.0
2010-10-18 17:00:00	QQQ	ETF	50.65	50.85	50.62	50.75	1915443.0
2010-10-18 18:00:00	QQQ	ETF	50.76	50.79	50.7	50.76	133237.0
2010-10-18 19:00:00	QQQ	ETF	50.77	50.81	50.76	50.78	54885.0
2010-10-18 05:00:00	IWM	ETF	70.29	70.38	70.29	70.37	2700.0
2010-10-18 06:00:00	IWM	ETF	70.48	70.48	70.43	70.43	4000.0
2010-10-18 07:00:00	IWM	ETF	70.35	70.36	70.26	70.27	213200.0
2010-10-18 08:00:00	IWM	ETF	70.27	70.53	69.94	70.53	478250.0
2010-10-18 09:00:00	IWM	ETF	70.5	70.78	70.26	70.66	5245066.0
2010-10-18 10:00:00	IWM	ETF	70.67	70.95	70.56	70.89	6773657.0
2010-10-18 11:00:00	IWM	ETF	70.9	70.93	70.49	70.6501	3061549.0
2010-10-18 12:00:00	IWM	ETF	70.65	70.78	70.56	70.59	2091601.0
2010-10-18 13:00:00	IWM	ETF	70.59	70.741	70.5701	70.7099	3150016.0
2010-10-18 14:00:00	IWM	ETF	70.7	70.88	70.65	70.815	5156349.0
2010-10-18 15:00:00	IWM	ETF	70.82	71.02	70.61	71.02	7934712.0
2010-10-18 16:00:00	IWM	ETF	71.02	71.03	70.26	70.32	2597975.0
2010-10-18 17:00:00	IWM	ETF	70.29	70.53	70.28	70.48	1343204.0
2010-10-18 18:00:00	IWM	ETF	70.54	70.54	70.37	70.42	5578.0
2010-10-18 19:00:00	IWM	ETF	70.39	70.46	70.37	70.37	7802.0
2010-10-18 05:00:00	DIA	ETF	110.4	110.4	110.4	110.4	203.0
2010-10-18 07:00:00	DIA	ETF	110.45	110.47	110.45	110.47	5100.0
2010-10-18 08:00:00	DIA	ETF	110.34	110.73	110.34	110.7	10460.0
2010-10-18 09:00:00	DIA	ETF	110.7	111.11	110.52	111.04	851421.0

> showing 50 of 5,239 rows — these rows as CSV

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