PREVIEW / etf_1min / 2020-03-16

all etf 1-min files

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

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-16 04:00:00	SPY	ETF	253.2	262.75	249.17	251.25	22813.0
2020-03-16 04:01:00	SPY	ETF	251.0	251.42	250.63	251.42	4177.0
2020-03-16 04:02:00	SPY	ETF	251.08	251.89	251.0	251.0	7018.0
2020-03-16 04:03:00	SPY	ETF	251.2	251.2	250.64	250.85	10587.0
2020-03-16 04:04:00	SPY	ETF	250.87	251.22	250.8	251.11	20379.0
2020-03-16 04:05:00	SPY	ETF	251.0	251.22	251.0	251.16	5148.0
2020-03-16 04:06:00	SPY	ETF	251.16	252.06	251.16	252.06	9831.0
2020-03-16 04:07:00	SPY	ETF	252.6	253.79	252.5	253.39	16923.0
2020-03-16 04:08:00	SPY	ETF	253.36	254.48	253.13	253.81	17996.0
2020-03-16 04:09:00	SPY	ETF	253.5	254.68	253.5	253.71	18814.0
2020-03-16 04:10:00	SPY	ETF	253.86	254.15	253.33	253.74	10135.0
2020-03-16 04:11:00	SPY	ETF	253.5	253.71	252.9	252.9	17475.0
2020-03-16 04:12:00	SPY	ETF	253.0	253.5	252.9	252.9	7337.0
2020-03-16 04:13:00	SPY	ETF	252.8	252.92	252.1	252.25	6939.0
2020-03-16 04:14:00	SPY	ETF	252.35	252.64	252.25	252.64	7610.0
2020-03-16 04:15:00	SPY	ETF	252.57	252.69	251.69	251.89	9382.0
2020-03-16 04:16:00	SPY	ETF	251.89	252.1	251.3	252.0	17150.0
2020-03-16 04:17:00	SPY	ETF	252.24	252.37	252.24	252.37	1069.0
2020-03-16 04:18:00	SPY	ETF	252.5	253.99	252.46	252.46	25432.0
2020-03-16 04:19:00	SPY	ETF	252.91	252.91	252.91	252.91	820.0
2020-03-16 04:20:00	SPY	ETF	252.65	252.65	252.5	252.51	5260.0
2020-03-16 04:21:00	SPY	ETF	252.51	252.51	252.36	252.5	17610.0
2020-03-16 04:22:00	SPY	ETF	252.36	252.55	251.72	251.91	14170.0
2020-03-16 04:23:00	SPY	ETF	251.82	251.82	251.5	251.5	3918.0
2020-03-16 04:24:00	SPY	ETF	251.44	251.44	250.64	250.64	5953.0
2020-03-16 04:25:00	SPY	ETF	251.03	251.15	250.71	250.73	5391.0
2020-03-16 04:26:00	SPY	ETF	250.73	251.0	250.11	250.44	13163.0
2020-03-16 04:27:00	SPY	ETF	250.44	250.5	250.05	250.5	9687.0
2020-03-16 04:28:00	SPY	ETF	250.5	250.6	249.5	249.9	11910.0
2020-03-16 04:29:00	SPY	ETF	249.46	249.72	248.51	249.0	11098.0
2020-03-16 04:30:00	SPY	ETF	248.86	248.96	247.99	248.28	15384.0
2020-03-16 04:31:00	SPY	ETF	248.54	248.62	248.11	248.45	8387.0
2020-03-16 04:32:00	SPY	ETF	248.11	248.49	247.93	248.2	12198.0
2020-03-16 04:33:00	SPY	ETF	248.0	248.49	247.0	247.21	7825.0
2020-03-16 04:34:00	SPY	ETF	247.39	247.39	246.26	246.96	17935.0
2020-03-16 04:35:00	SPY	ETF	246.22	246.96	245.0	245.11	23393.0
2020-03-16 04:36:00	SPY	ETF	245.05	245.75	244.21	245.01	17996.0
2020-03-16 04:37:00	SPY	ETF	245.0	246.2	244.78	246.2	6815.0
2020-03-16 04:38:00	SPY	ETF	246.3	246.3	245.57	245.82	3212.0
2020-03-16 04:39:00	SPY	ETF	246.01	246.3	245.82	245.82	3492.0
2020-03-16 04:40:00	SPY	ETF	245.85	245.85	245.01	245.22	5673.0
2020-03-16 04:41:00	SPY	ETF	245.53	245.83	245.35	245.83	1520.0
2020-03-16 04:42:00	SPY	ETF	245.7	246.0	245.35	245.7	5453.0
2020-03-16 04:43:00	SPY	ETF	245.6	245.8	245.6	245.8	980.0
2020-03-16 04:44:00	SPY	ETF	246.0	246.0	245.21	245.21	4438.0
2020-03-16 04:45:00	SPY	ETF	245.35	245.95	245.35	245.95	12030.0
2020-03-16 04:46:00	SPY	ETF	245.94	246.57	245.57	246.2	14344.0
2020-03-16 04:47:00	SPY	ETF	246.05	246.2	245.1	245.8	16273.0
2020-03-16 04:48:00	SPY	ETF	245.5	245.8	245.12	245.79	9546.0
2020-03-16 04:49:00	SPY	ETF	245.21	245.5	245.01	245.1	8303.0

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

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