PREVIEW / etf_30min / 2017-10-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-06.parquet
  size:    435 KB
  rows:    14,979

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-10-06 04:00:00	SPY	ETF	254.6	254.6	254.6	254.6	3000.0
2017-10-06 04:30:00	SPY	ETF	254.54	254.54	254.54	254.54	100.0
2017-10-06 05:00:00	SPY	ETF	254.52	254.59	254.52	254.59	1710.0
2017-10-06 05:30:00	SPY	ETF	254.56	254.56	254.56	254.56	1000.0
2017-10-06 06:30:00	SPY	ETF	254.63	254.63	254.58	254.6	7200.0
2017-10-06 07:00:00	SPY	ETF	254.62	254.66	254.6	254.6	37091.0
2017-10-06 07:30:00	SPY	ETF	254.59	254.64	254.55	254.55	48633.0
2017-10-06 08:00:00	SPY	ETF	254.57	254.57	254.43	254.5	162693.0
2017-10-06 08:30:00	SPY	ETF	254.44	254.5	254.05	254.05	1495483.0
2017-10-06 09:00:00	SPY	ETF	254.05	254.19	254.04	254.15	415384.0
2017-10-06 09:30:00	SPY	ETF	254.15	254.36	254.12	254.305	5659118.0
2017-10-06 10:00:00	SPY	ETF	254.305	254.46	254.29	254.43	3244337.0
2017-10-06 10:30:00	SPY	ETF	254.43	254.45	253.88	254.0	9587508.0
2017-10-06 11:00:00	SPY	ETF	253.9987	254.16	253.98	254.155	4008933.0
2017-10-06 11:30:00	SPY	ETF	254.16	254.16	253.87	253.97	3361835.0
2017-10-06 12:00:00	SPY	ETF	253.97	254.06	253.85	253.99	2638070.0
2017-10-06 12:30:00	SPY	ETF	253.99	254.19	253.97	254.075	3053624.0
2017-10-06 13:00:00	SPY	ETF	254.08	254.11	253.91	254.055	3573666.0
2017-10-06 13:30:00	SPY	ETF	254.055	254.11	254.015	254.0725	1946479.0
2017-10-06 14:00:00	SPY	ETF	254.07	254.7008	254.045	254.18	9380150.0
2017-10-06 14:30:00	SPY	ETF	254.18	254.31	254.11	254.29	3006377.0
2017-10-06 15:00:00	SPY	ETF	254.29	254.305	254.145	254.225	2802649.0
2017-10-06 15:30:00	SPY	ETF	254.22	254.42	254.15	254.4	9440168.0
2017-10-06 16:00:00	SPY	ETF	254.41	254.44	254.18	254.26	11273197.0
2017-10-06 16:30:00	SPY	ETF	254.26	254.4392	254.15	254.22	3997699.0
2017-10-06 17:00:00	SPY	ETF	254.23	254.25	254.18	254.22	49216.0
2017-10-06 17:30:00	SPY	ETF	254.24	254.29	254.23	254.29	99142.0
2017-10-06 18:00:00	SPY	ETF	254.25	254.29	254.25	254.25	1380.0
2017-10-06 18:30:00	SPY	ETF	254.28	254.29	254.28	254.28	2455.0
2017-10-06 19:00:00	SPY	ETF	254.28	254.29	254.24	254.25	14332.0
2017-10-06 19:30:00	SPY	ETF	254.28	254.28	254.26	254.26	4170.0
2017-10-06 04:00:00	QQQ	ETF	147.6	147.6	147.53	147.53	10500.0
2017-10-06 04:30:00	QQQ	ETF	147.52	147.52	147.52	147.52	803.0
2017-10-06 05:00:00	QQQ	ETF	147.49	147.49	147.49	147.49	300.0
2017-10-06 05:30:00	QQQ	ETF	147.61	147.61	147.61	147.61	200.0
2017-10-06 06:00:00	QQQ	ETF	147.66	147.69	147.66	147.68	5700.0
2017-10-06 06:30:00	QQQ	ETF	147.68	147.68	147.68	147.68	300.0
2017-10-06 07:00:00	QQQ	ETF	147.65	147.67	147.64	147.67	9084.0
2017-10-06 07:30:00	QQQ	ETF	147.59	147.65	147.59	147.62	2416.0
2017-10-06 08:00:00	QQQ	ETF	147.64	147.66	147.47	147.51	105884.0
2017-10-06 08:30:00	QQQ	ETF	147.46	147.46	147.0	147.04	536426.0
2017-10-06 09:00:00	QQQ	ETF	147.03	147.04	146.9	146.98	187709.0
2017-10-06 09:30:00	QQQ	ETF	146.97	147.4	146.96	147.3066	4108085.0
2017-10-06 10:00:00	QQQ	ETF	147.3	147.52	147.28	147.48	2262820.0
2017-10-06 10:30:00	QQQ	ETF	147.48	147.5	146.99	147.13	1989897.0
2017-10-06 11:00:00	QQQ	ETF	147.14	147.42	147.13	147.3926	629927.0
2017-10-06 11:30:00	QQQ	ETF	147.4	147.4	147.21	147.38	614857.0
2017-10-06 12:00:00	QQQ	ETF	147.375	147.48	147.26	147.48	924986.0
2017-10-06 12:30:00	QQQ	ETF	147.48	147.64	147.46	147.509	923836.0
2017-10-06 13:00:00	QQQ	ETF	147.505	147.54	147.39	147.41	696791.0

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

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