PREVIEW / etf_5min / 2020-07-23

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-23.parquet
  size:    1.6 MB
  rows:    76,059

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-07-23 04:00:00	SPY	ETF	328.15	328.35	328.01	328.01	9067.0
2020-07-23 04:05:00	SPY	ETF	328.04	328.33	328.01	328.33	4053.0
2020-07-23 04:10:00	SPY	ETF	328.24	328.24	328.24	328.24	200.0
2020-07-23 04:15:00	SPY	ETF	328.44	328.44	328.44	328.44	820.0
2020-07-23 04:20:00	SPY	ETF	328.51	328.51	328.46	328.46	2830.0
2020-07-23 04:25:00	SPY	ETF	328.41	328.43	328.41	328.43	850.0
2020-07-23 04:30:00	SPY	ETF	328.39	328.46	328.33	328.33	1454.0
2020-07-23 04:40:00	SPY	ETF	328.31	328.31	328.31	328.31	100.0
2020-07-23 04:45:00	SPY	ETF	328.24	328.26	328.0	328.0	3758.0
2020-07-23 04:50:00	SPY	ETF	327.87	327.91	327.8	327.89	2052.0
2020-07-23 04:55:00	SPY	ETF	327.93	327.93	327.57	327.57	4318.0
2020-07-23 05:00:00	SPY	ETF	327.56	327.73	327.56	327.64	1810.0
2020-07-23 05:05:00	SPY	ETF	327.76	327.76	327.76	327.76	406.0
2020-07-23 05:10:00	SPY	ETF	327.83	327.89	327.83	327.89	1985.0
2020-07-23 05:15:00	SPY	ETF	327.9	327.9	327.9	327.9	140.0
2020-07-23 05:20:00	SPY	ETF	327.84	327.84	327.84	327.84	400.0
2020-07-23 05:25:00	SPY	ETF	327.87	327.94	327.86	327.94	952.0
2020-07-23 05:30:00	SPY	ETF	327.98	327.98	327.98	327.98	125.0
2020-07-23 05:40:00	SPY	ETF	327.75	327.79	327.75	327.76	4630.0
2020-07-23 05:45:00	SPY	ETF	327.76	327.79	327.74	327.74	5048.0
2020-07-23 05:50:00	SPY	ETF	327.7	327.81	327.7	327.81	210.0
2020-07-23 05:55:00	SPY	ETF	327.8	327.85	327.8	327.85	3356.0
2020-07-23 06:00:00	SPY	ETF	327.85	328.1	327.85	328.09	2039.0
2020-07-23 06:05:00	SPY	ETF	328.14	328.27	328.14	328.27	2766.0
2020-07-23 06:10:00	SPY	ETF	328.23	328.27	328.05	328.06	8746.0
2020-07-23 06:15:00	SPY	ETF	328.16	328.16	328.16	328.16	110.0
2020-07-23 06:20:00	SPY	ETF	328.16	328.16	327.87	327.87	800.0
2020-07-23 06:25:00	SPY	ETF	327.8	327.9	327.79	327.87	10190.0
2020-07-23 06:30:00	SPY	ETF	327.91	327.91	327.88	327.89	2100.0
2020-07-23 06:35:00	SPY	ETF	327.84	327.84	327.72	327.76	3001.0
2020-07-23 06:40:00	SPY	ETF	327.79	327.79	327.72	327.72	7667.0
2020-07-23 06:45:00	SPY	ETF	327.72	327.76	327.59	327.76	10718.0
2020-07-23 06:50:00	SPY	ETF	327.74	327.79	327.74	327.79	1800.0
2020-07-23 06:55:00	SPY	ETF	327.75	327.75	327.64	327.64	335.0
2020-07-23 07:00:00	SPY	ETF	327.68	327.82	327.66	327.82	41659.0
2020-07-23 07:05:00	SPY	ETF	327.8	327.93	327.8	327.83	32582.0
2020-07-23 07:10:00	SPY	ETF	327.93	327.93	327.8	327.9	21284.0
2020-07-23 07:15:00	SPY	ETF	327.91	327.93	327.75	327.75	1926.0
2020-07-23 07:20:00	SPY	ETF	327.74	327.83	327.73	327.83	4633.0
2020-07-23 07:25:00	SPY	ETF	327.81	327.81	327.55	327.55	20390.0
2020-07-23 07:30:00	SPY	ETF	327.55	327.79	327.53	327.79	25942.0
2020-07-23 07:35:00	SPY	ETF	327.79	327.8	327.55	327.6	35712.0
2020-07-23 07:40:00	SPY	ETF	327.61	327.62	327.54	327.54	35925.0
2020-07-23 07:45:00	SPY	ETF	327.62	327.69	327.6	327.61	57232.0
2020-07-23 07:50:00	SPY	ETF	327.6	327.6	327.21	327.4	22845.0
2020-07-23 07:55:00	SPY	ETF	327.45	327.75	327.45	327.65	20139.0
2020-07-23 08:00:00	SPY	ETF	327.9	328.19	326.53	327.53	30940.0
2020-07-23 08:05:00	SPY	ETF	327.54	327.54	327.33	327.33	11120.0
2020-07-23 08:10:00	SPY	ETF	327.33	327.35	327.16	327.35	41500.0
2020-07-23 08:15:00	SPY	ETF	327.35	327.4299	327.31	327.38	5996.0

> showing 50 of 76,059 rows — these rows as CSV

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