PREVIEW / etf_1min / 2020-09-08

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-09-08.parquet
  size:    4.2 MB
  rows:    227,764

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-08 04:00:00	SPY	ETF	343.44	343.58	343.44	343.58	2538.0
2020-09-08 04:01:00	SPY	ETF	343.33	343.33	343.33	343.33	266.0
2020-09-08 04:02:00	SPY	ETF	343.24	343.24	343.24	343.24	1475.0
2020-09-08 04:03:00	SPY	ETF	343.31	343.32	343.28	343.31	473.0
2020-09-08 04:06:00	SPY	ETF	343.16	343.19	343.13	343.18	5239.0
2020-09-08 04:07:00	SPY	ETF	343.15	343.15	343.15	343.15	179.0
2020-09-08 04:09:00	SPY	ETF	343.14	343.14	343.14	343.14	188.0
2020-09-08 04:10:00	SPY	ETF	343.14	343.15	343.12	343.15	1201.0
2020-09-08 04:11:00	SPY	ETF	343.1	343.1	343.1	343.1	100.0
2020-09-08 04:12:00	SPY	ETF	343.02	343.05	343.0	343.0	360.0
2020-09-08 04:13:00	SPY	ETF	342.78	342.78	342.78	342.78	205.0
2020-09-08 04:14:00	SPY	ETF	342.64	342.66	342.63	342.64	570.0
2020-09-08 04:15:00	SPY	ETF	342.63	342.63	342.34	342.36	1941.0
2020-09-08 04:16:00	SPY	ETF	342.44	342.44	342.28	342.31	1750.0
2020-09-08 04:17:00	SPY	ETF	342.24	342.24	342.21	342.21	305.0
2020-09-08 04:18:00	SPY	ETF	342.13	342.13	342.13	342.13	300.0
2020-09-08 04:19:00	SPY	ETF	341.9	342.03	341.9	342.03	1020.0
2020-09-08 04:20:00	SPY	ETF	341.92	341.93	341.76	341.76	2457.0
2020-09-08 04:21:00	SPY	ETF	341.69	341.74	341.67	341.74	922.0
2020-09-08 04:22:00	SPY	ETF	341.83	341.83	341.81	341.81	1704.0
2020-09-08 04:24:00	SPY	ETF	341.55	341.55	341.51	341.51	481.0
2020-09-08 04:25:00	SPY	ETF	341.41	341.62	341.41	341.56	1040.0
2020-09-08 04:26:00	SPY	ETF	341.43	341.43	341.43	341.43	244.0
2020-09-08 04:27:00	SPY	ETF	341.12	341.12	341.11	341.11	786.0
2020-09-08 04:28:00	SPY	ETF	341.23	341.41	341.23	341.41	5295.0
2020-09-08 04:29:00	SPY	ETF	341.45	341.57	341.45	341.57	501.0
2020-09-08 04:30:00	SPY	ETF	341.6	341.6	341.57	341.57	223.0
2020-09-08 04:31:00	SPY	ETF	341.48	341.48	341.43	341.43	1200.0
2020-09-08 04:33:00	SPY	ETF	341.38	341.45	341.38	341.45	300.0
2020-09-08 04:34:00	SPY	ETF	341.46	341.46	341.44	341.44	715.0
2020-09-08 04:35:00	SPY	ETF	341.39	341.53	341.39	341.53	450.0
2020-09-08 04:36:00	SPY	ETF	341.36	341.36	341.36	341.36	401.0
2020-09-08 04:37:00	SPY	ETF	341.04	341.29	341.0	341.29	984.0
2020-09-08 04:38:00	SPY	ETF	341.43	341.59	341.43	341.59	701.0
2020-09-08 04:39:00	SPY	ETF	341.63	341.63	341.61	341.61	375.0
2020-09-08 04:40:00	SPY	ETF	341.61	341.61	341.51	341.51	2500.0
2020-09-08 04:42:00	SPY	ETF	341.47	341.47	341.47	341.47	100.0
2020-09-08 04:44:00	SPY	ETF	341.16	341.16	340.84	340.86	3447.0
2020-09-08 04:45:00	SPY	ETF	340.8	340.91	340.36	340.36	6697.0
2020-09-08 04:46:00	SPY	ETF	340.59	340.68	340.33	340.36	13833.0
2020-09-08 04:47:00	SPY	ETF	340.43	340.43	340.27	340.27	1719.0
2020-09-08 04:48:00	SPY	ETF	340.41	340.6	340.41	340.6	450.0
2020-09-08 04:49:00	SPY	ETF	340.6	340.62	340.6	340.61	755.0
2020-09-08 04:50:00	SPY	ETF	340.47	340.47	340.47	340.47	257.0
2020-09-08 04:51:00	SPY	ETF	340.45	340.45	340.45	340.45	205.0
2020-09-08 04:53:00	SPY	ETF	340.43	340.43	340.43	340.43	305.0
2020-09-08 04:55:00	SPY	ETF	340.45	340.56	340.45	340.53	1106.0
2020-09-08 04:56:00	SPY	ETF	340.61	340.63	340.54	340.6	400.0
2020-09-08 04:57:00	SPY	ETF	340.54	340.54	340.51	340.51	330.0
2020-09-08 04:58:00	SPY	ETF	340.46	340.64	340.46	340.64	475.0

> showing 50 of 227,764 rows — these rows as CSV

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