PREVIEW / etf_1hour / 2012-08-23

all etf 1-hour files

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

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-23 04:00:00	SPY	ETF	142.24	142.24	142.0	142.04	2006.0
2012-08-23 05:00:00	SPY	ETF	142.09	142.29	142.09	142.25	1750.0
2012-08-23 06:00:00	SPY	ETF	142.28	142.28	142.11	142.18	44005.0
2012-08-23 07:00:00	SPY	ETF	142.18	142.23	141.74	141.76	226866.0
2012-08-23 08:00:00	SPY	ETF	141.79	142.39	141.4	141.45	2958405.0
2012-08-23 09:00:00	SPY	ETF	141.43	141.82	140.91	141.0	13566047.0
2012-08-23 10:00:00	SPY	ETF	140.99	141.3	140.8	141.18	22173929.0
2012-08-23 11:00:00	SPY	ETF	141.18	141.33	140.98	141.12	11637569.0
2012-08-23 12:00:00	SPY	ETF	141.13	141.15	140.78	140.84	11533504.0
2012-08-23 13:00:00	SPY	ETF	140.83	140.85	140.44	140.65	10671225.0
2012-08-23 14:00:00	SPY	ETF	140.65	140.9	140.6	140.76	11697190.0
2012-08-23 15:00:00	SPY	ETF	140.75	140.95	140.56	140.69	17682589.0
2012-08-23 16:00:00	SPY	ETF	140.68	141.7678	140.57	140.62	6486339.0
2012-08-23 17:00:00	SPY	ETF	140.66	140.78	140.65	140.7	306456.0
2012-08-23 18:00:00	SPY	ETF	140.71	140.8	140.7	140.78	42907.0
2012-08-23 19:00:00	SPY	ETF	140.78	140.81	140.73	140.77	49127.0
2012-08-23 04:00:00	QQQ	ETF	68.42	68.42	68.42	68.42	500.0
2012-08-23 05:00:00	QQQ	ETF	68.58	68.58	68.58	68.58	270.0
2012-08-23 07:00:00	QQQ	ETF	68.53	68.53	68.31	68.34	58854.0
2012-08-23 08:00:00	QQQ	ETF	68.34	68.56	68.14	68.18	151239.0
2012-08-23 09:00:00	QQQ	ETF	68.16	68.4	67.84	67.89	3164229.0
2012-08-23 10:00:00	QQQ	ETF	67.89	68.13	67.72	68.072	5733899.0
2012-08-23 11:00:00	QQQ	ETF	68.08	68.34	68.0	68.118	2440626.0
2012-08-23 12:00:00	QQQ	ETF	68.12	68.12	67.86	67.9175	2525074.0
2012-08-23 13:00:00	QQQ	ETF	67.9199	67.95	67.6905	67.89	2648126.0
2012-08-23 14:00:00	QQQ	ETF	67.89	68.06	67.83	67.98	2172700.0
2012-08-23 15:00:00	QQQ	ETF	67.98	68.14	67.85	67.87	4481872.0
2012-08-23 16:00:00	QQQ	ETF	67.88	68.3956	67.81	67.85	4580878.0
2012-08-23 17:00:00	QQQ	ETF	67.86	67.9	67.85	67.9	1776.0
2012-08-23 18:00:00	QQQ	ETF	67.87	67.87	67.87	67.87	9823.0
2012-08-23 19:00:00	QQQ	ETF	67.89	67.92	67.89	67.92	1900.0
2012-08-23 07:00:00	IWM	ETF	81.61	81.61	81.31	81.32	26583.0
2012-08-23 08:00:00	IWM	ETF	81.32	81.73	81.0	81.01	241301.0
2012-08-23 09:00:00	IWM	ETF	80.98	81.1	80.52	80.63	3686345.0
2012-08-23 10:00:00	IWM	ETF	80.64	80.93	80.44	80.77	5045089.0
2012-08-23 11:00:00	IWM	ETF	80.78	80.8611	80.6	80.79	3009437.0
2012-08-23 12:00:00	IWM	ETF	80.8	80.81	80.4	80.47	3568558.0
2012-08-23 13:00:00	IWM	ETF	80.47	80.48	80.2	80.411	2909171.0
2012-08-23 14:00:00	IWM	ETF	80.41	80.73	80.36	80.61	1959976.0
2012-08-23 15:00:00	IWM	ETF	80.6	80.775	80.45	80.58	4180481.0
2012-08-23 16:00:00	IWM	ETF	80.57	80.6	80.46	80.49	4673506.0
2012-08-23 17:00:00	IWM	ETF	80.49	80.79	80.49	80.79	1320.0
2012-08-23 18:00:00	IWM	ETF	80.58	80.58	80.58	80.58	200.0
2012-08-23 19:00:00	IWM	ETF	80.6	80.6	80.6	80.6	200.0
2012-08-23 08:00:00	DIA	ETF	131.78	131.78	131.2	131.2	22230.0
2012-08-23 09:00:00	DIA	ETF	131.22	131.32	130.6	130.69	466798.0
2012-08-23 10:00:00	DIA	ETF	130.68	130.9	130.49	130.78	723690.0
2012-08-23 11:00:00	DIA	ETF	130.78	130.86	130.58	130.69	480987.0
2012-08-23 12:00:00	DIA	ETF	130.71	130.71	130.45	130.5	437830.0
2012-08-23 13:00:00	DIA	ETF	130.5	130.51	130.2	130.335	566151.0

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

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