PREVIEW / etf_1hour / 2017-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-27.parquet
  size:    285 KB
  rows:    9,468

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-11-27 04:00:00	SPY	ETF	260.35	260.62	260.35	260.4	37852.0
2017-11-27 05:00:00	SPY	ETF	260.5	260.56	260.48	260.54	13671.0
2017-11-27 06:00:00	SPY	ETF	260.59	260.66	260.54	260.56	12637.0
2017-11-27 07:00:00	SPY	ETF	260.53	260.53	260.2	260.29	264213.0
2017-11-27 08:00:00	SPY	ETF	260.52	260.52	260.18	260.28	366309.0
2017-11-27 09:00:00	SPY	ETF	260.3	260.75	260.24	260.575	4428833.0
2017-11-27 10:00:00	SPY	ETF	260.58	260.6868	260.47	260.61	5278338.0
2017-11-27 11:00:00	SPY	ETF	260.62	260.63	260.0	260.31	9504624.0
2017-11-27 12:00:00	SPY	ETF	260.31	260.32	260.15	260.27	5013768.0
2017-11-27 13:00:00	SPY	ETF	260.27	260.44	260.265	260.42	2590431.0
2017-11-27 14:00:00	SPY	ETF	260.42	260.43	260.27	260.39	3565073.0
2017-11-27 15:00:00	SPY	ETF	260.38	260.42	260.25	260.26	11233652.0
2017-11-27 16:00:00	SPY	ETF	260.25	260.48	260.23	260.46	7625578.0
2017-11-27 17:00:00	SPY	ETF	260.44	260.45	260.35	260.4	97638.0
2017-11-27 18:00:00	SPY	ETF	260.4	260.41	260.14	260.14	116473.0
2017-11-27 19:00:00	SPY	ETF	260.18	260.23	259.96	259.98	78853.0
2017-11-27 04:00:00	QQQ	ETF	156.4	156.43	156.36	156.42	10300.0
2017-11-27 05:00:00	QQQ	ETF	156.43	156.43	156.43	156.43	1500.0
2017-11-27 06:00:00	QQQ	ETF	156.45	156.55	156.43	156.45	5598.0
2017-11-27 07:00:00	QQQ	ETF	156.46	156.46	156.17	156.17	147228.0
2017-11-27 08:00:00	QQQ	ETF	156.16	156.45	156.08	156.16	170306.0
2017-11-27 09:00:00	QQQ	ETF	156.16	156.44	156.0547	156.3099	3344266.0
2017-11-27 10:00:00	QQQ	ETF	156.305	156.56	156.29	156.42	2284570.0
2017-11-27 11:00:00	QQQ	ETF	156.43	156.46	155.83	156.13	3527963.0
2017-11-27 12:00:00	QQQ	ETF	156.13	156.2	156.01	156.117	1833415.0
2017-11-27 13:00:00	QQQ	ETF	156.115	156.3	156.115	156.27	1155257.0
2017-11-27 14:00:00	QQQ	ETF	156.27	156.285	156.1	156.23	915534.0
2017-11-27 15:00:00	QQQ	ETF	156.2366	156.26	156.12	156.19	2263661.0
2017-11-27 16:00:00	QQQ	ETF	156.19	156.31	156.1814	156.3	292660.0
2017-11-27 17:00:00	QQQ	ETF	156.32	156.32	156.28	156.28	6075.0
2017-11-27 18:00:00	QQQ	ETF	156.25	156.25	156.1	156.1	23861.0
2017-11-27 19:00:00	QQQ	ETF	156.16	156.16	156.01	156.01	22150.0
2017-11-27 04:00:00	IWM	ETF	151.16	151.16	151.16	151.16	215.0
2017-11-27 05:00:00	IWM	ETF	151.16	151.16	151.16	151.16	5100.0
2017-11-27 06:00:00	IWM	ETF	151.26	151.26	151.17	151.2	6300.0
2017-11-27 07:00:00	IWM	ETF	151.21	151.22	150.9	151.01	42566.0
2017-11-27 08:00:00	IWM	ETF	151.22	151.39	150.97	151.21	656372.0
2017-11-27 09:00:00	IWM	ETF	151.23	151.62	151.0725	151.2346	2319250.0
2017-11-27 10:00:00	IWM	ETF	151.24	151.37	150.99	151.08	1140262.0
2017-11-27 11:00:00	IWM	ETF	151.07	151.08	150.55	150.74	2036190.0
2017-11-27 12:00:00	IWM	ETF	150.74	150.75	150.55	150.73	941770.0
2017-11-27 13:00:00	IWM	ETF	150.74	151.0325	150.73	150.87	1050300.0
2017-11-27 14:00:00	IWM	ETF	150.87	150.88	150.73	150.84	693603.0
2017-11-27 15:00:00	IWM	ETF	150.83	150.99	150.44	150.46	2781187.0
2017-11-27 16:00:00	IWM	ETF	150.49	150.69	150.46	150.68	2174149.0
2017-11-27 17:00:00	IWM	ETF	150.8597	151.0826	150.8597	151.0826	81523.0
2017-11-27 18:00:00	IWM	ETF	150.67	150.68	150.48	150.62	4757.0
2017-11-27 19:00:00	IWM	ETF	150.47	150.52	150.33	150.38	5920.0
2017-11-27 05:00:00	DIA	ETF	235.56	235.56	235.56	235.56	100.0
2017-11-27 06:00:00	DIA	ETF	235.87	235.87	235.87	235.87	2209.0

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

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