PREVIEW / etf_1hour / 2014-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-20.parquet
  size:    232 KB
  rows:    7,313

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
2014-10-20 04:00:00	SPY	ETF	188.9	189.38	188.75	188.75	19519.0
2014-10-20 05:00:00	SPY	ETF	188.81	189.26	188.77	189.09	52458.0
2014-10-20 06:00:00	SPY	ETF	189.19	189.2	188.44	188.44	418121.0
2014-10-20 07:00:00	SPY	ETF	188.44	188.68	187.94	188.14	1594818.0
2014-10-20 08:00:00	SPY	ETF	188.15	189.0284	188.1	188.46	1694909.0
2014-10-20 09:00:00	SPY	ETF	188.48	189.44	187.86	188.9799	20088701.0
2014-10-20 10:00:00	SPY	ETF	188.98	189.5	188.53	189.13	23146098.0
2014-10-20 11:00:00	SPY	ETF	189.13	189.58	188.895	189.3967	12496661.0
2014-10-20 12:00:00	SPY	ETF	189.39	189.64	189.05	189.14	9432866.0
2014-10-20 13:00:00	SPY	ETF	189.1399	189.74	189.05	189.54	8743169.0
2014-10-20 14:00:00	SPY	ETF	189.53	190.03	189.515	189.97	9203022.0
2014-10-20 15:00:00	SPY	ETF	189.97	190.45	189.93	190.32	22793710.0
2014-10-20 16:00:00	SPY	ETF	190.32	191.0	188.4955	190.77	9296016.0
2014-10-20 17:00:00	SPY	ETF	190.75	191.0	189.34	190.93	421494.0
2014-10-20 18:00:00	SPY	ETF	190.93	190.93	190.78	190.8	149765.0
2014-10-20 19:00:00	SPY	ETF	190.78	190.89	190.4	190.47	252711.0
2014-10-20 04:00:00	QQQ	ETF	93.29	93.3	93.29	93.3	300.0
2014-10-20 05:00:00	QQQ	ETF	93.23	93.37	93.22	93.37	6900.0
2014-10-20 06:00:00	QQQ	ETF	93.34	93.34	93.11	93.14	15300.0
2014-10-20 07:00:00	QQQ	ETF	93.04	93.08	92.62	92.89	584493.0
2014-10-20 08:00:00	QQQ	ETF	92.92	93.2	92.77	93.11	417300.0
2014-10-20 09:00:00	QQQ	ETF	93.11	93.52	92.76	93.46	6758742.0
2014-10-20 10:00:00	QQQ	ETF	93.46	93.82	93.32	93.65	8289384.0
2014-10-20 11:00:00	QQQ	ETF	93.65	93.77	93.47	93.7	2783574.0
2014-10-20 12:00:00	QQQ	ETF	93.69	93.93	93.67	93.71	2288458.0
2014-10-20 13:00:00	QQQ	ETF	93.71	94.01	93.61	93.89	2223335.0
2014-10-20 14:00:00	QQQ	ETF	93.89	94.235	93.8733	94.23	3471865.0
2014-10-20 15:00:00	QQQ	ETF	94.23	94.47	94.19	94.4	7112813.0
2014-10-20 16:00:00	QQQ	ETF	94.4	94.81	93.0752	94.79	1904915.0
2014-10-20 17:00:00	QQQ	ETF	94.78	94.92	93.0752	94.88	599457.0
2014-10-20 18:00:00	QQQ	ETF	94.88	94.88	94.75	94.75	166263.0
2014-10-20 19:00:00	QQQ	ETF	94.76	94.8	94.53	94.57	63690.0
2014-10-20 07:00:00	IWM	ETF	107.0	107.14	106.82	106.82	148610.0
2014-10-20 08:00:00	IWM	ETF	106.82	107.28	106.82	107.16	512223.0
2014-10-20 09:00:00	IWM	ETF	107.19	108.48	106.72	108.12	7501004.0
2014-10-20 10:00:00	IWM	ETF	108.11	108.63	107.79	108.31	5435920.0
2014-10-20 11:00:00	IWM	ETF	108.3	108.47	108.13	108.28	3199401.0
2014-10-20 12:00:00	IWM	ETF	108.28	108.39	107.99	108.005	1929543.0
2014-10-20 13:00:00	IWM	ETF	108.0	108.4	107.95	108.25	1996419.0
2014-10-20 14:00:00	IWM	ETF	108.25	108.43	108.18	108.34	2089404.0
2014-10-20 15:00:00	IWM	ETF	108.331	108.74	108.25	108.73	5696981.0
2014-10-20 16:00:00	IWM	ETF	108.72	109.02	108.4936	109.0	2013841.0
2014-10-20 17:00:00	IWM	ETF	108.99	109.32	108.99	109.25	84842.0
2014-10-20 18:00:00	IWM	ETF	109.17	109.17	109.08	109.12	530.0
2014-10-20 19:00:00	IWM	ETF	109.03	109.14	108.74	108.74	1600.0
2014-10-20 05:00:00	DIA	ETF	163.9	164.0	163.9	164.0	400.0
2014-10-20 07:00:00	DIA	ETF	163.1	163.1	162.6	162.75	9600.0
2014-10-20 08:00:00	DIA	ETF	162.56	163.04	162.56	162.72	22000.0
2014-10-20 09:00:00	DIA	ETF	162.66	162.98	161.92	162.865	2163924.0
2014-10-20 10:00:00	DIA	ETF	162.88	163.24	162.5	162.958	1328413.0

> showing 50 of 7,313 rows — these rows as CSV

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