PREVIEW / etf_1hour / 2017-03-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	237.45	237.51	237.35	237.51	1300.0
2017-03-13 05:00:00	SPY	ETF	237.49	237.49	237.3	237.33	10393.0
2017-03-13 06:00:00	SPY	ETF	237.31	237.35	237.27	237.31	17487.0
2017-03-13 07:00:00	SPY	ETF	237.3	237.49	237.22	237.43	74327.0
2017-03-13 08:00:00	SPY	ETF	237.32	237.76	237.25	237.65	3985164.0
2017-03-13 09:00:00	SPY	ETF	237.57	237.86	237.44	237.45	4538289.0
2017-03-13 10:00:00	SPY	ETF	237.45	237.69	237.39	237.51	8126395.0
2017-03-13 11:00:00	SPY	ETF	237.51	237.63	237.24	237.62	5892510.0
2017-03-13 12:00:00	SPY	ETF	237.62	237.69	237.36	237.52	4038493.0
2017-03-13 13:00:00	SPY	ETF	237.5246	237.58	237.33	237.4774	3327837.0
2017-03-13 14:00:00	SPY	ETF	237.475	237.66	237.4	237.66	3237274.0
2017-03-13 15:00:00	SPY	ETF	237.66	237.85	237.57	237.76	14699899.0
2017-03-13 16:00:00	SPY	ETF	237.76	237.85	237.71	237.77	8336309.0
2017-03-13 17:00:00	SPY	ETF	237.77	237.77	237.72	237.75	87413.0
2017-03-13 18:00:00	SPY	ETF	237.75	237.79	237.71	237.73	168936.0
2017-03-13 19:00:00	SPY	ETF	237.72	237.8	237.69	237.8	1022139.0
2017-03-13 04:00:00	QQQ	ETF	131.32	131.32	131.32	131.32	300.0
2017-03-13 05:00:00	QQQ	ETF	131.26	131.26	131.26	131.26	200.0
2017-03-13 06:00:00	QQQ	ETF	131.22	131.25	131.19	131.23	17595.0
2017-03-13 07:00:00	QQQ	ETF	131.16	131.24	131.16	131.2	12294.0
2017-03-13 08:00:00	QQQ	ETF	131.2	131.32	131.2	131.3	66205.0
2017-03-13 09:00:00	QQQ	ETF	131.3	131.53	131.26	131.37	1197490.0
2017-03-13 10:00:00	QQQ	ETF	131.37	131.45	131.27	131.3753	1647527.0
2017-03-13 11:00:00	QQQ	ETF	131.37	131.475	131.32	131.455	1038854.0
2017-03-13 12:00:00	QQQ	ETF	131.45	131.52	131.32	131.455	922487.0
2017-03-13 13:00:00	QQQ	ETF	131.46	131.52	131.4	131.4657	989905.0
2017-03-13 14:00:00	QQQ	ETF	131.46	131.59	131.425	131.57	1166478.0
2017-03-13 15:00:00	QQQ	ETF	131.57	131.64	131.51	131.59	2087156.0
2017-03-13 16:00:00	QQQ	ETF	131.61	131.62	131.46	131.61	357762.0
2017-03-13 17:00:00	QQQ	ETF	131.5834	131.63	131.5834	131.63	20800.0
2017-03-13 18:00:00	QQQ	ETF	131.62	131.64	131.59	131.61	8660.0
2017-03-13 19:00:00	QQQ	ETF	131.61	131.61	131.57	131.57	2613.0
2017-03-13 04:00:00	IWM	ETF	135.7	135.7	135.63	135.66	600.0
2017-03-13 06:00:00	IWM	ETF	135.5	135.5	135.47	135.47	1500.0
2017-03-13 07:00:00	IWM	ETF	135.49	135.58	135.37	135.58	54502.0
2017-03-13 08:00:00	IWM	ETF	135.52	135.82	135.52	135.7	67274.0
2017-03-13 09:00:00	IWM	ETF	135.62	136.26	135.56	135.88	1997591.0
2017-03-13 10:00:00	IWM	ETF	135.88	136.79	135.875	136.6	4529991.0
2017-03-13 11:00:00	IWM	ETF	136.6	136.615	136.05	136.48	2843969.0
2017-03-13 12:00:00	IWM	ETF	136.47	136.55	136.12	136.34	1771182.0
2017-03-13 13:00:00	IWM	ETF	136.35	136.42	135.88	136.115	2337891.0
2017-03-13 14:00:00	IWM	ETF	136.11	136.36	136.07	136.325	1518563.0
2017-03-13 15:00:00	IWM	ETF	136.33	136.44	136.145	136.32	3805427.0
2017-03-13 16:00:00	IWM	ETF	136.28	136.42	136.26	136.35	1048357.0
2017-03-13 17:00:00	IWM	ETF	136.35	136.35	136.35	136.35	200.0
2017-03-13 18:00:00	IWM	ETF	136.31	136.34	136.3	136.34	2060.0
2017-03-13 19:00:00	IWM	ETF	136.31	136.31	136.27	136.27	1624.0
2017-03-13 08:00:00	DIA	ETF	208.96	209.21	208.96	209.21	13504.0
2017-03-13 09:00:00	DIA	ETF	209.25	209.34	208.9	208.9	255261.0
2017-03-13 10:00:00	DIA	ETF	208.88	209.02	208.67	208.83	479171.0

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

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