PREVIEW / etf_30min / 2015-05-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-08.parquet
  size:    381 KB
  rows:    12,820

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-05-08 04:00:00	SPY	ETF	209.36	209.47	209.2	209.25	22996.0
2015-05-08 04:30:00	SPY	ETF	209.3	209.35	209.15	209.25	10001.0
2015-05-08 05:00:00	SPY	ETF	209.25	209.27	209.21	209.23	28258.0
2015-05-08 05:30:00	SPY	ETF	209.28	209.3	209.2	209.22	5503.0
2015-05-08 06:00:00	SPY	ETF	209.13	209.38	209.1	209.33	8811.0
2015-05-08 06:30:00	SPY	ETF	209.28	209.4	209.28	209.29	14763.0
2015-05-08 07:00:00	SPY	ETF	209.35	209.43	209.27	209.4	77280.0
2015-05-08 07:30:00	SPY	ETF	209.42	209.43	209.23	209.36	258697.0
2015-05-08 08:00:00	SPY	ETF	209.36	209.7	209.26	209.41	412615.0
2015-05-08 08:30:00	SPY	ETF	209.41	211.2	209.31	210.89	6516561.0
2015-05-08 09:00:00	SPY	ETF	210.87	210.99	210.71	210.87	2280400.0
2015-05-08 09:30:00	SPY	ETF	210.88	211.43	210.78	211.29	22710564.0
2015-05-08 10:00:00	SPY	ETF	211.29	211.58	211.23	211.36	13784322.0
2015-05-08 10:30:00	SPY	ETF	211.365	211.49	211.29	211.415	6240319.0
2015-05-08 11:00:00	SPY	ETF	211.415	211.66	211.41	211.51	7432943.0
2015-05-08 11:30:00	SPY	ETF	211.52	211.86	211.5	211.74	8473874.0
2015-05-08 12:00:00	SPY	ETF	211.74	211.82	211.52	211.6	5976464.0
2015-05-08 12:30:00	SPY	ETF	211.605	211.675	211.52	211.6099	4819516.0
2015-05-08 13:00:00	SPY	ETF	211.6	211.77	211.535	211.55	6238175.0
2015-05-08 13:30:00	SPY	ETF	211.555	211.59	211.395	211.42	5631094.0
2015-05-08 14:00:00	SPY	ETF	211.43	211.48	211.3422	211.35	9137967.0
2015-05-08 14:30:00	SPY	ETF	211.36	211.58	211.3	211.57	9925928.0
2015-05-08 15:00:00	SPY	ETF	211.57	211.65	211.45	211.5	6416197.0
2015-05-08 15:30:00	SPY	ETF	211.5	211.76	211.495	211.62	16620063.0
2015-05-08 16:00:00	SPY	ETF	211.63	211.673	208.8568	211.4	13403007.0
2015-05-08 16:30:00	SPY	ETF	211.41	211.43	211.36	211.36	3818769.0
2015-05-08 17:00:00	SPY	ETF	211.37	211.41	211.34	211.41	93718.0
2015-05-08 17:30:00	SPY	ETF	211.4	211.62	210.86	211.48	2772880.0
2015-05-08 18:00:00	SPY	ETF	211.47	211.52	211.47	211.5	50542.0
2015-05-08 18:30:00	SPY	ETF	211.5	211.52	211.48	211.52	4965.0
2015-05-08 19:00:00	SPY	ETF	211.51	211.51	211.47	211.47	11064.0
2015-05-08 19:30:00	SPY	ETF	211.47	211.59	211.47	211.59	34849.0
2015-05-08 04:00:00	QQQ	ETF	107.8	107.8	107.71	107.77	11350.0
2015-05-08 04:30:00	QQQ	ETF	107.7	107.81	107.7	107.81	9733.0
2015-05-08 05:00:00	QQQ	ETF	107.72	107.72	107.72	107.72	25286.0
2015-05-08 05:30:00	QQQ	ETF	107.72	107.73	107.72	107.72	15199.0
2015-05-08 06:00:00	QQQ	ETF	107.72	107.75	107.72	107.75	18469.0
2015-05-08 06:30:00	QQQ	ETF	107.75	107.75	107.73	107.75	5300.0
2015-05-08 07:00:00	QQQ	ETF	107.74	107.8	107.74	107.78	31182.0
2015-05-08 07:30:00	QQQ	ETF	107.76	107.76	107.59	107.69	21742.0
2015-05-08 08:00:00	QQQ	ETF	107.67	107.77	107.59	107.74	78978.0
2015-05-08 08:30:00	QQQ	ETF	107.79	108.66	107.79	108.53	863897.0
2015-05-08 09:00:00	QQQ	ETF	108.53	108.58	108.4	108.46	288466.0
2015-05-08 09:30:00	QQQ	ETF	108.46	108.78	108.3	108.6299	4480972.0
2015-05-08 10:00:00	QQQ	ETF	108.63	108.74	108.545	108.67	2368669.0
2015-05-08 10:30:00	QQQ	ETF	108.68	108.75	108.565	108.625	1571052.0
2015-05-08 11:00:00	QQQ	ETF	108.62	108.85	108.61	108.731	1956716.0
2015-05-08 11:30:00	QQQ	ETF	108.74	108.92	108.7345	108.87	2015054.0
2015-05-08 12:00:00	QQQ	ETF	108.87	108.915	108.69	108.71	1089069.0
2015-05-08 12:30:00	QQQ	ETF	108.71	108.79	108.69	108.73	913850.0

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

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