PREVIEW / etf_1min / 2020-04-07

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-07.parquet
  size:    4.7 MB
  rows:    246,600

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-04-07 04:00:00	SPY	ETF	270.75	270.9	270.57	270.71	14271.0
2020-04-07 04:01:00	SPY	ETF	270.71	270.86	270.6	270.7	4721.0
2020-04-07 04:02:00	SPY	ETF	270.72	270.75	270.48	270.75	6150.0
2020-04-07 04:03:00	SPY	ETF	270.8	271.14	270.8	271.14	8930.0
2020-04-07 04:04:00	SPY	ETF	271.01	271.06	270.89	271.04	5284.0
2020-04-07 04:05:00	SPY	ETF	271.2	271.39	271.2	271.21	2525.0
2020-04-07 04:06:00	SPY	ETF	271.23	271.23	270.8	270.81	5262.0
2020-04-07 04:07:00	SPY	ETF	270.78	270.89	270.69	270.69	2754.0
2020-04-07 04:08:00	SPY	ETF	270.71	270.74	270.66	270.73	3066.0
2020-04-07 04:09:00	SPY	ETF	270.74	270.93	270.68	270.93	10252.0
2020-04-07 04:10:00	SPY	ETF	270.88	271.1	270.88	271.1	2755.0
2020-04-07 04:11:00	SPY	ETF	271.05	271.11	270.99	271.11	3379.0
2020-04-07 04:12:00	SPY	ETF	271.3	271.31	271.13	271.28	1900.0
2020-04-07 04:13:00	SPY	ETF	271.24	271.29	271.03	271.29	2702.0
2020-04-07 04:14:00	SPY	ETF	271.29	271.38	271.06	271.06	6827.0
2020-04-07 04:15:00	SPY	ETF	271.16	271.21	271.16	271.2	2239.0
2020-04-07 04:16:00	SPY	ETF	271.23	271.29	271.2	271.28	2108.0
2020-04-07 04:17:00	SPY	ETF	271.28	271.28	271.19	271.19	2385.0
2020-04-07 04:18:00	SPY	ETF	271.35	271.48	271.35	271.48	3817.0
2020-04-07 04:19:00	SPY	ETF	271.41	271.45	271.34	271.39	3400.0
2020-04-07 04:20:00	SPY	ETF	271.42	271.77	271.42	271.76	7853.0
2020-04-07 04:21:00	SPY	ETF	271.76	271.76	271.63	271.63	315.0
2020-04-07 04:22:00	SPY	ETF	271.49	272.0	271.48	271.84	9098.0
2020-04-07 04:23:00	SPY	ETF	271.99	272.0	271.9	271.9	7695.0
2020-04-07 04:24:00	SPY	ETF	271.71	271.89	271.71	271.87	4220.0
2020-04-07 04:25:00	SPY	ETF	272.0	272.0	271.62	271.72	12356.0
2020-04-07 04:26:00	SPY	ETF	271.69	271.92	271.65	271.92	3130.0
2020-04-07 04:27:00	SPY	ETF	271.79	272.26	271.79	272.04	11529.0
2020-04-07 04:28:00	SPY	ETF	271.86	271.87	271.81	271.82	3850.0
2020-04-07 04:29:00	SPY	ETF	271.95	271.99	271.95	271.99	1170.0
2020-04-07 04:30:00	SPY	ETF	271.97	271.97	271.65	271.65	6538.0
2020-04-07 04:31:00	SPY	ETF	271.61	271.61	271.12	271.59	13980.0
2020-04-07 04:32:00	SPY	ETF	271.53	271.59	271.39	271.39	2774.0
2020-04-07 04:33:00	SPY	ETF	271.34	271.34	271.15	271.15	3893.0
2020-04-07 04:34:00	SPY	ETF	271.11	271.15	270.92	271.12	5713.0
2020-04-07 04:35:00	SPY	ETF	271.08	271.16	271.08	271.15	2440.0
2020-04-07 04:36:00	SPY	ETF	271.32	271.32	271.2	271.29	1922.0
2020-04-07 04:37:00	SPY	ETF	271.28	271.53	271.28	271.53	1413.0
2020-04-07 04:38:00	SPY	ETF	271.42	271.5	271.42	271.5	1235.0
2020-04-07 04:39:00	SPY	ETF	271.64	271.66	271.64	271.66	300.0
2020-04-07 04:40:00	SPY	ETF	271.41	271.45	271.41	271.45	1636.0
2020-04-07 04:41:00	SPY	ETF	271.61	271.94	271.61	271.94	4230.0
2020-04-07 04:42:00	SPY	ETF	271.9	271.9	271.88	271.88	884.0
2020-04-07 04:43:00	SPY	ETF	271.66	271.66	271.56	271.56	312.0
2020-04-07 04:44:00	SPY	ETF	271.76	271.76	271.75	271.75	1650.0
2020-04-07 04:45:00	SPY	ETF	271.83	271.83	271.58	271.58	296.0
2020-04-07 04:46:00	SPY	ETF	271.7	271.74	271.58	271.58	2003.0
2020-04-07 04:47:00	SPY	ETF	271.41	271.41	271.38	271.38	1381.0
2020-04-07 04:48:00	SPY	ETF	271.32	271.48	271.2	271.48	2348.0
2020-04-07 04:49:00	SPY	ETF	271.6	271.73	271.6	271.73	559.0

> showing 50 of 246,600 rows — these rows as CSV

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