PREVIEW / etf_1min / 2020-08-07

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-07.parquet
  size:    3.8 MB
  rows:    206,656

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-07 04:00:00	SPY	ETF	334.02	334.02	334.02	334.02	1178.0
2020-08-07 04:02:00	SPY	ETF	333.93	333.93	333.93	333.93	525.0
2020-08-07 04:03:00	SPY	ETF	333.9	333.9	333.9	333.9	200.0
2020-08-07 04:05:00	SPY	ETF	333.82	333.82	333.65	333.65	886.0
2020-08-07 04:06:00	SPY	ETF	333.8	333.8	333.79	333.79	500.0
2020-08-07 04:07:00	SPY	ETF	333.66	333.71	333.66	333.71	1300.0
2020-08-07 04:08:00	SPY	ETF	333.62	333.62	333.62	333.62	1015.0
2020-08-07 04:09:00	SPY	ETF	333.63	333.63	333.61	333.61	520.0
2020-08-07 04:10:00	SPY	ETF	333.55	333.55	333.55	333.55	155.0
2020-08-07 04:12:00	SPY	ETF	333.6	333.6	333.6	333.6	1035.0
2020-08-07 04:13:00	SPY	ETF	333.6	333.6	333.6	333.6	2115.0
2020-08-07 04:19:00	SPY	ETF	333.63	333.63	333.63	333.63	1055.0
2020-08-07 04:22:00	SPY	ETF	333.5	333.5	333.5	333.5	200.0
2020-08-07 04:23:00	SPY	ETF	333.42	333.42	333.42	333.42	100.0
2020-08-07 04:27:00	SPY	ETF	333.3	333.3	333.3	333.3	125.0
2020-08-07 04:28:00	SPY	ETF	333.33	333.33	333.33	333.33	1000.0
2020-08-07 04:29:00	SPY	ETF	333.33	333.33	333.3	333.3	1200.0
2020-08-07 04:30:00	SPY	ETF	333.25	333.4	333.25	333.4	717.0
2020-08-07 04:31:00	SPY	ETF	333.28	333.28	333.28	333.28	300.0
2020-08-07 04:32:00	SPY	ETF	333.22	333.22	333.22	333.22	150.0
2020-08-07 04:33:00	SPY	ETF	333.21	333.21	333.21	333.21	237.0
2020-08-07 04:34:00	SPY	ETF	333.2	333.22	333.2	333.22	1200.0
2020-08-07 04:37:00	SPY	ETF	333.25	333.25	333.12	333.15	2550.0
2020-08-07 04:40:00	SPY	ETF	333.1	333.1	333.05	333.05	4610.0
2020-08-07 04:46:00	SPY	ETF	333.15	333.15	333.15	333.15	235.0
2020-08-07 04:47:00	SPY	ETF	333.1	333.1	333.1	333.1	527.0
2020-08-07 04:50:00	SPY	ETF	333.25	333.25	333.25	333.25	200.0
2020-08-07 04:54:00	SPY	ETF	333.25	333.25	333.25	333.25	115.0
2020-08-07 04:59:00	SPY	ETF	333.26	333.28	333.26	333.26	309.0
2020-08-07 05:01:00	SPY	ETF	333.22	333.22	333.11	333.11	421.0
2020-08-07 05:03:00	SPY	ETF	333.02	333.02	333.01	333.02	910.0
2020-08-07 05:04:00	SPY	ETF	333.0	333.0	332.93	332.93	1274.0
2020-08-07 05:05:00	SPY	ETF	332.88	332.88	332.73	332.75	5543.0
2020-08-07 05:08:00	SPY	ETF	332.9	332.91	332.9	332.91	200.0
2020-08-07 05:10:00	SPY	ETF	332.81	332.81	332.81	332.81	120.0
2020-08-07 05:11:00	SPY	ETF	332.85	332.85	332.85	332.85	240.0
2020-08-07 05:12:00	SPY	ETF	332.85	332.85	332.85	332.85	213.0
2020-08-07 05:13:00	SPY	ETF	332.72	332.72	332.68	332.68	350.0
2020-08-07 05:14:00	SPY	ETF	332.7	332.7	332.63	332.65	405.0
2020-08-07 05:15:00	SPY	ETF	332.46	332.58	332.46	332.58	1571.0
2020-08-07 05:16:00	SPY	ETF	332.7	332.7	332.7	332.7	185.0
2020-08-07 05:18:00	SPY	ETF	332.75	332.75	332.75	332.75	500.0
2020-08-07 05:22:00	SPY	ETF	332.82	332.82	332.76	332.76	205.0
2020-08-07 05:24:00	SPY	ETF	332.76	332.76	332.75	332.75	203.0
2020-08-07 05:26:00	SPY	ETF	332.55	332.55	332.55	332.55	578.0
2020-08-07 05:29:00	SPY	ETF	332.65	332.65	332.65	332.65	500.0
2020-08-07 05:30:00	SPY	ETF	332.51	332.51	332.51	332.51	130.0
2020-08-07 05:32:00	SPY	ETF	332.72	332.72	332.72	332.72	180.0
2020-08-07 05:33:00	SPY	ETF	332.67	332.67	332.65	332.65	300.0
2020-08-07 05:35:00	SPY	ETF	332.55	332.57	332.54	332.54	700.0

> showing 50 of 206,656 rows — these rows as CSV

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