PREVIEW / etf_1hour / 2013-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-26.parquet
  size:    206 KB
  rows:    6,561

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-12-26 04:00:00	SPY	ETF	183.3	183.36	183.24	183.36	1200.0
2013-12-26 05:00:00	SPY	ETF	183.33	183.33	183.33	183.33	100.0
2013-12-26 06:00:00	SPY	ETF	183.33	183.49	183.28	183.39	8585.0
2013-12-26 07:00:00	SPY	ETF	183.37	183.44	183.28	183.36	51854.0
2013-12-26 08:00:00	SPY	ETF	183.37	183.51	183.31	183.5	358075.0
2013-12-26 09:00:00	SPY	ETF	183.48	183.53	183.32	183.37	7545670.0
2013-12-26 10:00:00	SPY	ETF	183.36	183.6318	183.36	183.46	6588435.0
2013-12-26 11:00:00	SPY	ETF	183.455	183.64	183.39	183.5597	5455476.0
2013-12-26 12:00:00	SPY	ETF	183.555	183.729	183.48	183.685	5942728.0
2013-12-26 13:00:00	SPY	ETF	183.69	183.87	183.67	183.87	3689018.0
2013-12-26 14:00:00	SPY	ETF	183.87	183.9	183.74	183.85	8712412.0
2013-12-26 15:00:00	SPY	ETF	183.84	183.96	183.79	183.87	15870364.0
2013-12-26 16:00:00	SPY	ETF	183.86	183.89	183.32	183.83	7417046.0
2013-12-26 17:00:00	SPY	ETF	183.85	183.88	183.81	183.82	60106.0
2013-12-26 18:00:00	SPY	ETF	183.82	183.83	183.75	183.76	75942.0
2013-12-26 19:00:00	SPY	ETF	183.75	183.78	183.66	183.66	81502.0
2013-12-26 05:00:00	QQQ	ETF	87.44	87.52	87.44	87.52	1700.0
2013-12-26 06:00:00	QQQ	ETF	87.56	87.68	87.56	87.6	5900.0
2013-12-26 07:00:00	QQQ	ETF	87.61	87.62	87.58	87.62	2129.0
2013-12-26 08:00:00	QQQ	ETF	87.61	87.67	87.59	87.66	89721.0
2013-12-26 09:00:00	QQQ	ETF	87.66	87.68	87.44	87.45	2270145.0
2013-12-26 10:00:00	QQQ	ETF	87.45	87.668	87.45	87.6253	2070339.0
2013-12-26 11:00:00	QQQ	ETF	87.6299	87.75	87.61	87.6875	1341837.0
2013-12-26 12:00:00	QQQ	ETF	87.69	87.74	87.65	87.74	1541559.0
2013-12-26 13:00:00	QQQ	ETF	87.74	87.79	87.7	87.7899	1372749.0
2013-12-26 14:00:00	QQQ	ETF	87.785	87.79	87.68	87.74	1004560.0
2013-12-26 15:00:00	QQQ	ETF	87.74	87.81	87.72	87.73	2988749.0
2013-12-26 16:00:00	QQQ	ETF	87.74	87.79	87.4587	87.78	1328701.0
2013-12-26 17:00:00	QQQ	ETF	87.8	87.83	87.8	87.81	86722.0
2013-12-26 18:00:00	QQQ	ETF	87.79	87.79	87.76	87.76	6250.0
2013-12-26 19:00:00	QQQ	ETF	87.73	87.73	87.68	87.68	6950.0
2013-12-26 06:00:00	IWM	ETF	115.68	115.68	115.68	115.68	700.0
2013-12-26 07:00:00	IWM	ETF	115.67	115.67	115.67	115.67	1350.0
2013-12-26 08:00:00	IWM	ETF	115.62	115.78	115.62	115.77	278717.0
2013-12-26 09:00:00	IWM	ETF	115.75	115.97	115.63	115.65	3228523.0
2013-12-26 10:00:00	IWM	ETF	115.655	115.89	115.4	115.4899	3455138.0
2013-12-26 11:00:00	IWM	ETF	115.49	115.575	115.39	115.4051	1503489.0
2013-12-26 12:00:00	IWM	ETF	115.409	115.43	115.1	115.37	1625191.0
2013-12-26 13:00:00	IWM	ETF	115.37	115.44	115.33	115.38	1486924.0
2013-12-26 14:00:00	IWM	ETF	115.38	115.39	115.26	115.3299	1352019.0
2013-12-26 15:00:00	IWM	ETF	115.32	115.53	115.21	115.22	3915272.0
2013-12-26 16:00:00	IWM	ETF	115.22	115.5119	115.21	115.3	864513.0
2013-12-26 17:00:00	IWM	ETF	115.47	115.47	115.47	115.47	100.0
2013-12-26 18:00:00	IWM	ETF	115.2	115.2	115.2	115.2	100.0
2013-12-26 07:00:00	DIA	ETF	163.5	163.69	163.5	163.69	600.0
2013-12-26 08:00:00	DIA	ETF	163.67	163.74	163.67	163.73	38620.0
2013-12-26 09:00:00	DIA	ETF	163.73	163.9	163.58	163.89	1037780.0
2013-12-26 10:00:00	DIA	ETF	163.89	163.96	163.73	163.795	655083.0
2013-12-26 11:00:00	DIA	ETF	163.796	163.97	163.72	163.9465	378657.0
2013-12-26 12:00:00	DIA	ETF	163.95	164.16	163.91	164.13	336914.0

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

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