PREVIEW / etf_1min / 2020-08-20

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-20.parquet
  size:    3.5 MB
  rows:    194,067

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-08-20 04:00:00	SPY	ETF	336.54	336.54	336.26	336.26	1412.0
2020-08-20 04:03:00	SPY	ETF	336.1	336.1	336.1	336.1	649.0
2020-08-20 04:04:00	SPY	ETF	336.1	336.1	336.1	336.1	187.0
2020-08-20 04:05:00	SPY	ETF	336.1	336.1	336.1	336.1	102.0
2020-08-20 04:06:00	SPY	ETF	336.02	336.02	335.9	335.9	1141.0
2020-08-20 04:09:00	SPY	ETF	336.05	336.05	336.05	336.05	302.0
2020-08-20 04:10:00	SPY	ETF	336.04	336.04	336.04	336.04	225.0
2020-08-20 04:11:00	SPY	ETF	336.05	336.05	336.05	336.05	161.0
2020-08-20 04:15:00	SPY	ETF	335.75	335.75	335.75	335.75	1181.0
2020-08-20 04:16:00	SPY	ETF	335.76	335.76	335.58	335.6	665.0
2020-08-20 04:18:00	SPY	ETF	335.55	335.55	335.53	335.53	218.0
2020-08-20 04:19:00	SPY	ETF	335.55	335.55	335.35	335.35	6166.0
2020-08-20 04:20:00	SPY	ETF	335.4	335.4	335.4	335.4	639.0
2020-08-20 04:22:00	SPY	ETF	335.3	335.3	335.27	335.27	849.0
2020-08-20 04:23:00	SPY	ETF	335.34	335.34	335.34	335.34	336.0
2020-08-20 04:24:00	SPY	ETF	335.3	335.3	335.25	335.29	1718.0
2020-08-20 04:25:00	SPY	ETF	335.13	335.13	335.07	335.07	2577.0
2020-08-20 04:26:00	SPY	ETF	335.19	335.2	335.13	335.2	5803.0
2020-08-20 04:27:00	SPY	ETF	335.23	335.23	335.23	335.23	1100.0
2020-08-20 04:28:00	SPY	ETF	335.19	335.19	335.19	335.19	511.0
2020-08-20 04:29:00	SPY	ETF	335.27	335.27	335.27	335.27	2605.0
2020-08-20 04:30:00	SPY	ETF	335.2	335.2	335.15	335.15	1087.0
2020-08-20 04:31:00	SPY	ETF	335.17	335.27	335.17	335.23	4252.0
2020-08-20 04:32:00	SPY	ETF	335.13	335.13	335.13	335.13	167.0
2020-08-20 04:34:00	SPY	ETF	335.2	335.2	335.2	335.2	293.0
2020-08-20 04:35:00	SPY	ETF	335.08	335.08	335.03	335.03	426.0
2020-08-20 04:36:00	SPY	ETF	335.32	335.32	335.32	335.32	611.0
2020-08-20 04:37:00	SPY	ETF	335.33	335.39	335.33	335.39	312.0
2020-08-20 04:38:00	SPY	ETF	335.48	335.48	335.48	335.48	704.0
2020-08-20 04:43:00	SPY	ETF	335.47	335.47	335.47	335.47	200.0
2020-08-20 04:45:00	SPY	ETF	335.49	335.49	335.49	335.49	147.0
2020-08-20 04:47:00	SPY	ETF	335.65	335.66	335.64	335.65	2700.0
2020-08-20 04:48:00	SPY	ETF	335.63	335.63	335.62	335.62	720.0
2020-08-20 04:51:00	SPY	ETF	335.58	335.6	335.58	335.6	1502.0
2020-08-20 04:53:00	SPY	ETF	335.88	335.88	335.88	335.88	527.0
2020-08-20 04:54:00	SPY	ETF	335.83	335.88	335.82	335.86	1701.0
2020-08-20 04:56:00	SPY	ETF	335.95	335.97	335.95	335.95	1064.0
2020-08-20 04:57:00	SPY	ETF	335.94	336.07	335.94	336.07	570.0
2020-08-20 05:00:00	SPY	ETF	335.91	335.95	335.91	335.95	401.0
2020-08-20 05:02:00	SPY	ETF	336.0	336.02	336.0	336.01	2957.0
2020-08-20 05:03:00	SPY	ETF	335.96	335.96	335.96	335.96	1818.0
2020-08-20 05:04:00	SPY	ETF	335.96	335.96	335.96	335.96	116.0
2020-08-20 05:05:00	SPY	ETF	336.1	336.1	336.1	336.1	650.0
2020-08-20 05:06:00	SPY	ETF	336.01	336.08	336.01	336.08	261.0
2020-08-20 05:07:00	SPY	ETF	336.08	336.08	336.08	336.08	300.0
2020-08-20 05:09:00	SPY	ETF	336.09	336.09	336.09	336.09	500.0
2020-08-20 05:10:00	SPY	ETF	336.1	336.1	336.1	336.1	196.0
2020-08-20 05:11:00	SPY	ETF	336.12	336.15	336.12	336.12	3000.0
2020-08-20 05:13:00	SPY	ETF	336.09	336.09	336.09	336.09	505.0
2020-08-20 05:18:00	SPY	ETF	335.9	335.93	335.9	335.93	1011.0

> showing 50 of 194,067 rows — these rows as CSV

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