PREVIEW / etf_5min / 2020-04-03

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-03.parquet
  size:    1.7 MB
  rows:    75,941

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-03 04:00:00	SPY	ETF	250.0	250.02	249.73	249.83	8107.0
2020-04-03 04:05:00	SPY	ETF	249.83	250.26	249.83	250.26	5551.0
2020-04-03 04:10:00	SPY	ETF	250.0	250.16	250.0	250.06	881.0
2020-04-03 04:15:00	SPY	ETF	249.92	249.92	249.92	249.92	279.0
2020-04-03 04:20:00	SPY	ETF	249.73	249.73	249.3	249.41	16806.0
2020-04-03 04:25:00	SPY	ETF	249.28	249.28	249.0	249.05	5675.0
2020-04-03 04:30:00	SPY	ETF	249.29	249.29	248.68	248.83	14648.0
2020-04-03 04:35:00	SPY	ETF	248.75	248.97	248.6	248.97	6875.0
2020-04-03 04:40:00	SPY	ETF	248.72	248.72	248.44	248.64	4998.0
2020-04-03 04:45:00	SPY	ETF	248.94	249.14	248.7	249.14	4880.0
2020-04-03 04:50:00	SPY	ETF	249.06	249.06	249.02	249.02	1076.0
2020-04-03 04:55:00	SPY	ETF	248.97	249.14	248.97	249.14	1264.0
2020-04-03 05:00:00	SPY	ETF	249.14	249.45	249.14	249.32	3040.0
2020-04-03 05:05:00	SPY	ETF	248.95	249.05	248.8	249.05	8609.0
2020-04-03 05:10:00	SPY	ETF	248.85	249.07	248.85	248.99	6152.0
2020-04-03 05:15:00	SPY	ETF	248.94	248.94	248.49	248.68	12604.0
2020-04-03 05:20:00	SPY	ETF	248.56	248.56	248.23	248.31	4712.0
2020-04-03 05:25:00	SPY	ETF	248.42	248.79	248.42	248.79	6290.0
2020-04-03 05:30:00	SPY	ETF	248.68	248.68	248.25	248.25	9150.0
2020-04-03 05:35:00	SPY	ETF	248.32	248.32	248.02	248.21	12447.0
2020-04-03 05:40:00	SPY	ETF	248.33	248.72	248.33	248.64	10423.0
2020-04-03 05:45:00	SPY	ETF	248.53	248.9	248.44	248.78	3799.0
2020-04-03 05:50:00	SPY	ETF	248.79	249.44	248.72	249.38	11111.0
2020-04-03 05:55:00	SPY	ETF	249.33	249.42	248.99	249.42	8155.0
2020-04-03 06:00:00	SPY	ETF	249.45	249.45	249.26	249.43	4050.0
2020-04-03 06:05:00	SPY	ETF	249.5	249.7	249.3	249.53	9761.0
2020-04-03 06:10:00	SPY	ETF	249.54	249.54	249.15	249.15	14056.0
2020-04-03 06:15:00	SPY	ETF	249.15	249.15	249.0	249.09	1790.0
2020-04-03 06:20:00	SPY	ETF	248.93	249.24	248.8	249.02	12462.0
2020-04-03 06:25:00	SPY	ETF	249.05	249.15	249.02	249.05	9849.0
2020-04-03 06:30:00	SPY	ETF	248.91	249.82	248.91	249.82	10728.0
2020-04-03 06:35:00	SPY	ETF	249.8	249.8	249.22	249.22	6371.0
2020-04-03 06:40:00	SPY	ETF	249.24	249.46	249.1	249.14	30570.0
2020-04-03 06:45:00	SPY	ETF	249.4	249.77	249.4	249.76	8451.0
2020-04-03 06:50:00	SPY	ETF	249.59	249.68	249.49	249.62	3740.0
2020-04-03 06:55:00	SPY	ETF	249.65	249.65	249.57	249.6	1440.0
2020-04-03 07:00:00	SPY	ETF	249.59	250.0	249.48	249.93	36706.0
2020-04-03 07:05:00	SPY	ETF	250.0	250.0	249.71	249.76	27916.0
2020-04-03 07:10:00	SPY	ETF	249.74	249.74	249.59	249.7	15223.0
2020-04-03 07:15:00	SPY	ETF	249.71	249.81	249.38	249.42	21330.0
2020-04-03 07:20:00	SPY	ETF	249.4	249.82	249.4	249.82	8397.0
2020-04-03 07:25:00	SPY	ETF	249.79	249.84	249.62	249.79	39184.0
2020-04-03 07:30:00	SPY	ETF	249.75	250.17	249.75	250.17	25648.0
2020-04-03 07:35:00	SPY	ETF	250.2	250.32	250.1	250.21	32620.0
2020-04-03 07:40:00	SPY	ETF	250.22	250.22	250.0	250.16	60249.0
2020-04-03 07:45:00	SPY	ETF	250.13	251.27	250.13	250.93	153808.0
2020-04-03 07:50:00	SPY	ETF	250.9	251.41	250.75	251.21	84769.0
2020-04-03 07:55:00	SPY	ETF	251.27	253.03	251.05	252.65	317121.0
2020-04-03 08:00:00	SPY	ETF	249.9301	252.97	248.2	252.04	463992.0
2020-04-03 08:05:00	SPY	ETF	251.99	252.12	251.35	251.36	134401.0

> showing 50 of 75,941 rows — these rows as CSV

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