PREVIEW / etf_1hour / 2013-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-01.parquet
  size:    199 KB
  rows:    6,208

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
2013-03-01 04:00:00	SPY	ETF	151.6	151.74	151.29	151.29	24332.0
2013-03-01 05:00:00	SPY	ETF	151.32	151.41	151.22	151.34	131858.0
2013-03-01 06:00:00	SPY	ETF	151.34	151.34	151.1	151.2	172601.0
2013-03-01 07:00:00	SPY	ETF	151.21	151.22	150.85	150.92	541083.0
2013-03-01 08:00:00	SPY	ETF	150.9	151.78	150.79	151.13	2177992.0
2013-03-01 09:00:00	SPY	ETF	151.13	151.61	150.41	150.9	26093814.0
2013-03-01 10:00:00	SPY	ETF	150.9	152.01	150.895	152.01	32826035.0
2013-03-01 11:00:00	SPY	ETF	152.01	152.17	151.36	151.64	22724999.0
2013-03-01 12:00:00	SPY	ETF	151.63	152.33	151.62	152.27	13139391.0
2013-03-01 13:00:00	SPY	ETF	152.26	152.34	151.86	152.07	10883034.0
2013-03-01 14:00:00	SPY	ETF	152.07	152.28	151.86	152.08	10493513.0
2013-03-01 15:00:00	SPY	ETF	152.08	152.2	151.86	152.13	31490676.0
2013-03-01 16:00:00	SPY	ETF	152.13	152.23	151.3	152.03	15284395.0
2013-03-01 17:00:00	SPY	ETF	152.03	152.12	151.99	152.08	398201.0
2013-03-01 18:00:00	SPY	ETF	152.08	152.11	152.05	152.11	11361.0
2013-03-01 19:00:00	SPY	ETF	152.11	152.14	152.03	152.03	17586.0
2013-03-01 04:00:00	QQQ	ETF	67.2	67.27	67.2	67.27	2500.0
2013-03-01 05:00:00	QQQ	ETF	67.08	67.08	67.05	67.05	1200.0
2013-03-01 06:00:00	QQQ	ETF	67.01	67.01	66.97	66.97	7600.0
2013-03-01 07:00:00	QQQ	ETF	66.99	66.99	66.84	66.87	18543.0
2013-03-01 08:00:00	QQQ	ETF	66.82	66.92	66.8	66.9	569362.0
2013-03-01 09:00:00	QQQ	ETF	66.9	66.91	66.54	66.6954	5254308.0
2013-03-01 10:00:00	QQQ	ETF	66.7	67.32	66.673	67.31	7018222.0
2013-03-01 11:00:00	QQQ	ETF	67.32	67.43	67.03	67.17	4603480.0
2013-03-01 12:00:00	QQQ	ETF	67.16	67.5	67.16	67.45	2839176.0
2013-03-01 13:00:00	QQQ	ETF	67.44	67.49	67.28	67.38	2277910.0
2013-03-01 14:00:00	QQQ	ETF	67.39	67.47	67.29	67.36	2670380.0
2013-03-01 15:00:00	QQQ	ETF	67.36	67.46	67.31	67.39	3846098.0
2013-03-01 16:00:00	QQQ	ETF	67.39	67.44	66.736	67.43	864975.0
2013-03-01 17:00:00	QQQ	ETF	67.43	67.46	67.42	67.42	7742.0
2013-03-01 18:00:00	QQQ	ETF	67.42	67.43	67.42	67.43	960.0
2013-03-01 19:00:00	QQQ	ETF	67.44	67.45	67.44	67.45	552.0
2013-03-01 07:00:00	IWM	ETF	90.24	90.24	89.8	89.8	69673.0
2013-03-01 08:00:00	IWM	ETF	89.81	90.55	89.73	89.97	476968.0
2013-03-01 09:00:00	IWM	ETF	89.93	89.96	89.21	89.64	10408474.0
2013-03-01 10:00:00	IWM	ETF	89.64	90.43	89.631	90.42	8886825.0
2013-03-01 11:00:00	IWM	ETF	90.42	90.55	90.09	90.37	5636716.0
2013-03-01 12:00:00	IWM	ETF	90.36	90.8	90.34	90.76	3288938.0
2013-03-01 13:00:00	IWM	ETF	90.76	90.82	90.62	90.76	2923355.0
2013-03-01 14:00:00	IWM	ETF	90.76	90.95	90.59	90.75	3564596.0
2013-03-01 15:00:00	IWM	ETF	90.74	91.06	90.66	90.9	7661259.0
2013-03-01 16:00:00	IWM	ETF	90.89	91.0	90.796	90.92	1478492.0
2013-03-01 17:00:00	IWM	ETF	90.94	90.96	90.9	90.91	75900.0
2013-03-01 19:00:00	IWM	ETF	90.95	90.95	90.95	90.95	600.0
2013-03-01 06:00:00	DIA	ETF	139.97	139.97	139.97	139.97	100.0
2013-03-01 07:00:00	DIA	ETF	139.93	139.93	139.73	139.74	8300.0
2013-03-01 08:00:00	DIA	ETF	139.76	139.9	139.67	139.9	10322.0
2013-03-01 09:00:00	DIA	ETF	139.9	139.94	139.17	139.6	1618966.0
2013-03-01 10:00:00	DIA	ETF	139.75	140.56	139.5605	140.56	1425157.0
2013-03-01 11:00:00	DIA	ETF	140.56	140.67	140.05	140.26	977248.0

> showing 50 of 6,208 rows — these rows as CSV

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