PREVIEW / etf_5min / 2020-04-01

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-01.parquet
  size:    1.8 MB
  rows:    80,490

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-01 04:00:00	SPY	ETF	251.84	251.98	248.67	249.04	40694.0
2020-04-01 04:05:00	SPY	ETF	248.96	249.86	248.6	249.76	38297.0
2020-04-01 04:10:00	SPY	ETF	249.8	250.2	249.65	249.96	14816.0
2020-04-01 04:15:00	SPY	ETF	249.77	250.16	249.48	250.01	11807.0
2020-04-01 04:20:00	SPY	ETF	249.93	249.93	249.13	249.75	17683.0
2020-04-01 04:25:00	SPY	ETF	249.72	249.72	248.93	249.12	18365.0
2020-04-01 04:30:00	SPY	ETF	249.19	249.36	248.78	249.34	13578.0
2020-04-01 04:35:00	SPY	ETF	249.28	249.53	248.76	248.77	29784.0
2020-04-01 04:40:00	SPY	ETF	248.7	248.92	248.35	248.91	96990.0
2020-04-01 04:45:00	SPY	ETF	248.92	249.44	248.85	249.44	2639.0
2020-04-01 04:50:00	SPY	ETF	249.57	249.57	249.09	249.09	6905.0
2020-04-01 04:55:00	SPY	ETF	249.09	249.85	249.09	249.7	26149.0
2020-04-01 05:00:00	SPY	ETF	249.7	250.13	249.68	249.87	33955.0
2020-04-01 05:05:00	SPY	ETF	249.89	250.45	249.89	250.45	29331.0
2020-04-01 05:10:00	SPY	ETF	250.45	250.76	250.17	250.2	20538.0
2020-04-01 05:15:00	SPY	ETF	250.26	250.26	249.5	249.69	9218.0
2020-04-01 05:20:00	SPY	ETF	249.56	249.9	249.15	249.9	24201.0
2020-04-01 05:25:00	SPY	ETF	249.87	250.11	249.79	250.05	5319.0
2020-04-01 05:30:00	SPY	ETF	250.1	250.25	249.83	250.2	9626.0
2020-04-01 05:35:00	SPY	ETF	250.28	250.28	249.95	249.95	2984.0
2020-04-01 05:40:00	SPY	ETF	249.88	250.35	249.88	250.2	7125.0
2020-04-01 05:45:00	SPY	ETF	250.22	250.39	249.87	250.39	4518.0
2020-04-01 05:50:00	SPY	ETF	250.25	250.66	250.25	250.66	3332.0
2020-04-01 05:55:00	SPY	ETF	250.55	250.61	250.17	250.3	4485.0
2020-04-01 06:00:00	SPY	ETF	250.25	250.81	250.25	250.7	8536.0
2020-04-01 06:05:00	SPY	ETF	250.79	251.01	250.45	250.45	14853.0
2020-04-01 06:10:00	SPY	ETF	250.32	250.57	250.0	250.0	18730.0
2020-04-01 06:15:00	SPY	ETF	250.0	250.53	250.0	250.53	6132.0
2020-04-01 06:20:00	SPY	ETF	250.33	250.33	249.49	249.49	28974.0
2020-04-01 06:25:00	SPY	ETF	249.5	249.81	249.48	249.78	36521.0
2020-04-01 06:30:00	SPY	ETF	249.82	250.12	249.78	250.1	35887.0
2020-04-01 06:35:00	SPY	ETF	250.18	250.22	249.98	250.06	7454.0
2020-04-01 06:40:00	SPY	ETF	250.0	250.0	249.2	249.2	29968.0
2020-04-01 06:45:00	SPY	ETF	249.2	249.74	249.2	249.41	57546.0
2020-04-01 06:50:00	SPY	ETF	249.53	249.53	249.06	249.07	19321.0
2020-04-01 06:55:00	SPY	ETF	249.11	249.52	248.95	249.4	62332.0
2020-04-01 07:00:00	SPY	ETF	249.46	249.67	248.64	248.64	86522.0
2020-04-01 07:05:00	SPY	ETF	248.72	248.91	248.5	248.5	37970.0
2020-04-01 07:10:00	SPY	ETF	248.5	248.97	248.37	248.95	52638.0
2020-04-01 07:15:00	SPY	ETF	248.97	249.15	248.76	248.99	39300.0
2020-04-01 07:20:00	SPY	ETF	249.03	249.25	248.65	249.0	89207.0
2020-04-01 07:25:00	SPY	ETF	249.06	249.12	248.81	249.12	48631.0
2020-04-01 07:30:00	SPY	ETF	249.1	249.65	249.09	249.45	120400.0
2020-04-01 07:35:00	SPY	ETF	249.45	249.69	249.24	249.55	85766.0
2020-04-01 07:40:00	SPY	ETF	249.55	249.55	249.2	249.21	108090.0
2020-04-01 07:45:00	SPY	ETF	249.21	249.24	248.88	248.95	112343.0
2020-04-01 07:50:00	SPY	ETF	248.95	249.08	248.76	248.77	78250.0
2020-04-01 07:55:00	SPY	ETF	248.76	248.86	248.7	248.75	36666.0
2020-04-01 08:00:00	SPY	ETF	248.74	253.28	248.02	248.05	358151.0
2020-04-01 08:05:00	SPY	ETF	248.02	248.25	247.7	247.98	196979.0

> showing 50 of 80,490 rows — these rows as CSV

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