PREVIEW / etf_1hour / 2014-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-13.parquet
  size:    213 KB
  rows:    6,822

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-06-13 04:00:00	SPY	ETF	193.6	193.9	193.59	193.9	4494.0
2014-06-13 05:00:00	SPY	ETF	193.78	193.79	193.53	193.53	5447.0
2014-06-13 06:00:00	SPY	ETF	193.5	193.58	193.3	193.34	76319.0
2014-06-13 07:00:00	SPY	ETF	193.35	193.6	193.2	193.58	465322.0
2014-06-13 08:00:00	SPY	ETF	193.43	193.67	193.34	193.67	1906169.0
2014-06-13 09:00:00	SPY	ETF	193.68	193.98	193.44	193.625	9497256.0
2014-06-13 10:00:00	SPY	ETF	193.62	194.3	193.3	194.2	12856476.0
2014-06-13 11:00:00	SPY	ETF	194.2	194.32	193.83	193.93	6099070.0
2014-06-13 12:00:00	SPY	ETF	193.93	194.15	193.86	193.901	4482760.0
2014-06-13 13:00:00	SPY	ETF	193.9	194.06	193.79	194.03	6070367.0
2014-06-13 14:00:00	SPY	ETF	194.03	194.17	193.98	194.07	3638671.0
2014-06-13 15:00:00	SPY	ETF	194.065	194.32	193.68	194.14	23031895.0
2014-06-13 16:00:00	SPY	ETF	194.14	194.28	194.06	194.2	12541440.0
2014-06-13 17:00:00	SPY	ETF	194.2	194.21	194.13	194.19	168634.0
2014-06-13 18:00:00	SPY	ETF	194.17	194.18	194.17	194.18	11675.0
2014-06-13 19:00:00	SPY	ETF	194.18	194.2	194.17	194.2	13344.0
2014-06-13 04:00:00	QQQ	ETF	92.16	92.28	92.16	92.28	8000.0
2014-06-13 06:00:00	QQQ	ETF	92.08	92.18	92.08	92.15	3550.0
2014-06-13 07:00:00	QQQ	ETF	92.14	92.26	92.09	92.25	273690.0
2014-06-13 08:00:00	QQQ	ETF	92.23	92.31	92.13	92.31	354101.0
2014-06-13 09:00:00	QQQ	ETF	92.32	92.48	92.11	92.23	7151934.0
2014-06-13 10:00:00	QQQ	ETF	92.23	92.52	91.92	92.52	5985307.0
2014-06-13 11:00:00	QQQ	ETF	92.52	92.55	92.17	92.23	1917168.0
2014-06-13 12:00:00	QQQ	ETF	92.23	92.4	92.21	92.22	1570510.0
2014-06-13 13:00:00	QQQ	ETF	92.219	92.32	92.15	92.31	1880626.0
2014-06-13 14:00:00	QQQ	ETF	92.31	92.38	92.24	92.26	1128835.0
2014-06-13 15:00:00	QQQ	ETF	92.265	92.379	92.03	92.31	4337370.0
2014-06-13 16:00:00	QQQ	ETF	92.31	92.36	92.0277	92.34	1532038.0
2014-06-13 17:00:00	QQQ	ETF	92.34	92.34	92.34	92.34	7900.0
2014-06-13 18:00:00	QQQ	ETF	92.32	92.34	92.32	92.34	1300.0
2014-06-13 19:00:00	QQQ	ETF	92.33	92.34	92.3	92.3	2562.0
2014-06-13 05:00:00	IWM	ETF	115.14	115.14	115.14	115.14	100.0
2014-06-13 06:00:00	IWM	ETF	115.32	115.32	115.32	115.32	100.0
2014-06-13 07:00:00	IWM	ETF	115.47	115.47	115.44	115.44	6900.0
2014-06-13 08:00:00	IWM	ETF	115.46	115.49	115.23	115.47	278414.0
2014-06-13 09:00:00	IWM	ETF	115.47	115.73	114.97	115.06	3864770.0
2014-06-13 10:00:00	IWM	ETF	115.06	115.89	114.66	115.88	6985974.0
2014-06-13 11:00:00	IWM	ETF	115.88	115.91	115.34	115.44	3668031.0
2014-06-13 12:00:00	IWM	ETF	115.44	115.65	115.39	115.49	1960047.0
2014-06-13 13:00:00	IWM	ETF	115.485	115.71	115.43	115.65	1896859.0
2014-06-13 14:00:00	IWM	ETF	115.65	115.8	115.58	115.68	2035590.0
2014-06-13 15:00:00	IWM	ETF	115.69	115.84	115.29	115.62	7568887.0
2014-06-13 16:00:00	IWM	ETF	115.61	115.79	115.0747	115.67	979218.0
2014-06-13 17:00:00	IWM	ETF	115.3569	115.71	115.3569	115.63	263801.0
2014-06-13 07:00:00	DIA	ETF	167.22	167.34	167.22	167.34	2500.0
2014-06-13 08:00:00	DIA	ETF	167.33	167.36	167.29	167.36	1352.0
2014-06-13 09:00:00	DIA	ETF	167.39	167.65	167.19	167.34	407886.0
2014-06-13 10:00:00	DIA	ETF	167.33	167.83	167.13	167.68	449708.0
2014-06-13 11:00:00	DIA	ETF	167.69	167.8201	167.51	167.6	261914.0
2014-06-13 12:00:00	DIA	ETF	167.61	167.72	167.48	167.48	236236.0

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

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