PREVIEW / etf_1hour / 2012-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-04.parquet
  size:    187 KB
  rows:    5,807

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
2012-04-04 04:00:00	SPY	ETF	140.67	140.67	140.29	140.29	49060.0
2012-04-04 05:00:00	SPY	ETF	140.32	140.37	140.21	140.21	204760.0
2012-04-04 06:00:00	SPY	ETF	140.28	140.44	140.15	140.27	129400.0
2012-04-04 07:00:00	SPY	ETF	140.27	140.39	140.07	140.31	632232.0
2012-04-04 08:00:00	SPY	ETF	140.31	141.15	140.05	140.16	1875901.0
2012-04-04 09:00:00	SPY	ETF	140.14	140.339	140.0	140.27	15604823.0
2012-04-04 10:00:00	SPY	ETF	140.278	140.29	139.4	139.42	33605843.0
2012-04-04 11:00:00	SPY	ETF	139.43	140.3099	139.41	139.7	21283418.0
2012-04-04 12:00:00	SPY	ETF	139.69	139.86	139.62	139.68	8552412.0
2012-04-04 13:00:00	SPY	ETF	139.67	139.79	139.34	139.754	13826113.0
2012-04-04 14:00:00	SPY	ETF	139.76	140.0	139.55	139.8999	15110697.0
2012-04-04 15:00:00	SPY	ETF	139.89	140.14	139.81	139.88	28924119.0
2012-04-04 16:00:00	SPY	ETF	139.87	139.9985	139.72	139.75	5509699.0
2012-04-04 17:00:00	SPY	ETF	139.76	139.77	139.59	139.64	325964.0
2012-04-04 18:00:00	SPY	ETF	139.66	139.82	139.66	139.76	74539.0
2012-04-04 19:00:00	SPY	ETF	139.78	139.85	139.76	139.78	43846.0
2012-04-04 04:00:00	QQQ	ETF	67.92	67.92	67.85	67.85	200.0
2012-04-04 05:00:00	QQQ	ETF	67.75	67.78	67.75	67.76	450.0
2012-04-04 06:00:00	QQQ	ETF	67.74	67.85	67.74	67.81	27550.0
2012-04-04 07:00:00	QQQ	ETF	67.77	67.82	67.67	67.8	93595.0
2012-04-04 08:00:00	QQQ	ETF	67.77	68.0	67.59	67.71	450647.0
2012-04-04 09:00:00	QQQ	ETF	67.71	67.76	67.56	67.65	4715136.0
2012-04-04 10:00:00	QQQ	ETF	67.65	67.65	67.04	67.05	11106847.0
2012-04-04 11:00:00	QQQ	ETF	67.05	67.23	67.05	67.11	5845653.0
2012-04-04 12:00:00	QQQ	ETF	67.12	67.1999	67.05	67.079	3981271.0
2012-04-04 13:00:00	QQQ	ETF	67.08	67.115	66.91	67.11	5883038.0
2012-04-04 14:00:00	QQQ	ETF	67.11	67.26	67.03	67.165	5446725.0
2012-04-04 15:00:00	QQQ	ETF	67.165	67.43	67.12	67.3	9992737.0
2012-04-04 16:00:00	QQQ	ETF	67.31	67.3682	67.2	67.23	792075.0
2012-04-04 17:00:00	QQQ	ETF	67.22	67.22	67.13	67.19	9700.0
2012-04-04 18:00:00	QQQ	ETF	67.19	67.26	67.19	67.25	12100.0
2012-04-04 19:00:00	QQQ	ETF	67.26	67.28	67.24	67.25	20120.0
2012-04-04 04:00:00	IWM	ETF	82.75	82.75	82.75	82.75	100.0
2012-04-04 06:00:00	IWM	ETF	82.4	82.49	82.4	82.49	31200.0
2012-04-04 07:00:00	IWM	ETF	82.28	82.49	82.25	82.42	18526.0
2012-04-04 08:00:00	IWM	ETF	82.4	82.82	82.25	82.28	326974.0
2012-04-04 09:00:00	IWM	ETF	82.29	82.44	82.04	82.36	5863265.0
2012-04-04 10:00:00	IWM	ETF	82.37	82.37	81.49	81.54	14511056.0
2012-04-04 11:00:00	IWM	ETF	81.54	81.83	81.52	81.75	6377799.0
2012-04-04 12:00:00	IWM	ETF	81.75	81.79	81.59	81.65	3152901.0
2012-04-04 13:00:00	IWM	ETF	81.65	81.71	81.45	81.6955	4314487.0
2012-04-04 14:00:00	IWM	ETF	81.7	81.79	81.49	81.7375	5118491.0
2012-04-04 15:00:00	IWM	ETF	81.73	81.97	81.67	81.93	9277168.0
2012-04-04 16:00:00	IWM	ETF	81.94	83.3041	81.68	81.71	5128615.0
2012-04-04 17:00:00	IWM	ETF	81.69	81.69	81.63	81.64	7821.0
2012-04-04 19:00:00	IWM	ETF	81.64	81.7	81.64	81.7	11541.0
2012-04-04 07:00:00	DIA	ETF	130.78	130.78	130.72	130.72	800.0
2012-04-04 08:00:00	DIA	ETF	130.94	130.95	130.62	130.62	22950.0
2012-04-04 09:00:00	DIA	ETF	130.62	130.769	130.47	130.72	675330.0
2012-04-04 10:00:00	DIA	ETF	130.71	130.73	129.95	129.97	4243614.0

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

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