PREVIEW / etf_30min / 2017-11-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-10.parquet
  size:    433 KB
  rows:    14,916

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-11-10 04:00:00	SPY	ETF	257.73	257.79	257.16	257.23	22046.0
2017-11-10 04:30:00	SPY	ETF	257.24	257.36	257.17	257.23	23883.0
2017-11-10 05:00:00	SPY	ETF	257.31	257.48	257.31	257.4	6011.0
2017-11-10 05:30:00	SPY	ETF	257.46	257.49	257.46	257.49	1104.0
2017-11-10 06:00:00	SPY	ETF	257.58	257.63	257.54	257.56	8959.0
2017-11-10 06:30:00	SPY	ETF	257.56	257.56	257.37	257.47	12481.0
2017-11-10 07:00:00	SPY	ETF	257.42	257.6	257.32	257.48	127386.0
2017-11-10 07:30:00	SPY	ETF	257.45	257.7	257.44	257.66	156274.0
2017-11-10 08:00:00	SPY	ETF	257.65	257.79	257.38	257.68	246559.0
2017-11-10 08:30:00	SPY	ETF	257.69	257.85	257.68	257.76	141979.0
2017-11-10 09:00:00	SPY	ETF	257.75	257.83	257.67	257.74	161341.0
2017-11-10 09:30:00	SPY	ETF	257.73	257.96	257.57	257.72	5379397.0
2017-11-10 10:00:00	SPY	ETF	257.7101	257.93	257.41	257.72	5744355.0
2017-11-10 10:30:00	SPY	ETF	257.71	257.78	257.37	257.73	2910210.0
2017-11-10 11:00:00	SPY	ETF	257.74	257.81	257.5	257.57	2113437.0
2017-11-10 11:30:00	SPY	ETF	257.58	257.86	257.57	257.84	1261268.0
2017-11-10 12:00:00	SPY	ETF	257.835	257.98	257.78	257.825	1645001.0
2017-11-10 12:30:00	SPY	ETF	257.83	257.88	257.68	257.7	1000852.0
2017-11-10 13:00:00	SPY	ETF	257.71	257.91	257.63	257.87	1249317.0
2017-11-10 13:30:00	SPY	ETF	257.86	257.92	257.69	257.83	1122564.0
2017-11-10 14:00:00	SPY	ETF	257.83	258.13	257.83	258.085	3492679.0
2017-11-10 14:30:00	SPY	ETF	258.09	258.19	258.03	258.15	5032908.0
2017-11-10 15:00:00	SPY	ETF	258.15	258.21	258.04	258.155	3704743.0
2017-11-10 15:30:00	SPY	ETF	258.16	258.2926	258.01	258.08	9963419.0
2017-11-10 16:00:00	SPY	ETF	258.09	258.1	257.94	258.0	11022625.0
2017-11-10 16:30:00	SPY	ETF	258.0	258.0613	257.92	257.94	1402637.0
2017-11-10 17:00:00	SPY	ETF	257.96	258.02	257.94	258.01	164090.0
2017-11-10 17:30:00	SPY	ETF	258.0	258.15	257.97	257.99	187428.0
2017-11-10 18:00:00	SPY	ETF	257.98	258.05	257.98	258.05	23530.0
2017-11-10 18:30:00	SPY	ETF	258.01	258.02	258.01	258.02	5606.0
2017-11-10 19:00:00	SPY	ETF	258.02	258.02	258.02	258.02	5119.0
2017-11-10 19:30:00	SPY	ETF	258.02	258.02	257.96	258.02	15333.0
2017-11-10 04:00:00	QQQ	ETF	153.58	153.58	153.12	153.13	15656.0
2017-11-10 04:30:00	QQQ	ETF	153.1	153.14	153.01	153.02	38031.0
2017-11-10 05:00:00	QQQ	ETF	153.15	153.2	153.1	153.14	3497.0
2017-11-10 05:30:00	QQQ	ETF	153.18	153.18	153.18	153.18	200.0
2017-11-10 06:00:00	QQQ	ETF	153.29	153.3	153.28	153.3	65600.0
2017-11-10 06:30:00	QQQ	ETF	153.29	153.32	153.2	153.28	5957.0
2017-11-10 07:00:00	QQQ	ETF	153.35	153.35	153.18	153.29	12001.0
2017-11-10 07:30:00	QQQ	ETF	153.3	153.5	153.3	153.5	72557.0
2017-11-10 08:00:00	QQQ	ETF	153.5	153.54	153.38	153.43	101704.0
2017-11-10 08:30:00	QQQ	ETF	153.44	153.55	153.41	153.46	37988.0
2017-11-10 09:00:00	QQQ	ETF	153.43	153.46	153.31	153.35	117185.0
2017-11-10 09:30:00	QQQ	ETF	153.36	153.61	153.22	153.391	2871879.0
2017-11-10 10:00:00	QQQ	ETF	153.39	153.48	153.14	153.285	1504979.0
2017-11-10 10:30:00	QQQ	ETF	153.28	153.4	153.06	153.38	797571.0
2017-11-10 11:00:00	QQQ	ETF	153.381	153.46	153.19	153.274	709305.0
2017-11-10 11:30:00	QQQ	ETF	153.275	153.46	153.25	153.44	397185.0
2017-11-10 12:00:00	QQQ	ETF	153.45	153.68	153.39	153.5263	834321.0
2017-11-10 12:30:00	QQQ	ETF	153.525	153.545	153.3749	153.39	386959.0

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

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