PREVIEW / etf_1hour / 2018-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-08.parquet
  size:    294 KB
  rows:    9,645

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-06-08 04:00:00	SPY	ETF	276.55	276.55	275.62	275.98	44847.0
2018-06-08 05:00:00	SPY	ETF	276.03	276.23	275.86	275.94	94392.0
2018-06-08 06:00:00	SPY	ETF	275.93	276.38	275.86	276.1	113942.0
2018-06-08 07:00:00	SPY	ETF	276.07	276.79	276.07	276.58	271195.0
2018-06-08 08:00:00	SPY	ETF	277.02	277.37	276.0	276.75	1143711.0
2018-06-08 09:00:00	SPY	ETF	276.76	277.3116	276.66	277.29	7206796.0
2018-06-08 10:00:00	SPY	ETF	277.304	277.34	276.67	277.2	7832123.0
2018-06-08 11:00:00	SPY	ETF	277.19	277.42	276.87	277.22	6291940.0
2018-06-08 12:00:00	SPY	ETF	277.225	277.99	277.21	277.84	5412732.0
2018-06-08 13:00:00	SPY	ETF	277.85	277.9497	277.46	277.69	4751704.0
2018-06-08 14:00:00	SPY	ETF	277.7	278.1	277.67	277.9	3626692.0
2018-06-08 15:00:00	SPY	ETF	277.9	278.25	277.69	278.2	14108349.0
2018-06-08 16:00:00	SPY	ETF	278.19	278.3	278.09	278.24	20031888.0
2018-06-08 17:00:00	SPY	ETF	278.21	278.35	278.12	278.21	367964.0
2018-06-08 18:00:00	SPY	ETF	278.21	278.39	278.18	278.27	114101.0
2018-06-08 19:00:00	SPY	ETF	278.32	278.42	278.31	278.42	14541.0
2018-06-08 04:00:00	QQQ	ETF	173.56	173.56	172.66	173.05	32790.0
2018-06-08 05:00:00	QQQ	ETF	172.99	173.13	172.8	172.88	15136.0
2018-06-08 06:00:00	QQQ	ETF	172.89	173.3	172.75	172.85	104460.0
2018-06-08 07:00:00	QQQ	ETF	172.91	173.42	172.91	173.29	290825.0
2018-06-08 08:00:00	QQQ	ETF	173.29	173.69	172.92	173.45	201118.0
2018-06-08 09:00:00	QQQ	ETF	173.46	173.99	173.38	173.97	4574327.0
2018-06-08 10:00:00	QQQ	ETF	173.98	174.06	173.18	173.8	4710205.0
2018-06-08 11:00:00	QQQ	ETF	173.8	174.24	173.645	173.9673	2956230.0
2018-06-08 12:00:00	QQQ	ETF	173.96	174.46	173.96	174.38	1684271.0
2018-06-08 13:00:00	QQQ	ETF	174.385	174.45	174.12	174.27	2098519.0
2018-06-08 14:00:00	QQQ	ETF	174.27	174.61	174.27	174.45	1563194.0
2018-06-08 15:00:00	QQQ	ETF	174.46	174.7	174.33	174.44	4249174.0
2018-06-08 16:00:00	QQQ	ETF	174.45	174.5	174.31	174.38	1032208.0
2018-06-08 17:00:00	QQQ	ETF	174.42	174.46	174.31	174.45	5708.0
2018-06-08 18:00:00	QQQ	ETF	174.4	174.45	174.4	174.45	700.0
2018-06-08 19:00:00	QQQ	ETF	174.49	174.53	174.42	174.53	5932.0
2018-06-08 04:00:00	IWM	ETF	165.53	165.53	165.4	165.48	2363.0
2018-06-08 05:00:00	IWM	ETF	165.42	165.52	165.42	165.46	16100.0
2018-06-08 06:00:00	IWM	ETF	165.35	165.58	165.35	165.5	1888.0
2018-06-08 07:00:00	IWM	ETF	165.6	165.92	165.56	165.83	13199.0
2018-06-08 08:00:00	IWM	ETF	165.8501	166.16	165.8	166.08	19445.0
2018-06-08 09:00:00	IWM	ETF	166.07	166.41	165.78	166.35	1951216.0
2018-06-08 10:00:00	IWM	ETF	166.34	166.47	165.76	166.01	1796093.0
2018-06-08 11:00:00	IWM	ETF	166.0	166.19	165.81	166.15	1262879.0
2018-06-08 12:00:00	IWM	ETF	166.15	166.48	166.12	166.445	888029.0
2018-06-08 13:00:00	IWM	ETF	166.44	166.57	166.2	166.44	1341200.0
2018-06-08 14:00:00	IWM	ETF	166.45	166.61	166.39	166.43	1612267.0
2018-06-08 15:00:00	IWM	ETF	166.43	166.6	166.3575	166.52	3579133.0
2018-06-08 16:00:00	IWM	ETF	166.5	166.52	166.32	166.36	719051.0
2018-06-08 17:00:00	IWM	ETF	166.43	166.43	166.36	166.4	4955.0
2018-06-08 18:00:00	IWM	ETF	166.46	166.46	166.46	166.46	200.0
2018-06-08 19:00:00	IWM	ETF	166.49	166.5	166.49	166.5	1100.0
2018-06-08 04:00:00	DIA	ETF	252.0	252.0	251.06	251.06	2825.0
2018-06-08 05:00:00	DIA	ETF	251.29	251.3	251.29	251.3	600.0

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

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