PREVIEW / etf_1hour / 2018-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-09.parquet
  size:    299 KB
  rows:    9,786

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
2018-04-09 04:00:00	SPY	ETF	261.67	262.27	261.67	262.09	36534.0
2018-04-09 05:00:00	SPY	ETF	262.04	262.33	261.85	261.85	19520.0
2018-04-09 06:00:00	SPY	ETF	261.74	262.15	261.59	261.61	118943.0
2018-04-09 07:00:00	SPY	ETF	261.58	261.85	261.39	261.7	274714.0
2018-04-09 08:00:00	SPY	ETF	261.48	262.37	259.72	261.23	979357.0
2018-04-09 09:00:00	SPY	ETF	261.26	262.45	260.87	262.09	8398033.0
2018-04-09 10:00:00	SPY	ETF	262.1	263.1	261.57	262.85	9885914.0
2018-04-09 11:00:00	SPY	ETF	262.86	264.09	262.58	263.9791	10216677.0
2018-04-09 12:00:00	SPY	ETF	264.0	264.33	263.62	264.1	6423513.0
2018-04-09 13:00:00	SPY	ETF	264.12	264.84	264.11	264.78	7474773.0
2018-04-09 14:00:00	SPY	ETF	264.79	264.8	263.2	263.86	9464801.0
2018-04-09 15:00:00	SPY	ETF	263.86	263.9	260.54	260.86	32324115.0
2018-04-09 16:00:00	SPY	ETF	260.85	263.02	260.49	261.28	11096825.0
2018-04-09 17:00:00	SPY	ETF	261.26	261.29	261.0	261.25	233692.0
2018-04-09 18:00:00	SPY	ETF	261.27	261.5	260.72	260.9	255737.0
2018-04-09 19:00:00	SPY	ETF	260.89	261.3	260.75	261.12	215358.0
2018-04-09 04:00:00	QQQ	ETF	158.1	158.61	158.1	158.44	41680.0
2018-04-09 05:00:00	QQQ	ETF	158.5	158.69	158.38	158.43	12812.0
2018-04-09 06:00:00	QQQ	ETF	158.37	158.57	158.16	158.17	36639.0
2018-04-09 07:00:00	QQQ	ETF	158.18	158.37	157.6166	158.19	288846.0
2018-04-09 08:00:00	QQQ	ETF	156.63	158.29	156.63	157.98	172844.0
2018-04-09 09:00:00	QQQ	ETF	157.95	159.22	157.68	158.99	4995615.0
2018-04-09 10:00:00	QQQ	ETF	158.99	159.74	158.74	159.5261	4302600.0
2018-04-09 11:00:00	QQQ	ETF	159.53	160.4	159.18	160.3701	3965179.0
2018-04-09 12:00:00	QQQ	ETF	160.38	160.88	160.07	160.39	4475892.0
2018-04-09 13:00:00	QQQ	ETF	160.41	160.73	160.06	160.4528	3229912.0
2018-04-09 14:00:00	QQQ	ETF	160.455	160.505	159.29	159.73	3997895.0
2018-04-09 15:00:00	QQQ	ETF	159.73	159.74	157.46	157.64	8855478.0
2018-04-09 16:00:00	QQQ	ETF	157.63	160.2764	157.31	157.89	1981307.0
2018-04-09 17:00:00	QQQ	ETF	157.92	157.92	157.74	157.82	79582.0
2018-04-09 18:00:00	QQQ	ETF	157.78	158.05	157.5	157.72	77012.0
2018-04-09 19:00:00	QQQ	ETF	157.61	157.9	157.59	157.67	50483.0
2018-04-09 04:00:00	IWM	ETF	151.6	151.77	151.56	151.77	6844.0
2018-04-09 05:00:00	IWM	ETF	151.71	151.85	151.55	151.55	3500.0
2018-04-09 07:00:00	IWM	ETF	151.41	151.906	151.29	151.29	4900.0
2018-04-09 08:00:00	IWM	ETF	151.48	151.54	151.2	151.2	131697.0
2018-04-09 09:00:00	IWM	ETF	151.23	151.68	150.85	151.4	1962445.0
2018-04-09 10:00:00	IWM	ETF	151.43	151.89	150.94	151.73	2144654.0
2018-04-09 11:00:00	IWM	ETF	151.76	152.34	151.56	152.09	1681205.0
2018-04-09 12:00:00	IWM	ETF	152.08	152.4	151.83	151.9	1322412.0
2018-04-09 13:00:00	IWM	ETF	151.95	152.6	151.94	152.43	1051723.0
2018-04-09 14:00:00	IWM	ETF	152.43	152.45	151.55	151.96	1519882.0
2018-04-09 15:00:00	IWM	ETF	151.95	152.0	150.42	150.52	4067598.0
2018-04-09 16:00:00	IWM	ETF	150.52	150.85	150.25	150.81	3378076.0
2018-04-09 17:00:00	IWM	ETF	150.7	150.79	150.61	150.79	2120.0
2018-04-09 18:00:00	IWM	ETF	150.8	150.88	150.41	150.54	13983.0
2018-04-09 19:00:00	IWM	ETF	150.51	150.75	150.45	150.53	9454.0
2018-04-09 04:00:00	DIA	ETF	241.1	241.41	241.1	241.41	700.0
2018-04-09 05:00:00	DIA	ETF	241.37	241.37	241.37	241.37	200.0
2018-04-09 06:00:00	DIA	ETF	241.3	241.3	241.25	241.25	900.0

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

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