PREVIEW / etf_30min / 2020-03-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-02.parquet
  size:    632 KB
  rows:    23,023

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-03-02 04:00:00	SPY	ETF	300.2	300.57	298.62	299.77	114884.0
2020-03-02 04:30:00	SPY	ETF	300.04	300.12	296.22	297.24	123442.0
2020-03-02 05:00:00	SPY	ETF	297.51	297.51	296.14	297.16	67168.0
2020-03-02 05:30:00	SPY	ETF	297.2	297.9	295.95	296.12	91985.0
2020-03-02 06:00:00	SPY	ETF	296.0	296.08	294.07	294.07	311577.0
2020-03-02 06:30:00	SPY	ETF	294.15	294.34	290.65	291.1	654218.0
2020-03-02 07:00:00	SPY	ETF	291.14	293.45	290.9	293.45	758369.0
2020-03-02 07:30:00	SPY	ETF	293.39	294.86	292.48	294.29	649724.0
2020-03-02 08:00:00	SPY	ETF	294.42	302.07	290.99	293.06	1784396.0
2020-03-02 08:30:00	SPY	ETF	293.05	296.41	292.65	296.14	1418627.0
2020-03-02 09:00:00	SPY	ETF	296.2	298.78	296.2	298.28	2303886.0
2020-03-02 09:30:00	SPY	ETF	298.21	299.11	295.87	296.48	25383186.0
2020-03-02 10:00:00	SPY	ETF	296.49	297.11	294.46	296.33	15683899.0
2020-03-02 10:30:00	SPY	ETF	296.32	300.06	295.17	298.52	16966019.0
2020-03-02 11:00:00	SPY	ETF	298.52	301.95	298.15	301.6	16514762.0
2020-03-02 11:30:00	SPY	ETF	301.6	303.88	301.0	303.61	13825683.0
2020-03-02 12:00:00	SPY	ETF	303.6	304.07	301.49	302.38	12861491.0
2020-03-02 12:30:00	SPY	ETF	302.36	303.9	302.28	303.63	10615969.0
2020-03-02 13:00:00	SPY	ETF	303.62	303.99	300.81	301.31	12571784.0
2020-03-02 13:30:00	SPY	ETF	301.32	302.8755	300.79	302.57	9880571.0
2020-03-02 14:00:00	SPY	ETF	302.54	303.43	301.47	301.51	8883049.0
2020-03-02 14:30:00	SPY	ETF	301.507	301.95	298.98	300.06	13799917.0
2020-03-02 15:00:00	SPY	ETF	300.06	303.66	299.94	303.35	12046934.0
2020-03-02 15:30:00	SPY	ETF	303.35	309.16	303.07	309.08	36603573.0
2020-03-02 16:00:00	SPY	ETF	309.09	309.42	306.32	307.11	18004034.0
2020-03-02 16:30:00	SPY	ETF	307.11	309.0006	306.8	307.29	1479914.0
2020-03-02 17:00:00	SPY	ETF	307.15	309.09	307.01	307.3	1735078.0
2020-03-02 17:30:00	SPY	ETF	307.3	308.5	307.24	308.01	369088.0
2020-03-02 18:00:00	SPY	ETF	308.02	308.47	307.22	307.67	643697.0
2020-03-02 18:30:00	SPY	ETF	307.6	308.53	306.94	308.53	173559.0
2020-03-02 19:00:00	SPY	ETF	308.6	309.63	308.5	309.09	361228.0
2020-03-02 19:30:00	SPY	ETF	309.09	309.43	308.86	309.4	125152.0
2020-03-02 04:00:00	QQQ	ETF	209.61	210.55	209.14	209.96	89249.0
2020-03-02 04:30:00	QQQ	ETF	209.95	210.14	207.42	208.32	126284.0
2020-03-02 05:00:00	QQQ	ETF	208.0	208.19	207.26	208.19	53568.0
2020-03-02 05:30:00	QQQ	ETF	208.01	208.71	207.35	207.38	131859.0
2020-03-02 06:00:00	QQQ	ETF	207.33	207.33	205.94	205.94	124876.0
2020-03-02 06:30:00	QQQ	ETF	205.97	206.31	204.04	204.44	190474.0
2020-03-02 07:00:00	QQQ	ETF	204.46	205.64	204.39	205.48	571208.0
2020-03-02 07:30:00	QQQ	ETF	205.47	206.43	204.9	206.07	675190.0
2020-03-02 08:00:00	QQQ	ETF	206.16	211.5	204.22	205.41	889610.0
2020-03-02 08:30:00	QQQ	ETF	205.39	207.68	205.02	207.55	703296.0
2020-03-02 09:00:00	QQQ	ETF	207.57	209.07	207.57	208.83	1362354.0
2020-03-02 09:30:00	QQQ	ETF	208.87	209.67	206.94	207.69	13281046.0
2020-03-02 10:00:00	QQQ	ETF	207.69	208.15	205.94	206.9599	5625907.0
2020-03-02 10:30:00	QQQ	ETF	206.95	209.7	206.06	208.706	5662049.0
2020-03-02 11:00:00	QQQ	ETF	208.67	211.39	208.61	211.17	5811546.0
2020-03-02 11:30:00	QQQ	ETF	211.16	212.92	210.66	212.8008	6734207.0
2020-03-02 12:00:00	QQQ	ETF	212.81	213.04	211.09	211.736	4132290.0
2020-03-02 12:30:00	QQQ	ETF	211.765	213.08	211.67	212.85	3058410.0

> showing 50 of 23,023 rows — these rows as CSV

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