PREVIEW / etf_1hour / 2019-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-28.parquet
  size:    314 KB
  rows:    10,435

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-03-28 04:00:00	SPY	ETF	279.06	280.1	279.06	279.98	30981.0
2019-03-28 05:00:00	SPY	ETF	280.05	280.22	279.85	280.0	11156.0
2019-03-28 06:00:00	SPY	ETF	279.95	280.27	279.75	279.93	23327.0
2019-03-28 07:00:00	SPY	ETF	279.94	279.99	279.41	279.6	386362.0
2019-03-28 08:00:00	SPY	ETF	279.58	280.17	279.08	279.91	506000.0
2019-03-28 09:00:00	SPY	ETF	279.9	280.86	279.7499	280.71	6809843.0
2019-03-28 10:00:00	SPY	ETF	280.71	281.21	280.38	280.4	7647972.0
2019-03-28 11:00:00	SPY	ETF	280.41	280.4885	279.18	279.63	10057535.0
2019-03-28 12:00:00	SPY	ETF	279.64	280.08	279.07	280.0	5009132.0
2019-03-28 13:00:00	SPY	ETF	280.005	280.42	279.99	280.39	4779894.0
2019-03-28 14:00:00	SPY	ETF	280.39	280.48	280.01	280.3	4406776.0
2019-03-28 15:00:00	SPY	ETF	280.3	280.94	280.2	280.78	12278497.0
2019-03-28 16:00:00	SPY	ETF	280.78	281.06	280.61	281.0	2862003.0
2019-03-28 17:00:00	SPY	ETF	280.99	280.99	280.73	280.9	158924.0
2019-03-28 18:00:00	SPY	ETF	280.89	281.09	280.83	280.94	107319.0
2019-03-28 19:00:00	SPY	ETF	280.94	281.67	280.92	281.49	118585.0
2019-03-28 04:00:00	QQQ	ETF	177.54	178.23	177.54	178.22	17150.0
2019-03-28 05:00:00	QQQ	ETF	178.17	178.29	178.01	178.18	28209.0
2019-03-28 06:00:00	QQQ	ETF	178.12	178.29	177.99	178.12	32935.0
2019-03-28 07:00:00	QQQ	ETF	178.13	178.13	177.75	177.95	289196.0
2019-03-28 08:00:00	QQQ	ETF	178.0299	178.28	177.67	178.07	503762.0
2019-03-28 09:00:00	QQQ	ETF	178.06	178.57	177.77	178.5253	3675337.0
2019-03-28 10:00:00	QQQ	ETF	178.53	178.98	178.17	178.2	5919329.0
2019-03-28 11:00:00	QQQ	ETF	178.22	178.26	177.24	177.72	5814144.0
2019-03-28 12:00:00	QQQ	ETF	177.68	178.19	177.37	178.14	2109636.0
2019-03-28 13:00:00	QQQ	ETF	178.15	178.37	178.0599	178.2599	1492189.0
2019-03-28 14:00:00	QQQ	ETF	178.25	178.3	177.87	178.06	1476595.0
2019-03-28 15:00:00	QQQ	ETF	178.07	178.49	178.02	178.34	4051729.0
2019-03-28 16:00:00	QQQ	ETF	178.34	178.61	178.27	178.54	531750.0
2019-03-28 17:00:00	QQQ	ETF	178.45	178.59	178.45	178.54	8196.0
2019-03-28 18:00:00	QQQ	ETF	178.53	178.61	178.45	178.56	51131.0
2019-03-28 19:00:00	QQQ	ETF	178.55	179.12	178.54	178.96	88912.0
2019-03-28 04:00:00	IWM	ETF	151.11	151.5	151.11	151.5	1035.0
2019-03-28 06:00:00	IWM	ETF	151.5	151.55	151.35	151.35	3420.0
2019-03-28 07:00:00	IWM	ETF	151.44	151.44	151.1	151.28	82734.0
2019-03-28 08:00:00	IWM	ETF	151.33	151.59	151.12	151.47	305387.0
2019-03-28 09:00:00	IWM	ETF	151.48	152.76	151.39	152.74	2460359.0
2019-03-28 10:00:00	IWM	ETF	152.73	152.93	152.12	152.1972	2994703.0
2019-03-28 11:00:00	IWM	ETF	152.2	152.22	150.93	151.38	3533327.0
2019-03-28 12:00:00	IWM	ETF	151.37	151.92	151.0	151.88	1498034.0
2019-03-28 13:00:00	IWM	ETF	151.9	152.45	151.87	152.38	1529348.0
2019-03-28 14:00:00	IWM	ETF	152.38	152.47	151.89	152.07	1224147.0
2019-03-28 15:00:00	IWM	ETF	152.07	152.72	152.0	152.61	2592470.0
2019-03-28 16:00:00	IWM	ETF	152.62	152.79	152.0356	152.78	728480.0
2019-03-28 17:00:00	IWM	ETF	152.71	152.71	152.62	152.69	1950.0
2019-03-28 18:00:00	IWM	ETF	152.71	152.73	152.62	152.62	2100.0
2019-03-28 19:00:00	IWM	ETF	152.75	153.16	152.75	153.0	7087.0
2019-03-28 07:00:00	DIA	ETF	255.93	255.93	255.93	255.93	100.0
2019-03-28 08:00:00	DIA	ETF	256.5	256.53	256.03	256.47	8837.0
2019-03-28 09:00:00	DIA	ETF	256.3	257.28	256.3	256.73	273965.0

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

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