PREVIEW / etf_30min / 2017-05-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-11.parquet
  size:    426 KB
  rows:    14,586

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-05-11 04:00:00	SPY	ETF	239.65	239.65	239.57	239.57	6522.0
2017-05-11 04:30:00	SPY	ETF	239.51	239.55	239.51	239.52	700.0
2017-05-11 05:00:00	SPY	ETF	239.49	239.49	239.49	239.49	100.0
2017-05-11 05:30:00	SPY	ETF	239.51	239.51	239.34	239.34	26800.0
2017-05-11 06:00:00	SPY	ETF	239.37	239.38	239.32	239.38	9385.0
2017-05-11 06:30:00	SPY	ETF	239.35	239.41	239.35	239.38	20022.0
2017-05-11 07:00:00	SPY	ETF	239.38	239.44	239.33	239.44	19180.0
2017-05-11 07:30:00	SPY	ETF	239.44	239.46	239.07	239.2	180805.0
2017-05-11 08:00:00	SPY	ETF	239.15	239.4	239.09	239.13	199337.0
2017-05-11 08:30:00	SPY	ETF	239.14	239.35	239.04	239.3	324609.0
2017-05-11 09:00:00	SPY	ETF	239.32	239.35	239.26	239.33	153652.0
2017-05-11 09:30:00	SPY	ETF	239.35	239.46	238.31	238.5601	8245764.0
2017-05-11 10:00:00	SPY	ETF	238.56	238.687	238.14	238.36	9500666.0
2017-05-11 10:30:00	SPY	ETF	238.355	238.58	238.13	238.5768	4684259.0
2017-05-11 11:00:00	SPY	ETF	238.58	239.3	238.56	238.72	4754788.0
2017-05-11 11:30:00	SPY	ETF	238.72	238.83	238.62	238.6787	3884463.0
2017-05-11 12:00:00	SPY	ETF	238.68	239.1	238.66	238.99	3048521.0
2017-05-11 12:30:00	SPY	ETF	238.99	239.13	238.93	238.96	2069677.0
2017-05-11 13:00:00	SPY	ETF	238.965	239.23	238.93	239.01	1718235.0
2017-05-11 13:30:00	SPY	ETF	239.0	239.31	238.99	239.3	1285581.0
2017-05-11 14:00:00	SPY	ETF	239.31	239.57	239.09	239.44	3649342.0
2017-05-11 14:30:00	SPY	ETF	239.44	239.4666	239.21	239.29	2262732.0
2017-05-11 15:00:00	SPY	ETF	239.29	239.44	239.23	239.28	1576853.0
2017-05-11 15:30:00	SPY	ETF	239.28	239.51	239.24	239.41	6714833.0
2017-05-11 16:00:00	SPY	ETF	239.41	239.53	239.27	239.27	6535979.0
2017-05-11 16:30:00	SPY	ETF	239.28	239.426	238.4683	239.26	435009.0
2017-05-11 17:00:00	SPY	ETF	239.26	239.3	239.26	239.3	17557.0
2017-05-11 17:30:00	SPY	ETF	239.28	239.31	239.28	239.31	25970.0
2017-05-11 18:00:00	SPY	ETF	239.28	239.31	239.22	239.27	57688.0
2017-05-11 18:30:00	SPY	ETF	239.27	239.33	239.27	239.29	11110.0
2017-05-11 19:00:00	SPY	ETF	239.28	239.28	239.23	239.23	15419.0
2017-05-11 19:30:00	SPY	ETF	239.26	239.29	239.26	239.27	15694.0
2017-05-11 05:00:00	QQQ	ETF	138.2	138.2	138.2	138.2	100.0
2017-05-11 05:30:00	QQQ	ETF	138.16	138.16	138.1	138.1	7470.0
2017-05-11 06:00:00	QQQ	ETF	138.08	138.08	138.06	138.06	3900.0
2017-05-11 06:30:00	QQQ	ETF	138.09	138.09	138.08	138.08	14200.0
2017-05-11 07:00:00	QQQ	ETF	138.08	138.09	138.06	138.09	7572.0
2017-05-11 07:30:00	QQQ	ETF	138.07	138.07	137.86	137.87	114125.0
2017-05-11 08:00:00	QQQ	ETF	137.89	138.09	137.85	137.9	43760.0
2017-05-11 08:30:00	QQQ	ETF	137.91	138.03	137.87	138.02	30725.0
2017-05-11 09:00:00	QQQ	ETF	138.0	138.04	138.0	138.02	72149.0
2017-05-11 09:30:00	QQQ	ETF	138.03	138.16	137.51	137.65	3739282.0
2017-05-11 10:00:00	QQQ	ETF	137.64	137.69	137.41	137.55	3293741.0
2017-05-11 10:30:00	QQQ	ETF	137.54	137.62	137.38	137.5254	2069232.0
2017-05-11 11:00:00	QQQ	ETF	137.53	137.71	137.5	137.69	1285465.0
2017-05-11 11:30:00	QQQ	ETF	137.7	137.7899	137.64	137.68	451550.0
2017-05-11 12:00:00	QQQ	ETF	137.68	137.87	137.6696	137.83	808314.0
2017-05-11 12:30:00	QQQ	ETF	137.83	137.91	137.81	137.84	1168393.0
2017-05-11 13:00:00	QQQ	ETF	137.8374	138.055	137.82	137.97	784510.0
2017-05-11 13:30:00	QQQ	ETF	137.96	138.2	137.96	138.19	707443.0

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

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