PREVIEW / etf_1min / 2020-03-17

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-17.parquet
  size:    5.3 MB
  rows:    265,191

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-03-17 04:00:00	SPY	ETF	246.97	253.25	246.97	252.96	31538.0
2020-03-17 04:01:00	SPY	ETF	252.99	254.0	252.99	254.0	6441.0
2020-03-17 04:02:00	SPY	ETF	254.2	255.05	253.98	255.01	11849.0
2020-03-17 04:03:00	SPY	ETF	255.01	255.55	255.0	255.07	8314.0
2020-03-17 04:04:00	SPY	ETF	255.54	256.45	255.48	256.45	11545.0
2020-03-17 04:05:00	SPY	ETF	256.21	256.21	255.62	255.63	33692.0
2020-03-17 04:06:00	SPY	ETF	255.62	255.63	255.01	255.2	6566.0
2020-03-17 04:07:00	SPY	ETF	255.06	255.06	255.0	255.0	9861.0
2020-03-17 04:08:00	SPY	ETF	255.01	255.2	255.0	255.08	4294.0
2020-03-17 04:09:00	SPY	ETF	255.07	255.43	254.97	255.0	28604.0
2020-03-17 04:10:00	SPY	ETF	254.72	254.72	253.54	253.68	3281.0
2020-03-17 04:11:00	SPY	ETF	253.65	254.0	253.37	253.8	2196.0
2020-03-17 04:12:00	SPY	ETF	253.9	254.5	253.36	254.18	7223.0
2020-03-17 04:13:00	SPY	ETF	254.19	254.25	253.8	253.8	4074.0
2020-03-17 04:14:00	SPY	ETF	253.85	253.89	253.84	253.89	8329.0
2020-03-17 04:15:00	SPY	ETF	253.89	253.9	253.89	253.9	3723.0
2020-03-17 04:16:00	SPY	ETF	253.9	254.0	253.14	253.2	14603.0
2020-03-17 04:19:00	SPY	ETF	253.5	253.5	253.12	253.12	1685.0
2020-03-17 04:20:00	SPY	ETF	253.11	253.2	252.5	252.5	5151.0
2020-03-17 04:21:00	SPY	ETF	252.5	252.5	252.0	252.0	4336.0
2020-03-17 04:22:00	SPY	ETF	251.88	251.88	249.28	249.38	47883.0
2020-03-17 04:23:00	SPY	ETF	249.08	250.51	249.08	250.32	23751.0
2020-03-17 04:24:00	SPY	ETF	250.26	250.54	250.26	250.47	8597.0
2020-03-17 04:25:00	SPY	ETF	250.24	250.4	249.08	249.08	20456.0
2020-03-17 04:26:00	SPY	ETF	249.19	249.27	248.37	248.92	15348.0
2020-03-17 04:27:00	SPY	ETF	248.7	249.66	248.57	249.53	11625.0
2020-03-17 04:28:00	SPY	ETF	249.46	249.63	249.19	249.49	8580.0
2020-03-17 04:29:00	SPY	ETF	249.48	250.34	249.48	250.3	30398.0
2020-03-17 04:30:00	SPY	ETF	250.16	250.39	250.09	250.23	17893.0
2020-03-17 04:31:00	SPY	ETF	250.23	250.23	249.52	250.0	24618.0
2020-03-17 04:32:00	SPY	ETF	249.69	250.74	249.65	249.65	24251.0
2020-03-17 04:33:00	SPY	ETF	249.74	250.0	249.28	249.33	16313.0
2020-03-17 04:34:00	SPY	ETF	249.36	250.35	248.89	249.7	21128.0
2020-03-17 04:35:00	SPY	ETF	249.8	249.88	249.16	249.69	19405.0
2020-03-17 04:36:00	SPY	ETF	249.66	249.73	249.49	249.64	11308.0
2020-03-17 04:37:00	SPY	ETF	249.4	249.4	248.8	248.8	2706.0
2020-03-17 04:38:00	SPY	ETF	248.89	249.2	248.4	249.2	21919.0
2020-03-17 04:39:00	SPY	ETF	248.37	248.54	248.1	248.1	2604.0
2020-03-17 04:40:00	SPY	ETF	248.03	248.43	247.82	248.03	29346.0
2020-03-17 04:41:00	SPY	ETF	247.88	248.26	247.23	247.36	30091.0
2020-03-17 04:42:00	SPY	ETF	247.42	247.42	246.0	246.91	27911.0
2020-03-17 04:43:00	SPY	ETF	246.81	247.19	246.73	246.79	13023.0
2020-03-17 04:44:00	SPY	ETF	246.84	247.7	246.58	247.27	11941.0
2020-03-17 04:45:00	SPY	ETF	247.41	247.54	246.91	247.0	20063.0
2020-03-17 04:46:00	SPY	ETF	246.81	247.1	246.74	247.06	8725.0
2020-03-17 04:47:00	SPY	ETF	247.06	247.17	247.04	247.07	9972.0
2020-03-17 04:48:00	SPY	ETF	247.22	247.27	247.0	247.0	3714.0
2020-03-17 04:49:00	SPY	ETF	246.92	246.92	246.77	246.77	2960.0
2020-03-17 04:50:00	SPY	ETF	246.36	246.86	245.69	246.8	20330.0
2020-03-17 04:51:00	SPY	ETF	246.69	246.85	246.47	246.83	34012.0

> showing 50 of 265,191 rows — these rows as CSV

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