PREVIEW / etf_30min / 2017-07-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-26.parquet
  size:    430 KB
  rows:    14,868

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-07-26 04:00:00	SPY	ETF	247.46	247.68	247.46	247.5	2690.0
2017-07-26 04:30:00	SPY	ETF	247.49	247.49	247.49	247.49	400.0
2017-07-26 05:00:00	SPY	ETF	247.49	247.53	247.47	247.53	3200.0
2017-07-26 05:30:00	SPY	ETF	247.58	247.68	247.58	247.6	3600.0
2017-07-26 06:00:00	SPY	ETF	247.54	247.6	247.5	247.53	8135.0
2017-07-26 06:30:00	SPY	ETF	247.52	247.63	247.52	247.63	1200.0
2017-07-26 07:00:00	SPY	ETF	247.57	247.6	247.54	247.58	44329.0
2017-07-26 07:30:00	SPY	ETF	247.6	247.78	247.57	247.78	102557.0
2017-07-26 08:00:00	SPY	ETF	247.75	247.86	247.6	247.82	129397.0
2017-07-26 08:30:00	SPY	ETF	247.82	247.86	247.77	247.81	156411.0
2017-07-26 09:00:00	SPY	ETF	247.83	247.88	247.75	247.77	153358.0
2017-07-26 09:30:00	SPY	ETF	247.75	247.79	247.47	247.63	4561419.0
2017-07-26 10:00:00	SPY	ETF	247.63	247.79	247.51	247.5805	2538871.0
2017-07-26 10:30:00	SPY	ETF	247.59	247.695	247.43	247.4799	3331870.0
2017-07-26 11:00:00	SPY	ETF	247.47	247.59	247.46	247.54	2608900.0
2017-07-26 11:30:00	SPY	ETF	247.53	247.595	247.48	247.56	2740407.0
2017-07-26 12:00:00	SPY	ETF	247.56	247.66	247.53	247.575	906453.0
2017-07-26 12:30:00	SPY	ETF	247.575	247.62	247.49	247.535	1609181.0
2017-07-26 13:00:00	SPY	ETF	247.53	247.53	247.37	247.375	1521483.0
2017-07-26 13:30:00	SPY	ETF	247.37	247.53	247.35	247.36	2495225.0
2017-07-26 14:00:00	SPY	ETF	247.375	247.68	247.28	247.67	3630268.0
2017-07-26 14:30:00	SPY	ETF	247.67	247.67	247.39	247.395	2083685.0
2017-07-26 15:00:00	SPY	ETF	247.39	247.51	247.345	247.44	2796111.0
2017-07-26 15:30:00	SPY	ETF	247.445	247.485	247.13	247.45	8908744.0
2017-07-26 16:00:00	SPY	ETF	247.43	247.51	247.28	247.32	6063823.0
2017-07-26 16:30:00	SPY	ETF	247.32	247.5976	247.31	247.4319	258069.0
2017-07-26 17:00:00	SPY	ETF	247.38	247.45	247.36	247.44	56065.0
2017-07-26 17:30:00	SPY	ETF	247.43	247.46	247.41	247.44	18040.0
2017-07-26 18:00:00	SPY	ETF	247.44	247.56	247.44	247.52	134034.0
2017-07-26 18:30:00	SPY	ETF	247.56	247.64	247.55	247.61	57597.0
2017-07-26 19:00:00	SPY	ETF	247.6	247.69	247.6	247.64	18522.0
2017-07-26 19:30:00	SPY	ETF	247.64	247.65	247.62	247.63	40243.0
2017-07-26 04:00:00	QQQ	ETF	144.49	144.49	144.46	144.46	2400.0
2017-07-26 04:30:00	QQQ	ETF	144.45	144.45	144.39	144.45	2800.0
2017-07-26 05:00:00	QQQ	ETF	144.43	144.43	144.43	144.43	400.0
2017-07-26 05:30:00	QQQ	ETF	144.53	144.55	144.46	144.46	13000.0
2017-07-26 06:00:00	QQQ	ETF	144.46	144.46	144.45	144.45	1390.0
2017-07-26 06:30:00	QQQ	ETF	144.51	144.6	144.5	144.6	4872.0
2017-07-26 07:00:00	QQQ	ETF	144.58	144.58	144.55	144.55	1225.0
2017-07-26 07:30:00	QQQ	ETF	144.58	144.63	144.56	144.62	6220.0
2017-07-26 08:00:00	QQQ	ETF	144.61	144.78	144.38	144.77	196723.0
2017-07-26 08:30:00	QQQ	ETF	144.75	144.88	144.75	144.85	58248.0
2017-07-26 09:00:00	QQQ	ETF	144.88	144.89	144.73	144.73	55720.0
2017-07-26 09:30:00	QQQ	ETF	144.74	144.87	144.64	144.83	2345299.0
2017-07-26 10:00:00	QQQ	ETF	144.83	144.95	144.77	144.86	1419226.0
2017-07-26 10:30:00	QQQ	ETF	144.86	144.9	144.63	144.66	895388.0
2017-07-26 11:00:00	QQQ	ETF	144.66	144.76	144.56	144.61	601515.0
2017-07-26 11:30:00	QQQ	ETF	144.62	144.671	144.57	144.64	564870.0
2017-07-26 12:00:00	QQQ	ETF	144.65	144.8	144.6433	144.72	1072052.0
2017-07-26 12:30:00	QQQ	ETF	144.72	144.76	144.64	144.71	407412.0

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

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