PREVIEW / etf_30min / 2015-04-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-28.parquet
  size:    376 KB
  rows:    12,725

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
2015-04-28 04:00:00	SPY	ETF	210.7	210.7	210.11	210.45	4816.0
2015-04-28 04:30:00	SPY	ETF	210.45	210.5	210.45	210.5	1101.0
2015-04-28 05:00:00	SPY	ETF	210.57	210.57	210.49	210.5	5200.0
2015-04-28 05:30:00	SPY	ETF	210.47	210.49	210.42	210.45	8852.0
2015-04-28 06:00:00	SPY	ETF	210.49	210.63	210.45	210.45	11370.0
2015-04-28 06:30:00	SPY	ETF	210.45	210.5	210.11	210.2	62250.0
2015-04-28 07:00:00	SPY	ETF	210.25	210.3	210.05	210.2	149872.0
2015-04-28 07:30:00	SPY	ETF	210.2	210.28	210.08	210.28	108495.0
2015-04-28 08:00:00	SPY	ETF	210.45	210.94	210.12	210.37	328341.0
2015-04-28 08:30:00	SPY	ETF	210.36	210.57	210.36	210.53	362040.0
2015-04-28 09:00:00	SPY	ETF	210.54	210.74	210.53	210.71	729787.0
2015-04-28 09:30:00	SPY	ETF	210.74	210.92	210.4	210.63	9842694.0
2015-04-28 10:00:00	SPY	ETF	210.63	210.63	209.3301	209.98	16174233.0
2015-04-28 10:30:00	SPY	ETF	209.97	210.62	209.9	210.4099	8713456.0
2015-04-28 11:00:00	SPY	ETF	210.41	211.03	210.4	210.78	6579659.0
2015-04-28 11:30:00	SPY	ETF	210.78	211.27	210.77	211.1	5048940.0
2015-04-28 12:00:00	SPY	ETF	211.1	211.235	210.93	211.12	3139137.0
2015-04-28 12:30:00	SPY	ETF	211.12	211.46	211.035	211.3062	4102305.0
2015-04-28 13:00:00	SPY	ETF	211.3	211.5	211.24	211.3128	2662466.0
2015-04-28 13:30:00	SPY	ETF	211.32	211.435	211.17	211.29	2720043.0
2015-04-28 14:00:00	SPY	ETF	211.29	211.295	210.97	211.07	3868553.0
2015-04-28 14:30:00	SPY	ETF	211.07	211.3	210.95	211.18	2546330.0
2015-04-28 15:00:00	SPY	ETF	211.18	211.43	211.15	211.27	4971204.0
2015-04-28 15:30:00	SPY	ETF	211.26	211.43	211.06	211.42	8720354.0
2015-04-28 16:00:00	SPY	ETF	211.42	211.7	211.3529	211.65	3106416.0
2015-04-28 16:30:00	SPY	ETF	211.64	211.68	211.62	211.63	1449247.0
2015-04-28 17:00:00	SPY	ETF	211.631	211.65	211.57	211.58	843054.0
2015-04-28 17:30:00	SPY	ETF	211.58	211.62	211.57	211.57	31816.0
2015-04-28 18:00:00	SPY	ETF	211.56	211.59	211.53	211.55	26287.0
2015-04-28 18:30:00	SPY	ETF	211.55	211.55	211.49	211.52	30755.0
2015-04-28 19:00:00	SPY	ETF	211.52	211.56	211.5	211.53	6225.0
2015-04-28 19:30:00	SPY	ETF	211.54	211.55	211.51	211.54	15970.0
2015-04-28 06:00:00	QQQ	ETF	110.32	110.38	110.31	110.31	21499.0
2015-04-28 06:30:00	QQQ	ETF	110.27	110.32	110.22	110.25	19900.0
2015-04-28 07:00:00	QQQ	ETF	110.24	110.3	110.17	110.24	33067.0
2015-04-28 07:30:00	QQQ	ETF	110.25	110.29	110.19	110.29	20559.0
2015-04-28 08:00:00	QQQ	ETF	110.3	110.35	110.23	110.28	92241.0
2015-04-28 08:30:00	QQQ	ETF	110.28	110.34	110.25	110.3	79189.0
2015-04-28 09:00:00	QQQ	ETF	110.31	110.39	110.27	110.33	352237.0
2015-04-28 09:30:00	QQQ	ETF	110.34	110.41	109.8	109.82	5692050.0
2015-04-28 10:00:00	QQQ	ETF	109.81	109.87	109.11	109.62	5610010.0
2015-04-28 10:30:00	QQQ	ETF	109.62	110.04	109.5699	109.86	2879222.0
2015-04-28 11:00:00	QQQ	ETF	109.86	110.24	109.85	110.05	2189300.0
2015-04-28 11:30:00	QQQ	ETF	110.06	110.35	110.06	110.303	1530880.0
2015-04-28 12:00:00	QQQ	ETF	110.3	110.47	110.255	110.3849	927254.0
2015-04-28 12:30:00	QQQ	ETF	110.38	110.55	110.2634	110.4362	938705.0
2015-04-28 13:00:00	QQQ	ETF	110.436	110.54	110.39	110.39	609519.0
2015-04-28 13:30:00	QQQ	ETF	110.395	110.42	110.23	110.27	1192182.0
2015-04-28 14:00:00	QQQ	ETF	110.266	110.266	110.01	110.08	1138216.0
2015-04-28 14:30:00	QQQ	ETF	110.07	110.209	109.97	110.06	969321.0

> showing 50 of 12,725 rows — these rows as CSV

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