PREVIEW / etf_5min / 2020-04-22

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-22.parquet
  size:    1.6 MB
  rows:    73,811

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-22 04:00:00	SPY	ETF	275.77	275.87	275.6	275.65	18928.0
2020-04-22 04:05:00	SPY	ETF	275.8	276.13	275.8	276.13	11429.0
2020-04-22 04:10:00	SPY	ETF	276.18	276.52	276.13	276.48	5391.0
2020-04-22 04:15:00	SPY	ETF	276.46	276.7	276.46	276.69	18254.0
2020-04-22 04:20:00	SPY	ETF	276.75	276.77	276.52	276.52	4152.0
2020-04-22 04:25:00	SPY	ETF	276.81	277.0	276.7	276.7	9030.0
2020-04-22 04:30:00	SPY	ETF	276.69	276.76	276.68	276.69	2622.0
2020-04-22 04:35:00	SPY	ETF	276.86	277.1	276.86	277.05	26170.0
2020-04-22 04:40:00	SPY	ETF	277.09	277.28	277.0	277.03	26923.0
2020-04-22 04:45:00	SPY	ETF	277.0	277.0	276.76	276.86	21209.0
2020-04-22 04:50:00	SPY	ETF	276.86	277.24	276.86	277.24	32910.0
2020-04-22 04:55:00	SPY	ETF	277.47	277.5	277.38	277.47	2767.0
2020-04-22 05:00:00	SPY	ETF	277.57	277.57	277.32	277.32	7555.0
2020-04-22 05:05:00	SPY	ETF	277.37	277.47	277.25	277.25	2051.0
2020-04-22 05:10:00	SPY	ETF	277.6	277.82	277.6	277.71	51906.0
2020-04-22 05:15:00	SPY	ETF	277.75	277.91	277.75	277.9	35192.0
2020-04-22 05:20:00	SPY	ETF	277.57	277.66	277.46	277.54	1805.0
2020-04-22 05:25:00	SPY	ETF	277.49	277.69	277.48	277.52	1755.0
2020-04-22 05:30:00	SPY	ETF	277.61	277.61	276.99	277.0	24610.0
2020-04-22 05:35:00	SPY	ETF	277.05	277.05	277.0	277.04	1277.0
2020-04-22 05:40:00	SPY	ETF	277.1	277.33	277.1	277.33	878.0
2020-04-22 05:45:00	SPY	ETF	277.16	277.17	277.06	277.1	3340.0
2020-04-22 05:50:00	SPY	ETF	277.04	277.2	276.97	277.12	2197.0
2020-04-22 05:55:00	SPY	ETF	277.2	277.3	277.17	277.17	6700.0
2020-04-22 06:00:00	SPY	ETF	277.3	277.3	276.8	276.8	23398.0
2020-04-22 06:05:00	SPY	ETF	276.83	276.83	276.7	276.7	3489.0
2020-04-22 06:10:00	SPY	ETF	276.73	276.93	276.63	276.9	6281.0
2020-04-22 06:15:00	SPY	ETF	276.88	276.88	276.53	276.56	11571.0
2020-04-22 06:20:00	SPY	ETF	276.6	276.66	276.43	276.43	4225.0
2020-04-22 06:25:00	SPY	ETF	276.71	276.71	276.43	276.43	1835.0
2020-04-22 06:30:00	SPY	ETF	276.53	276.73	276.52	276.73	3321.0
2020-04-22 06:35:00	SPY	ETF	276.79	276.79	276.3	276.42	12610.0
2020-04-22 06:40:00	SPY	ETF	276.49	276.49	276.2	276.21	7116.0
2020-04-22 06:45:00	SPY	ETF	276.36	276.5	276.28	276.44	3460.0
2020-04-22 06:50:00	SPY	ETF	276.41	276.41	276.11	276.35	3395.0
2020-04-22 06:55:00	SPY	ETF	276.24	276.62	276.16	276.58	13767.0
2020-04-22 07:00:00	SPY	ETF	276.66	276.76	276.59	276.61	29960.0
2020-04-22 07:05:00	SPY	ETF	276.67	276.85	276.67	276.83	20953.0
2020-04-22 07:10:00	SPY	ETF	276.84	277.22	276.71	277.19	89898.0
2020-04-22 07:15:00	SPY	ETF	277.26	277.45	277.09	277.13	27046.0
2020-04-22 07:20:00	SPY	ETF	277.15	277.15	276.84	276.86	26371.0
2020-04-22 07:25:00	SPY	ETF	276.9	277.14	276.75	276.83	21093.0
2020-04-22 07:30:00	SPY	ETF	276.84	277.05	276.84	276.87	78671.0
2020-04-22 07:35:00	SPY	ETF	277.0	277.03	276.43	276.43	134101.0
2020-04-22 07:40:00	SPY	ETF	276.46	276.65	276.41	276.59	145659.0
2020-04-22 07:45:00	SPY	ETF	276.62	276.63	276.3	276.48	78802.0
2020-04-22 07:50:00	SPY	ETF	276.46	276.81	276.42	276.81	21980.0
2020-04-22 07:55:00	SPY	ETF	276.74	277.03	276.72	276.95	59048.0
2020-04-22 08:00:00	SPY	ETF	274.07	277.3004	273.29	276.5578	1431543.0
2020-04-22 08:05:00	SPY	ETF	276.56	276.68	276.02	276.04	90486.0

> showing 50 of 73,811 rows — these rows as CSV

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