PREVIEW / etf_1min / 2020-08-13

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-13.parquet
  size:    3.6 MB
  rows:    198,001

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-08-13 04:00:00	SPY	ETF	336.98	336.98	336.88	336.88	2509.0
2020-08-13 04:01:00	SPY	ETF	337.05	337.13	337.05	337.13	4230.0
2020-08-13 04:02:00	SPY	ETF	336.86	336.86	336.86	336.86	100.0
2020-08-13 04:03:00	SPY	ETF	336.75	336.75	336.73	336.73	330.0
2020-08-13 04:05:00	SPY	ETF	336.63	336.63	336.61	336.61	819.0
2020-08-13 04:07:00	SPY	ETF	336.6	336.6	336.6	336.6	288.0
2020-08-13 04:08:00	SPY	ETF	336.71	336.71	336.71	336.71	500.0
2020-08-13 04:10:00	SPY	ETF	336.63	336.75	336.63	336.63	10000.0
2020-08-13 04:12:00	SPY	ETF	336.73	336.75	336.73	336.74	5000.0
2020-08-13 04:13:00	SPY	ETF	336.71	336.71	336.7	336.7	5100.0
2020-08-13 04:14:00	SPY	ETF	336.73	336.75	336.73	336.74	5000.0
2020-08-13 04:15:00	SPY	ETF	336.75	336.75	336.64	336.64	11030.0
2020-08-13 04:16:00	SPY	ETF	336.64	336.64	336.64	336.64	4025.0
2020-08-13 04:18:00	SPY	ETF	336.87	336.87	336.83	336.83	229.0
2020-08-13 04:19:00	SPY	ETF	336.84	336.84	336.79	336.79	1100.0
2020-08-13 04:21:00	SPY	ETF	336.64	336.64	336.64	336.64	300.0
2020-08-13 04:31:00	SPY	ETF	336.6	336.6	336.53	336.53	640.0
2020-08-13 04:32:00	SPY	ETF	336.57	336.57	336.57	336.57	100.0
2020-08-13 04:34:00	SPY	ETF	336.62	336.62	336.62	336.62	100.0
2020-08-13 04:38:00	SPY	ETF	336.69	336.69	336.69	336.69	190.0
2020-08-13 04:47:00	SPY	ETF	336.97	336.97	336.97	336.97	193.0
2020-08-13 04:48:00	SPY	ETF	336.98	336.98	336.98	336.98	100.0
2020-08-13 04:49:00	SPY	ETF	337.0	337.0	337.0	337.0	126.0
2020-08-13 04:51:00	SPY	ETF	337.01	337.08	337.01	337.08	2210.0
2020-08-13 04:52:00	SPY	ETF	337.09	337.09	337.09	337.09	400.0
2020-08-13 05:06:00	SPY	ETF	337.03	337.03	337.03	337.03	100.0
2020-08-13 05:11:00	SPY	ETF	337.02	337.02	337.02	337.02	100.0
2020-08-13 05:14:00	SPY	ETF	336.96	336.96	336.96	336.96	109.0
2020-08-13 05:16:00	SPY	ETF	336.99	336.99	336.99	336.99	343.0
2020-08-13 05:17:00	SPY	ETF	336.98	336.98	336.98	336.98	100.0
2020-08-13 05:34:00	SPY	ETF	336.71	336.71	336.71	336.71	105.0
2020-08-13 05:40:00	SPY	ETF	336.69	336.69	336.67	336.67	1100.0
2020-08-13 05:44:00	SPY	ETF	336.61	336.61	336.61	336.61	397.0
2020-08-13 05:45:00	SPY	ETF	336.66	336.66	336.66	336.66	166.0
2020-08-13 05:46:00	SPY	ETF	336.67	336.67	336.67	336.67	100.0
2020-08-13 05:50:00	SPY	ETF	336.72	336.72	336.72	336.72	1200.0
2020-08-13 05:52:00	SPY	ETF	336.75	336.75	336.75	336.75	141.0
2020-08-13 06:11:00	SPY	ETF	336.72	336.72	336.72	336.72	2500.0
2020-08-13 06:21:00	SPY	ETF	336.77	336.77	336.77	336.77	200.0
2020-08-13 06:23:00	SPY	ETF	336.79	336.79	336.75	336.75	200.0
2020-08-13 06:24:00	SPY	ETF	336.74	336.78	336.74	336.78	1115.0
2020-08-13 06:26:00	SPY	ETF	336.75	336.75	336.75	336.75	122.0
2020-08-13 06:39:00	SPY	ETF	336.87	336.89	336.87	336.89	2800.0
2020-08-13 06:40:00	SPY	ETF	336.89	336.89	336.89	336.89	300.0
2020-08-13 06:43:00	SPY	ETF	336.89	336.89	336.89	336.89	100.0
2020-08-13 06:47:00	SPY	ETF	336.88	336.93	336.87	336.93	950.0
2020-08-13 06:49:00	SPY	ETF	336.91	336.91	336.91	336.91	1000.0
2020-08-13 06:50:00	SPY	ETF	336.9	336.9	336.9	336.9	300.0
2020-08-13 06:53:00	SPY	ETF	336.86	336.86	336.86	336.86	170.0
2020-08-13 06:56:00	SPY	ETF	336.83	336.83	336.79	336.79	724.0

> showing 50 of 198,001 rows — these rows as CSV

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