PREVIEW / etf_1hour / 2014-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-22.parquet
  size:    233 KB
  rows:    7,390

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-22 04:00:00	SPY	ETF	194.25	194.25	193.7	193.88	72883.0
2014-10-22 05:00:00	SPY	ETF	193.87	194.05	193.84	193.84	200711.0
2014-10-22 06:00:00	SPY	ETF	193.91	194.14	193.8	194.08	157360.0
2014-10-22 07:00:00	SPY	ETF	194.09	194.29	193.93	194.25	668379.0
2014-10-22 08:00:00	SPY	ETF	194.25	194.63	193.93	194.53	2005113.0
2014-10-22 09:00:00	SPY	ETF	194.55	194.72	193.92	194.64	16702004.0
2014-10-22 10:00:00	SPY	ETF	194.65	194.68	194.055	194.43	17198614.0
2014-10-22 11:00:00	SPY	ETF	194.43	194.91	194.36	194.611	14076637.0
2014-10-22 12:00:00	SPY	ETF	194.61	194.7	193.42	193.9	19142395.0
2014-10-22 13:00:00	SPY	ETF	193.9	194.09	193.15	193.21	17351019.0
2014-10-22 14:00:00	SPY	ETF	193.2	193.71	192.92	193.68	23204177.0
2014-10-22 15:00:00	SPY	ETF	193.69	193.73	192.61	192.71	28691152.0
2014-10-22 16:00:00	SPY	ETF	192.72	193.8838	192.6553	193.05	8575506.0
2014-10-22 17:00:00	SPY	ETF	193.06	193.09	192.69	193.05	1454997.0
2014-10-22 18:00:00	SPY	ETF	193.05	193.3	192.94	193.3	221105.0
2014-10-22 19:00:00	SPY	ETF	193.31	193.4	193.11	193.21	177339.0
2014-10-22 04:00:00	QQQ	ETF	96.9	96.9	96.89	96.89	3283.0
2014-10-22 05:00:00	QQQ	ETF	96.99	97.02	96.94	97.02	3900.0
2014-10-22 06:00:00	QQQ	ETF	96.94	97.12	96.92	97.06	20513.0
2014-10-22 07:00:00	QQQ	ETF	97.06	97.14	96.96	97.08	128872.0
2014-10-22 08:00:00	QQQ	ETF	97.06	97.22	96.92	97.17	262865.0
2014-10-22 09:00:00	QQQ	ETF	97.19	97.27	96.671	97.22	6867823.0
2014-10-22 10:00:00	QQQ	ETF	97.23	97.25	96.79	97.08	5064232.0
2014-10-22 11:00:00	QQQ	ETF	97.08	97.3	97.01	97.04	3891134.0
2014-10-22 12:00:00	QQQ	ETF	97.045	97.1	96.47	96.77	5141477.0
2014-10-22 13:00:00	QQQ	ETF	96.78	96.899	96.585	96.64	4325883.0
2014-10-22 14:00:00	QQQ	ETF	96.64	96.86	96.49	96.85	4316586.0
2014-10-22 15:00:00	QQQ	ETF	96.85	96.88	96.305	96.35	6785377.0
2014-10-22 16:00:00	QQQ	ETF	96.34	97.2	96.3257	96.55	1447138.0
2014-10-22 17:00:00	QQQ	ETF	96.55	96.62	96.5	96.51	39864.0
2014-10-22 18:00:00	QQQ	ETF	96.51	96.62	96.45	96.62	32817.0
2014-10-22 19:00:00	QQQ	ETF	96.63	96.7	96.53	96.61	11700.0
2014-10-22 07:00:00	IWM	ETF	110.63	110.63	110.58	110.63	6100.0
2014-10-22 08:00:00	IWM	ETF	110.64	110.77	110.5	110.76	144101.0
2014-10-22 09:00:00	IWM	ETF	110.76	110.94	110.29	110.88	4838996.0
2014-10-22 10:00:00	IWM	ETF	110.88	110.94	110.36	110.8	6171347.0
2014-10-22 11:00:00	IWM	ETF	110.81	111.06	110.68	110.695	4508723.0
2014-10-22 12:00:00	IWM	ETF	110.69	110.78	109.61	110.01	8134892.0
2014-10-22 13:00:00	IWM	ETF	110.02	110.16	109.5	109.62	5362687.0
2014-10-22 14:00:00	IWM	ETF	109.61	109.75	109.32	109.69	4917997.0
2014-10-22 15:00:00	IWM	ETF	109.68	109.735	108.86	108.93	7988096.0
2014-10-22 16:00:00	IWM	ETF	108.94	110.5475	108.9	109.07	1581349.0
2014-10-22 17:00:00	IWM	ETF	109.06	109.07	108.8	109.02	68693.0
2014-10-22 18:00:00	IWM	ETF	109.21	109.21	109.21	109.21	1950.0
2014-10-22 19:00:00	IWM	ETF	109.21	109.21	109.09	109.09	850.0
2014-10-22 09:00:00	DIA	ETF	166.01	166.18	165.67	166.03	1033415.0
2014-10-22 10:00:00	DIA	ETF	166.05	166.17	165.76	165.84	1169397.0
2014-10-22 11:00:00	DIA	ETF	165.85	166.2327	165.82	165.92	514827.0
2014-10-22 12:00:00	DIA	ETF	165.91	165.98	165.09	165.35	718802.0
2014-10-22 13:00:00	DIA	ETF	165.35	165.44	164.72	164.77	694209.0

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

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