PREVIEW / etf_5min / 2020-04-09

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-09.parquet
  size:    1.9 MB
  rows:    85,153

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-09 04:00:00	SPY	ETF	276.56	277.06	276.56	276.74	42815.0
2020-04-09 04:05:00	SPY	ETF	276.78	276.94	276.6	276.64	12992.0
2020-04-09 04:10:00	SPY	ETF	276.45	276.45	276.1	276.28	5989.0
2020-04-09 04:15:00	SPY	ETF	276.18	276.18	275.8	275.96	7606.0
2020-04-09 04:20:00	SPY	ETF	275.84	276.0	275.57	275.57	15595.0
2020-04-09 04:25:00	SPY	ETF	275.49	275.52	274.94	274.94	13630.0
2020-04-09 04:30:00	SPY	ETF	274.97	275.25	274.96	275.23	18200.0
2020-04-09 04:35:00	SPY	ETF	274.96	275.03	274.16	274.16	6332.0
2020-04-09 04:40:00	SPY	ETF	274.42	274.7	274.33	274.41	23956.0
2020-04-09 04:45:00	SPY	ETF	274.47	274.81	274.47	274.65	8010.0
2020-04-09 04:50:00	SPY	ETF	274.69	274.7	274.0	274.25	9423.0
2020-04-09 04:55:00	SPY	ETF	274.17	274.21	273.84	273.84	6111.0
2020-04-09 05:00:00	SPY	ETF	273.81	274.23	273.81	274.17	9907.0
2020-04-09 05:05:00	SPY	ETF	274.11	274.33	273.96	273.96	4345.0
2020-04-09 05:10:00	SPY	ETF	274.03	274.03	273.5	273.58	13554.0
2020-04-09 05:15:00	SPY	ETF	273.84	273.88	273.14	273.2	22089.0
2020-04-09 05:20:00	SPY	ETF	273.22	273.9	273.18	273.71	9529.0
2020-04-09 05:25:00	SPY	ETF	273.9	274.1	273.9	274.01	7226.0
2020-04-09 05:30:00	SPY	ETF	274.04	274.2	273.8	273.85	16062.0
2020-04-09 05:35:00	SPY	ETF	273.71	274.01	273.6	273.94	2721.0
2020-04-09 05:40:00	SPY	ETF	273.98	274.29	273.91	274.17	8641.0
2020-04-09 05:45:00	SPY	ETF	273.96	274.19	273.23	273.28	11047.0
2020-04-09 05:50:00	SPY	ETF	273.41	273.67	272.87	272.99	13404.0
2020-04-09 05:55:00	SPY	ETF	273.0	273.22	272.97	273.19	7717.0
2020-04-09 06:00:00	SPY	ETF	272.96	273.49	272.85	273.4	18473.0
2020-04-09 06:05:00	SPY	ETF	273.58	273.76	273.4	273.76	5779.0
2020-04-09 06:10:00	SPY	ETF	273.61	273.69	273.52	273.52	5055.0
2020-04-09 06:15:00	SPY	ETF	273.62	273.62	273.16	273.23	3572.0
2020-04-09 06:20:00	SPY	ETF	273.16	273.26	272.74	272.74	15412.0
2020-04-09 06:25:00	SPY	ETF	272.68	272.86	272.34	272.86	18211.0
2020-04-09 06:30:00	SPY	ETF	272.66	273.01	271.76	272.11	32138.0
2020-04-09 06:35:00	SPY	ETF	272.28	272.69	272.25	272.66	24575.0
2020-04-09 06:40:00	SPY	ETF	272.68	272.92	272.52	272.57	25569.0
2020-04-09 06:45:00	SPY	ETF	272.8	272.87	272.47	272.7	6531.0
2020-04-09 06:50:00	SPY	ETF	272.65	272.77	272.24	272.25	23724.0
2020-04-09 06:55:00	SPY	ETF	272.24	272.76	272.21	272.76	7094.0
2020-04-09 07:00:00	SPY	ETF	272.8	273.45	272.76	273.31	85985.0
2020-04-09 07:05:00	SPY	ETF	273.34	274.01	273.29	273.85	119130.0
2020-04-09 07:10:00	SPY	ETF	273.8	274.0	273.49	273.5	31897.0
2020-04-09 07:15:00	SPY	ETF	273.46	273.72	273.4	273.4	18272.0
2020-04-09 07:20:00	SPY	ETF	273.36	273.5	272.52	272.58	70215.0
2020-04-09 07:25:00	SPY	ETF	272.58	272.58	271.55	271.59	145630.0
2020-04-09 07:30:00	SPY	ETF	271.51	272.1	271.15	272.1	159786.0
2020-04-09 07:35:00	SPY	ETF	272.1	272.18	271.6	271.7	68781.0
2020-04-09 07:40:00	SPY	ETF	271.74	271.85	271.39	271.53	158119.0
2020-04-09 07:45:00	SPY	ETF	271.5	272.34	271.47	272.25	67119.0
2020-04-09 07:50:00	SPY	ETF	272.22	272.65	272.22	272.6	106503.0
2020-04-09 07:55:00	SPY	ETF	272.54	272.55	271.86	271.86	78224.0
2020-04-09 08:00:00	SPY	ETF	274.0	277.21	271.1996	271.59	336138.0
2020-04-09 08:05:00	SPY	ETF	271.66	271.92	271.46	271.6699	170829.0

> showing 50 of 85,153 rows — these rows as CSV

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