PREVIEW / etf_1hour / 2013-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-27.parquet
  size:    208 KB
  rows:    6,662

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-27 04:00:00	SPY	ETF	183.76	183.76	183.72	183.72	8100.0
2013-12-27 05:00:00	SPY	ETF	183.7	183.7	183.53	183.53	14000.0
2013-12-27 06:00:00	SPY	ETF	183.66	183.78	183.66	183.73	18600.0
2013-12-27 07:00:00	SPY	ETF	183.73	183.97	183.7	183.97	68074.0
2013-12-27 08:00:00	SPY	ETF	183.64	183.97	183.59	183.94	640373.0
2013-12-27 09:00:00	SPY	ETF	183.94	184.18	183.93	184.03	10011687.0
2013-12-27 10:00:00	SPY	ETF	184.03	184.13	183.66	183.6697	11642536.0
2013-12-27 11:00:00	SPY	ETF	183.67	183.98	183.66	183.888	6969173.0
2013-12-27 12:00:00	SPY	ETF	183.89	183.92	183.71	183.74	3765763.0
2013-12-27 13:00:00	SPY	ETF	183.7351	183.82	183.69	183.79	4122358.0
2013-12-27 14:00:00	SPY	ETF	183.785	183.94	183.76	183.77	5913402.0
2013-12-27 15:00:00	SPY	ETF	183.76	183.91	183.76	183.83	12178145.0
2013-12-27 16:00:00	SPY	ETF	183.83	184.07	183.81	183.8851	5417337.0
2013-12-27 17:00:00	SPY	ETF	183.89	183.9	183.679	183.7	205826.0
2013-12-27 18:00:00	SPY	ETF	183.72	183.8	183.72	183.79	16050.0
2013-12-27 19:00:00	SPY	ETF	183.8	183.85	183.77	183.85	3335.0
2013-12-27 05:00:00	QQQ	ETF	87.7	87.7	87.68	87.7	1456.0
2013-12-27 06:00:00	QQQ	ETF	87.75	87.79	87.75	87.79	2696.0
2013-12-27 07:00:00	QQQ	ETF	87.77	87.85	87.77	87.85	7420.0
2013-12-27 08:00:00	QQQ	ETF	87.85	87.85	87.78	87.8	33570.0
2013-12-27 09:00:00	QQQ	ETF	87.819	87.9	87.71	87.72	2468059.0
2013-12-27 10:00:00	QQQ	ETF	87.72	87.85	87.51	87.5105	2438276.0
2013-12-27 11:00:00	QQQ	ETF	87.51	87.71	87.51	87.64	1586042.0
2013-12-27 12:00:00	QQQ	ETF	87.64	87.66	87.54	87.55	1234429.0
2013-12-27 13:00:00	QQQ	ETF	87.56	87.58	87.49	87.53	1237769.0
2013-12-27 14:00:00	QQQ	ETF	87.54	87.595	87.47	87.47	924700.0
2013-12-27 15:00:00	QQQ	ETF	87.47	87.52	87.412	87.52	3824228.0
2013-12-27 16:00:00	QQQ	ETF	87.52	87.746	87.48	87.51	895160.0
2013-12-27 18:00:00	QQQ	ETF	87.51	87.54	87.51	87.54	2600.0
2013-12-27 19:00:00	QQQ	ETF	87.51	87.57	87.51	87.57	1857.0
2013-12-27 08:00:00	IWM	ETF	115.39	115.39	115.26	115.36	63283.0
2013-12-27 09:00:00	IWM	ETF	115.38	115.74	115.225	115.27	1869337.0
2013-12-27 10:00:00	IWM	ETF	115.27	115.32	114.78	114.855	3331011.0
2013-12-27 11:00:00	IWM	ETF	114.86	115.045	114.845	115.02	2480216.0
2013-12-27 12:00:00	IWM	ETF	115.01	115.05	114.84	114.895	1231143.0
2013-12-27 13:00:00	IWM	ETF	114.9	114.97	114.81	114.928	1142791.0
2013-12-27 14:00:00	IWM	ETF	114.925	115.095	114.92	115.0101	2494963.0
2013-12-27 15:00:00	IWM	ETF	115.01	115.17	114.97	115.15	3306785.0
2013-12-27 16:00:00	IWM	ETF	115.15	115.21	115.12	115.13	439117.0
2013-12-27 17:00:00	IWM	ETF	115.15	115.16	115.12	115.12	6500.0
2013-12-27 18:00:00	IWM	ETF	115.29	115.29	115.11	115.11	480.0
2013-12-27 19:00:00	IWM	ETF	115.0	115.28	115.0	115.28	200.0
2013-12-27 07:00:00	DIA	ETF	164.61	164.61	164.61	164.61	100.0
2013-12-27 08:00:00	DIA	ETF	164.5	164.67	164.5	164.65	6161.0
2013-12-27 09:00:00	DIA	ETF	164.65	164.92	164.65	164.6577	1111126.0
2013-12-27 10:00:00	DIA	ETF	164.66	164.76	164.25	164.26	1360405.0
2013-12-27 11:00:00	DIA	ETF	164.26	164.56	164.22	164.51	553931.0
2013-12-27 12:00:00	DIA	ETF	164.51	164.53	164.29	164.32	1015524.0
2013-12-27 13:00:00	DIA	ETF	164.32	164.48	164.27	164.4101	282896.0
2013-12-27 14:00:00	DIA	ETF	164.42	164.49	164.32	164.38	501621.0

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

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