PREVIEW / etf_1hour / 2012-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-21.parquet
  size:    188 KB
  rows:    5,784

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-21 04:00:00	SPY	ETF	142.3	142.48	142.3	142.48	2034.0
2012-08-21 05:00:00	SPY	ETF	142.41	142.42	142.33	142.33	2026.0
2012-08-21 06:00:00	SPY	ETF	142.42	142.45	142.4	142.42	3950.0
2012-08-21 07:00:00	SPY	ETF	142.42	142.47	142.33	142.47	32055.0
2012-08-21 08:00:00	SPY	ETF	142.45	142.67	142.35	142.6	654211.0
2012-08-21 09:00:00	SPY	ETF	142.59	142.76	142.46	142.74	10497847.0
2012-08-21 10:00:00	SPY	ETF	142.74	143.09	142.74	142.92	15897113.0
2012-08-21 11:00:00	SPY	ETF	142.91	142.96	142.385	142.45	18588233.0
2012-08-21 12:00:00	SPY	ETF	142.44	142.53	142.24	142.33	7729813.0
2012-08-21 13:00:00	SPY	ETF	142.34	142.34	141.89	142.0715	8336852.0
2012-08-21 14:00:00	SPY	ETF	142.08	142.15	141.79	141.87	9768754.0
2012-08-21 15:00:00	SPY	ETF	141.875	141.88	141.45	141.77	21602764.0
2012-08-21 16:00:00	SPY	ETF	141.78	142.59	141.68	141.85	6883400.0
2012-08-21 17:00:00	SPY	ETF	141.85	141.88	141.7823	141.86	5067074.0
2012-08-21 18:00:00	SPY	ETF	141.85	141.85	141.69	141.72	103265.0
2012-08-21 19:00:00	SPY	ETF	141.75	141.75	141.67	141.74	87420.0
2012-08-21 04:00:00	QQQ	ETF	68.43	68.49	68.43	68.49	600.0
2012-08-21 05:00:00	QQQ	ETF	68.5	68.5	68.5	68.5	1000.0
2012-08-21 06:00:00	QQQ	ETF	68.51	68.53	68.51	68.53	700.0
2012-08-21 07:00:00	QQQ	ETF	68.51	68.53	68.48	68.53	3900.0
2012-08-21 08:00:00	QQQ	ETF	68.52	68.66	68.49	68.6	167011.0
2012-08-21 09:00:00	QQQ	ETF	68.61	68.76	68.56	68.73	4470854.0
2012-08-21 10:00:00	QQQ	ETF	68.73	68.88	68.55	68.59	6181569.0
2012-08-21 11:00:00	QQQ	ETF	68.59	68.64	68.33	68.34	4587621.0
2012-08-21 12:00:00	QQQ	ETF	68.34	68.37	68.14	68.195	3900192.0
2012-08-21 13:00:00	QQQ	ETF	68.195	68.2	67.89	68.06	4731352.0
2012-08-21 14:00:00	QQQ	ETF	68.06	68.23	68.04	68.1	4245029.0
2012-08-21 15:00:00	QQQ	ETF	68.1	68.15	67.88	68.14	5768050.0
2012-08-21 16:00:00	QQQ	ETF	68.14	68.4183	67.9597	68.19	3907999.0
2012-08-21 17:00:00	QQQ	ETF	68.19	68.2	68.16	68.17	10459.0
2012-08-21 18:00:00	QQQ	ETF	68.17	68.17	68.11	68.11	23652.0
2012-08-21 19:00:00	QQQ	ETF	68.11	68.13	68.1	68.13	10990.0
2012-08-21 06:00:00	IWM	ETF	81.75	81.75	81.75	81.75	200.0
2012-08-21 07:00:00	IWM	ETF	81.76	81.78	81.71	81.78	50500.0
2012-08-21 08:00:00	IWM	ETF	81.78	81.98	81.68	81.92	587063.0
2012-08-21 09:00:00	IWM	ETF	81.88	82.18	81.82	82.16	4718763.0
2012-08-21 10:00:00	IWM	ETF	82.16	82.71	82.151	82.53	8851292.0
2012-08-21 11:00:00	IWM	ETF	82.53	82.57	82.07	82.15	4993640.0
2012-08-21 12:00:00	IWM	ETF	82.15	82.17	81.86	81.97	2834785.0
2012-08-21 13:00:00	IWM	ETF	81.96	81.96	81.4	81.62	3144172.0
2012-08-21 14:00:00	IWM	ETF	81.63	81.74	81.45	81.56	3091687.0
2012-08-21 15:00:00	IWM	ETF	81.56	81.56	81.19	81.47	5747167.0
2012-08-21 16:00:00	IWM	ETF	81.46	81.56	81.46	81.55	1246208.0
2012-08-21 17:00:00	IWM	ETF	81.5	81.5	81.44	81.45	35410.0
2012-08-21 18:00:00	IWM	ETF	81.44	81.5	81.42	81.43	2195.0
2012-08-21 19:00:00	IWM	ETF	81.42	81.42	81.39	81.39	1756.0
2012-08-21 08:00:00	DIA	ETF	132.45	132.65	132.45	132.62	8185.0
2012-08-21 09:00:00	DIA	ETF	132.63	132.72	132.445	132.69	310918.0
2012-08-21 10:00:00	DIA	ETF	132.69	133.02	132.69	132.9	834385.0
2012-08-21 11:00:00	DIA	ETF	132.905	132.94	132.38	132.42	351434.0

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

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