PREVIEW / etf_1hour / 2018-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-13.parquet
  size:    305 KB
  rows:    10,003

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-02-13 04:00:00	SPY	ETF	264.01	264.24	263.66	263.85	46209.0
2018-02-13 05:00:00	SPY	ETF	263.75	264.18	263.63	264.17	23292.0
2018-02-13 06:00:00	SPY	ETF	264.06	264.13	263.5	264.12	146113.0
2018-02-13 07:00:00	SPY	ETF	264.07	264.7	263.97	264.56	186063.0
2018-02-13 08:00:00	SPY	ETF	264.12	264.93	263.76	263.93	428678.0
2018-02-13 09:00:00	SPY	ETF	263.91	264.59	263.31	264.01	9329214.0
2018-02-13 10:00:00	SPY	ETF	263.97	265.16	263.81	264.86	15924865.0
2018-02-13 11:00:00	SPY	ETF	264.87	265.06	264.14	264.83	11753805.0
2018-02-13 12:00:00	SPY	ETF	264.84	265.12	264.24	264.45	5436410.0
2018-02-13 13:00:00	SPY	ETF	264.44	266.21	264.4299	265.89	7250573.0
2018-02-13 14:00:00	SPY	ETF	265.895	266.51	265.63	266.23	8088592.0
2018-02-13 15:00:00	SPY	ETF	266.22	266.62	265.7499	266.01	14388841.0
2018-02-13 16:00:00	SPY	ETF	266.01	266.43	264.65	266.18	5128614.0
2018-02-13 17:00:00	SPY	ETF	266.19	266.25	266.0	266.1	1922789.0
2018-02-13 18:00:00	SPY	ETF	266.11	266.39	266.02	266.36	89969.0
2018-02-13 19:00:00	SPY	ETF	266.34	266.48	266.2	266.4	34826.0
2018-02-13 04:00:00	QQQ	ETF	158.72	158.72	158.17	158.28	8737.0
2018-02-13 05:00:00	QQQ	ETF	158.31	158.56	158.15	158.34	10400.0
2018-02-13 06:00:00	QQQ	ETF	158.18	158.18	157.74	158.18	8224.0
2018-02-13 07:00:00	QQQ	ETF	158.17	158.62	158.05	158.47	73082.0
2018-02-13 08:00:00	QQQ	ETF	158.13	158.73	157.88	157.88	219198.0
2018-02-13 09:00:00	QQQ	ETF	157.89	158.6689	157.61	158.36	4466503.0
2018-02-13 10:00:00	QQQ	ETF	158.35	159.29	158.34	159.04	5273942.0
2018-02-13 11:00:00	QQQ	ETF	159.04	159.11	158.44	158.9199	2910713.0
2018-02-13 12:00:00	QQQ	ETF	158.929	159.11	158.4107	158.57	1851460.0
2018-02-13 13:00:00	QQQ	ETF	158.58	159.7	158.57	159.495	3283083.0
2018-02-13 14:00:00	QQQ	ETF	159.4999	159.93	159.37	159.771	2597700.0
2018-02-13 15:00:00	QQQ	ETF	159.76	160.01	159.43	159.64	6636420.0
2018-02-13 16:00:00	QQQ	ETF	159.66	159.91	158.41	159.79	1067345.0
2018-02-13 17:00:00	QQQ	ETF	159.72	159.89	159.69	159.69	83869.0
2018-02-13 18:00:00	QQQ	ETF	159.72	159.87	159.69	159.86	18463.0
2018-02-13 19:00:00	QQQ	ETF	159.87	159.98	159.82	159.88	22080.0
2018-02-13 04:00:00	IWM	ETF	147.17	147.22	147.0	147.05	9385.0
2018-02-13 05:00:00	IWM	ETF	146.91	147.26	146.9	147.26	9503.0
2018-02-13 06:00:00	IWM	ETF	147.26	147.26	146.75	147.03	67176.0
2018-02-13 07:00:00	IWM	ETF	147.29	147.55	147.17	147.51	40708.0
2018-02-13 08:00:00	IWM	ETF	147.51	147.6	147.1	147.1	129741.0
2018-02-13 09:00:00	IWM	ETF	147.1	148.0299	146.9	147.245	2991958.0
2018-02-13 10:00:00	IWM	ETF	147.24	148.26	147.06	148.05	3015720.0
2018-02-13 11:00:00	IWM	ETF	148.04	148.055	147.53	147.79	1980963.0
2018-02-13 12:00:00	IWM	ETF	147.79	147.92	147.45	147.65	1492085.0
2018-02-13 13:00:00	IWM	ETF	147.65	148.27	147.63	147.99	2237872.0
2018-02-13 14:00:00	IWM	ETF	147.99	148.52	147.96	148.3338	1856983.0
2018-02-13 15:00:00	IWM	ETF	148.34	148.79	148.1	148.49	3937431.0
2018-02-13 16:00:00	IWM	ETF	148.49	148.86	147.82	148.71	680354.0
2018-02-13 17:00:00	IWM	ETF	148.7	148.7	148.68	148.68	1400.0
2018-02-13 18:00:00	IWM	ETF	148.72	148.93	148.63	148.9	6560.0
2018-02-13 19:00:00	IWM	ETF	148.84	148.97	148.81	148.94	10081.0
2018-02-13 05:00:00	DIA	ETF	244.55	244.55	244.55	244.55	100.0
2018-02-13 06:00:00	DIA	ETF	244.45	244.6	244.45	244.6	1600.0

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

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