PREVIEW / etf_1hour / 2013-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-28.parquet
  size:    210 KB
  rows:    6,516

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-08-28 04:00:00	SPY	ETF	163.58	163.92	163.58	163.76	34430.0
2013-08-28 05:00:00	SPY	ETF	163.74	163.74	163.44	163.5	14000.0
2013-08-28 06:00:00	SPY	ETF	163.52	163.56	163.34	163.46	41400.0
2013-08-28 07:00:00	SPY	ETF	163.46	163.49	163.18	163.19	594573.0
2013-08-28 08:00:00	SPY	ETF	163.94	163.94	163.18	163.4	709274.0
2013-08-28 09:00:00	SPY	ETF	163.4	163.78	163.05	163.53	15102232.0
2013-08-28 10:00:00	SPY	ETF	163.53	164.02	163.39	163.989	14934661.0
2013-08-28 11:00:00	SPY	ETF	163.99	164.28	163.84	164.24	11314419.0
2013-08-28 12:00:00	SPY	ETF	164.231	164.47	164.12	164.381	7089714.0
2013-08-28 13:00:00	SPY	ETF	164.385	164.49	164.23	164.409	8386041.0
2013-08-28 14:00:00	SPY	ETF	164.4	164.45	163.86	164.001	9969584.0
2013-08-28 15:00:00	SPY	ETF	164.01	164.4	163.85	163.92	17373125.0
2013-08-28 16:00:00	SPY	ETF	163.92	164.372	163.41	163.62	16387250.0
2013-08-28 17:00:00	SPY	ETF	163.62	163.65	163.57	163.62	106197.0
2013-08-28 18:00:00	SPY	ETF	163.62	163.7	163.62	163.7	319751.0
2013-08-28 19:00:00	SPY	ETF	163.7	163.71	163.51	163.62	74206.0
2013-08-28 04:00:00	QQQ	ETF	75.3	75.36	75.25	75.31	27900.0
2013-08-28 05:00:00	QQQ	ETF	75.28	75.28	75.2	75.2	9700.0
2013-08-28 06:00:00	QQQ	ETF	75.24	75.24	75.15	75.2	12700.0
2013-08-28 07:00:00	QQQ	ETF	75.22	75.22	75.08	75.09	64110.0
2013-08-28 08:00:00	QQQ	ETF	75.08	75.33	75.08	75.18	119407.0
2013-08-28 09:00:00	QQQ	ETF	75.15	75.46	75.05	75.34	3434392.0
2013-08-28 10:00:00	QQQ	ETF	75.3432	75.5314	75.2	75.5	3015687.0
2013-08-28 11:00:00	QQQ	ETF	75.51	75.57	75.35	75.55	2515433.0
2013-08-28 12:00:00	QQQ	ETF	75.55	75.72	75.5	75.68	1899566.0
2013-08-28 13:00:00	QQQ	ETF	75.69	75.75	75.62	75.71	1572210.0
2013-08-28 14:00:00	QQQ	ETF	75.72	75.75	75.4501	75.52	1840453.0
2013-08-28 15:00:00	QQQ	ETF	75.52	75.73	75.415	75.43	4033938.0
2013-08-28 16:00:00	QQQ	ETF	75.43	75.48	75.3	75.31	632419.0
2013-08-28 17:00:00	QQQ	ETF	75.31	75.32	75.28	75.28	40300.0
2013-08-28 18:00:00	QQQ	ETF	75.34	75.34	75.32	75.32	7840.0
2013-08-28 19:00:00	QQQ	ETF	75.32	75.32	75.28	75.29	3050.0
2013-08-28 05:00:00	IWM	ETF	101.0	101.0	100.8	100.8	300.0
2013-08-28 07:00:00	IWM	ETF	100.89	100.89	100.55	100.55	43600.0
2013-08-28 08:00:00	IWM	ETF	100.58	100.86	100.58	100.77	139863.0
2013-08-28 09:00:00	IWM	ETF	100.73	101.1	100.5001	100.81	4717608.0
2013-08-28 10:00:00	IWM	ETF	100.8	101.17	100.69	101.13	4140164.0
2013-08-28 11:00:00	IWM	ETF	101.14	101.25	100.95	101.22	2865590.0
2013-08-28 12:00:00	IWM	ETF	101.23	101.34	101.09	101.28	1992276.0
2013-08-28 13:00:00	IWM	ETF	101.27	101.365	101.22	101.335	1674829.0
2013-08-28 14:00:00	IWM	ETF	101.34	101.34	100.79	100.96	3143450.0
2013-08-28 15:00:00	IWM	ETF	100.97	101.23	100.91	100.97	5351318.0
2013-08-28 16:00:00	IWM	ETF	100.96	101.1154	100.7047	100.8	2457612.0
2013-08-28 17:00:00	IWM	ETF	100.8	100.81	100.77	100.77	14200.0
2013-08-28 18:00:00	IWM	ETF	100.89	100.95	100.83	100.95	1224.0
2013-08-28 04:00:00	DIA	ETF	147.96	147.97	147.96	147.97	200.0
2013-08-28 08:00:00	DIA	ETF	147.51	147.51	147.44	147.44	537.0
2013-08-28 09:00:00	DIA	ETF	147.52	147.86	147.37	147.65	649109.0
2013-08-28 10:00:00	DIA	ETF	147.65	147.96	147.5801	147.93	1006675.0
2013-08-28 11:00:00	DIA	ETF	147.93	148.19	147.85	148.14	674582.0

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

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