PREVIEW / etf_30min / 2017-08-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-01.parquet
  size:    437 KB
  rows:    15,242

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-08-01 04:00:00	SPY	ETF	247.4	247.61	247.38	247.59	4215.0
2017-08-01 04:30:00	SPY	ETF	247.59	247.67	247.57	247.64	8799.0
2017-08-01 05:00:00	SPY	ETF	247.5	247.5	247.49	247.49	41257.0
2017-08-01 05:30:00	SPY	ETF	247.55	247.56	247.54	247.56	5928.0
2017-08-01 06:00:00	SPY	ETF	247.5	247.5	247.43	247.45	3400.0
2017-08-01 06:30:00	SPY	ETF	247.47	247.47	247.3	247.34	6850.0
2017-08-01 07:00:00	SPY	ETF	247.33	247.33	247.09	247.11	13075.0
2017-08-01 07:30:00	SPY	ETF	247.15	247.28	247.15	247.27	28996.0
2017-08-01 08:00:00	SPY	ETF	247.3	247.34	247.15	247.252	360524.0
2017-08-01 08:30:00	SPY	ETF	247.28	247.47	246.77	247.45	173797.0
2017-08-01 09:00:00	SPY	ETF	247.47	247.59	247.43	247.44	474987.0
2017-08-01 09:30:00	SPY	ETF	247.46	247.5	246.92	247.0	5639692.0
2017-08-01 10:00:00	SPY	ETF	247.005	247.3	246.86	246.96	4849500.0
2017-08-01 10:30:00	SPY	ETF	246.95	247.32	246.95	247.245	3471632.0
2017-08-01 11:00:00	SPY	ETF	247.24	247.32	246.8	246.898	3364626.0
2017-08-01 11:30:00	SPY	ETF	246.89	247.28	246.89	247.265	1718009.0
2017-08-01 12:00:00	SPY	ETF	247.26	247.39	247.24	247.27	2767690.0
2017-08-01 12:30:00	SPY	ETF	247.27	247.31	247.21	247.27	1054278.0
2017-08-01 13:00:00	SPY	ETF	247.26	247.38	247.26	247.32	1194096.0
2017-08-01 13:30:00	SPY	ETF	247.32	247.35	247.23	247.33	2178340.0
2017-08-01 14:00:00	SPY	ETF	247.34	247.37	246.716	247.32	1311817.0
2017-08-01 14:30:00	SPY	ETF	247.33	247.36	247.22	247.335	1604931.0
2017-08-01 15:00:00	SPY	ETF	247.3314	247.365	247.15	247.27	1881154.0
2017-08-01 15:30:00	SPY	ETF	247.27	247.36	247.15	247.309	6733097.0
2017-08-01 16:00:00	SPY	ETF	247.31	247.36	247.11	247.24	10627586.0
2017-08-01 16:30:00	SPY	ETF	247.28	247.46	247.2585	247.41	3603215.0
2017-08-01 17:00:00	SPY	ETF	247.42	247.47	247.32	247.44	132931.0
2017-08-01 17:30:00	SPY	ETF	247.41	247.43	247.31	247.39	97754.0
2017-08-01 18:00:00	SPY	ETF	247.41	247.52	247.4	247.42	57464.0
2017-08-01 18:30:00	SPY	ETF	247.42	247.42	247.37	247.39	2850.0
2017-08-01 19:00:00	SPY	ETF	247.43	247.45	247.43	247.45	2800.0
2017-08-01 19:30:00	SPY	ETF	247.45	247.56	247.41	247.54	12440.0
2017-08-01 04:00:00	QQQ	ETF	143.69	143.88	143.69	143.88	1807.0
2017-08-01 04:30:00	QQQ	ETF	143.85	143.97	143.85	143.97	2300.0
2017-08-01 05:00:00	QQQ	ETF	143.95	143.95	143.95	143.95	400.0
2017-08-01 05:30:00	QQQ	ETF	143.91	144.0	143.87	143.88	13200.0
2017-08-01 06:00:00	QQQ	ETF	143.88	143.9	143.85	143.85	4000.0
2017-08-01 06:30:00	QQQ	ETF	143.89	143.9	143.7	143.75	20704.0
2017-08-01 07:00:00	QQQ	ETF	143.75	143.75	143.52	143.59	23516.0
2017-08-01 07:30:00	QQQ	ETF	143.56	143.67	143.56	143.67	6778.0
2017-08-01 08:00:00	QQQ	ETF	143.65	143.75	143.55	143.55	29337.0
2017-08-01 08:30:00	QQQ	ETF	143.6	143.69	143.23	143.68	267618.0
2017-08-01 09:00:00	QQQ	ETF	143.69	143.77	143.67	143.69	279092.0
2017-08-01 09:30:00	QQQ	ETF	143.7	143.76	143.31	143.4214	3712505.0
2017-08-01 10:00:00	QQQ	ETF	143.42	143.61	143.12	143.27	2269087.0
2017-08-01 10:30:00	QQQ	ETF	143.26	143.73	143.26	143.63	1288024.0
2017-08-01 11:00:00	QQQ	ETF	143.62	143.67	143.22	143.28	1157331.0
2017-08-01 11:30:00	QQQ	ETF	143.28	143.5101	143.28	143.49	694569.0
2017-08-01 12:00:00	QQQ	ETF	143.49	143.52	143.32	143.3865	486855.0
2017-08-01 12:30:00	QQQ	ETF	143.38	143.43	143.32	143.41	626344.0

> showing 50 of 15,242 rows — these rows as CSV

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