PREVIEW / etf_1hour / 2019-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-11.parquet
  size:    340 KB
  rows:    11,146

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-09-11 04:00:00	SPY	ETF	298.58	298.64	298.18	298.3	3849.0
2019-09-11 05:00:00	SPY	ETF	298.0	298.13	297.77	298.13	9420.0
2019-09-11 06:00:00	SPY	ETF	298.14	298.34	298.0	298.09	51413.0
2019-09-11 07:00:00	SPY	ETF	298.05	298.68	298.05	298.6	259124.0
2019-09-11 08:00:00	SPY	ETF	298.12	298.8	298.07	298.54	361556.0
2019-09-11 09:00:00	SPY	ETF	298.54	298.95	297.75	298.57	7185047.0
2019-09-11 10:00:00	SPY	ETF	298.59	299.1	298.5	299.06	7805437.0
2019-09-11 11:00:00	SPY	ETF	299.07	299.44	298.91	299.43	7230793.0
2019-09-11 12:00:00	SPY	ETF	299.43	299.9	299.43	299.72	7839737.0
2019-09-11 13:00:00	SPY	ETF	299.725	299.92	299.54	299.595	6223190.0
2019-09-11 14:00:00	SPY	ETF	299.59	299.63	299.3	299.46	5067705.0
2019-09-11 15:00:00	SPY	ETF	299.45	300.34	299.44	300.29	14518247.0
2019-09-11 16:00:00	SPY	ETF	300.3	300.67	300.16	300.48	10301669.0
2019-09-11 17:00:00	SPY	ETF	300.48	300.53	300.43	300.47	73867.0
2019-09-11 18:00:00	SPY	ETF	300.49	300.56	300.41	300.43	357987.0
2019-09-11 19:00:00	SPY	ETF	300.47	302.2	300.41	302.05	445542.0
2019-09-11 04:00:00	QQQ	ETF	191.03	191.15	190.77	190.92	21285.0
2019-09-11 05:00:00	QQQ	ETF	190.56	190.56	190.08	190.54	26999.0
2019-09-11 06:00:00	QQQ	ETF	190.58	190.73	190.43	190.48	16425.0
2019-09-11 07:00:00	QQQ	ETF	190.49	191.18	190.45	191.11	255175.0
2019-09-11 08:00:00	QQQ	ETF	190.5899	191.25	190.55	191.03	172465.0
2019-09-11 09:00:00	QQQ	ETF	191.0	191.57	190.56	191.42	3630442.0
2019-09-11 10:00:00	QQQ	ETF	191.42	191.97	191.335	191.76	3122360.0
2019-09-11 11:00:00	QQQ	ETF	191.77	192.22	191.64	192.18	2219016.0
2019-09-11 12:00:00	QQQ	ETF	192.18	192.52	192.18	192.33	2070988.0
2019-09-11 13:00:00	QQQ	ETF	192.3133	192.41	191.95	192.0174	1518331.0
2019-09-11 14:00:00	QQQ	ETF	192.02	192.03	191.69	191.9103	1564705.0
2019-09-11 15:00:00	QQQ	ETF	191.9	192.53	191.9	192.45	5803305.0
2019-09-11 16:00:00	QQQ	ETF	192.45	192.75	190.6949	192.51	1367278.0
2019-09-11 17:00:00	QQQ	ETF	192.53	192.63	192.43	192.62	80108.0
2019-09-11 18:00:00	QQQ	ETF	192.53	192.57	192.41	192.45	47973.0
2019-09-11 19:00:00	QQQ	ETF	192.46	194.19	192.4	193.97	174396.0
2019-09-11 04:00:00	IWM	ETF	154.42	154.42	154.18	154.18	740.0
2019-09-11 05:00:00	IWM	ETF	154.19	154.19	154.19	154.19	225.0
2019-09-11 06:00:00	IWM	ETF	154.28	154.28	154.28	154.28	100.0
2019-09-11 07:00:00	IWM	ETF	154.21	154.46	154.2	154.46	114044.0
2019-09-11 08:00:00	IWM	ETF	154.2	154.61	154.2	154.52	70981.0
2019-09-11 09:00:00	IWM	ETF	154.52	155.16	153.555	154.865	4317470.0
2019-09-11 10:00:00	IWM	ETF	154.87	155.72	154.74	155.67	4472037.0
2019-09-11 11:00:00	IWM	ETF	155.68	155.77	155.01	155.505	3079869.0
2019-09-11 12:00:00	IWM	ETF	155.5	155.99	155.48	155.83	2513303.0
2019-09-11 13:00:00	IWM	ETF	155.84	156.33	155.82	156.16	2543706.0
2019-09-11 14:00:00	IWM	ETF	156.15	156.86	156.09	156.525	3807161.0
2019-09-11 15:00:00	IWM	ETF	156.55	157.16	156.54	156.96	7235583.0
2019-09-11 16:00:00	IWM	ETF	156.97	157.31	156.5299	157.24	3187793.0
2019-09-11 17:00:00	IWM	ETF	157.2	157.35	157.0	157.0	797849.0
2019-09-11 18:00:00	IWM	ETF	157.18	157.18	157.14	157.14	1550.0
2019-09-11 19:00:00	IWM	ETF	157.14	158.0	157.14	157.97	53337.0
2019-09-11 05:00:00	DIA	ETF	269.42	269.42	269.42	269.42	500.0
2019-09-11 07:00:00	DIA	ETF	269.6	269.8	269.56	269.8	710.0

> showing 50 of 11,146 rows — these rows as CSV

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