PREVIEW / etf_1hour / 2016-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-21.parquet
  size:    248 KB
  rows:    8,030

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
2016-06-21 04:00:00	SPY	ETF	208.6	208.79	208.49	208.65	75805.0
2016-06-21 05:00:00	SPY	ETF	208.58	208.6	208.42	208.52	90897.0
2016-06-21 06:00:00	SPY	ETF	208.48	208.92	208.48	208.83	44754.0
2016-06-21 07:00:00	SPY	ETF	208.8	208.84	208.64	208.71	140894.0
2016-06-21 08:00:00	SPY	ETF	208.7	208.8	208.09	208.34	1110494.0
2016-06-21 09:00:00	SPY	ETF	208.33	208.46	207.95	208.17	7664100.0
2016-06-21 10:00:00	SPY	ETF	208.16	208.3724	207.78	208.12	13691223.0
2016-06-21 11:00:00	SPY	ETF	208.12	208.63	208.02	208.27	9111291.0
2016-06-21 12:00:00	SPY	ETF	208.28	208.53	208.16	208.26	4753340.0
2016-06-21 13:00:00	SPY	ETF	208.27	208.41	208.0	208.295	6114348.0
2016-06-21 14:00:00	SPY	ETF	208.295	208.92	208.2	208.585	8493502.0
2016-06-21 15:00:00	SPY	ETF	208.5801	208.86	208.34	208.39	16602741.0
2016-06-21 16:00:00	SPY	ETF	208.4	208.54	208.25	208.29	3408531.0
2016-06-21 17:00:00	SPY	ETF	208.31	208.44	208.27	208.34	291715.0
2016-06-21 18:00:00	SPY	ETF	208.33	208.33	208.11	208.19	102095.0
2016-06-21 19:00:00	SPY	ETF	208.21	208.3	208.15	208.15	30353.0
2016-06-21 04:00:00	QQQ	ETF	107.56	107.56	107.54	107.54	9000.0
2016-06-21 05:00:00	QQQ	ETF	107.51	107.51	107.39	107.48	6399.0
2016-06-21 06:00:00	QQQ	ETF	107.48	107.66	107.48	107.66	2499.0
2016-06-21 07:00:00	QQQ	ETF	107.64	107.67	107.57	107.63	17415.0
2016-06-21 08:00:00	QQQ	ETF	107.58	107.64	107.29	107.43	115464.0
2016-06-21 09:00:00	QQQ	ETF	107.4	107.62	107.25	107.5801	5358066.0
2016-06-21 10:00:00	QQQ	ETF	107.56	107.59	107.19	107.23	2771520.0
2016-06-21 11:00:00	QQQ	ETF	107.23	107.52	107.1899	107.39	1856611.0
2016-06-21 12:00:00	QQQ	ETF	107.39	107.6	107.28	107.2999	921207.0
2016-06-21 13:00:00	QQQ	ETF	107.3	107.42	107.1	107.29	1231984.0
2016-06-21 14:00:00	QQQ	ETF	107.3	107.65	107.23	107.475	1746425.0
2016-06-21 15:00:00	QQQ	ETF	107.48	107.715	107.32	107.46	3961101.0
2016-06-21 16:00:00	QQQ	ETF	107.46	107.5	107.28	107.31	400396.0
2016-06-21 17:00:00	QQQ	ETF	107.37	107.47	107.29	107.34	88457.0
2016-06-21 18:00:00	QQQ	ETF	107.35	107.35	107.21	107.26	82990.0
2016-06-21 19:00:00	QQQ	ETF	107.28	107.29	107.19	107.19	7384.0
2016-06-21 04:00:00	IWM	ETF	115.7	115.75	115.7	115.75	399.0
2016-06-21 06:00:00	IWM	ETF	115.81	115.81	115.81	115.81	600.0
2016-06-21 07:00:00	IWM	ETF	115.8	115.8	115.71	115.74	6300.0
2016-06-21 08:00:00	IWM	ETF	115.67	115.69	115.31	115.45	13026.0
2016-06-21 09:00:00	IWM	ETF	115.43	115.48	114.79	114.97	3533418.0
2016-06-21 10:00:00	IWM	ETF	114.94	115.16	114.42	114.46	5232220.0
2016-06-21 11:00:00	IWM	ETF	114.45	115.03	114.33	114.59	3509779.0
2016-06-21 12:00:00	IWM	ETF	114.59	114.71	114.44	114.558	1247237.0
2016-06-21 13:00:00	IWM	ETF	114.55	114.73	114.35	114.63	1727920.0
2016-06-21 14:00:00	IWM	ETF	114.62	115.38	114.545	115.07	3130982.0
2016-06-21 15:00:00	IWM	ETF	115.07	115.205	114.91	115.06	4809430.0
2016-06-21 16:00:00	IWM	ETF	115.08	115.11	114.9	114.96	3984178.0
2016-06-21 17:00:00	IWM	ETF	114.95	115.02	114.93	115.02	1725.0
2016-06-21 18:00:00	IWM	ETF	114.92	114.95	114.91	114.95	4422.0
2016-06-21 19:00:00	IWM	ETF	114.95	114.98	114.95	114.95	600.0
2016-06-21 06:00:00	DIA	ETF	178.6	178.6	178.53	178.53	500.0
2016-06-21 07:00:00	DIA	ETF	178.52	178.52	178.52	178.52	100.0
2016-06-21 09:00:00	DIA	ETF	178.13	178.29	177.84	178.02	336537.0

> showing 50 of 8,030 rows — these rows as CSV

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