PREVIEW / etf_5min / 2020-04-07

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-07.parquet
  size:    1.9 MB
  rows:    83,964

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-07 04:00:00	SPY	ETF	270.75	271.14	270.48	271.04	39356.0
2020-04-07 04:05:00	SPY	ETF	271.2	271.39	270.66	270.93	23859.0
2020-04-07 04:10:00	SPY	ETF	270.88	271.38	270.88	271.06	17563.0
2020-04-07 04:15:00	SPY	ETF	271.16	271.48	271.16	271.39	13949.0
2020-04-07 04:20:00	SPY	ETF	271.42	272.0	271.42	271.87	29181.0
2020-04-07 04:25:00	SPY	ETF	272.0	272.26	271.62	271.99	32035.0
2020-04-07 04:30:00	SPY	ETF	271.97	271.97	270.92	271.12	32898.0
2020-04-07 04:35:00	SPY	ETF	271.08	271.66	271.08	271.66	7310.0
2020-04-07 04:40:00	SPY	ETF	271.41	271.94	271.41	271.75	8712.0
2020-04-07 04:45:00	SPY	ETF	271.83	271.83	271.2	271.73	6587.0
2020-04-07 04:50:00	SPY	ETF	271.78	271.78	271.04	271.08	7856.0
2020-04-07 04:55:00	SPY	ETF	271.23	271.45	270.71	270.75	24809.0
2020-04-07 05:00:00	SPY	ETF	270.78	271.4	270.71	271.31	10655.0
2020-04-07 05:05:00	SPY	ETF	271.21	271.44	271.0	271.0	17228.0
2020-04-07 05:10:00	SPY	ETF	271.0	271.1	270.82	270.83	7461.0
2020-04-07 05:15:00	SPY	ETF	271.1	271.22	270.82	271.19	17271.0
2020-04-07 05:20:00	SPY	ETF	271.26	271.89	270.99	271.79	37977.0
2020-04-07 05:25:00	SPY	ETF	271.88	272.2	271.67	271.7	30315.0
2020-04-07 05:30:00	SPY	ETF	271.6	271.98	271.32	271.98	14072.0
2020-04-07 05:35:00	SPY	ETF	271.96	271.96	271.44	271.8	10942.0
2020-04-07 05:40:00	SPY	ETF	271.8	272.08	271.76	271.88	14478.0
2020-04-07 05:45:00	SPY	ETF	271.88	272.05	271.86	271.9	6289.0
2020-04-07 05:50:00	SPY	ETF	271.81	272.07	271.58	271.88	21964.0
2020-04-07 05:55:00	SPY	ETF	271.85	271.85	271.5	271.77	3941.0
2020-04-07 06:00:00	SPY	ETF	271.81	273.32	271.62	273.1	56191.0
2020-04-07 06:05:00	SPY	ETF	272.87	273.15	272.46	272.78	61883.0
2020-04-07 06:10:00	SPY	ETF	272.79	273.61	272.65	273.51	58925.0
2020-04-07 06:15:00	SPY	ETF	273.65	274.5	273.5	274.5	121646.0
2020-04-07 06:20:00	SPY	ETF	274.54	274.64	273.94	274.34	72286.0
2020-04-07 06:25:00	SPY	ETF	274.19	274.37	273.55	273.61	90170.0
2020-04-07 06:30:00	SPY	ETF	273.57	273.68	272.96	273.17	102886.0
2020-04-07 06:35:00	SPY	ETF	273.25	273.35	272.73	272.98	65995.0
2020-04-07 06:40:00	SPY	ETF	273.05	273.54	272.9	273.43	43242.0
2020-04-07 06:45:00	SPY	ETF	273.43	273.56	273.3	273.53	47507.0
2020-04-07 06:50:00	SPY	ETF	273.47	273.88	273.41	273.88	29673.0
2020-04-07 06:55:00	SPY	ETF	273.89	274.11	273.7	274.02	145017.0
2020-04-07 07:00:00	SPY	ETF	274.02	274.07	273.27	273.46	220349.0
2020-04-07 07:05:00	SPY	ETF	273.46	273.46	273.16	273.22	151538.0
2020-04-07 07:10:00	SPY	ETF	273.28	273.35	273.06	273.25	149052.0
2020-04-07 07:15:00	SPY	ETF	273.28	273.45	272.75	273.03	149852.0
2020-04-07 07:20:00	SPY	ETF	273.11	273.11	272.7	272.82	91488.0
2020-04-07 07:25:00	SPY	ETF	272.82	273.35	272.82	273.15	74673.0
2020-04-07 07:30:00	SPY	ETF	273.15	273.21	272.83	272.91	94232.0
2020-04-07 07:35:00	SPY	ETF	272.94	273.23	272.76	272.82	198648.0
2020-04-07 07:40:00	SPY	ETF	272.77	272.92	272.37	272.37	196077.0
2020-04-07 07:45:00	SPY	ETF	272.36	272.69	272.2	272.57	88943.0
2020-04-07 07:50:00	SPY	ETF	272.57	272.76	272.22	272.22	119834.0
2020-04-07 07:55:00	SPY	ETF	272.2	272.25	271.92	272.04	170721.0
2020-04-07 08:00:00	SPY	ETF	272.04	274.05	263.22	271.65	436857.0
2020-04-07 08:05:00	SPY	ETF	272.54	272.6499	272.26	272.53	102650.0

> showing 50 of 83,964 rows — these rows as CSV

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