PREVIEW / etf_30min / 2019-06-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-04.parquet
  size:    511 KB
  rows:    17,665

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-06-04 04:00:00	SPY	ETF	276.18	276.18	275.87	275.96	21348.0
2019-06-04 04:30:00	SPY	ETF	276.2	276.34	276.19	276.34	15206.0
2019-06-04 05:00:00	SPY	ETF	276.4	276.49	276.2	276.2	4815.0
2019-06-04 05:30:00	SPY	ETF	276.12	276.49	276.09	276.47	6013.0
2019-06-04 06:00:00	SPY	ETF	276.49	276.61	276.4	276.4	14839.0
2019-06-04 06:30:00	SPY	ETF	276.47	276.47	276.23	276.34	32077.0
2019-06-04 07:00:00	SPY	ETF	276.32	276.41	276.16	276.25	153357.0
2019-06-04 07:30:00	SPY	ETF	276.23	277.12	276.11	276.75	503195.0
2019-06-04 08:00:00	SPY	ETF	275.21	277.1001	274.57	276.99	650752.0
2019-06-04 08:30:00	SPY	ETF	276.97	277.2	276.93	277.04	376092.0
2019-06-04 09:00:00	SPY	ETF	277.06	277.45	277.04	277.1	766131.0
2019-06-04 09:30:00	SPY	ETF	277.12	277.64	276.62	277.07	9243602.0
2019-06-04 10:00:00	SPY	ETF	277.07	278.25	276.68	278.04	6632810.0
2019-06-04 10:30:00	SPY	ETF	278.05	278.23	277.45	278.11	4731810.0
2019-06-04 11:00:00	SPY	ETF	278.11	279.09	277.93	278.95	5169123.0
2019-06-04 11:30:00	SPY	ETF	278.96	279.35	278.8	279.135	4047945.0
2019-06-04 12:00:00	SPY	ETF	279.14	279.23	278.7	278.93	2971001.0
2019-06-04 12:30:00	SPY	ETF	278.94	279.7262	278.67	279.45	3017807.0
2019-06-04 13:00:00	SPY	ETF	279.45	279.64	279.11	279.52	3016262.0
2019-06-04 13:30:00	SPY	ETF	279.53	279.84	279.36	279.785	3318815.0
2019-06-04 14:00:00	SPY	ETF	279.78	279.84	279.27	279.5201	3615214.0
2019-06-04 14:30:00	SPY	ETF	279.52	279.63	279.31	279.3334	3214005.0
2019-06-04 15:00:00	SPY	ETF	279.34	279.95	279.32	279.95	3712052.0
2019-06-04 15:30:00	SPY	ETF	279.94	280.68	279.67	280.52	14042546.0
2019-06-04 16:00:00	SPY	ETF	280.53	280.75	279.5	280.68	5221561.0
2019-06-04 16:30:00	SPY	ETF	280.69	280.8	280.53	280.72	670151.0
2019-06-04 17:00:00	SPY	ETF	280.73	280.83	280.53	280.81	254323.0
2019-06-04 17:30:00	SPY	ETF	280.81	280.87	280.53	280.83	113340.0
2019-06-04 18:00:00	SPY	ETF	280.87	281.48	280.87	281.43	337891.0
2019-06-04 18:30:00	SPY	ETF	281.42	281.47	281.0	281.02	61560.0
2019-06-04 19:00:00	SPY	ETF	281.02	281.17	281.0	281.07	30572.0
2019-06-04 19:30:00	SPY	ETF	281.06	281.4	281.01	281.39	46887.0
2019-06-04 04:00:00	QQQ	ETF	171.26	171.31	171.12	171.19	18475.0
2019-06-04 04:30:00	QQQ	ETF	171.2	171.52	171.2	171.52	23229.0
2019-06-04 05:00:00	QQQ	ETF	171.42	171.57	171.28	171.33	21839.0
2019-06-04 05:30:00	QQQ	ETF	171.26	171.52	171.24	171.52	16690.0
2019-06-04 06:00:00	QQQ	ETF	171.48	171.66	171.47	171.48	6551.0
2019-06-04 06:30:00	QQQ	ETF	171.42	171.48	171.27	171.27	30523.0
2019-06-04 07:00:00	QQQ	ETF	171.31	171.33	171.12	171.2	52338.0
2019-06-04 07:30:00	QQQ	ETF	171.2	171.88	171.12	171.53	188269.0
2019-06-04 08:00:00	QQQ	ETF	171.3299	171.88	170.12	171.79	214106.0
2019-06-04 08:30:00	QQQ	ETF	171.83	172.0899	171.77	171.92	345768.0
2019-06-04 09:00:00	QQQ	ETF	171.95	172.34	171.92	171.99	548156.0
2019-06-04 09:30:00	QQQ	ETF	171.98	172.35	171.37	171.7015	5815903.0
2019-06-04 10:00:00	QQQ	ETF	171.7	172.965	171.44	172.8	5419551.0
2019-06-04 10:30:00	QQQ	ETF	172.8	172.95	172.42	172.92	2628231.0
2019-06-04 11:00:00	QQQ	ETF	172.91	174.0	172.7815	173.9105	2950058.0
2019-06-04 11:30:00	QQQ	ETF	173.915	174.19	173.8	173.96	1873039.0
2019-06-04 12:00:00	QQQ	ETF	173.96	174.04	173.47	173.69	1571643.0
2019-06-04 12:30:00	QQQ	ETF	173.7	174.22	173.5	174.07	1665696.0

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

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