PREVIEW / etf_1hour / 2018-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-09.parquet
  size:    299 KB
  rows:    9,806

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-05-09 04:00:00	SPY	ETF	267.65	268.3	267.29	268.3	22465.0
2018-05-09 05:00:00	SPY	ETF	268.31	268.36	268.12	268.24	16498.0
2018-05-09 06:00:00	SPY	ETF	268.29	268.32	267.97	268.1	57802.0
2018-05-09 07:00:00	SPY	ETF	268.06	268.18	267.82	267.82	113779.0
2018-05-09 08:00:00	SPY	ETF	267.85	268.16	267.25	267.76	332873.0
2018-05-09 09:00:00	SPY	ETF	267.76	268.06	267.37	267.635	5652951.0
2018-05-09 10:00:00	SPY	ETF	267.63	268.03	267.12	267.18	6464003.0
2018-05-09 11:00:00	SPY	ETF	267.19	267.8	267.09	267.73	4896168.0
2018-05-09 12:00:00	SPY	ETF	267.74	269.21	267.725	269.04	7113879.0
2018-05-09 13:00:00	SPY	ETF	269.045	269.68	268.93	269.63	6953622.0
2018-05-09 14:00:00	SPY	ETF	269.64	269.865	269.18	269.62	5805778.0
2018-05-09 15:00:00	SPY	ETF	269.62	269.76	269.02	269.48	14909820.0
2018-05-09 16:00:00	SPY	ETF	269.47	269.62	269.4115	269.52	5974337.0
2018-05-09 17:00:00	SPY	ETF	269.49	269.55	269.48	269.52	95597.0
2018-05-09 18:00:00	SPY	ETF	269.52	269.7	269.46	269.54	77631.0
2018-05-09 19:00:00	SPY	ETF	269.53	269.54	269.21	269.49	44434.0
2018-05-09 04:00:00	QQQ	ETF	166.38	166.75	166.32	166.75	15189.0
2018-05-09 05:00:00	QQQ	ETF	166.76	166.8	166.62	166.77	13284.0
2018-05-09 06:00:00	QQQ	ETF	166.73	166.73	166.51	166.52	9146.0
2018-05-09 07:00:00	QQQ	ETF	166.53	166.7	166.49	166.5	93689.0
2018-05-09 08:00:00	QQQ	ETF	166.55	166.65	166.4	166.4497	85181.0
2018-05-09 09:00:00	QQQ	ETF	166.42	166.68	166.05	166.12	2929519.0
2018-05-09 10:00:00	QQQ	ETF	166.13	166.57	165.8	165.9	2883421.0
2018-05-09 11:00:00	QQQ	ETF	165.91	166.4728	165.78	166.46	1975107.0
2018-05-09 12:00:00	QQQ	ETF	166.46	167.37	166.42	167.2762	3078879.0
2018-05-09 13:00:00	QQQ	ETF	167.2799	167.87	167.161	167.8	3281721.0
2018-05-09 14:00:00	QQQ	ETF	167.81	168.0	167.59	167.91	4013864.0
2018-05-09 15:00:00	QQQ	ETF	167.89	168.0	167.62	167.895	5567517.0
2018-05-09 16:00:00	QQQ	ETF	167.89	168.05	167.8142	167.89	2502303.0
2018-05-09 17:00:00	QQQ	ETF	167.96	167.96	167.86	167.9	7415.0
2018-05-09 18:00:00	QQQ	ETF	167.92	168.0	167.86	167.91	26986.0
2018-05-09 19:00:00	QQQ	ETF	167.88	167.9	167.75	167.87	33225.0
2018-05-09 04:00:00	IWM	ETF	158.35	158.71	158.35	158.71	1523.0
2018-05-09 05:00:00	IWM	ETF	158.73	158.78	158.68	158.68	5997.0
2018-05-09 06:00:00	IWM	ETF	158.58	158.58	158.42	158.42	14803.0
2018-05-09 07:00:00	IWM	ETF	158.52	158.52	158.24	158.24	20184.0
2018-05-09 08:00:00	IWM	ETF	158.25	158.29	158.08	158.08	14033.0
2018-05-09 09:00:00	IWM	ETF	158.08	158.44	157.83	158.105	1609563.0
2018-05-09 10:00:00	IWM	ETF	158.12	158.36	157.42	157.53	1823730.0
2018-05-09 11:00:00	IWM	ETF	157.54	157.92	157.38	157.875	1146525.0
2018-05-09 12:00:00	IWM	ETF	157.89	158.6	157.84	158.52	1598706.0
2018-05-09 13:00:00	IWM	ETF	158.52	159.07	158.52	159.05	1698961.0
2018-05-09 14:00:00	IWM	ETF	159.04	159.1	158.82	158.93	1262179.0
2018-05-09 15:00:00	IWM	ETF	158.92	158.93	158.645	158.69	3050924.0
2018-05-09 16:00:00	IWM	ETF	158.69	158.9	158.67	158.88	1074816.0
2018-05-09 17:00:00	IWM	ETF	158.87	158.87	158.68	158.87	581.0
2018-05-09 18:00:00	IWM	ETF	158.87	158.9	158.78	158.78	5573.0
2018-05-09 19:00:00	IWM	ETF	158.79	158.84	158.65	158.84	5841.0
2018-05-09 04:00:00	DIA	ETF	243.83	244.74	243.83	244.74	2826.0
2018-05-09 05:00:00	DIA	ETF	245.0	245.01	245.0	245.01	400.0

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

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