PREVIEW / etf_5min / 2020-11-18

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-11-18.parquet
  size:    1.7 MB
  rows:    79,806

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-11-18 04:00:00	SPY	ETF	360.17	360.3	360.17	360.25	3404.0
2020-11-18 04:05:00	SPY	ETF	360.23	360.32	360.21	360.28	1130.0
2020-11-18 04:10:00	SPY	ETF	360.52	360.53	360.38	360.38	592.0
2020-11-18 04:15:00	SPY	ETF	360.39	360.63	360.39	360.55	1653.0
2020-11-18 04:20:00	SPY	ETF	360.73	360.94	360.68	360.94	7081.0
2020-11-18 04:25:00	SPY	ETF	360.87	361.04	360.87	361.04	5729.0
2020-11-18 04:30:00	SPY	ETF	360.91	360.91	360.91	360.91	1000.0
2020-11-18 04:35:00	SPY	ETF	360.86	360.94	360.86	360.92	2808.0
2020-11-18 04:40:00	SPY	ETF	360.97	360.97	360.88	360.9	800.0
2020-11-18 04:45:00	SPY	ETF	360.96	360.98	360.96	360.98	295.0
2020-11-18 04:50:00	SPY	ETF	360.88	360.88	360.88	360.88	100.0
2020-11-18 04:55:00	SPY	ETF	361.0	361.0	361.0	361.0	260.0
2020-11-18 05:00:00	SPY	ETF	361.05	361.05	361.02	361.02	280.0
2020-11-18 05:05:00	SPY	ETF	361.09	361.3	361.09	361.3	4485.0
2020-11-18 05:10:00	SPY	ETF	361.32	361.38	361.3	361.38	3140.0
2020-11-18 05:15:00	SPY	ETF	361.48	361.5	361.3	361.32	2722.0
2020-11-18 05:20:00	SPY	ETF	361.39	361.48	361.3	361.48	3833.0
2020-11-18 05:25:00	SPY	ETF	361.6	361.7	361.6	361.7	574.0
2020-11-18 05:35:00	SPY	ETF	361.48	361.51	361.48	361.5	1448.0
2020-11-18 05:40:00	SPY	ETF	361.43	361.47	361.38	361.4	3206.0
2020-11-18 05:50:00	SPY	ETF	361.35	361.35	361.35	361.35	595.0
2020-11-18 05:55:00	SPY	ETF	361.39	361.42	361.39	361.42	965.0
2020-11-18 06:00:00	SPY	ETF	361.43	361.43	361.4	361.4	2841.0
2020-11-18 06:05:00	SPY	ETF	361.55	361.55	361.55	361.55	520.0
2020-11-18 06:10:00	SPY	ETF	361.56	361.7	361.55	361.7	12695.0
2020-11-18 06:15:00	SPY	ETF	361.7	361.73	361.65	361.65	365.0
2020-11-18 06:20:00	SPY	ETF	361.4	361.4	361.4	361.4	715.0
2020-11-18 06:25:00	SPY	ETF	361.45	361.45	361.34	361.41	4851.0
2020-11-18 06:30:00	SPY	ETF	361.4	361.4	361.39	361.4	1001.0
2020-11-18 06:35:00	SPY	ETF	361.35	361.4	361.27	361.28	26465.0
2020-11-18 06:40:00	SPY	ETF	361.3	361.4	361.28	361.4	2595.0
2020-11-18 06:45:00	SPY	ETF	361.46	361.89	361.45	361.86	14096.0
2020-11-18 06:50:00	SPY	ETF	361.8	361.88	361.6	361.61	11473.0
2020-11-18 06:55:00	SPY	ETF	361.6	361.65	361.52	361.55	4396.0
2020-11-18 07:00:00	SPY	ETF	361.57	361.72	361.55	361.68	11328.0
2020-11-18 07:05:00	SPY	ETF	361.68	361.77	361.68	361.73	3744.0
2020-11-18 07:10:00	SPY	ETF	361.78	361.81	361.76	361.79	14777.0
2020-11-18 07:15:00	SPY	ETF	361.76	361.86	361.76	361.78	3296.0
2020-11-18 07:20:00	SPY	ETF	361.8	361.87	361.8	361.8	16376.0
2020-11-18 07:25:00	SPY	ETF	361.84	362.02	361.83	362.01	18222.0
2020-11-18 07:30:00	SPY	ETF	362.01	362.08	361.94	362.04	20318.0
2020-11-18 07:35:00	SPY	ETF	362.02	362.14	361.95	362.12	32581.0
2020-11-18 07:40:00	SPY	ETF	362.12	362.21	362.1	362.13	79615.0
2020-11-18 07:45:00	SPY	ETF	362.12	362.12	361.9	361.94	14115.0
2020-11-18 07:50:00	SPY	ETF	361.93	361.95	361.61	361.73	24785.0
2020-11-18 07:55:00	SPY	ETF	361.73	361.85	361.71	361.76	11556.0
2020-11-18 08:00:00	SPY	ETF	361.6999	362.21	358.91	361.55	60932.0
2020-11-18 08:05:00	SPY	ETF	361.54	361.54	361.44	361.48	17532.0
2020-11-18 08:10:00	SPY	ETF	361.48	361.48	361.29	361.34	11859.0
2020-11-18 08:15:00	SPY	ETF	361.36	361.46	361.31	361.39	11327.0

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

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