PREVIEW / etf_1hour / 2015-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-04.parquet
  size:    240 KB
  rows:    7,673

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-04 04:00:00	SPY	ETF	210.75	211.15	210.75	211.12	7010.0
2015-05-04 05:00:00	SPY	ETF	211.14	211.2	211.0	211.08	19960.0
2015-05-04 06:00:00	SPY	ETF	211.08	211.25	210.98	211.19	51020.0
2015-05-04 07:00:00	SPY	ETF	211.19	211.38	211.18	211.3	150491.0
2015-05-04 08:00:00	SPY	ETF	211.3	211.38	211.18	211.32	286373.0
2015-05-04 09:00:00	SPY	ETF	211.32	211.98	211.1	211.91	10278295.0
2015-05-04 10:00:00	SPY	ETF	211.919	212.02	211.53	211.6	10641356.0
2015-05-04 11:00:00	SPY	ETF	211.61	211.75	211.41	211.655	6605636.0
2015-05-04 12:00:00	SPY	ETF	211.65	211.74	211.37	211.43	5154987.0
2015-05-04 13:00:00	SPY	ETF	211.43	211.56	211.18	211.535	6184541.0
2015-05-04 14:00:00	SPY	ETF	211.54	211.75	211.4	211.545	6838788.0
2015-05-04 15:00:00	SPY	ETF	211.55	211.7	211.31	211.34	15591766.0
2015-05-04 16:00:00	SPY	ETF	211.34	211.6268	211.27	211.44	6178529.0
2015-05-04 17:00:00	SPY	ETF	211.44	211.47	211.41	211.44	62800.0
2015-05-04 18:00:00	SPY	ETF	211.44	211.49	211.36	211.42	76287.0
2015-05-04 19:00:00	SPY	ETF	211.42	211.44	211.39	211.44	19653.0
2015-05-04 04:00:00	QQQ	ETF	109.18	109.18	109.18	109.18	3700.0
2015-05-04 05:00:00	QQQ	ETF	109.18	109.21	109.13	109.13	18550.0
2015-05-04 06:00:00	QQQ	ETF	109.15	109.23	109.14	109.18	38150.0
2015-05-04 07:00:00	QQQ	ETF	109.18	109.36	109.18	109.32	61745.0
2015-05-04 08:00:00	QQQ	ETF	109.32	109.4	109.3	109.34	63792.0
2015-05-04 09:00:00	QQQ	ETF	109.35	109.9	109.3	109.88	4126185.0
2015-05-04 10:00:00	QQQ	ETF	109.88	109.91	109.49	109.51	3898787.0
2015-05-04 11:00:00	QQQ	ETF	109.54	109.62	109.43	109.57	1846072.0
2015-05-04 12:00:00	QQQ	ETF	109.58	109.67	109.35	109.4	1605767.0
2015-05-04 13:00:00	QQQ	ETF	109.4	109.47	109.17	109.4648	2118653.0
2015-05-04 14:00:00	QQQ	ETF	109.465	109.58	109.345	109.45	1339694.0
2015-05-04 15:00:00	QQQ	ETF	109.455	109.46	109.18	109.2	3132675.0
2015-05-04 16:00:00	QQQ	ETF	109.21	109.28	109.11	109.23	352612.0
2015-05-04 17:00:00	QQQ	ETF	109.22	109.24	109.21	109.23	11730.0
2015-05-04 18:00:00	QQQ	ETF	109.21	109.25	109.19	109.22	9150.0
2015-05-04 19:00:00	QQQ	ETF	109.22	109.22	109.18	109.21	7600.0
2015-05-04 06:00:00	IWM	ETF	122.06	122.06	122.06	122.06	100.0
2015-05-04 07:00:00	IWM	ETF	122.15	122.24	122.15	122.24	54907.0
2015-05-04 08:00:00	IWM	ETF	122.22	122.27	122.16	122.2	132330.0
2015-05-04 09:00:00	IWM	ETF	122.15	122.95	121.795	122.95	4069861.0
2015-05-04 10:00:00	IWM	ETF	122.945	123.345	122.62	122.68	5630097.0
2015-05-04 11:00:00	IWM	ETF	122.69	123.06	122.67	122.93	3011989.0
2015-05-04 12:00:00	IWM	ETF	122.935	122.965	122.55	122.675	1877133.0
2015-05-04 13:00:00	IWM	ETF	122.675	122.7	122.21	122.67	2718710.0
2015-05-04 14:00:00	IWM	ETF	122.67	122.8	122.48	122.6	2146364.0
2015-05-04 15:00:00	IWM	ETF	122.6	122.66	122.36	122.42	6806495.0
2015-05-04 16:00:00	IWM	ETF	122.41	122.43	122.22	122.28	1522675.0
2015-05-04 17:00:00	IWM	ETF	122.31	122.31	122.31	122.31	269.0
2015-05-04 18:00:00	IWM	ETF	122.26	122.26	122.26	122.26	150.0
2015-05-04 19:00:00	IWM	ETF	122.4	122.4	122.4	122.4	100.0
2015-05-04 07:00:00	DIA	ETF	180.6	180.6	180.6	180.6	1000.0
2015-05-04 08:00:00	DIA	ETF	180.5	180.5	180.5	180.5	350.0
2015-05-04 09:00:00	DIA	ETF	180.4	181.01	180.25	180.9547	822290.0
2015-05-04 10:00:00	DIA	ETF	180.97	181.05	180.61	180.694	749004.0

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

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