PREVIEW / etf_30min / 2020-06-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-30.parquet
  size:    545 KB
  rows:    20,446

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
2020-06-30 04:00:00	SPY	ETF	304.0	304.2	303.58	304.02	39049.0
2020-06-30 04:30:00	SPY	ETF	303.97	304.06	303.37	303.46	51099.0
2020-06-30 05:00:00	SPY	ETF	303.48	304.0	303.2	303.99	96499.0
2020-06-30 05:30:00	SPY	ETF	303.88	304.37	303.88	304.3	46813.0
2020-06-30 06:00:00	SPY	ETF	304.29	304.7	304.19	304.65	16402.0
2020-06-30 06:30:00	SPY	ETF	304.55	304.7	304.34	304.4	40562.0
2020-06-30 07:00:00	SPY	ETF	304.34	305.0	304.2	304.95	96291.0
2020-06-30 07:30:00	SPY	ETF	304.96	305.54	304.59	304.71	281972.0
2020-06-30 08:00:00	SPY	ETF	305.4399	305.4501	303.4	304.08	176030.0
2020-06-30 08:30:00	SPY	ETF	304.09	304.18	303.67	304.05	181853.0
2020-06-30 09:00:00	SPY	ETF	304.02	304.35	303.65	303.99	230792.0
2020-06-30 09:30:00	SPY	ETF	303.99	305.375	303.82	304.79	7412792.0
2020-06-30 10:00:00	SPY	ETF	304.8	305.96	304.73	305.47	6044370.0
2020-06-30 10:30:00	SPY	ETF	305.45	306.68	305.24	306.56	5297993.0
2020-06-30 11:00:00	SPY	ETF	306.57	307.33	306.44	306.89	4035212.0
2020-06-30 11:30:00	SPY	ETF	306.89	306.92	306.27	306.79	3827790.0
2020-06-30 12:00:00	SPY	ETF	306.79	307.53	306.6	307.205	3065820.0
2020-06-30 12:30:00	SPY	ETF	307.2	307.39	306.2	306.31	4575458.0
2020-06-30 13:00:00	SPY	ETF	306.31	306.56	305.69	306.44	2710895.0
2020-06-30 13:30:00	SPY	ETF	306.44	306.63	305.91	306.52	2312582.0
2020-06-30 14:00:00	SPY	ETF	306.51	307.06	306.033	307.06	4157950.0
2020-06-30 14:30:00	SPY	ETF	307.0494	307.43	306.9	307.415	4599485.0
2020-06-30 15:00:00	SPY	ETF	307.42	307.92	306.67	307.6777	5569217.0
2020-06-30 15:30:00	SPY	ETF	307.68	310.2	307.6	308.57	31347647.0
2020-06-30 16:00:00	SPY	ETF	308.56	309.09	308.18	308.5	20926357.0
2020-06-30 16:30:00	SPY	ETF	308.48	309.0417	308.26	308.5901	484150.0
2020-06-30 17:00:00	SPY	ETF	308.63	308.63	308.25	308.35	905869.0
2020-06-30 17:30:00	SPY	ETF	308.35	308.61	308.35	308.6	1075886.0
2020-06-30 18:00:00	SPY	ETF	308.6	308.89	308.34	308.74	116229.0
2020-06-30 18:30:00	SPY	ETF	308.74	308.88	308.35	308.35	69342.0
2020-06-30 19:00:00	SPY	ETF	308.38	308.76	308.27	308.51	174439.0
2020-06-30 19:30:00	SPY	ETF	308.58	308.59	308.1	308.28	206331.0
2020-06-30 04:00:00	QQQ	ETF	243.35	243.47	242.97	243.22	17862.0
2020-06-30 04:30:00	QQQ	ETF	243.1	243.31	242.87	243.1	19372.0
2020-06-30 05:00:00	QQQ	ETF	242.95	243.29	242.85	243.22	9897.0
2020-06-30 05:30:00	QQQ	ETF	243.26	243.4	243.15	243.4	15900.0
2020-06-30 06:00:00	QQQ	ETF	243.48	243.5	243.22	243.45	21785.0
2020-06-30 06:30:00	QQQ	ETF	243.5	243.5	243.09	243.12	18992.0
2020-06-30 07:00:00	QQQ	ETF	243.1	243.34	242.97	243.3	61165.0
2020-06-30 07:30:00	QQQ	ETF	243.33	243.65	243.2	243.27	81460.0
2020-06-30 08:00:00	QQQ	ETF	243.2901	244.35	242.97	242.97	56779.0
2020-06-30 08:30:00	QQQ	ETF	242.9799	243.0	242.5	242.78	75212.0
2020-06-30 09:00:00	QQQ	ETF	242.8	242.89	242.53	242.75	79862.0
2020-06-30 09:30:00	QQQ	ETF	242.73	244.82	242.58	244.55	4055095.0
2020-06-30 10:00:00	QQQ	ETF	244.54	245.1	244.43	244.59	2205000.0
2020-06-30 10:30:00	QQQ	ETF	244.57	245.56	244.52	245.47	1878037.0
2020-06-30 11:00:00	QQQ	ETF	245.47	246.09	245.37	245.7	1934000.0
2020-06-30 11:30:00	QQQ	ETF	245.7	245.9201	245.46	245.8301	1028968.0
2020-06-30 12:00:00	QQQ	ETF	245.83	246.47	245.6697	246.25	1534292.0
2020-06-30 12:30:00	QQQ	ETF	246.25	246.37	245.32	245.53	1400660.0

> showing 50 of 20,446 rows — these rows as CSV

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