PREVIEW / etf_1min / 2020-05-13

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-13.parquet
  size:    4.3 MB
  rows:    227,459

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-05-13 04:00:00	SPY	ETF	285.68	285.7	285.6	285.64	15130.0
2020-05-13 04:01:00	SPY	ETF	285.54	285.54	285.42	285.44	2302.0
2020-05-13 04:02:00	SPY	ETF	285.45	285.45	285.39	285.39	721.0
2020-05-13 04:03:00	SPY	ETF	285.43	285.44	285.43	285.44	3095.0
2020-05-13 04:04:00	SPY	ETF	285.26	285.28	285.24	285.28	571.0
2020-05-13 04:05:00	SPY	ETF	285.48	285.65	285.48	285.63	1655.0
2020-05-13 04:06:00	SPY	ETF	285.66	285.73	285.62	285.64	1037.0
2020-05-13 04:07:00	SPY	ETF	285.66	285.66	285.63	285.63	730.0
2020-05-13 04:08:00	SPY	ETF	285.55	285.55	285.46	285.5	586.0
2020-05-13 04:09:00	SPY	ETF	285.63	285.74	285.63	285.74	3426.0
2020-05-13 04:10:00	SPY	ETF	285.79	285.87	285.79	285.87	780.0
2020-05-13 04:11:00	SPY	ETF	285.87	285.93	285.87	285.92	1780.0
2020-05-13 04:12:00	SPY	ETF	285.91	285.91	285.89	285.89	1928.0
2020-05-13 04:13:00	SPY	ETF	285.89	285.95	285.89	285.95	2211.0
2020-05-13 04:14:00	SPY	ETF	285.95	286.0	285.94	286.0	3008.0
2020-05-13 04:15:00	SPY	ETF	286.17	286.17	286.16	286.17	2051.0
2020-05-13 04:16:00	SPY	ETF	286.09	286.18	286.09	286.15	5894.0
2020-05-13 04:17:00	SPY	ETF	286.08	286.08	286.07	286.08	1056.0
2020-05-13 04:18:00	SPY	ETF	286.15	286.16	286.02	286.04	1825.0
2020-05-13 04:19:00	SPY	ETF	286.04	286.04	286.0	286.0	1180.0
2020-05-13 04:20:00	SPY	ETF	286.16	286.16	286.16	286.16	329.0
2020-05-13 04:21:00	SPY	ETF	286.14	286.36	286.14	286.34	4518.0
2020-05-13 04:22:00	SPY	ETF	286.3	286.3	286.23	286.23	1609.0
2020-05-13 04:23:00	SPY	ETF	286.28	286.28	286.28	286.28	350.0
2020-05-13 04:24:00	SPY	ETF	286.14	286.14	286.14	286.14	192.0
2020-05-13 04:25:00	SPY	ETF	286.15	286.15	286.15	286.15	187.0
2020-05-13 04:26:00	SPY	ETF	286.16	286.16	286.13	286.13	710.0
2020-05-13 04:27:00	SPY	ETF	286.03	286.03	286.03	286.03	200.0
2020-05-13 04:28:00	SPY	ETF	286.06	286.06	285.98	285.99	2920.0
2020-05-13 04:29:00	SPY	ETF	286.0	286.2	286.0	286.2	2722.0
2020-05-13 04:30:00	SPY	ETF	286.26	286.33	286.23	286.29	4607.0
2020-05-13 04:31:00	SPY	ETF	286.3	286.31	286.3	286.3	1497.0
2020-05-13 04:32:00	SPY	ETF	286.25	286.25	286.23	286.23	2000.0
2020-05-13 04:33:00	SPY	ETF	286.19	286.3	286.19	286.3	5050.0
2020-05-13 04:34:00	SPY	ETF	286.45	286.45	286.44	286.44	1313.0
2020-05-13 04:35:00	SPY	ETF	286.46	286.59	286.46	286.49	6652.0
2020-05-13 04:36:00	SPY	ETF	286.47	286.48	286.4	286.4	930.0
2020-05-13 04:37:00	SPY	ETF	286.35	286.41	286.32	286.41	2927.0
2020-05-13 04:38:00	SPY	ETF	286.52	286.52	286.49	286.49	2340.0
2020-05-13 04:39:00	SPY	ETF	286.49	286.49	286.46	286.46	270.0
2020-05-13 04:40:00	SPY	ETF	286.38	286.38	286.33	286.33	1000.0
2020-05-13 04:41:00	SPY	ETF	286.33	286.33	286.25	286.26	3710.0
2020-05-13 04:42:00	SPY	ETF	286.22	286.22	286.19	286.19	2864.0
2020-05-13 04:43:00	SPY	ETF	286.23	286.23	286.15	286.15	504.0
2020-05-13 04:44:00	SPY	ETF	286.23	286.23	286.2	286.22	1573.0
2020-05-13 04:46:00	SPY	ETF	286.19	286.19	286.16	286.16	420.0
2020-05-13 04:47:00	SPY	ETF	286.02	286.06	286.02	286.06	710.0
2020-05-13 04:48:00	SPY	ETF	285.95	285.95	285.95	285.95	605.0
2020-05-13 04:49:00	SPY	ETF	286.01	286.01	285.98	285.98	1375.0
2020-05-13 04:50:00	SPY	ETF	286.01	286.01	286.01	286.01	237.0

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

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