PREVIEW / etf_30min / 2020-03-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-20.parquet
  size:    622 KB
  rows:    23,082

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-20 04:00:00	SPY	ETF	243.85	249.79	243.85	247.43	187530.0
2020-03-20 04:30:00	SPY	ETF	247.57	249.0	245.52	248.89	160373.0
2020-03-20 05:00:00	SPY	ETF	249.0	249.8	248.2	248.2	181924.0
2020-03-20 05:30:00	SPY	ETF	248.49	250.08	247.74	249.48	163357.0
2020-03-20 06:00:00	SPY	ETF	249.48	249.96	247.38	247.42	150064.0
2020-03-20 06:30:00	SPY	ETF	247.44	247.55	246.0	246.75	550016.0
2020-03-20 07:00:00	SPY	ETF	246.52	246.75	242.8	243.45	930651.0
2020-03-20 07:30:00	SPY	ETF	243.46	245.09	243.0	244.74	690014.0
2020-03-20 08:00:00	SPY	ETF	237.698	249.795	237.698	241.29	2041377.0
2020-03-20 08:30:00	SPY	ETF	241.2	242.88	240.75	240.77	1702379.0
2020-03-20 09:00:00	SPY	ETF	240.79	243.02	239.79	242.59	2324204.0
2020-03-20 09:30:00	SPY	ETF	242.53	243.55	236.61	239.11	34113797.0
2020-03-20 10:00:00	SPY	ETF	239.1	242.3	238.82	241.75	36820187.0
2020-03-20 10:30:00	SPY	ETF	241.78	244.41	241.1	244.06	20535853.0
2020-03-20 11:00:00	SPY	ETF	244.05	244.47	237.74	238.9601	26536036.0
2020-03-20 11:30:00	SPY	ETF	238.95	240.42	238.05	238.82	20846892.0
2020-03-20 12:00:00	SPY	ETF	238.79	239.35	234.3	235.31	19884221.0
2020-03-20 12:30:00	SPY	ETF	235.3	242.5416	234.91	237.47	17136655.0
2020-03-20 13:00:00	SPY	ETF	237.475	239.7899	236.53	237.3799	10948947.0
2020-03-20 13:30:00	SPY	ETF	237.33	238.45	236.44	237.83	11940318.0
2020-03-20 14:00:00	SPY	ETF	237.835	238.89	233.93	234.86	12434020.0
2020-03-20 14:30:00	SPY	ETF	234.9363	235.69	231.2	232.31	18736768.0
2020-03-20 15:00:00	SPY	ETF	232.31	234.43	230.02	233.51	24196695.0
2020-03-20 15:30:00	SPY	ETF	233.56	234.91	228.5	228.94	48750580.0
2020-03-20 16:00:00	SPY	ETF	228.94	230.41	228.25	228.51	21832625.0
2020-03-20 16:30:00	SPY	ETF	228.5	229.6853	226.41	227.1999	5526600.0
2020-03-20 17:00:00	SPY	ETF	227.02	228.8	226.7	227.0301	2727974.0
2020-03-20 17:30:00	SPY	ETF	227.05	228.8	226.4	226.7	410445.0
2020-03-20 18:00:00	SPY	ETF	226.64	228.8	226.61	227.19	2354196.0
2020-03-20 18:30:00	SPY	ETF	227.2	229.685	226.9	227.0	227536.0
2020-03-20 19:00:00	SPY	ETF	227.0	228.8	227.0	227.11	174173.0
2020-03-20 19:30:00	SPY	ETF	227.11	227.19	226.37	226.4	105167.0
2020-03-20 04:00:00	QQQ	ETF	183.0	186.72	183.0	186.45	104200.0
2020-03-20 04:30:00	QQQ	ETF	186.43	186.72	184.69	186.72	95269.0
2020-03-20 05:00:00	QQQ	ETF	186.72	186.72	185.8	186.51	35626.0
2020-03-20 05:30:00	QQQ	ETF	186.28	186.9	186.24	186.83	56981.0
2020-03-20 06:00:00	QQQ	ETF	186.84	186.98	186.06	186.57	49080.0
2020-03-20 06:30:00	QQQ	ETF	186.41	186.76	185.31	185.71	128156.0
2020-03-20 07:00:00	QQQ	ETF	185.68	185.8	183.06	183.75	249416.0
2020-03-20 07:30:00	QQQ	ETF	183.8	184.54	183.29	184.0	182865.0
2020-03-20 08:00:00	QQQ	ETF	184.1	185.62	175.7	182.25	272348.0
2020-03-20 08:30:00	QQQ	ETF	182.31	183.25	181.6	181.6	288370.0
2020-03-20 09:00:00	QQQ	ETF	181.58	183.1	180.86	181.78	763776.0
2020-03-20 09:30:00	QQQ	ETF	181.74	182.6	178.25	179.82	9476052.0
2020-03-20 10:00:00	QQQ	ETF	179.78	181.9	179.56	181.258	6910760.0
2020-03-20 10:30:00	QQQ	ETF	181.24	182.87	180.51	182.65	5963588.0
2020-03-20 11:00:00	QQQ	ETF	182.66	182.86	178.39	179.4	6690910.0
2020-03-20 11:30:00	QQQ	ETF	179.38	180.31	178.29	178.74	6338901.0
2020-03-20 12:00:00	QQQ	ETF	178.7	179.11	174.48	175.21	8246191.0
2020-03-20 12:30:00	QQQ	ETF	175.2	178.725	174.92	177.41	7329666.0

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

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