PREVIEW / etf_5min / 2021-05-27

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-05-27.parquet
  size:    1.7 MB
  rows:    79,467

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
2021-05-27 04:00:00	SPY	ETF	418.11	418.35	418.1	418.35	6400.0
2021-05-27 04:05:00	SPY	ETF	418.35	418.38	418.27	418.35	2700.0
2021-05-27 04:10:00	SPY	ETF	418.31	418.35	418.31	418.35	550.0
2021-05-27 04:15:00	SPY	ETF	418.34	418.34	418.24	418.25	800.0
2021-05-27 04:20:00	SPY	ETF	418.34	418.37	418.34	418.37	483.0
2021-05-27 04:25:00	SPY	ETF	418.38	418.38	418.35	418.35	350.0
2021-05-27 04:30:00	SPY	ETF	418.29	418.29	418.29	418.29	399.0
2021-05-27 04:35:00	SPY	ETF	418.22	418.22	418.17	418.17	400.0
2021-05-27 04:40:00	SPY	ETF	418.19	418.19	418.17	418.18	4100.0
2021-05-27 04:45:00	SPY	ETF	418.12	418.12	417.99	417.99	1471.0
2021-05-27 04:50:00	SPY	ETF	418.05	418.05	417.88	417.88	1495.0
2021-05-27 04:55:00	SPY	ETF	417.84	417.97	417.81	417.97	2699.0
2021-05-27 05:00:00	SPY	ETF	417.97	418.0	417.9	417.9	800.0
2021-05-27 05:05:00	SPY	ETF	417.9	417.97	417.89	417.94	2028.0
2021-05-27 05:10:00	SPY	ETF	417.94	418.06	417.94	418.04	1118.0
2021-05-27 05:15:00	SPY	ETF	418.05	418.09	418.05	418.09	400.0
2021-05-27 05:20:00	SPY	ETF	418.07	418.07	417.96	417.98	2621.0
2021-05-27 05:25:00	SPY	ETF	417.96	417.96	417.87	417.87	800.0
2021-05-27 05:30:00	SPY	ETF	417.91	417.99	417.91	417.98	1850.0
2021-05-27 05:35:00	SPY	ETF	417.98	418.03	417.98	418.03	500.0
2021-05-27 05:40:00	SPY	ETF	417.91	417.91	417.89	417.89	800.0
2021-05-27 05:45:00	SPY	ETF	417.83	417.83	417.83	417.83	200.0
2021-05-27 05:50:00	SPY	ETF	417.89	417.97	417.89	417.97	1457.0
2021-05-27 05:55:00	SPY	ETF	417.9	417.9	417.9	417.9	100.0
2021-05-27 06:00:00	SPY	ETF	417.81	417.81	417.69	417.76	1371.0
2021-05-27 06:05:00	SPY	ETF	417.89	417.89	417.89	417.89	370.0
2021-05-27 06:15:00	SPY	ETF	418.02	418.14	418.02	418.11	14220.0
2021-05-27 06:20:00	SPY	ETF	418.14	418.14	418.03	418.03	798.0
2021-05-27 06:25:00	SPY	ETF	418.04	418.04	417.99	417.99	3803.0
2021-05-27 06:30:00	SPY	ETF	418.04	418.04	418.02	418.02	4978.0
2021-05-27 06:35:00	SPY	ETF	418.04	418.1	418.04	418.09	2317.0
2021-05-27 06:40:00	SPY	ETF	418.12	418.16	418.06	418.16	878.0
2021-05-27 06:45:00	SPY	ETF	418.19	418.19	418.19	418.19	169.0
2021-05-27 06:50:00	SPY	ETF	418.2	418.2	418.16	418.16	300.0
2021-05-27 06:55:00	SPY	ETF	418.17	418.2	418.13	418.18	4500.0
2021-05-27 07:00:00	SPY	ETF	418.18	418.31	418.16	418.31	8999.0
2021-05-27 07:05:00	SPY	ETF	418.34	418.34	418.23	418.27	10932.0
2021-05-27 07:10:00	SPY	ETF	418.25	418.28	418.2	418.27	1600.0
2021-05-27 07:15:00	SPY	ETF	418.27	418.39	418.27	418.34	3917.0
2021-05-27 07:20:00	SPY	ETF	418.37	418.37	418.33	418.35	9100.0
2021-05-27 07:25:00	SPY	ETF	418.37	418.37	418.25	418.26	4509.0
2021-05-27 07:30:00	SPY	ETF	418.25	418.26	418.2	418.22	1806.0
2021-05-27 07:35:00	SPY	ETF	418.25	418.28	418.12	418.12	9730.0
2021-05-27 07:40:00	SPY	ETF	418.11	418.18	418.0	418.1	31872.0
2021-05-27 07:45:00	SPY	ETF	418.14	418.22	418.14	418.22	7777.0
2021-05-27 07:50:00	SPY	ETF	418.28	418.38	418.24	418.38	4988.0
2021-05-27 07:55:00	SPY	ETF	418.39	418.79	418.39	418.76	24727.0
2021-05-27 08:00:00	SPY	ETF	418.16	419.55	418.0	418.9	134111.0
2021-05-27 08:05:00	SPY	ETF	418.88	419.09	418.63	418.66	69778.0
2021-05-27 08:10:00	SPY	ETF	418.63	418.81	418.59	418.72	25317.0

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

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