PREVIEW / etf_1hour / 2017-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-27.parquet
  size:    284 KB
  rows:    9,441

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-27 04:00:00	SPY	ETF	267.4	267.45	267.34	267.34	2160.0
2017-12-27 05:00:00	SPY	ETF	267.31	267.45	267.31	267.45	2400.0
2017-12-27 06:00:00	SPY	ETF	267.48	267.5	267.38	267.4	30997.0
2017-12-27 07:00:00	SPY	ETF	267.4	267.46	267.3	267.35	14845.0
2017-12-27 08:00:00	SPY	ETF	267.47	267.57	267.28	267.57	322100.0
2017-12-27 09:00:00	SPY	ETF	267.56	267.56	267.16	267.335	3847819.0
2017-12-27 10:00:00	SPY	ETF	267.33	267.67	267.33	267.66	7805565.0
2017-12-27 11:00:00	SPY	ETF	267.66	267.73	267.33	267.44	6309813.0
2017-12-27 12:00:00	SPY	ETF	267.43	267.49	267.27	267.28	5927996.0
2017-12-27 13:00:00	SPY	ETF	267.27	267.4335	267.16	267.329	4058165.0
2017-12-27 14:00:00	SPY	ETF	267.33	267.33	267.06	267.18	3372870.0
2017-12-27 15:00:00	SPY	ETF	267.18	267.35	267.01	267.33	12476172.0
2017-12-27 16:00:00	SPY	ETF	267.34	267.57	267.32	267.49	10518883.0
2017-12-27 17:00:00	SPY	ETF	267.5	267.51	267.4	267.4	45600.0
2017-12-27 18:00:00	SPY	ETF	267.45	267.55	267.4	267.54	30861.0
2017-12-27 19:00:00	SPY	ETF	267.54	267.58	267.54	267.58	27512.0
2017-12-27 05:00:00	QQQ	ETF	156.69	156.74	156.69	156.74	1500.0
2017-12-27 06:00:00	QQQ	ETF	156.74	156.74	156.6	156.63	4611.0
2017-12-27 07:00:00	QQQ	ETF	156.58	156.63	156.41	156.48	9078.0
2017-12-27 08:00:00	QQQ	ETF	156.63	156.73	156.4	156.73	57351.0
2017-12-27 09:00:00	QQQ	ETF	156.73	156.7895	156.42	156.76	1478648.0
2017-12-27 10:00:00	QQQ	ETF	156.77	156.94	156.77	156.88	1353571.0
2017-12-27 11:00:00	QQQ	ETF	156.88	156.96	156.49	156.53	3410634.0
2017-12-27 12:00:00	QQQ	ETF	156.52	156.71	156.45	156.5767	1179557.0
2017-12-27 13:00:00	QQQ	ETF	156.57	156.62	156.52	156.595	1219122.0
2017-12-27 14:00:00	QQQ	ETF	156.59	156.62	156.43	156.5	3552170.0
2017-12-27 15:00:00	QQQ	ETF	156.5	156.62	156.39	156.57	2895596.0
2017-12-27 16:00:00	QQQ	ETF	156.56	156.69	156.54	156.62	896323.0
2017-12-27 17:00:00	QQQ	ETF	156.69	156.69	156.54	156.66	45416.0
2017-12-27 18:00:00	QQQ	ETF	156.63	156.71	156.62	156.71	10430.0
2017-12-27 19:00:00	QQQ	ETF	156.7	156.73	156.69	156.73	6000.0
2017-12-27 06:00:00	IWM	ETF	153.37	153.37	153.28	153.28	2000.0
2017-12-27 07:00:00	IWM	ETF	153.34	153.34	153.34	153.34	100.0
2017-12-27 08:00:00	IWM	ETF	153.32	153.42	153.25	153.37	6416.0
2017-12-27 09:00:00	IWM	ETF	153.35	153.59	153.14	153.56	966641.0
2017-12-27 10:00:00	IWM	ETF	153.56	153.85	153.5449	153.72	1246380.0
2017-12-27 11:00:00	IWM	ETF	153.72	153.95	153.71	153.86	903301.0
2017-12-27 12:00:00	IWM	ETF	153.85	153.92	153.32	153.33	1321622.0
2017-12-27 13:00:00	IWM	ETF	153.32	153.34	152.81	153.19	1521875.0
2017-12-27 14:00:00	IWM	ETF	153.19	153.3165	153.08	153.2415	1063842.0
2017-12-27 15:00:00	IWM	ETF	153.2463	153.3	153.04	153.13	2383534.0
2017-12-27 16:00:00	IWM	ETF	153.14	153.8068	153.11	153.17	838510.0
2017-12-27 17:00:00	IWM	ETF	153.13	153.13	153.13	153.13	1300000.0
2017-12-27 18:00:00	IWM	ETF	153.15	153.21	153.14	153.21	514.0
2017-12-27 19:00:00	IWM	ETF	153.21	153.26	153.21	153.25	6908.0
2017-12-27 08:00:00	DIA	ETF	247.42	247.42	247.42	247.42	600.0
2017-12-27 09:00:00	DIA	ETF	247.32	247.49	247.1	247.17	392679.0
2017-12-27 10:00:00	DIA	ETF	247.17	247.64	247.16	247.6399	377857.0
2017-12-27 11:00:00	DIA	ETF	247.64	247.686	247.41	247.5	465467.0
2017-12-27 12:00:00	DIA	ETF	247.5	247.56	247.39	247.4751	332929.0

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

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