PREVIEW / etf_30min / 2019-05-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-29.parquet
  size:    506 KB
  rows:    17,687

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
2019-05-29 04:00:00	SPY	ETF	278.94	279.05	278.76	278.84	28255.0
2019-05-29 04:30:00	SPY	ETF	278.84	279.12	278.68	278.84	7730.0
2019-05-29 05:00:00	SPY	ETF	278.75	278.78	278.28	278.44	12938.0
2019-05-29 05:30:00	SPY	ETF	278.5	278.81	278.5	278.8	21572.0
2019-05-29 06:00:00	SPY	ETF	278.75	278.96	278.68	278.9	30713.0
2019-05-29 06:30:00	SPY	ETF	278.95	279.3	278.9	279.24	76345.0
2019-05-29 07:00:00	SPY	ETF	279.24	279.3	278.87	278.87	195272.0
2019-05-29 07:30:00	SPY	ETF	278.85	279.11	278.8	278.97	291243.0
2019-05-29 08:00:00	SPY	ETF	278.95	279.93	278.6	278.63	372122.0
2019-05-29 08:30:00	SPY	ETF	278.6	278.79	278.5	278.78	458543.0
2019-05-29 09:00:00	SPY	ETF	278.8	279.04	278.74	278.92	478540.0
2019-05-29 09:30:00	SPY	ETF	278.91	278.92	277.9775	278.435	10671867.0
2019-05-29 10:00:00	SPY	ETF	278.435	279.26	278.1114	279.249	8084337.0
2019-05-29 10:30:00	SPY	ETF	279.245	279.36	278.265	278.295	5165464.0
2019-05-29 11:00:00	SPY	ETF	278.29	278.93	277.66	277.79	8097319.0
2019-05-29 11:30:00	SPY	ETF	277.775	277.95	276.71	277.0	8912906.0
2019-05-29 12:00:00	SPY	ETF	277.0	277.96	276.8275	277.76	7025320.0
2019-05-29 12:30:00	SPY	ETF	277.755	277.99	277.37	277.4312	5014158.0
2019-05-29 13:00:00	SPY	ETF	277.4399	278.58	277.24	278.26	5508128.0
2019-05-29 13:30:00	SPY	ETF	278.253	278.64	278.13	278.2	3470198.0
2019-05-29 14:00:00	SPY	ETF	278.205	278.53	277.91	278.2199	3411042.0
2019-05-29 14:30:00	SPY	ETF	278.205	278.205	277.11	277.52	5080524.0
2019-05-29 15:00:00	SPY	ETF	277.52	277.86	276.96	277.81	5468925.0
2019-05-29 15:30:00	SPY	ETF	277.8	278.84	277.63	278.34	15297615.0
2019-05-29 16:00:00	SPY	ETF	278.33	278.4223	278.05	278.15	8815535.0
2019-05-29 16:30:00	SPY	ETF	278.16	278.4202	278.02	278.16	1460264.0
2019-05-29 17:00:00	SPY	ETF	278.15	278.21	278.1	278.12	181656.0
2019-05-29 17:30:00	SPY	ETF	278.12	278.12	278.01	278.05	92202.0
2019-05-29 18:00:00	SPY	ETF	278.06	278.62	278.05	278.52	201367.0
2019-05-29 18:30:00	SPY	ETF	278.5	278.54	278.33	278.54	24529.0
2019-05-29 19:00:00	SPY	ETF	278.54	278.55	278.37	278.43	29252.0
2019-05-29 19:30:00	SPY	ETF	278.42	278.47	278.2	278.28	33690.0
2019-05-29 04:00:00	QQQ	ETF	176.38	176.4	176.2	176.24	16877.0
2019-05-29 04:30:00	QQQ	ETF	176.38	176.5	176.23	176.3	13580.0
2019-05-29 05:00:00	QQQ	ETF	176.39	176.4	175.96	176.1	41257.0
2019-05-29 05:30:00	QQQ	ETF	176.14	176.36	176.1	176.34	27800.0
2019-05-29 06:00:00	QQQ	ETF	176.29	176.38	176.24	176.36	21873.0
2019-05-29 06:30:00	QQQ	ETF	176.37	176.62	176.35	176.61	38235.0
2019-05-29 07:00:00	QQQ	ETF	176.61	176.65	176.35	176.36	84354.0
2019-05-29 07:30:00	QQQ	ETF	176.35	176.57	176.29	176.46	73821.0
2019-05-29 08:00:00	QQQ	ETF	176.44	177.09	176.08	176.18	154413.0
2019-05-29 08:30:00	QQQ	ETF	176.22	176.38	176.13	176.33	97434.0
2019-05-29 09:00:00	QQQ	ETF	176.34	176.53	176.32	176.48	195227.0
2019-05-29 09:30:00	QQQ	ETF	176.46	176.6	175.8	176.2	4262261.0
2019-05-29 10:00:00	QQQ	ETF	176.2	176.97	175.952	176.95	3399581.0
2019-05-29 10:30:00	QQQ	ETF	176.95	177.0	176.111	176.14	2014348.0
2019-05-29 11:00:00	QQQ	ETF	176.14	176.55	175.62	175.73	2635728.0
2019-05-29 11:30:00	QQQ	ETF	175.72	175.86	175.09	175.37	3219992.0
2019-05-29 12:00:00	QQQ	ETF	175.37	175.97	175.2028	175.82	2089862.0
2019-05-29 12:30:00	QQQ	ETF	175.81	175.94	175.55	175.61	1109320.0

> showing 50 of 17,687 rows — these rows as CSV

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