PREVIEW / etf_1hour / 2012-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-22.parquet
  size:    184 KB
  rows:    5,714

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-08-22 04:00:00	SPY	ETF	141.41	141.75	141.41	141.75	2200.0
2012-08-22 05:00:00	SPY	ETF	141.7	141.7	141.56	141.57	1250.0
2012-08-22 06:00:00	SPY	ETF	141.59	141.71	141.43	141.43	44200.0
2012-08-22 07:00:00	SPY	ETF	141.47	141.52	141.41	141.47	183414.0
2012-08-22 08:00:00	SPY	ETF	141.49	141.76	141.3	141.49	2261220.0
2012-08-22 09:00:00	SPY	ETF	141.49	141.72	141.25	141.605	15194809.0
2012-08-22 10:00:00	SPY	ETF	141.605	141.75	141.32	141.33	16123286.0
2012-08-22 11:00:00	SPY	ETF	141.33	141.7343	141.19	141.41	12529143.0
2012-08-22 12:00:00	SPY	ETF	141.42	141.7342	141.07	141.11	9818913.0
2012-08-22 13:00:00	SPY	ETF	141.11	141.7342	141.08	141.26	17333924.0
2012-08-22 14:00:00	SPY	ETF	141.26	141.99	141.26	141.94	24447705.0
2012-08-22 15:00:00	SPY	ETF	141.95	142.05	141.71	141.79	19047465.0
2012-08-22 16:00:00	SPY	ETF	141.8	141.93	141.1649	141.87	15374602.0
2012-08-22 17:00:00	SPY	ETF	141.87	141.93	141.82	141.85	76538.0
2012-08-22 18:00:00	SPY	ETF	141.85	141.87	141.79	141.85	149501.0
2012-08-22 19:00:00	SPY	ETF	141.85	141.96	141.82	141.96	145890.0
2012-08-22 05:00:00	QQQ	ETF	68.07	68.07	68.07	68.07	300.0
2012-08-22 06:00:00	QQQ	ETF	68.09	68.09	68.09	68.09	500.0
2012-08-22 07:00:00	QQQ	ETF	67.99	68.0	67.96	67.99	22450.0
2012-08-22 08:00:00	QQQ	ETF	68.02	68.11	67.97	68.03	192783.0
2012-08-22 09:00:00	QQQ	ETF	68.04	68.16	67.81	68.13	7183593.0
2012-08-22 10:00:00	QQQ	ETF	68.14	68.24	67.99	68.06	4102987.0
2012-08-22 11:00:00	QQQ	ETF	68.06	68.17	67.99	68.158	3707670.0
2012-08-22 12:00:00	QQQ	ETF	68.155	68.19	67.94	67.97	2664821.0
2012-08-22 13:00:00	QQQ	ETF	67.96	68.19	67.94	68.07	1799458.0
2012-08-22 14:00:00	QQQ	ETF	68.08	68.4777	68.06	68.46	6987221.0
2012-08-22 15:00:00	QQQ	ETF	68.46	68.5601	68.35	68.4	5806304.0
2012-08-22 16:00:00	QQQ	ETF	68.4	68.45	67.9521	68.38	5163119.0
2012-08-22 17:00:00	QQQ	ETF	68.4	68.42	68.37	68.37	10960.0
2012-08-22 18:00:00	QQQ	ETF	68.37	68.38	68.35	68.36	19545.0
2012-08-22 19:00:00	QQQ	ETF	68.38	68.4	68.35	68.4	9100.0
2012-08-22 06:00:00	IWM	ETF	81.2	81.2	81.2	81.2	4000.0
2012-08-22 07:00:00	IWM	ETF	81.13	81.27	81.13	81.27	6300.0
2012-08-22 08:00:00	IWM	ETF	81.21	81.44	81.21	81.33	117708.0
2012-08-22 09:00:00	IWM	ETF	81.34	81.5	81.01	81.18	5476956.0
2012-08-22 10:00:00	IWM	ETF	81.18	81.47	81.07	81.08	4341970.0
2012-08-22 11:00:00	IWM	ETF	81.08	81.23	80.98	81.14	2845644.0
2012-08-22 12:00:00	IWM	ETF	81.14	81.18	80.8	80.83	2548033.0
2012-08-22 13:00:00	IWM	ETF	80.83	81.01	80.79	80.895	2199922.0
2012-08-22 14:00:00	IWM	ETF	80.9	81.43	80.88	81.31	8604423.0
2012-08-22 15:00:00	IWM	ETF	81.31	81.38	81.04	81.09	5116362.0
2012-08-22 16:00:00	IWM	ETF	81.09	81.17	81.05	81.09	1301091.0
2012-08-22 17:00:00	IWM	ETF	81.11	81.14	81.1	81.1	5400.0
2012-08-22 18:00:00	IWM	ETF	81.12	81.12	81.12	81.12	200.0
2012-08-22 19:00:00	IWM	ETF	81.11	81.11	81.11	81.11	400.0
2012-08-22 08:00:00	DIA	ETF	131.69	131.73	131.53	131.55	11300.0
2012-08-22 09:00:00	DIA	ETF	131.63	131.801	131.48	131.68	683172.0
2012-08-22 10:00:00	DIA	ETF	131.69	131.74	131.29	131.29	569011.0
2012-08-22 11:00:00	DIA	ETF	131.3	131.4	131.1	131.247	723460.0
2012-08-22 12:00:00	DIA	ETF	131.25	131.28	130.94	131.03	477575.0

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

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