PREVIEW / etf_30min / 2020-04-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-22.parquet
  size:    548 KB
  rows:    20,261

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-04-22 04:00:00	SPY	ETF	275.77	277.0	275.6	276.7	67184.0
2020-04-22 04:30:00	SPY	ETF	276.69	277.5	276.68	277.47	112601.0
2020-04-22 05:00:00	SPY	ETF	277.57	277.91	277.25	277.52	100264.0
2020-04-22 05:30:00	SPY	ETF	277.61	277.61	276.97	277.17	39002.0
2020-04-22 06:00:00	SPY	ETF	277.3	277.3	276.43	276.43	50799.0
2020-04-22 06:30:00	SPY	ETF	276.53	276.79	276.11	276.58	43669.0
2020-04-22 07:00:00	SPY	ETF	276.66	277.45	276.59	276.83	215321.0
2020-04-22 07:30:00	SPY	ETF	276.84	277.05	276.3	276.95	518261.0
2020-04-22 08:00:00	SPY	ETF	274.07	277.3004	273.29	276.87	1889891.0
2020-04-22 08:30:00	SPY	ETF	276.87	278.56	276.77	278.33	1431313.0
2020-04-22 09:00:00	SPY	ETF	278.31	278.58	277.93	278.34	841164.0
2020-04-22 09:30:00	SPY	ETF	278.35	278.9	277.05	277.81	9155067.0
2020-04-22 10:00:00	SPY	ETF	277.8	278.22	276.91	277.7	5502278.0
2020-04-22 10:30:00	SPY	ETF	277.74	278.67	277.45	277.59	5327236.0
2020-04-22 11:00:00	SPY	ETF	277.625	278.64	277.26	278.25	4096690.0
2020-04-22 11:30:00	SPY	ETF	278.25	279.05	278.18	278.68	4844864.0
2020-04-22 12:00:00	SPY	ETF	278.67	279.15	278.38	278.86	3619547.0
2020-04-22 12:30:00	SPY	ETF	278.86	279.3	278.32	278.59	3272393.0
2020-04-22 13:00:00	SPY	ETF	278.6	279.24	278.22	279.2207	3395321.0
2020-04-22 13:30:00	SPY	ETF	279.22	279.5	278.82	279.24	4581687.0
2020-04-22 14:00:00	SPY	ETF	279.25	279.51	278.96	279.2425	3624492.0
2020-04-22 14:30:00	SPY	ETF	279.24	280.24	279.24	279.99	9435998.0
2020-04-22 15:00:00	SPY	ETF	280.0	280.38	279.71	279.98	7156499.0
2020-04-22 15:30:00	SPY	ETF	279.98	281.0	279.07	279.17	17392076.0
2020-04-22 16:00:00	SPY	ETF	279.17	279.19	278.5	278.93	4155263.0
2020-04-22 16:30:00	SPY	ETF	278.93	279.31	278.91	279.31	505857.0
2020-04-22 17:00:00	SPY	ETF	279.28	279.35	279.18	279.18	69223.0
2020-04-22 17:30:00	SPY	ETF	279.17	279.37	279.12	279.36	67610.0
2020-04-22 18:00:00	SPY	ETF	279.18	279.43	278.4	278.79	207622.0
2020-04-22 18:30:00	SPY	ETF	278.8	279.1	278.2	278.26	142174.0
2020-04-22 19:00:00	SPY	ETF	278.42	278.45	277.88	278.25	160049.0
2020-04-22 19:30:00	SPY	ETF	278.25	278.25	277.65	278.15	179526.0
2020-04-22 04:00:00	QQQ	ETF	207.4	208.25	207.4	208.04	19467.0
2020-04-22 04:30:00	QQQ	ETF	208.1	208.67	208.1	208.67	152454.0
2020-04-22 05:00:00	QQQ	ETF	208.65	209.05	208.6	208.9	11310.0
2020-04-22 05:30:00	QQQ	ETF	208.71	208.74	208.47	208.6	3392.0
2020-04-22 06:00:00	QQQ	ETF	208.71	208.72	207.9	207.97	33688.0
2020-04-22 06:30:00	QQQ	ETF	207.94	208.1	207.7	208.1	76363.0
2020-04-22 07:00:00	QQQ	ETF	208.09	208.38	207.88	207.99	236365.0
2020-04-22 07:30:00	QQQ	ETF	208.06	208.45	207.85	208.45	621381.0
2020-04-22 08:00:00	QQQ	ETF	208.42	208.44	205.76	208.32	692464.0
2020-04-22 08:30:00	QQQ	ETF	208.34	209.35	208.24	209.21	650141.0
2020-04-22 09:00:00	QQQ	ETF	209.18	209.44	208.98	209.17	1061250.0
2020-04-22 09:30:00	QQQ	ETF	209.14	209.88	208.33	209.3	5893743.0
2020-04-22 10:00:00	QQQ	ETF	209.28	209.72	208.59	209.25	3179683.0
2020-04-22 10:30:00	QQQ	ETF	209.28	210.09	209.07	209.27	2686013.0
2020-04-22 11:00:00	QQQ	ETF	209.27	210.01	209.01	209.61	1984529.0
2020-04-22 11:30:00	QQQ	ETF	209.6	210.09	209.49	209.78	1417493.0
2020-04-22 12:00:00	QQQ	ETF	209.8	210.14	209.66	209.91	1360787.0
2020-04-22 12:30:00	QQQ	ETF	209.9	210.46	209.82	210.1	1510115.0

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

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