PREVIEW / etf_30min / 2017-09-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-06.parquet
  size:    432 KB
  rows:    14,920

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-09-06 04:00:00	SPY	ETF	246.65	246.68	246.51	246.51	9610.0
2017-09-06 04:30:00	SPY	ETF	246.41	246.6	246.41	246.56	1363.0
2017-09-06 05:00:00	SPY	ETF	246.51	246.51	246.38	246.38	1310.0
2017-09-06 05:30:00	SPY	ETF	246.44	246.44	246.11	246.26	8195.0
2017-09-06 06:00:00	SPY	ETF	246.46	246.47	246.45	246.47	1204.0
2017-09-06 06:30:00	SPY	ETF	246.31	246.44	246.28	246.31	7909.0
2017-09-06 07:00:00	SPY	ETF	246.37	246.5	246.37	246.5	49613.0
2017-09-06 07:30:00	SPY	ETF	246.52	246.71	246.52	246.68	67800.0
2017-09-06 08:00:00	SPY	ETF	246.67	246.77	246.46	246.77	156028.0
2017-09-06 08:30:00	SPY	ETF	246.77	246.91	246.68	246.87	487719.0
2017-09-06 09:00:00	SPY	ETF	246.87	246.97	246.82	246.87	390949.0
2017-09-06 09:30:00	SPY	ETF	246.84	247.0	246.6	246.77	5928585.0
2017-09-06 10:00:00	SPY	ETF	246.765	247.08	246.52	246.64	4908256.0
2017-09-06 10:30:00	SPY	ETF	246.64	246.78	246.24	246.69	5675345.0
2017-09-06 11:00:00	SPY	ETF	246.68	246.75	246.23	246.48	3117456.0
2017-09-06 11:30:00	SPY	ETF	246.48	246.61	246.39	246.59	1957585.0
2017-09-06 12:00:00	SPY	ETF	246.59	246.75	246.42	246.69	1891070.0
2017-09-06 12:30:00	SPY	ETF	246.7	246.86	246.57	246.82	1962440.0
2017-09-06 13:00:00	SPY	ETF	246.83	247.03	246.8	246.87	3426073.0
2017-09-06 13:30:00	SPY	ETF	246.88	247.0	246.83	246.88	1713756.0
2017-09-06 14:00:00	SPY	ETF	246.87	247.19	246.855	247.091	1924183.0
2017-09-06 14:30:00	SPY	ETF	247.09	247.15	246.95	247.0703	2351670.0
2017-09-06 15:00:00	SPY	ETF	247.08	247.28	246.99	247.24	3065451.0
2017-09-06 15:30:00	SPY	ETF	247.24	247.25	246.8	246.91	10311647.0
2017-09-06 16:00:00	SPY	ETF	246.91	246.97	246.81	246.92	2267432.0
2017-09-06 16:30:00	SPY	ETF	246.92	246.96	246.82	246.82	2098884.0
2017-09-06 17:00:00	SPY	ETF	246.84	246.84	246.6243	246.79	55531.0
2017-09-06 17:30:00	SPY	ETF	246.81	246.81	246.74	246.77	69570.0
2017-09-06 18:00:00	SPY	ETF	246.76	246.76	246.2	246.42	194309.0
2017-09-06 18:30:00	SPY	ETF	246.43	246.49	246.38	246.42	71542.0
2017-09-06 19:00:00	SPY	ETF	246.45	246.56	246.44	246.56	29470.0
2017-09-06 19:30:00	SPY	ETF	246.57	246.57	246.48	246.56	17739.0
2017-09-06 04:00:00	QQQ	ETF	145.17	145.2	145.07	145.07	4100.0
2017-09-06 05:00:00	QQQ	ETF	145.0	145.07	145.0	145.07	1038.0
2017-09-06 05:30:00	QQQ	ETF	144.86	145.02	144.77	145.02	1946.0
2017-09-06 06:00:00	QQQ	ETF	145.07	145.08	145.05	145.05	2100.0
2017-09-06 06:30:00	QQQ	ETF	144.96	144.96	144.92	144.92	12962.0
2017-09-06 07:00:00	QQQ	ETF	145.03	145.08	144.98	145.08	9234.0
2017-09-06 07:30:00	QQQ	ETF	145.09	145.15	145.08	145.15	29054.0
2017-09-06 08:00:00	QQQ	ETF	145.14	145.22	144.69	145.16	28584.0
2017-09-06 08:30:00	QQQ	ETF	145.14	145.2	145.1	145.17	52607.0
2017-09-06 09:00:00	QQQ	ETF	145.17	145.2	145.07	145.07	80638.0
2017-09-06 09:30:00	QQQ	ETF	145.06	145.34	144.77	144.99	2728087.0
2017-09-06 10:00:00	QQQ	ETF	144.98	145.17	144.42	144.6	2605099.0
2017-09-06 10:30:00	QQQ	ETF	144.62	144.74	144.23	144.61	2341618.0
2017-09-06 11:00:00	QQQ	ETF	144.6	144.65	144.08	144.4	1364559.0
2017-09-06 11:30:00	QQQ	ETF	144.4	144.71	144.321	144.67	990871.0
2017-09-06 12:00:00	QQQ	ETF	144.66	144.9	144.58	144.885	1244076.0
2017-09-06 12:30:00	QQQ	ETF	144.88	145.0	144.74	144.99	1054637.0
2017-09-06 13:00:00	QQQ	ETF	144.99	145.17	144.97	145.05	1344198.0

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

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