PREVIEW / etf_1hour / 2019-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-26.parquet
  size:    322 KB
  rows:    10,707

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-26 04:00:00	SPY	ETF	278.97	278.97	278.46	278.96	15368.0
2019-02-26 05:00:00	SPY	ETF	279.0	279.12	278.9	279.12	10406.0
2019-02-26 06:00:00	SPY	ETF	279.11	279.12	278.7	278.92	30347.0
2019-02-26 07:00:00	SPY	ETF	279.03	279.26	278.98	279.2	170691.0
2019-02-26 08:00:00	SPY	ETF	279.21	279.2599	278.7	278.79	445864.0
2019-02-26 09:00:00	SPY	ETF	278.79	279.43	278.79	279.275	7491777.0
2019-02-26 10:00:00	SPY	ETF	279.28	279.96	278.97	278.99	9830938.0
2019-02-26 11:00:00	SPY	ETF	278.995	280.24	278.9	279.7	6972538.0
2019-02-26 12:00:00	SPY	ETF	279.7099	279.82	279.24	279.32	4066477.0
2019-02-26 13:00:00	SPY	ETF	279.305	279.65	279.24	279.4545	3465669.0
2019-02-26 14:00:00	SPY	ETF	279.4585	280.03	279.35	279.95	6398594.0
2019-02-26 15:00:00	SPY	ETF	279.945	280.3	279.27	279.34	12724226.0
2019-02-26 16:00:00	SPY	ETF	279.34	279.39	278.85	278.88	3553828.0
2019-02-26 17:00:00	SPY	ETF	278.85	278.94	278.68	278.73	320197.0
2019-02-26 18:00:00	SPY	ETF	278.67	278.99	278.61	278.84	134458.0
2019-02-26 19:00:00	SPY	ETF	278.82	279.02	278.8	278.8	52455.0
2019-02-26 04:00:00	QQQ	ETF	172.92	173.01	172.7	173.01	44470.0
2019-02-26 05:00:00	QQQ	ETF	173.02	173.1	172.93	173.1	33817.0
2019-02-26 06:00:00	QQQ	ETF	173.1	173.19	172.89	173.05	19358.0
2019-02-26 07:00:00	QQQ	ETF	173.08	173.26	173.08	173.16	37384.0
2019-02-26 08:00:00	QQQ	ETF	173.13	173.21	172.7	172.79	177795.0
2019-02-26 09:00:00	QQQ	ETF	172.78	173.5	172.78	173.39	2862576.0
2019-02-26 10:00:00	QQQ	ETF	173.38	173.91	173.15	173.17	3789586.0
2019-02-26 11:00:00	QQQ	ETF	173.15	173.98	173.09	173.59	2998242.0
2019-02-26 12:00:00	QQQ	ETF	173.6	173.7	173.2548	173.3279	1409145.0
2019-02-26 13:00:00	QQQ	ETF	173.33	173.69	173.319	173.56	1412219.0
2019-02-26 14:00:00	QQQ	ETF	173.599	174.01	173.55	173.95	1847135.0
2019-02-26 15:00:00	QQQ	ETF	173.95	174.25	173.65	173.7	4249740.0
2019-02-26 16:00:00	QQQ	ETF	173.7	173.76	173.29	173.3	598121.0
2019-02-26 17:00:00	QQQ	ETF	173.38	173.38	173.26	173.26	38876.0
2019-02-26 18:00:00	QQQ	ETF	173.25	173.44	173.17	173.35	35434.0
2019-02-26 19:00:00	QQQ	ETF	173.42	173.51	173.37	173.45	17411.0
2019-02-26 05:00:00	IWM	ETF	157.96	158.05	157.94	158.05	21500.0
2019-02-26 06:00:00	IWM	ETF	158.05	158.05	157.89	157.89	3612.0
2019-02-26 07:00:00	IWM	ETF	158.08	158.18	158.08	158.08	10212.0
2019-02-26 08:00:00	IWM	ETF	158.16	158.16	157.92	157.96	140448.0
2019-02-26 09:00:00	IWM	ETF	158.0	158.19	157.8	157.81	2530281.0
2019-02-26 10:00:00	IWM	ETF	157.8	158.17	157.38	157.41	3049653.0
2019-02-26 11:00:00	IWM	ETF	157.38	157.9	157.3612	157.4322	2296909.0
2019-02-26 12:00:00	IWM	ETF	157.44	157.63	157.06	157.08	1494040.0
2019-02-26 13:00:00	IWM	ETF	157.08	157.38	157.075	157.16	1017352.0
2019-02-26 14:00:00	IWM	ETF	157.17	157.63	157.14	157.55	1879919.0
2019-02-26 15:00:00	IWM	ETF	157.545	157.73	156.89	157.01	4202387.0
2019-02-26 16:00:00	IWM	ETF	157.02	157.1	156.72	156.72	1096654.0
2019-02-26 17:00:00	IWM	ETF	156.71	156.8	156.7	156.71	15496.0
2019-02-26 18:00:00	IWM	ETF	156.66	156.83	156.61	156.74	16168.0
2019-02-26 19:00:00	IWM	ETF	156.74	156.85	156.74	156.84	7680.0
2019-02-26 04:00:00	DIA	ETF	260.0	260.0	260.0	260.0	1100.0
2019-02-26 05:00:00	DIA	ETF	260.18	260.18	260.18	260.18	100.0
2019-02-26 06:00:00	DIA	ETF	260.09	260.09	259.8	259.85	24841.0

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

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