PREVIEW / etf_1hour / 2017-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-07.parquet
  size:    272 KB
  rows:    8,816

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
2017-03-07 04:00:00	SPY	ETF	237.64	237.64	237.47	237.57	5060.0
2017-03-07 05:00:00	SPY	ETF	237.57	237.57	237.4	237.44	4100.0
2017-03-07 06:00:00	SPY	ETF	237.37	237.49	237.37	237.42	10400.0
2017-03-07 07:00:00	SPY	ETF	237.38	237.55	237.38	237.45	130924.0
2017-03-07 08:00:00	SPY	ETF	237.39	237.55	237.28	237.51	267468.0
2017-03-07 09:00:00	SPY	ETF	237.51	237.7576	236.92	237.175	7507614.0
2017-03-07 10:00:00	SPY	ETF	237.17	237.77	237.11	237.48	8737812.0
2017-03-07 11:00:00	SPY	ETF	237.48	237.555	237.02	237.24	4914154.0
2017-03-07 12:00:00	SPY	ETF	237.25	237.34	237.05	237.33	3582893.0
2017-03-07 13:00:00	SPY	ETF	237.33	237.49	237.16	237.18	3491537.0
2017-03-07 14:00:00	SPY	ETF	237.1847	237.45	237.14	237.4	4261012.0
2017-03-07 15:00:00	SPY	ETF	237.4	237.44	236.76	237.05	12995346.0
2017-03-07 16:00:00	SPY	ETF	237.055	237.07	236.85	236.91	7250659.0
2017-03-07 17:00:00	SPY	ETF	236.94	237.71	236.8	236.85	5488972.0
2017-03-07 18:00:00	SPY	ETF	236.85	236.9	236.66	236.66	135663.0
2017-03-07 19:00:00	SPY	ETF	236.7	237.0673	236.36	236.64	371261.0
2017-03-07 04:00:00	QQQ	ETF	130.7	130.7	130.63	130.63	1200.0
2017-03-07 05:00:00	QQQ	ETF	130.66	130.66	130.56	130.56	900.0
2017-03-07 06:00:00	QQQ	ETF	130.53	130.56	130.53	130.56	600.0
2017-03-07 07:00:00	QQQ	ETF	130.56	130.59	130.56	130.56	11711.0
2017-03-07 08:00:00	QQQ	ETF	130.61	130.61	130.49	130.54	36721.0
2017-03-07 09:00:00	QQQ	ETF	130.53	130.65	130.34	130.54	1336536.0
2017-03-07 10:00:00	QQQ	ETF	130.53	131.08	130.5	130.95	2936139.0
2017-03-07 11:00:00	QQQ	ETF	130.949	130.96	130.55	130.62	2047776.0
2017-03-07 12:00:00	QQQ	ETF	130.6242	130.64	130.43	130.62	946577.0
2017-03-07 13:00:00	QQQ	ETF	130.64	130.77	130.6	130.6107	697491.0
2017-03-07 14:00:00	QQQ	ETF	130.61	130.75	130.57	130.71	1320263.0
2017-03-07 15:00:00	QQQ	ETF	130.71	130.75	130.28	130.51	2877137.0
2017-03-07 16:00:00	QQQ	ETF	130.51	130.54	130.45	130.49	370158.0
2017-03-07 17:00:00	QQQ	ETF	130.5	130.51	130.5	130.5	2451.0
2017-03-07 18:00:00	QQQ	ETF	130.45	130.46	130.36	130.39	5700.0
2017-03-07 19:00:00	QQQ	ETF	130.35	130.35	130.26	130.33	9300.0
2017-03-07 05:00:00	IWM	ETF	137.47	137.47	137.47	137.47	100.0
2017-03-07 07:00:00	IWM	ETF	137.4	137.55	137.4	137.49	62032.0
2017-03-07 08:00:00	IWM	ETF	137.44	137.58	137.32	137.51	103269.0
2017-03-07 09:00:00	IWM	ETF	137.5	137.69	136.915	137.09	3319666.0
2017-03-07 10:00:00	IWM	ETF	137.09	137.74	137.03	137.545	2889573.0
2017-03-07 11:00:00	IWM	ETF	137.55	137.61	137.04	137.36	3284385.0
2017-03-07 12:00:00	IWM	ETF	137.36	137.49	137.145	137.455	2024861.0
2017-03-07 13:00:00	IWM	ETF	137.46	137.53	136.94	137.01	2027128.0
2017-03-07 14:00:00	IWM	ETF	137.0	137.2	136.95	137.16	2086397.0
2017-03-07 15:00:00	IWM	ETF	137.16	137.27	136.61	136.75	6309581.0
2017-03-07 16:00:00	IWM	ETF	136.8	136.8	136.65	136.7	3740540.0
2017-03-07 17:00:00	IWM	ETF	136.67	136.72	136.66	136.66	9559.0
2017-03-07 18:00:00	IWM	ETF	136.72	136.72	136.61	136.61	480.0
2017-03-07 19:00:00	IWM	ETF	136.61	136.61	136.52	136.54	5326.0
2017-03-07 08:00:00	DIA	ETF	209.39	209.39	209.27	209.27	19300.0
2017-03-07 09:00:00	DIA	ETF	209.36	209.37	208.975	209.17	345510.0
2017-03-07 10:00:00	DIA	ETF	209.16	209.66	209.12	209.44	293470.0
2017-03-07 11:00:00	DIA	ETF	209.45	209.51	209.105	209.25	217048.0

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

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