PREVIEW / etf_1hour / 2018-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-03.parquet
  size:    293 KB
  rows:    9,642

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-08-03 04:00:00	SPY	ETF	282.3	282.38	282.12	282.34	9827.0
2018-08-03 05:00:00	SPY	ETF	282.32	282.51	282.27	282.51	6405.0
2018-08-03 06:00:00	SPY	ETF	282.65	282.67	282.53	282.65	13812.0
2018-08-03 07:00:00	SPY	ETF	282.62	283.25	282.62	282.91	88650.0
2018-08-03 08:00:00	SPY	ETF	283.1799	283.25	282.39	282.42	650268.0
2018-08-03 09:00:00	SPY	ETF	282.44	282.76	282.33	282.53	5189512.0
2018-08-03 10:00:00	SPY	ETF	282.51	283.19	282.44	282.73	6202453.0
2018-08-03 11:00:00	SPY	ETF	282.74	282.99	282.505	282.51	4097009.0
2018-08-03 12:00:00	SPY	ETF	282.51	283.07	282.4901	282.98	2987471.0
2018-08-03 13:00:00	SPY	ETF	282.98	283.32	282.98	283.285	4006944.0
2018-08-03 14:00:00	SPY	ETF	283.28	283.35	283.15	283.335	4574694.0
2018-08-03 15:00:00	SPY	ETF	283.335	283.65	283.3	283.64	13756964.0
2018-08-03 16:00:00	SPY	ETF	283.65	283.74	283.4733	283.7	11216273.0
2018-08-03 17:00:00	SPY	ETF	283.73	283.73	283.59	283.61	53609.0
2018-08-03 18:00:00	SPY	ETF	283.6	283.69	283.6	283.64	6139.0
2018-08-03 19:00:00	SPY	ETF	283.65	283.66	283.61	283.62	12991.0
2018-08-03 04:00:00	QQQ	ETF	179.57	179.67	179.54	179.65	7490.0
2018-08-03 05:00:00	QQQ	ETF	179.64	179.82	179.61	179.82	8000.0
2018-08-03 06:00:00	QQQ	ETF	179.8	179.9	179.77	179.84	6623.0
2018-08-03 07:00:00	QQQ	ETF	179.84	180.36	179.83	180.22	76936.0
2018-08-03 08:00:00	QQQ	ETF	179.88	180.3499	179.53	179.64	269295.0
2018-08-03 09:00:00	QQQ	ETF	179.65	180.01	179.08	179.45	5253644.0
2018-08-03 10:00:00	QQQ	ETF	179.45	180.09	179.37	179.53	4466955.0
2018-08-03 11:00:00	QQQ	ETF	179.51	179.82	179.26	179.26	2345974.0
2018-08-03 12:00:00	QQQ	ETF	179.26	179.78	179.26	179.6565	2059574.0
2018-08-03 13:00:00	QQQ	ETF	179.66	179.94	179.55	179.91	1732373.0
2018-08-03 14:00:00	QQQ	ETF	179.9	179.94	179.695	179.83	1398504.0
2018-08-03 15:00:00	QQQ	ETF	179.83	180.08	179.7915	180.08	4827417.0
2018-08-03 16:00:00	QQQ	ETF	180.08	180.22	180.0	180.14	1837984.0
2018-08-03 17:00:00	QQQ	ETF	180.18	180.18	180.0	180.0	4288.0
2018-08-03 18:00:00	QQQ	ETF	180.05	180.09	180.0	180.0	1050.0
2018-08-03 19:00:00	QQQ	ETF	180.05	180.05	179.96	179.98	2398.0
2018-08-03 04:00:00	IWM	ETF	167.18	167.18	167.17	167.17	6500.0
2018-08-03 05:00:00	IWM	ETF	167.09	167.19	167.09	167.19	3500.0
2018-08-03 07:00:00	IWM	ETF	167.22	167.5	167.22	167.4	8893.0
2018-08-03 08:00:00	IWM	ETF	167.31	167.4	167.0	167.0	98140.0
2018-08-03 09:00:00	IWM	ETF	167.03	167.6799	166.95	167.18	1454207.0
2018-08-03 10:00:00	IWM	ETF	167.18	167.23	166.13	166.31	3211567.0
2018-08-03 11:00:00	IWM	ETF	166.3	166.48	165.8	165.88	2083377.0
2018-08-03 12:00:00	IWM	ETF	165.8886	166.07	165.61	165.75	1819330.0
2018-08-03 13:00:00	IWM	ETF	165.75	166.12	165.68	165.99	1468435.0
2018-08-03 14:00:00	IWM	ETF	165.98	166.13	165.82	166.12	1419111.0
2018-08-03 15:00:00	IWM	ETF	166.13	166.3	166.07	166.3	3979834.0
2018-08-03 16:00:00	IWM	ETF	166.39	167.1262	166.24	166.47	1826421.0
2018-08-03 17:00:00	IWM	ETF	166.4	166.47	166.39	166.47	3368.0
2018-08-03 19:00:00	IWM	ETF	166.45	166.45	166.45	166.45	100.0
2018-08-03 04:00:00	DIA	ETF	252.87	252.87	252.87	252.87	100.0
2018-08-03 07:00:00	DIA	ETF	253.59	253.9	253.59	253.9	475.0
2018-08-03 08:00:00	DIA	ETF	253.26	253.5001	252.9	253.0	10020.0
2018-08-03 09:00:00	DIA	ETF	253.0	253.56	253.0	253.45	328072.0

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

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