PREVIEW / etf_30min / 2020-03-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-25.parquet
  size:    619 KB
  rows:    22,883

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-25 04:00:00	SPY	ETF	246.89	247.97	245.1	247.95	153327.0
2020-03-25 04:30:00	SPY	ETF	247.81	248.74	246.9	248.09	104711.0
2020-03-25 05:00:00	SPY	ETF	248.25	249.97	248.2	249.97	138695.0
2020-03-25 05:30:00	SPY	ETF	249.83	250.0	247.21	247.94	131225.0
2020-03-25 06:00:00	SPY	ETF	247.8	247.94	245.62	245.83	192950.0
2020-03-25 06:30:00	SPY	ETF	245.8	246.0	240.41	240.7	505966.0
2020-03-25 07:00:00	SPY	ETF	240.6	243.0	240.1	241.51	1439120.0
2020-03-25 07:30:00	SPY	ETF	241.71	241.91	239.03	241.04	1015845.0
2020-03-25 08:00:00	SPY	ETF	241.25	249.77	239.05	241.18	2089120.0
2020-03-25 08:30:00	SPY	ETF	241.48	249.05	241.3	243.13	1215728.0
2020-03-25 09:00:00	SPY	ETF	243.12	245.3	242.35	244.83	2135990.0
2020-03-25 09:30:00	SPY	ETF	244.87	249.225	242.22	242.52	46003231.0
2020-03-25 10:00:00	SPY	ETF	242.5	243.205	239.75	242.33	27170327.0
2020-03-25 10:30:00	SPY	ETF	242.3	245.74	242.17	245.39	19745237.0
2020-03-25 11:00:00	SPY	ETF	245.41	246.75	244.53	245.39	15809768.0
2020-03-25 11:30:00	SPY	ETF	245.39	246.52	244.35	245.84	9730017.0
2020-03-25 12:00:00	SPY	ETF	245.82	250.28	245.71	249.74	14269493.0
2020-03-25 12:30:00	SPY	ETF	249.73	252.27	248.84	250.81	19910001.0
2020-03-25 13:00:00	SPY	ETF	250.8357	254.18	250.48	253.75	15660915.0
2020-03-25 13:30:00	SPY	ETF	253.74	256.35	252.91	254.03	18151454.0
2020-03-25 14:00:00	SPY	ETF	254.06	254.88	251.01	253.525	19176138.0
2020-03-25 14:30:00	SPY	ETF	253.51	255.03	251.43	254.42	15503411.0
2020-03-25 15:00:00	SPY	ETF	254.42	255.49	252.98	253.51	12110969.0
2020-03-25 15:30:00	SPY	ETF	253.5399	255.17	245.59	246.77	43897707.0
2020-03-25 16:00:00	SPY	ETF	246.8	248.29	244.6132	246.65	8841251.0
2020-03-25 16:30:00	SPY	ETF	246.65	247.12	245.96	246.83	1084827.0
2020-03-25 17:00:00	SPY	ETF	246.86	246.9	246.21	246.54	281716.0
2020-03-25 17:30:00	SPY	ETF	246.47	247.25	246.45	247.0	153756.0
2020-03-25 18:00:00	SPY	ETF	247.16	249.0	246.26	247.18	448092.0
2020-03-25 18:30:00	SPY	ETF	246.95	248.04	246.9	247.4	196443.0
2020-03-25 19:00:00	SPY	ETF	247.43	247.43	245.66	246.37	305071.0
2020-03-25 19:30:00	SPY	ETF	246.43	247.08	245.86	246.96	487949.0
2020-03-25 04:00:00	QQQ	ETF	186.1	187.17	185.3	187.17	113717.0
2020-03-25 04:30:00	QQQ	ETF	187.15	188.09	186.37	187.65	40232.0
2020-03-25 05:00:00	QQQ	ETF	187.8	189.16	187.62	189.06	57905.0
2020-03-25 05:30:00	QQQ	ETF	189.05	189.19	186.87	187.36	75330.0
2020-03-25 06:00:00	QQQ	ETF	187.27	187.33	185.5	185.67	139390.0
2020-03-25 06:30:00	QQQ	ETF	185.73	185.77	181.63	181.74	203705.0
2020-03-25 07:00:00	QQQ	ETF	181.73	183.75	181.55	182.78	547004.0
2020-03-25 07:30:00	QQQ	ETF	183.02	183.03	181.01	182.44	406599.0
2020-03-25 08:00:00	QQQ	ETF	183.2899	188.4	180.05	182.13	315328.0
2020-03-25 08:30:00	QQQ	ETF	182.45	183.81	182.39	183.59	159237.0
2020-03-25 09:00:00	QQQ	ETF	183.63	184.79	182.85	184.41	717062.0
2020-03-25 09:30:00	QQQ	ETF	184.41	187.1	182.25	182.47	10445869.0
2020-03-25 10:00:00	QQQ	ETF	182.39	182.6101	179.98	181.66	5933141.0
2020-03-25 10:30:00	QQQ	ETF	181.6732	183.53	181.51	183.29	4535326.0
2020-03-25 11:00:00	QQQ	ETF	183.32	183.99	182.46	183.17	3881495.0
2020-03-25 11:30:00	QQQ	ETF	183.165	183.75	182.21	183.0576	3314137.0
2020-03-25 12:00:00	QQQ	ETF	183.07	185.84	182.98	185.4	3933973.0
2020-03-25 12:30:00	QQQ	ETF	185.4	186.45	184.715	185.58	4280379.0

> showing 50 of 22,883 rows — these rows as CSV

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