PREVIEW / etf_1min / 2020-06-24

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-06-24.parquet
  size:    4.2 MB
  rows:    228,401

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-06-24 04:00:00	SPY	ETF	310.71	310.81	310.68	310.7	7782.0
2020-06-24 04:01:00	SPY	ETF	310.73	310.76	310.5	310.58	3581.0
2020-06-24 04:02:00	SPY	ETF	310.62	310.67	310.5	310.52	3059.0
2020-06-24 04:03:00	SPY	ETF	310.44	310.7	310.44	310.7	1953.0
2020-06-24 04:05:00	SPY	ETF	310.6	310.72	310.6	310.72	1230.0
2020-06-24 04:06:00	SPY	ETF	310.45	310.45	310.33	310.33	2455.0
2020-06-24 04:07:00	SPY	ETF	310.32	310.32	310.24	310.24	830.0
2020-06-24 04:08:00	SPY	ETF	310.13	310.13	309.85	309.87	4296.0
2020-06-24 04:09:00	SPY	ETF	309.84	309.84	309.6	309.6	8308.0
2020-06-24 04:10:00	SPY	ETF	309.73	309.76	309.57	309.57	5207.0
2020-06-24 04:11:00	SPY	ETF	309.57	309.71	309.55	309.62	5232.0
2020-06-24 04:12:00	SPY	ETF	309.51	309.53	309.32	309.33	5891.0
2020-06-24 04:13:00	SPY	ETF	309.34	309.34	309.34	309.34	118.0
2020-06-24 04:14:00	SPY	ETF	309.32	309.38	309.27	309.27	5313.0
2020-06-24 04:15:00	SPY	ETF	309.2	309.2	308.91	308.96	10213.0
2020-06-24 04:16:00	SPY	ETF	308.95	308.95	308.74	308.76	10995.0
2020-06-24 04:17:00	SPY	ETF	308.81	308.97	308.81	308.92	3392.0
2020-06-24 04:18:00	SPY	ETF	308.9	309.25	308.9	309.25	6732.0
2020-06-24 04:19:00	SPY	ETF	309.3	309.39	309.18	309.19	1514.0
2020-06-24 04:20:00	SPY	ETF	309.07	309.07	308.82	308.82	3386.0
2020-06-24 04:21:00	SPY	ETF	308.85	309.24	308.85	309.24	2170.0
2020-06-24 04:22:00	SPY	ETF	309.39	309.39	309.39	309.39	2825.0
2020-06-24 04:23:00	SPY	ETF	309.39	309.39	309.22	309.22	817.0
2020-06-24 04:24:00	SPY	ETF	309.36	309.36	309.36	309.36	250.0
2020-06-24 04:25:00	SPY	ETF	309.42	309.47	309.31	309.44	2568.0
2020-06-24 04:26:00	SPY	ETF	309.47	309.47	309.47	309.47	442.0
2020-06-24 04:27:00	SPY	ETF	309.43	309.46	309.43	309.43	505.0
2020-06-24 04:28:00	SPY	ETF	309.46	309.46	309.43	309.43	602.0
2020-06-24 04:29:00	SPY	ETF	309.4	309.4	309.38	309.38	482.0
2020-06-24 04:30:00	SPY	ETF	309.43	309.43	309.29	309.29	1200.0
2020-06-24 04:33:00	SPY	ETF	309.31	309.35	309.31	309.35	440.0
2020-06-24 04:34:00	SPY	ETF	309.35	309.5	309.35	309.5	722.0
2020-06-24 04:35:00	SPY	ETF	309.48	309.48	309.48	309.48	130.0
2020-06-24 04:36:00	SPY	ETF	309.58	309.58	309.58	309.58	245.0
2020-06-24 04:39:00	SPY	ETF	309.56	309.57	309.56	309.57	331.0
2020-06-24 04:40:00	SPY	ETF	309.46	309.49	309.46	309.49	1600.0
2020-06-24 04:41:00	SPY	ETF	309.48	309.48	309.48	309.48	221.0
2020-06-24 04:42:00	SPY	ETF	309.53	309.53	309.42	309.42	7000.0
2020-06-24 04:45:00	SPY	ETF	309.57	309.57	309.57	309.57	378.0
2020-06-24 04:46:00	SPY	ETF	309.6	309.73	309.6	309.67	3510.0
2020-06-24 04:47:00	SPY	ETF	309.68	309.68	309.68	309.68	100.0
2020-06-24 04:48:00	SPY	ETF	309.65	309.68	309.63	309.68	322.0
2020-06-24 04:50:00	SPY	ETF	309.73	309.73	309.73	309.73	166.0
2020-06-24 04:51:00	SPY	ETF	309.83	309.9	309.83	309.86	1096.0
2020-06-24 04:52:00	SPY	ETF	309.83	309.94	309.83	309.94	3228.0
2020-06-24 04:53:00	SPY	ETF	309.88	309.88	309.73	309.78	2910.0
2020-06-24 04:54:00	SPY	ETF	309.78	309.78	309.78	309.78	622.0
2020-06-24 04:59:00	SPY	ETF	309.75	309.83	309.75	309.81	1910.0
2020-06-24 05:01:00	SPY	ETF	309.84	309.97	309.84	309.96	1320.0
2020-06-24 05:02:00	SPY	ETF	310.0	310.13	310.0	310.13	530.0

> showing 50 of 228,401 rows — these rows as CSV

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