PREVIEW / etf_5min / 2021-09-14

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-09-14.parquet
  size:    1.7 MB
  rows:    80,631

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-09-14 04:00:00	SPY	ETF	446.84	447.0	446.61	446.69	27699.0
2021-09-14 04:05:00	SPY	ETF	446.76	446.77	446.64	446.69	1905.0
2021-09-14 04:10:00	SPY	ETF	446.8	446.8	446.7	446.7	351.0
2021-09-14 04:15:00	SPY	ETF	446.68	446.68	446.35	446.35	3078.0
2021-09-14 04:20:00	SPY	ETF	446.38	446.63	446.38	446.6	5603.0
2021-09-14 04:25:00	SPY	ETF	446.68	446.99	446.65	446.99	2199.0
2021-09-14 04:30:00	SPY	ETF	446.98	447.05	446.98	447.05	300.0
2021-09-14 04:35:00	SPY	ETF	447.27	447.35	447.24	447.35	2084.0
2021-09-14 04:40:00	SPY	ETF	447.32	447.32	447.32	447.32	100.0
2021-09-14 04:45:00	SPY	ETF	447.32	447.32	447.2	447.2	1000.0
2021-09-14 04:50:00	SPY	ETF	447.12	447.12	447.12	447.12	300.0
2021-09-14 05:00:00	SPY	ETF	447.25	447.25	447.17	447.17	200.0
2021-09-14 05:05:00	SPY	ETF	447.15	447.15	447.15	447.15	100.0
2021-09-14 05:10:00	SPY	ETF	447.27	447.36	447.27	447.36	1200.0
2021-09-14 05:25:00	SPY	ETF	447.2	447.21	447.17	447.17	900.0
2021-09-14 05:30:00	SPY	ETF	447.12	447.15	447.12	447.15	551.0
2021-09-14 05:35:00	SPY	ETF	447.16	447.16	447.11	447.12	1200.0
2021-09-14 05:40:00	SPY	ETF	447.03	447.03	446.93	446.98	900.0
2021-09-14 05:50:00	SPY	ETF	446.86	446.88	446.81	446.81	1025.0
2021-09-14 05:55:00	SPY	ETF	446.78	446.82	446.75	446.77	2200.0
2021-09-14 06:00:00	SPY	ETF	446.69	446.78	446.65	446.78	5105.0
2021-09-14 06:05:00	SPY	ETF	446.86	446.88	446.85	446.85	363.0
2021-09-14 06:10:00	SPY	ETF	446.93	447.03	446.93	447.03	1175.0
2021-09-14 06:15:00	SPY	ETF	447.14	447.15	447.14	447.15	451.0
2021-09-14 06:20:00	SPY	ETF	447.05	447.07	447.05	447.06	600.0
2021-09-14 06:25:00	SPY	ETF	447.03	447.13	447.03	447.11	6052.0
2021-09-14 06:35:00	SPY	ETF	447.15	447.16	447.15	447.16	300.0
2021-09-14 06:40:00	SPY	ETF	447.12	447.12	447.12	447.12	100.0
2021-09-14 06:50:00	SPY	ETF	446.97	447.0	446.9	446.9	3400.0
2021-09-14 06:55:00	SPY	ETF	446.84	446.86	446.76	446.76	51711.0
2021-09-14 07:00:00	SPY	ETF	446.95	446.97	446.9	446.94	17795.0
2021-09-14 07:05:00	SPY	ETF	446.94	446.97	446.8	446.8	55504.0
2021-09-14 07:10:00	SPY	ETF	446.81	446.83	446.78	446.79	26126.0
2021-09-14 07:15:00	SPY	ETF	446.79	446.82	446.75	446.78	28330.0
2021-09-14 07:20:00	SPY	ETF	446.8	446.81	446.75	446.75	7502.0
2021-09-14 07:25:00	SPY	ETF	446.77	446.78	446.68	446.68	2760.0
2021-09-14 07:30:00	SPY	ETF	446.65	446.86	446.65	446.83	8140.0
2021-09-14 07:35:00	SPY	ETF	446.83	446.87	446.76	446.76	24910.0
2021-09-14 07:40:00	SPY	ETF	446.75	446.85	446.61	446.61	9481.0
2021-09-14 07:45:00	SPY	ETF	446.62	446.62	446.3	446.34	58781.0
2021-09-14 07:50:00	SPY	ETF	446.25	446.25	445.78	445.95	33155.0
2021-09-14 07:55:00	SPY	ETF	445.94	446.12	445.85	446.05	65879.0
2021-09-14 08:00:00	SPY	ETF	446.94	447.23	445.78	446.23	56600.0
2021-09-14 08:05:00	SPY	ETF	446.17	446.26	446.07	446.15	23529.0
2021-09-14 08:10:00	SPY	ETF	446.12	446.19	445.99	446.1501	20425.0
2021-09-14 08:15:00	SPY	ETF	446.19	446.34	446.19	446.25	94191.0
2021-09-14 08:20:00	SPY	ETF	446.27	446.31	446.26	446.29	11579.0
2021-09-14 08:25:00	SPY	ETF	446.27	446.39	446.22	446.39	13535.0
2021-09-14 08:30:00	SPY	ETF	446.3	448.27	446.3	448.09	491853.0
2021-09-14 08:35:00	SPY	ETF	448.15	448.59	448.11	448.12	304312.0

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

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