PREVIEW / etf_1hour / 2016-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-21.parquet
  size:    251 KB
  rows:    8,056

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
2016-04-21 04:00:00	SPY	ETF	210.36	210.49	210.29	210.49	7662.0
2016-04-21 05:00:00	SPY	ETF	210.44	210.44	210.21	210.29	16646.0
2016-04-21 06:00:00	SPY	ETF	210.38	210.38	210.09	210.33	24810.0
2016-04-21 07:00:00	SPY	ETF	210.36	210.44	210.17	210.17	142774.0
2016-04-21 08:00:00	SPY	ETF	210.19	210.65	210.1	210.25	682836.0
2016-04-21 09:00:00	SPY	ETF	210.21	210.3	209.52	209.53	8187970.0
2016-04-21 10:00:00	SPY	ETF	209.53	210.13	209.34	210.01	11479368.0
2016-04-21 11:00:00	SPY	ETF	210.02	210.17	209.45	209.47	6946688.0
2016-04-21 12:00:00	SPY	ETF	209.48	209.7	209.29	209.41	6786661.0
2016-04-21 13:00:00	SPY	ETF	209.4	209.61	209.0	209.0761	7969030.0
2016-04-21 14:00:00	SPY	ETF	209.0703	209.16	208.65	208.94	12332785.0
2016-04-21 15:00:00	SPY	ETF	208.93	209.16	208.68	208.96	16449680.0
2016-04-21 16:00:00	SPY	ETF	208.96	209.28	208.28	208.65	10923498.0
2016-04-21 17:00:00	SPY	ETF	208.55	208.64	208.28	208.36	1246964.0
2016-04-21 18:00:00	SPY	ETF	208.38	208.53	208.19	208.45	395330.0
2016-04-21 19:00:00	SPY	ETF	208.48	208.6	208.45	208.5	69512.0
2016-04-21 04:00:00	QQQ	ETF	110.72	110.73	110.72	110.73	598.0
2016-04-21 06:00:00	QQQ	ETF	110.51	110.57	110.51	110.55	1580.0
2016-04-21 07:00:00	QQQ	ETF	110.6	110.71	110.6	110.66	4358.0
2016-04-21 08:00:00	QQQ	ETF	110.71	110.85	110.59	110.61	89869.0
2016-04-21 09:00:00	QQQ	ETF	110.6	110.67	110.15	110.27	2179015.0
2016-04-21 10:00:00	QQQ	ETF	110.26	110.96	110.17	110.935	2507177.0
2016-04-21 11:00:00	QQQ	ETF	110.9305	111.05	110.49	110.52	1583570.0
2016-04-21 12:00:00	QQQ	ETF	110.52	110.66	110.37	110.51	1395471.0
2016-04-21 13:00:00	QQQ	ETF	110.51	110.76	110.43	110.56	1268388.0
2016-04-21 14:00:00	QQQ	ETF	110.56	110.61	110.331	110.53	1712931.0
2016-04-21 15:00:00	QQQ	ETF	110.52	110.7	110.4	110.62	2989934.0
2016-04-21 16:00:00	QQQ	ETF	110.63	110.84	109.45	109.8	2316335.0
2016-04-21 17:00:00	QQQ	ETF	109.76	109.82	109.4	109.45	92855.0
2016-04-21 18:00:00	QQQ	ETF	109.45	109.45	109.25	109.4	263771.0
2016-04-21 19:00:00	QQQ	ETF	109.41	109.5	109.38	109.43	27643.0
2016-04-21 05:00:00	IWM	ETF	113.58	113.58	113.58	113.58	100.0
2016-04-21 06:00:00	IWM	ETF	113.39	113.39	113.39	113.39	1000.0
2016-04-21 07:00:00	IWM	ETF	113.65	113.66	113.56	113.59	7512.0
2016-04-21 08:00:00	IWM	ETF	113.58	113.74	113.43	113.53	31019.0
2016-04-21 09:00:00	IWM	ETF	113.47	113.82	113.3	113.32	1924631.0
2016-04-21 10:00:00	IWM	ETF	113.31	113.845	113.17	113.79	2694834.0
2016-04-21 11:00:00	IWM	ETF	113.78	113.92	113.3699	113.385	1673703.0
2016-04-21 12:00:00	IWM	ETF	113.38	113.385	113.1	113.28	1988876.0
2016-04-21 13:00:00	IWM	ETF	113.27	113.41	112.97	113.05	1557983.0
2016-04-21 14:00:00	IWM	ETF	113.05	113.06	112.66	112.88	2839551.0
2016-04-21 15:00:00	IWM	ETF	112.88	113.0701	112.85	112.95	3547949.0
2016-04-21 16:00:00	IWM	ETF	112.96	113.2001	112.68	112.8	2008876.0
2016-04-21 17:00:00	IWM	ETF	112.89	112.89	112.71	112.73	45469.0
2016-04-21 18:00:00	IWM	ETF	112.73	112.8	112.73	112.75	2700.0
2016-04-21 19:00:00	IWM	ETF	112.74	112.8	112.68	112.7	7277.0
2016-04-21 06:00:00	DIA	ETF	180.95	180.95	180.93	180.93	995.0
2016-04-21 07:00:00	DIA	ETF	181.21	181.21	181.21	181.21	100.0
2016-04-21 08:00:00	DIA	ETF	181.0	181.04	180.75	180.8	7907.0
2016-04-21 09:00:00	DIA	ETF	180.77	180.88	180.33	180.36	301843.0

> showing 50 of 8,056 rows — these rows as CSV

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