PREVIEW / etf_1hour / 2015-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-05.parquet
  size:    245 KB
  rows:    7,792

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
2015-05-05 04:00:00	SPY	ETF	211.24	211.64	211.2	211.22	20108.0
2015-05-05 05:00:00	SPY	ETF	211.24	211.42	211.1	211.32	49510.0
2015-05-05 06:00:00	SPY	ETF	211.32	211.35	211.04	211.13	41014.0
2015-05-05 07:00:00	SPY	ETF	211.12	211.34	211.01	211.29	163056.0
2015-05-05 08:00:00	SPY	ETF	211.31	211.41	210.65	210.77	1055016.0
2015-05-05 09:00:00	SPY	ETF	210.79	211.46	210.57	210.63	10669485.0
2015-05-05 10:00:00	SPY	ETF	210.64	210.88	210.27	210.51	17423534.0
2015-05-05 11:00:00	SPY	ETF	210.51	210.51	209.5	209.9301	14431342.0
2015-05-05 12:00:00	SPY	ETF	209.9301	210.23	209.75	209.77	6929441.0
2015-05-05 13:00:00	SPY	ETF	209.79	209.83	209.16	209.4	11155147.0
2015-05-05 14:00:00	SPY	ETF	209.405	209.62	208.741	208.93	14547691.0
2015-05-05 15:00:00	SPY	ETF	208.93	209.36	208.73	208.9	26452714.0
2015-05-05 16:00:00	SPY	ETF	208.89	209.15	208.8695	209.11	7147756.0
2015-05-05 17:00:00	SPY	ETF	209.11	209.14	209.07	209.11	614682.0
2015-05-05 18:00:00	SPY	ETF	209.12	209.28	209.12	209.24	103731.0
2015-05-05 19:00:00	SPY	ETF	209.21	209.27	209.13	209.24	26787.0
2015-05-05 04:00:00	QQQ	ETF	109.08	109.26	109.0	109.26	3000.0
2015-05-05 06:00:00	QQQ	ETF	109.2	109.2	109.01	109.02	14500.0
2015-05-05 07:00:00	QQQ	ETF	109.01	109.09	108.97	109.06	22961.0
2015-05-05 08:00:00	QQQ	ETF	109.09	109.12	108.67	108.74	351508.0
2015-05-05 09:00:00	QQQ	ETF	108.72	109.0	108.27	108.3	5476190.0
2015-05-05 10:00:00	QQQ	ETF	108.32	108.42	107.99	108.24	6510021.0
2015-05-05 11:00:00	QQQ	ETF	108.23	108.23	107.6	107.95	4580953.0
2015-05-05 12:00:00	QQQ	ETF	107.95	108.085	107.8	107.84	2107585.0
2015-05-05 13:00:00	QQQ	ETF	107.86	107.87	107.55	107.65	3002855.0
2015-05-05 14:00:00	QQQ	ETF	107.65	107.83	107.4	107.57	3853425.0
2015-05-05 15:00:00	QQQ	ETF	107.57	107.81	107.44	107.46	11529407.0
2015-05-05 16:00:00	QQQ	ETF	107.46	107.67	107.45	107.65	1168240.0
2015-05-05 17:00:00	QQQ	ETF	107.65	107.66	107.6	107.6	25409.0
2015-05-05 18:00:00	QQQ	ETF	107.63	107.67	107.63	107.64	75745.0
2015-05-05 19:00:00	QQQ	ETF	107.62	107.67	107.6	107.65	68430.0
2015-05-05 07:00:00	IWM	ETF	122.04	122.26	122.04	122.25	8600.0
2015-05-05 08:00:00	IWM	ETF	122.25	122.3	121.8	121.9	319775.0
2015-05-05 09:00:00	IWM	ETF	121.88	122.62	121.64	121.74	3597838.0
2015-05-05 10:00:00	IWM	ETF	121.76	121.83	121.11	121.14	6678117.0
2015-05-05 11:00:00	IWM	ETF	121.14	121.34	120.68	120.9	5203771.0
2015-05-05 12:00:00	IWM	ETF	120.91	121.09	120.82	120.86	2687594.0
2015-05-05 13:00:00	IWM	ETF	120.865	120.88	120.41	120.59	4091750.0
2015-05-05 14:00:00	IWM	ETF	120.59	120.63	120.28	120.44	5861555.0
2015-05-05 15:00:00	IWM	ETF	120.44	120.87	120.28	120.87	8051307.0
2015-05-05 16:00:00	IWM	ETF	120.86	122.5271	120.4937	120.96	3575258.0
2015-05-05 17:00:00	IWM	ETF	120.98	121.01	120.89	120.93	206066.0
2015-05-05 19:00:00	IWM	ETF	121.02	121.02	120.9	120.92	1974.0
2015-05-05 08:00:00	DIA	ETF	180.31	180.31	179.9	179.9	2150.0
2015-05-05 09:00:00	DIA	ETF	180.23	180.59	179.96	180.02	500802.0
2015-05-05 10:00:00	DIA	ETF	180.05	180.34	179.73	180.07	997412.0
2015-05-05 11:00:00	DIA	ETF	180.05	180.05	179.29	179.68	1012235.0
2015-05-05 12:00:00	DIA	ETF	179.68	179.97	179.62	179.65	345109.0
2015-05-05 13:00:00	DIA	ETF	179.66	179.69	179.16	179.38	516620.0
2015-05-05 14:00:00	DIA	ETF	179.36	179.53	178.79	178.92	824208.0

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

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