PREVIEW / etf_30min / 2020-04-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-02.parquet
  size:    566 KB
  rows:    20,952

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-02 04:00:00	SPY	ETF	249.53	250.63	249.53	250.27	273720.0
2020-04-02 04:30:00	SPY	ETF	250.22	250.45	249.53	249.67	358771.0
2020-04-02 05:00:00	SPY	ETF	249.65	249.86	249.28	249.61	55830.0
2020-04-02 05:30:00	SPY	ETF	249.72	249.83	248.89	249.05	72369.0
2020-04-02 06:00:00	SPY	ETF	249.02	249.67	248.5	249.52	93983.0
2020-04-02 06:30:00	SPY	ETF	249.55	249.71	249.02	249.48	137844.0
2020-04-02 07:00:00	SPY	ETF	249.46	249.53	248.65	249.15	286587.0
2020-04-02 07:30:00	SPY	ETF	249.16	250.02	248.8	249.88	271879.0
2020-04-02 08:00:00	SPY	ETF	248.6101	250.18	246.15	248.96	927513.0
2020-04-02 08:30:00	SPY	ETF	248.88	249.36	245.27	246.13	2405391.0
2020-04-02 09:00:00	SPY	ETF	246.13	246.64	242.94	245.2	2199324.0
2020-04-02 09:30:00	SPY	ETF	245.19	248.03	244.59	246.5	17354916.0
2020-04-02 10:00:00	SPY	ETF	246.51	249.09	246.15	249.05	10360830.0
2020-04-02 10:30:00	SPY	ETF	249.02	252.68	248.67	250.86	20099190.0
2020-04-02 11:00:00	SPY	ETF	250.85	251.34	248.67	249.22	10334312.0
2020-04-02 11:30:00	SPY	ETF	249.2	251.32	248.88	250.795	9920898.0
2020-04-02 12:00:00	SPY	ETF	250.8	251.95	250.39	250.5401	7121226.0
2020-04-02 12:30:00	SPY	ETF	250.55	251.5	250.205	250.98	6538172.0
2020-04-02 13:00:00	SPY	ETF	251.0	251.72	247.82	248.0	10892169.0
2020-04-02 13:30:00	SPY	ETF	248.0	249.24	247.53	248.25	7549288.0
2020-04-02 14:00:00	SPY	ETF	248.26	248.3	245.93	247.72	13147569.0
2020-04-02 14:30:00	SPY	ETF	247.7001	249.3479	246.82	249.31	8851436.0
2020-04-02 15:00:00	SPY	ETF	249.3	250.21	248.5	249.6423	9307517.0
2020-04-02 15:30:00	SPY	ETF	249.6499	252.26	248.37	251.87	24342499.0
2020-04-02 16:00:00	SPY	ETF	251.88	252.81	249.4543	251.95	7997849.0
2020-04-02 16:30:00	SPY	ETF	251.95	253.0	251.8	251.93	2176320.0
2020-04-02 17:00:00	SPY	ETF	251.86	252.05	251.64	251.65	1164887.0
2020-04-02 17:30:00	SPY	ETF	251.65	251.99	251.55	251.95	134927.0
2020-04-02 18:00:00	SPY	ETF	251.89	252.73	251.15	252.3899	347088.0
2020-04-02 18:30:00	SPY	ETF	252.39	252.39	251.57	252.12	172027.0
2020-04-02 19:00:00	SPY	ETF	252.12	252.37	251.51	251.66	106643.0
2020-04-02 19:30:00	SPY	ETF	251.65	251.65	250.25	250.79	360497.0
2020-04-02 04:00:00	QQQ	ETF	184.79	185.34	184.79	185.29	27573.0
2020-04-02 04:30:00	QQQ	ETF	185.17	185.51	184.75	184.8	21922.0
2020-04-02 05:00:00	QQQ	ETF	184.8	184.93	184.51	184.69	19235.0
2020-04-02 05:30:00	QQQ	ETF	184.79	184.79	183.81	183.83	27570.0
2020-04-02 06:00:00	QQQ	ETF	183.66	184.38	183.33	184.21	44288.0
2020-04-02 06:30:00	QQQ	ETF	184.23	184.26	183.71	183.89	39386.0
2020-04-02 07:00:00	QQQ	ETF	184.02	184.09	183.5	184.01	86706.0
2020-04-02 07:30:00	QQQ	ETF	184.01	184.77	183.8	184.71	88830.0
2020-04-02 08:00:00	QQQ	ETF	184.04	185.1	182.94	184.32	336188.0
2020-04-02 08:30:00	QQQ	ETF	184.07	184.74	181.6	181.96	702604.0
2020-04-02 09:00:00	QQQ	ETF	181.95	182.37	180.27	181.57	503286.0
2020-04-02 09:30:00	QQQ	ETF	181.57	183.71	180.97	182.49	5843059.0
2020-04-02 10:00:00	QQQ	ETF	182.4801	183.9	182.24	183.77	3382432.0
2020-04-02 10:30:00	QQQ	ETF	183.74	186.06	183.55	184.8167	5876608.0
2020-04-02 11:00:00	QQQ	ETF	184.81	185.4	184.01	184.26	3390191.0
2020-04-02 11:30:00	QQQ	ETF	184.25	185.81	184.15	185.5	2200987.0
2020-04-02 12:00:00	QQQ	ETF	185.52	186.06	184.88	184.94	2108491.0
2020-04-02 12:30:00	QQQ	ETF	184.95	185.66	184.76	185.36	1629743.0

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

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