PREVIEW / etf_1min / 2020-09-01

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-09-01.parquet
  size:    3.9 MB
  rows:    213,951

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-09-01 04:00:00	SPY	ETF	351.27	351.34	351.27	351.3	12041.0
2020-09-01 04:01:00	SPY	ETF	351.35	351.35	351.35	351.35	618.0
2020-09-01 04:02:00	SPY	ETF	351.4	351.43	351.35	351.38	1215.0
2020-09-01 04:03:00	SPY	ETF	351.32	351.34	351.27	351.27	1015.0
2020-09-01 04:05:00	SPY	ETF	351.16	351.16	351.16	351.16	251.0
2020-09-01 04:07:00	SPY	ETF	351.24	351.24	351.24	351.24	300.0
2020-09-01 04:09:00	SPY	ETF	351.11	351.13	351.1	351.13	1350.0
2020-09-01 04:10:00	SPY	ETF	351.06	351.06	351.06	351.06	156.0
2020-09-01 04:12:00	SPY	ETF	351.15	351.15	351.15	351.15	180.0
2020-09-01 04:15:00	SPY	ETF	351.0	351.0	351.0	351.0	405.0
2020-09-01 04:16:00	SPY	ETF	350.98	351.06	350.98	351.06	750.0
2020-09-01 04:17:00	SPY	ETF	351.06	351.06	351.06	351.06	10000.0
2020-09-01 04:18:00	SPY	ETF	351.22	351.22	351.19	351.19	872.0
2020-09-01 04:19:00	SPY	ETF	351.1	351.1	351.03	351.03	755.0
2020-09-01 04:20:00	SPY	ETF	351.03	351.03	351.03	351.03	100.0
2020-09-01 04:25:00	SPY	ETF	351.12	351.17	351.12	351.17	1401.0
2020-09-01 04:26:00	SPY	ETF	351.32	351.35	351.32	351.35	3200.0
2020-09-01 04:30:00	SPY	ETF	351.04	351.06	351.04	351.06	374.0
2020-09-01 04:34:00	SPY	ETF	351.03	351.15	351.03	351.15	300.0
2020-09-01 04:35:00	SPY	ETF	351.19	351.19	351.19	351.19	200.0
2020-09-01 04:36:00	SPY	ETF	351.19	351.19	351.19	351.19	100.0
2020-09-01 04:38:00	SPY	ETF	351.28	351.28	351.28	351.28	700.0
2020-09-01 04:41:00	SPY	ETF	351.07	351.07	351.07	351.07	200.0
2020-09-01 04:43:00	SPY	ETF	350.76	350.76	350.72	350.72	4206.0
2020-09-01 04:44:00	SPY	ETF	350.93	350.93	350.91	350.91	950.0
2020-09-01 04:45:00	SPY	ETF	350.8	350.8	350.8	350.8	150.0
2020-09-01 04:54:00	SPY	ETF	350.61	350.61	350.59	350.59	4105.0
2020-09-01 04:55:00	SPY	ETF	350.45	350.45	350.45	350.45	103.0
2020-09-01 04:56:00	SPY	ETF	350.54	350.54	350.51	350.51	705.0
2020-09-01 04:57:00	SPY	ETF	350.54	350.54	350.54	350.54	100.0
2020-09-01 04:59:00	SPY	ETF	350.56	350.56	350.5	350.5	10335.0
2020-09-01 05:03:00	SPY	ETF	350.61	350.61	350.61	350.61	100.0
2020-09-01 05:04:00	SPY	ETF	350.48	350.61	350.48	350.61	346.0
2020-09-01 05:06:00	SPY	ETF	350.72	350.73	350.72	350.73	1500.0
2020-09-01 05:07:00	SPY	ETF	350.58	350.58	350.58	350.58	250.0
2020-09-01 05:11:00	SPY	ETF	350.72	350.72	350.72	350.72	700.0
2020-09-01 05:15:00	SPY	ETF	350.83	350.88	350.83	350.86	1125.0
2020-09-01 05:16:00	SPY	ETF	350.93	350.93	350.93	350.93	200.0
2020-09-01 05:17:00	SPY	ETF	350.91	350.95	350.91	350.95	375.0
2020-09-01 05:18:00	SPY	ETF	350.99	350.99	350.99	350.99	129.0
2020-09-01 05:19:00	SPY	ETF	350.93	351.01	350.93	351.01	750.0
2020-09-01 05:20:00	SPY	ETF	351.08	351.08	351.03	351.04	6270.0
2020-09-01 05:22:00	SPY	ETF	351.05	351.05	351.05	351.05	200.0
2020-09-01 05:23:00	SPY	ETF	351.06	351.1	351.06	351.1	230.0
2020-09-01 05:24:00	SPY	ETF	351.11	351.11	351.05	351.1	699.0
2020-09-01 05:27:00	SPY	ETF	351.13	351.13	351.13	351.13	130.0
2020-09-01 05:29:00	SPY	ETF	351.14	351.15	351.14	351.15	300.0
2020-09-01 05:31:00	SPY	ETF	351.16	351.16	351.16	351.16	100.0
2020-09-01 05:34:00	SPY	ETF	351.19	351.19	351.19	351.19	125.0
2020-09-01 05:36:00	SPY	ETF	351.17	351.17	351.16	351.16	500.0

> showing 50 of 213,951 rows — these rows as CSV

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