PREVIEW / etf_5min / 2020-04-21

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-21.parquet
  size:    1.8 MB
  rows:    79,458

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-21 04:00:00	SPY	ETF	279.19	279.71	279.09	279.68	13609.0
2020-04-21 04:05:00	SPY	ETF	279.6	280.02	279.6	280.0	8162.0
2020-04-21 04:10:00	SPY	ETF	280.18	280.3	279.93	279.93	12019.0
2020-04-21 04:15:00	SPY	ETF	279.96	280.06	279.7	279.7	1810.0
2020-04-21 04:20:00	SPY	ETF	279.81	279.9	279.44	279.44	4158.0
2020-04-21 04:25:00	SPY	ETF	279.49	279.52	279.41	279.45	4576.0
2020-04-21 04:30:00	SPY	ETF	279.62	279.68	279.22	279.22	6727.0
2020-04-21 04:35:00	SPY	ETF	279.43	279.61	279.37	279.61	4687.0
2020-04-21 04:40:00	SPY	ETF	279.6	279.63	279.13	279.13	6420.0
2020-04-21 04:45:00	SPY	ETF	279.23	279.89	279.23	279.86	1821.0
2020-04-21 04:50:00	SPY	ETF	279.86	280.05	279.8	279.88	3070.0
2020-04-21 04:55:00	SPY	ETF	279.86	279.86	279.75	279.8	3908.0
2020-04-21 05:00:00	SPY	ETF	280.0	280.18	280.0	280.11	2054.0
2020-04-21 05:05:00	SPY	ETF	279.6	279.84	279.6	279.65	1506.0
2020-04-21 05:10:00	SPY	ETF	279.79	279.79	278.67	278.78	30018.0
2020-04-21 05:15:00	SPY	ETF	278.82	279.09	278.63	278.73	7045.0
2020-04-21 05:20:00	SPY	ETF	278.7	279.0	278.7	278.82	21258.0
2020-04-21 05:25:00	SPY	ETF	278.61	278.61	278.2	278.2	29261.0
2020-04-21 05:30:00	SPY	ETF	278.58	278.63	277.88	277.95	67977.0
2020-04-21 05:35:00	SPY	ETF	278.35	278.5	278.17	278.45	20481.0
2020-04-21 05:40:00	SPY	ETF	278.37	278.7	278.37	278.42	2998.0
2020-04-21 05:45:00	SPY	ETF	278.3	278.32	277.82	278.16	11039.0
2020-04-21 05:50:00	SPY	ETF	278.18	278.3	277.75	277.85	29777.0
2020-04-21 05:55:00	SPY	ETF	277.75	278.2	277.54	278.2	42394.0
2020-04-21 06:00:00	SPY	ETF	278.12	278.72	278.12	278.46	51964.0
2020-04-21 06:05:00	SPY	ETF	278.39	278.39	278.05	278.27	8188.0
2020-04-21 06:10:00	SPY	ETF	278.2	278.2	277.24	277.32	36909.0
2020-04-21 06:15:00	SPY	ETF	277.37	277.47	276.9	276.9	32304.0
2020-04-21 06:20:00	SPY	ETF	276.95	277.2	276.77	277.15	56259.0
2020-04-21 06:25:00	SPY	ETF	277.13	277.33	277.03	277.12	83052.0
2020-04-21 06:30:00	SPY	ETF	276.86	277.5	276.64	277.48	42070.0
2020-04-21 06:35:00	SPY	ETF	277.44	277.85	277.3	277.74	50234.0
2020-04-21 06:40:00	SPY	ETF	277.8	277.99	277.74	277.83	34615.0
2020-04-21 06:45:00	SPY	ETF	277.98	278.17	277.42	277.42	16690.0
2020-04-21 06:50:00	SPY	ETF	277.44	277.51	277.31	277.4	4458.0
2020-04-21 06:55:00	SPY	ETF	277.25	277.42	277.09	277.42	34398.0
2020-04-21 07:00:00	SPY	ETF	277.27	279.44	277.27	277.4	100767.0
2020-04-21 07:05:00	SPY	ETF	277.35	277.35	276.85	276.9	60173.0
2020-04-21 07:10:00	SPY	ETF	276.85	277.05	276.57	277.0	71614.0
2020-04-21 07:15:00	SPY	ETF	277.08	277.35	276.89	277.0	49916.0
2020-04-21 07:20:00	SPY	ETF	277.15	277.3	276.88	277.19	112131.0
2020-04-21 07:25:00	SPY	ETF	277.279	277.36	276.77	276.87	51908.0
2020-04-21 07:30:00	SPY	ETF	276.82	277.1	276.49	276.51	132104.0
2020-04-21 07:35:00	SPY	ETF	276.48	276.75	276.29	276.37	207381.0
2020-04-21 07:40:00	SPY	ETF	276.38	276.57	275.99	276.1	226744.0
2020-04-21 07:45:00	SPY	ETF	276.08	276.3	275.96	276.04	155908.0
2020-04-21 07:50:00	SPY	ETF	276.06	276.52	275.83	276.3	214488.0
2020-04-21 07:55:00	SPY	ETF	276.32	276.6	276.22	276.3	106729.0
2020-04-21 08:00:00	SPY	ETF	276.3	280.79	275.81	275.88	228364.0
2020-04-21 08:05:00	SPY	ETF	275.88	276.1	275.48	275.61	152120.0

> showing 50 of 79,458 rows — these rows as CSV

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