PREVIEW / etf_1hour / 2017-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-20.parquet
  size:    293 KB
  rows:    9,655

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
2017-12-20 04:00:00	SPY	ETF	267.83	268.06	267.83	267.98	16400.0
2017-12-20 05:00:00	SPY	ETF	267.98	268.1	267.95	268.1	14683.0
2017-12-20 06:00:00	SPY	ETF	268.05	268.05	267.86	268.0	17501.0
2017-12-20 07:00:00	SPY	ETF	268.03	268.12	267.99	268.06	192799.0
2017-12-20 08:00:00	SPY	ETF	267.99	268.16	267.99	268.1	364413.0
2017-12-20 09:00:00	SPY	ETF	268.1	268.33	267.09	267.47	8836168.0
2017-12-20 10:00:00	SPY	ETF	267.47	267.6289	266.69	267.0047	12275231.0
2017-12-20 11:00:00	SPY	ETF	267.01	267.41	266.87	267.16	6712819.0
2017-12-20 12:00:00	SPY	ETF	267.16	267.39	266.99	267.27	5364413.0
2017-12-20 13:00:00	SPY	ETF	267.27	267.6	267.22	267.41	6499390.0
2017-12-20 14:00:00	SPY	ETF	267.419	267.48	266.945	267.11	7113715.0
2017-12-20 15:00:00	SPY	ETF	267.11	267.365	266.97	267.04	10297874.0
2017-12-20 16:00:00	SPY	ETF	267.05	267.458	266.9	266.94	17484534.0
2017-12-20 17:00:00	SPY	ETF	266.98	266.98	266.87	266.91	229818.0
2017-12-20 18:00:00	SPY	ETF	266.94	267.03	266.88	267.02	92162.0
2017-12-20 19:00:00	SPY	ETF	267.03	267.16	266.96	267.01	30315.0
2017-12-20 04:00:00	QQQ	ETF	158.21	158.21	158.08	158.19	650.0
2017-12-20 05:00:00	QQQ	ETF	158.35	158.38	158.35	158.38	1306.0
2017-12-20 06:00:00	QQQ	ETF	158.27	158.36	158.26	158.33	10225.0
2017-12-20 07:00:00	QQQ	ETF	158.34	158.43	158.33	158.4	85569.0
2017-12-20 08:00:00	QQQ	ETF	158.33	158.46	158.33	158.43	75576.0
2017-12-20 09:00:00	QQQ	ETF	158.43	158.44	157.0	157.29	6298054.0
2017-12-20 10:00:00	QQQ	ETF	157.29	157.44	156.91	157.05	5063786.0
2017-12-20 11:00:00	QQQ	ETF	157.05	157.37	157.0	157.35	2857188.0
2017-12-20 12:00:00	QQQ	ETF	157.35	157.62	157.3337	157.49	1698864.0
2017-12-20 13:00:00	QQQ	ETF	157.5	157.82	157.47	157.7	1458513.0
2017-12-20 14:00:00	QQQ	ETF	157.71	157.76	157.39	157.5	1564548.0
2017-12-20 15:00:00	QQQ	ETF	157.5	157.68	157.4	157.55	4960120.0
2017-12-20 16:00:00	QQQ	ETF	157.54	157.765	157.4	157.4	3423804.0
2017-12-20 17:00:00	QQQ	ETF	157.4	157.5262	157.4	157.41	1624539.0
2017-12-20 18:00:00	QQQ	ETF	157.44	157.53	157.22	157.42	851857.0
2017-12-20 19:00:00	QQQ	ETF	157.44	157.48	157.35	157.41	18800.0
2017-12-20 04:00:00	IWM	ETF	153.47	153.47	153.38	153.38	200.0
2017-12-20 06:00:00	IWM	ETF	153.4	153.49	153.4	153.49	2100.0
2017-12-20 07:00:00	IWM	ETF	153.51	153.52	153.34	153.45	31412.0
2017-12-20 08:00:00	IWM	ETF	153.44	153.61	153.44	153.59	77732.0
2017-12-20 09:00:00	IWM	ETF	153.6	153.93	153.13	153.53	2413414.0
2017-12-20 10:00:00	IWM	ETF	153.54	153.5998	152.84	153.3	2261720.0
2017-12-20 11:00:00	IWM	ETF	153.3	153.64	153.22	153.375	1465117.0
2017-12-20 12:00:00	IWM	ETF	153.37	153.71	153.3	153.63	992186.0
2017-12-20 13:00:00	IWM	ETF	153.635	153.935	153.55	153.81	1098258.0
2017-12-20 14:00:00	IWM	ETF	153.81	153.88	153.41	153.58	1243283.0
2017-12-20 15:00:00	IWM	ETF	153.58	153.65	153.31	153.37	3223933.0
2017-12-20 16:00:00	IWM	ETF	153.38	153.5371	152.98	153.09	608479.0
2017-12-20 17:00:00	IWM	ETF	153.17	153.17	153.01	153.01	2165.0
2017-12-20 18:00:00	IWM	ETF	153.08	153.19	153.08	153.11	10234.0
2017-12-20 19:00:00	IWM	ETF	153.17	153.27	153.16	153.16	4685.0
2017-12-20 05:00:00	DIA	ETF	248.06	248.06	248.06	248.06	1000.0
2017-12-20 06:00:00	DIA	ETF	248.12	248.12	248.12	248.12	200.0
2017-12-20 07:00:00	DIA	ETF	248.33	248.33	248.19	248.25	2399.0

> showing 50 of 9,655 rows — these rows as CSV

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