PREVIEW / etf_1hour / 2019-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-21.parquet
  size:    316 KB
  rows:    10,539

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
2019-02-21 04:00:00	SPY	ETF	278.89	278.93	278.73	278.78	4948.0
2019-02-21 05:00:00	SPY	ETF	278.85	278.97	278.75	278.85	5725.0
2019-02-21 06:00:00	SPY	ETF	278.87	278.97	278.65	278.7	7826.0
2019-02-21 07:00:00	SPY	ETF	278.75	278.81	277.92	278.21	163955.0
2019-02-21 08:00:00	SPY	ETF	278.7	279.5	277.75	278.1	347466.0
2019-02-21 09:00:00	SPY	ETF	278.1	278.24	276.95	277.3	8924726.0
2019-02-21 10:00:00	SPY	ETF	277.3	277.5	276.85	277.17	8522693.0
2019-02-21 11:00:00	SPY	ETF	277.17	277.91	276.99	277.72	5606803.0
2019-02-21 12:00:00	SPY	ETF	277.73	278.05	277.56	278.0337	4504856.0
2019-02-21 13:00:00	SPY	ETF	278.0385	278.1	277.58	277.75	3478393.0
2019-02-21 14:00:00	SPY	ETF	277.7401	277.8	276.37	276.61	7924278.0
2019-02-21 15:00:00	SPY	ETF	276.6125	277.47	276.345	277.46	15569243.0
2019-02-21 16:00:00	SPY	ETF	277.47	277.57	277.3	277.35	8334212.0
2019-02-21 17:00:00	SPY	ETF	277.3	277.38	277.27	277.28	47108.0
2019-02-21 18:00:00	SPY	ETF	277.27	277.4	277.14	277.38	111038.0
2019-02-21 19:00:00	SPY	ETF	277.38	277.47	277.18	277.47	107199.0
2019-02-21 04:00:00	QQQ	ETF	172.63	172.69	172.55	172.6	8600.0
2019-02-21 05:00:00	QQQ	ETF	172.71	172.77	172.61	172.74	14000.0
2019-02-21 06:00:00	QQQ	ETF	172.69	172.84	172.6	172.6	13600.0
2019-02-21 07:00:00	QQQ	ETF	172.63	172.71	172.01	172.21	86237.0
2019-02-21 08:00:00	QQQ	ETF	172.61	173.16	171.81	172.05	162943.0
2019-02-21 09:00:00	QQQ	ETF	172.06	172.18	170.89	171.14	3696137.0
2019-02-21 10:00:00	QQQ	ETF	171.14	171.31	170.71	171.15	4072227.0
2019-02-21 11:00:00	QQQ	ETF	171.14	171.981	170.99	171.86	3060498.0
2019-02-21 12:00:00	QQQ	ETF	171.8662	172.26	171.82	172.21	2691877.0
2019-02-21 13:00:00	QQQ	ETF	172.22	172.25	171.85	171.9672	1373000.0
2019-02-21 14:00:00	QQQ	ETF	171.97	172.03	170.931	171.07	2803285.0
2019-02-21 15:00:00	QQQ	ETF	171.065	171.61	170.9	171.6	4032466.0
2019-02-21 16:00:00	QQQ	ETF	171.6	171.65	171.38	171.4999	1481705.0
2019-02-21 17:00:00	QQQ	ETF	171.39	171.43	171.3	171.31	65029.0
2019-02-21 18:00:00	QQQ	ETF	171.31	171.36	171.18	171.35	70905.0
2019-02-21 19:00:00	QQQ	ETF	171.3	171.39	171.21	171.39	8380.0
2019-02-21 05:00:00	IWM	ETF	157.65	157.65	157.63	157.63	700.0
2019-02-21 06:00:00	IWM	ETF	157.8	157.8	157.64	157.64	7000.0
2019-02-21 07:00:00	IWM	ETF	157.74	157.74	157.35	157.43	13690.0
2019-02-21 08:00:00	IWM	ETF	157.75	157.75	157.23	157.41	24330.0
2019-02-21 09:00:00	IWM	ETF	157.38	157.38	156.77	156.8	2202371.0
2019-02-21 10:00:00	IWM	ETF	156.81	156.95	156.41	156.43	2327661.0
2019-02-21 11:00:00	IWM	ETF	156.43	156.935	156.3501	156.88	1803147.0
2019-02-21 12:00:00	IWM	ETF	156.88	156.96	156.545	156.92	1226644.0
2019-02-21 13:00:00	IWM	ETF	156.93	157.03	156.82	156.95	949771.0
2019-02-21 14:00:00	IWM	ETF	156.96	157.01	156.06	156.25	2264980.0
2019-02-21 15:00:00	IWM	ETF	156.25	156.82	156.19	156.79	3312976.0
2019-02-21 16:00:00	IWM	ETF	156.79	156.96	156.7571	156.82	738287.0
2019-02-21 17:00:00	IWM	ETF	156.85	156.85	156.79	156.79	43415.0
2019-02-21 18:00:00	IWM	ETF	156.78	156.85	156.72	156.84	5657.0
2019-02-21 19:00:00	IWM	ETF	156.87	156.89	156.7562	156.89	155350.0
2019-02-21 06:00:00	DIA	ETF	259.98	260.02	259.98	260.02	300.0
2019-02-21 07:00:00	DIA	ETF	259.94	259.94	259.05	259.4	4522.0
2019-02-21 08:00:00	DIA	ETF	259.25	260.6	259.0	259.34	15944.0

> showing 50 of 10,539 rows — these rows as CSV

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