PREVIEW / etf_5min / 2020-03-03

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-03.parquet
  size:    1.9 MB
  rows:    83,172

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-03-03 04:00:00	SPY	ETF	308.71	308.71	308.2	308.2	8927.0
2020-03-03 04:05:00	SPY	ETF	308.18	308.56	308.18	308.54	16722.0
2020-03-03 04:10:00	SPY	ETF	308.54	309.1	308.54	309.1	15092.0
2020-03-03 04:15:00	SPY	ETF	309.11	309.36	309.0	309.29	11819.0
2020-03-03 04:20:00	SPY	ETF	309.26	309.47	308.91	308.91	5585.0
2020-03-03 04:25:00	SPY	ETF	308.86	308.86	308.7	308.76	3350.0
2020-03-03 04:30:00	SPY	ETF	308.56	309.32	308.53	309.22	5689.0
2020-03-03 04:35:00	SPY	ETF	309.18	309.34	308.99	309.17	10194.0
2020-03-03 04:40:00	SPY	ETF	309.33	309.6	309.33	309.47	6374.0
2020-03-03 04:45:00	SPY	ETF	309.41	309.91	309.4	309.91	6804.0
2020-03-03 04:50:00	SPY	ETF	309.96	310.0	309.74	309.74	5725.0
2020-03-03 04:55:00	SPY	ETF	309.71	309.75	309.39	309.75	25393.0
2020-03-03 05:00:00	SPY	ETF	310.09	310.1	309.95	309.99	5858.0
2020-03-03 05:05:00	SPY	ETF	310.0	310.09	309.33	309.33	4535.0
2020-03-03 05:10:00	SPY	ETF	309.59	309.59	309.19	309.2	2308.0
2020-03-03 05:15:00	SPY	ETF	309.39	309.79	309.39	309.79	221.0
2020-03-03 05:20:00	SPY	ETF	309.52	309.77	309.5	309.77	690.0
2020-03-03 05:25:00	SPY	ETF	309.75	309.87	309.75	309.83	770.0
2020-03-03 05:30:00	SPY	ETF	309.66	309.88	309.66	309.8	5305.0
2020-03-03 05:35:00	SPY	ETF	309.4	309.53	309.2	309.53	8688.0
2020-03-03 05:40:00	SPY	ETF	309.53	309.53	309.21	309.3	3795.0
2020-03-03 05:45:00	SPY	ETF	309.3	309.56	309.23	309.28	11857.0
2020-03-03 05:50:00	SPY	ETF	309.33	309.61	309.25	309.6	5059.0
2020-03-03 05:55:00	SPY	ETF	309.56	309.56	309.36	309.38	9733.0
2020-03-03 06:00:00	SPY	ETF	309.52	309.52	308.88	309.06	6538.0
2020-03-03 06:05:00	SPY	ETF	309.06	309.2	308.12	308.5	23276.0
2020-03-03 06:10:00	SPY	ETF	308.45	308.47	307.77	308.29	16892.0
2020-03-03 06:15:00	SPY	ETF	308.12	308.46	308.01	308.46	12585.0
2020-03-03 06:20:00	SPY	ETF	308.44	308.69	308.15	308.16	17392.0
2020-03-03 06:25:00	SPY	ETF	308.01	308.04	307.57	307.91	22691.0
2020-03-03 06:30:00	SPY	ETF	307.9	308.47	307.9	308.3	29572.0
2020-03-03 06:35:00	SPY	ETF	308.21	308.44	308.0	308.0	10302.0
2020-03-03 06:40:00	SPY	ETF	308.11	308.11	307.7	307.99	24957.0
2020-03-03 06:45:00	SPY	ETF	308.0	308.18	307.78	307.96	8358.0
2020-03-03 06:50:00	SPY	ETF	308.0	308.09	307.89	307.89	66392.0
2020-03-03 06:55:00	SPY	ETF	307.92	308.0	307.62	307.98	45284.0
2020-03-03 07:00:00	SPY	ETF	307.8	308.41	307.7	308.41	124119.0
2020-03-03 07:05:00	SPY	ETF	308.43	308.52	307.83	308.5	64805.0
2020-03-03 07:10:00	SPY	ETF	308.46	308.97	308.33	308.83	75970.0
2020-03-03 07:15:00	SPY	ETF	308.76	308.9	308.59	308.86	44662.0
2020-03-03 07:20:00	SPY	ETF	308.75	308.96	308.5	308.8	80489.0
2020-03-03 07:25:00	SPY	ETF	308.85	309.1	308.64	309.03	95182.0
2020-03-03 07:30:00	SPY	ETF	309.0	309.78	308.44	308.92	234147.0
2020-03-03 07:35:00	SPY	ETF	308.87	308.87	306.4	307.18	401036.0
2020-03-03 07:40:00	SPY	ETF	307.1	307.81	305.99	306.23	277778.0
2020-03-03 07:45:00	SPY	ETF	306.18	306.4	305.35	305.89	453551.0
2020-03-03 07:50:00	SPY	ETF	306.03	306.72	305.99	306.24	262802.0
2020-03-03 07:55:00	SPY	ETF	306.11	307.32	305.68	306.76	170615.0
2020-03-03 08:00:00	SPY	ETF	306.73	310.0	304.8	305.85	204981.0
2020-03-03 08:05:00	SPY	ETF	305.96	309.0	305.3	305.99	381014.0

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

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