PREVIEW / etf_30min / 2017-03-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-14.parquet
  size:    422 KB
  rows:    14,527

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-14 04:00:00	SPY	ETF	237.89	237.89	237.38	237.38	11944.0
2017-03-14 04:30:00	SPY	ETF	237.37	237.44	237.29	237.31	12402.0
2017-03-14 05:00:00	SPY	ETF	237.33	237.46	237.33	237.46	4709.0
2017-03-14 05:30:00	SPY	ETF	237.46	237.53	237.46	237.53	9102.0
2017-03-14 06:00:00	SPY	ETF	237.5	237.58	237.5	237.57	2204.0
2017-03-14 06:30:00	SPY	ETF	237.5	237.51	237.41	237.51	19025.0
2017-03-14 07:00:00	SPY	ETF	237.54	237.55	237.36	237.36	41766.0
2017-03-14 07:30:00	SPY	ETF	237.36	237.48	237.28	237.3	105527.0
2017-03-14 08:00:00	SPY	ETF	237.3	237.48	236.9	237.0	408189.0
2017-03-14 08:30:00	SPY	ETF	237.02	237.22	236.97	237.11	244282.0
2017-03-14 09:00:00	SPY	ETF	237.11	237.23	237.07	237.2	440240.0
2017-03-14 09:30:00	SPY	ETF	237.18	237.24	236.7	236.85	6474024.0
2017-03-14 10:00:00	SPY	ETF	236.855	237.2	236.32	236.3799	5783169.0
2017-03-14 10:30:00	SPY	ETF	236.37	236.62	236.19	236.62	5781666.0
2017-03-14 11:00:00	SPY	ETF	236.62	236.98	236.34	236.86	4988751.0
2017-03-14 11:30:00	SPY	ETF	236.86	237.0	236.76	236.955	2872739.0
2017-03-14 12:00:00	SPY	ETF	236.955	237.0146	236.415	236.59	3305578.0
2017-03-14 12:30:00	SPY	ETF	236.585	237.15	236.45	236.54	1718102.0
2017-03-14 13:00:00	SPY	ETF	236.54	237.07	236.49	236.83	2959706.0
2017-03-14 13:30:00	SPY	ETF	236.82	236.88	236.66	236.71	4281654.0
2017-03-14 14:00:00	SPY	ETF	236.7	236.81	236.6	236.77	2145419.0
2017-03-14 14:30:00	SPY	ETF	236.77	236.95	236.67	236.74	1992043.0
2017-03-14 15:00:00	SPY	ETF	236.74	237.03	236.72	237.015	2140390.0
2017-03-14 15:30:00	SPY	ETF	237.02	237.03	236.84	236.93	6723646.0
2017-03-14 16:00:00	SPY	ETF	236.94	237.1	236.86	236.99	4958361.0
2017-03-14 16:30:00	SPY	ETF	236.99	237.07	236.9	237.05	1290032.0
2017-03-14 17:00:00	SPY	ETF	237.04	237.7381	237.0	237.03	56121.0
2017-03-14 17:30:00	SPY	ETF	237.03	237.07	237.0	237.05	26607.0
2017-03-14 18:00:00	SPY	ETF	237.05	237.1	237.04	237.08	13255.0
2017-03-14 18:30:00	SPY	ETF	237.06	237.14	237.06	237.1	6192.0
2017-03-14 19:00:00	SPY	ETF	237.1	237.13	237.08	237.1	7359.0
2017-03-14 19:30:00	SPY	ETF	237.07	237.1	237.06	237.08	9729.0
2017-03-14 04:00:00	QQQ	ETF	131.48	131.48	131.48	131.48	371.0
2017-03-14 04:30:00	QQQ	ETF	131.46	131.46	131.4	131.43	30800.0
2017-03-14 06:00:00	QQQ	ETF	131.53	131.55	131.53	131.55	24997.0
2017-03-14 07:00:00	QQQ	ETF	131.5	131.5	131.47	131.47	800.0
2017-03-14 07:30:00	QQQ	ETF	131.43	131.48	131.43	131.47	10789.0
2017-03-14 08:00:00	QQQ	ETF	131.43	131.44	131.21	131.25	203625.0
2017-03-14 08:30:00	QQQ	ETF	131.27	131.29	131.26	131.27	16058.0
2017-03-14 09:00:00	QQQ	ETF	131.28	131.33	131.26	131.31	39052.0
2017-03-14 09:30:00	QQQ	ETF	131.31	131.36	131.02	131.14	2505473.0
2017-03-14 10:00:00	QQQ	ETF	131.14	131.16	130.83	130.84	1512108.0
2017-03-14 10:30:00	QQQ	ETF	130.84	131.01	130.76	131.01	1089767.0
2017-03-14 11:00:00	QQQ	ETF	131.0	131.13	130.88	131.08	820303.0
2017-03-14 11:30:00	QQQ	ETF	131.0931	131.2	131.05	131.18	515707.0
2017-03-14 12:00:00	QQQ	ETF	131.18	131.23	130.94	131.04	656886.0
2017-03-14 12:30:00	QQQ	ETF	131.03	131.09	130.995	131.038	511791.0
2017-03-14 13:00:00	QQQ	ETF	131.03	131.22	131.02	131.2	455791.0
2017-03-14 13:30:00	QQQ	ETF	131.18	131.2446	131.14	131.17	677739.0
2017-03-14 14:00:00	QQQ	ETF	131.18	131.21	131.09	131.17	491219.0

> showing 50 of 14,527 rows — these rows as CSV

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