PREVIEW / etf_1min / 2020-07-08

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-08.parquet
  size:    3.7 MB
  rows:    209,430

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-07-08 04:00:00	SPY	ETF	314.61	314.61	314.6	314.6	1332.0
2020-07-08 04:01:00	SPY	ETF	314.6	314.6	314.5	314.5	1556.0
2020-07-08 04:02:00	SPY	ETF	314.42	314.42	314.42	314.42	100.0
2020-07-08 04:04:00	SPY	ETF	314.42	314.51	314.42	314.42	1785.0
2020-07-08 04:05:00	SPY	ETF	314.56	314.57	314.53	314.53	2060.0
2020-07-08 04:06:00	SPY	ETF	314.45	314.45	314.31	314.31	1203.0
2020-07-08 04:07:00	SPY	ETF	314.28	314.28	314.28	314.28	270.0
2020-07-08 04:09:00	SPY	ETF	314.45	314.45	314.45	314.45	500.0
2020-07-08 04:11:00	SPY	ETF	314.41	314.41	314.41	314.41	246.0
2020-07-08 04:13:00	SPY	ETF	314.77	314.79	314.77	314.79	664.0
2020-07-08 04:14:00	SPY	ETF	314.53	314.53	314.53	314.53	200.0
2020-07-08 04:17:00	SPY	ETF	314.62	314.62	314.62	314.62	301.0
2020-07-08 04:18:00	SPY	ETF	314.5	314.53	314.44	314.53	972.0
2020-07-08 04:23:00	SPY	ETF	314.78	314.78	314.78	314.78	432.0
2020-07-08 04:26:00	SPY	ETF	314.71	314.82	314.71	314.76	1518.0
2020-07-08 04:27:00	SPY	ETF	314.71	314.78	314.71	314.78	318.0
2020-07-08 04:29:00	SPY	ETF	314.68	314.69	314.61	314.68	610.0
2020-07-08 04:30:00	SPY	ETF	314.65	314.65	314.65	314.65	360.0
2020-07-08 04:31:00	SPY	ETF	314.54	314.54	314.5	314.5	1040.0
2020-07-08 04:35:00	SPY	ETF	314.44	315.33	314.44	315.14	6110.0
2020-07-08 04:36:00	SPY	ETF	315.21	315.21	315.02	315.02	1180.0
2020-07-08 04:37:00	SPY	ETF	315.02	315.03	314.99	315.01	4219.0
2020-07-08 04:39:00	SPY	ETF	314.69	314.69	314.67	314.67	440.0
2020-07-08 04:42:00	SPY	ETF	314.94	314.94	314.94	314.94	165.0
2020-07-08 04:43:00	SPY	ETF	314.88	314.88	314.88	314.88	100.0
2020-07-08 04:44:00	SPY	ETF	314.88	314.88	314.88	314.88	200.0
2020-07-08 04:46:00	SPY	ETF	314.89	314.89	314.89	314.89	447.0
2020-07-08 04:48:00	SPY	ETF	314.82	314.82	314.82	314.82	400.0
2020-07-08 04:49:00	SPY	ETF	314.8	314.8	314.8	314.8	1024.0
2020-07-08 04:50:00	SPY	ETF	314.83	314.83	314.83	314.83	274.0
2020-07-08 04:51:00	SPY	ETF	314.71	314.71	314.69	314.69	1510.0
2020-07-08 04:53:00	SPY	ETF	314.66	314.71	314.56	314.56	2176.0
2020-07-08 04:54:00	SPY	ETF	314.56	314.57	314.56	314.57	200.0
2020-07-08 04:55:00	SPY	ETF	314.49	314.49	314.49	314.49	210.0
2020-07-08 04:56:00	SPY	ETF	314.29	314.29	314.29	314.29	1075.0
2020-07-08 04:57:00	SPY	ETF	314.4	314.44	314.39	314.39	2010.0
2020-07-08 04:59:00	SPY	ETF	314.33	314.43	314.32	314.34	2759.0
2020-07-08 05:00:00	SPY	ETF	314.45	314.45	314.45	314.45	250.0
2020-07-08 05:02:00	SPY	ETF	314.42	314.42	314.42	314.42	250.0
2020-07-08 05:03:00	SPY	ETF	314.3	314.3	314.3	314.3	411.0
2020-07-08 05:04:00	SPY	ETF	314.26	314.32	314.26	314.32	1120.0
2020-07-08 05:05:00	SPY	ETF	314.3	314.3	314.3	314.3	100.0
2020-07-08 05:06:00	SPY	ETF	314.33	314.33	314.22	314.22	2150.0
2020-07-08 05:07:00	SPY	ETF	314.19	314.19	314.19	314.19	412.0
2020-07-08 05:08:00	SPY	ETF	314.3	314.3	314.3	314.3	330.0
2020-07-08 05:09:00	SPY	ETF	314.27	314.27	314.27	314.27	305.0
2020-07-08 05:11:00	SPY	ETF	314.21	314.21	314.21	314.21	666.0
2020-07-08 05:13:00	SPY	ETF	314.2	314.2	313.96	313.96	2325.0
2020-07-08 05:14:00	SPY	ETF	313.77	313.77	313.71	313.71	433.0
2020-07-08 05:15:00	SPY	ETF	313.63	313.63	313.5	313.62	1180.0

> showing 50 of 209,430 rows — these rows as CSV

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