PREVIEW / etf_1min / 2020-04-14

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-14.parquet
  size:    4.4 MB
  rows:    234,132

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-14 04:00:00	SPY	ETF	279.27	279.27	279.27	279.27	1007.0
2020-04-14 04:01:00	SPY	ETF	278.98	278.98	278.84	278.94	1867.0
2020-04-14 04:02:00	SPY	ETF	278.97	279.1	278.97	279.1	4075.0
2020-04-14 04:03:00	SPY	ETF	279.2	279.3	279.15	279.3	10690.0
2020-04-14 04:04:00	SPY	ETF	279.28	279.29	279.22	279.25	13501.0
2020-04-14 04:05:00	SPY	ETF	279.14	279.14	279.12	279.14	2766.0
2020-04-14 04:06:00	SPY	ETF	279.06	279.07	279.06	279.07	1030.0
2020-04-14 04:07:00	SPY	ETF	279.06	279.06	279.0	279.0	771.0
2020-04-14 04:09:00	SPY	ETF	279.11	279.11	279.11	279.11	2020.0
2020-04-14 04:10:00	SPY	ETF	279.16	279.16	278.88	278.9	5164.0
2020-04-14 04:11:00	SPY	ETF	278.9	278.9	278.9	278.9	120.0
2020-04-14 04:12:00	SPY	ETF	278.89	278.89	278.88	278.88	401.0
2020-04-14 04:13:00	SPY	ETF	278.85	278.85	278.83	278.83	1305.0
2020-04-14 04:14:00	SPY	ETF	278.87	278.87	278.85	278.85	11501.0
2020-04-14 04:17:00	SPY	ETF	278.67	278.68	278.67	278.68	411.0
2020-04-14 04:18:00	SPY	ETF	278.63	278.64	278.63	278.64	900.0
2020-04-14 04:22:00	SPY	ETF	278.92	278.92	278.92	278.92	308.0
2020-04-14 04:25:00	SPY	ETF	279.09	279.14	279.09	279.14	9573.0
2020-04-14 04:26:00	SPY	ETF	279.16	279.16	279.08	279.08	4032.0
2020-04-14 04:27:00	SPY	ETF	279.13	279.13	279.13	279.13	250.0
2020-04-14 04:28:00	SPY	ETF	279.11	279.11	279.11	279.11	135.0
2020-04-14 04:29:00	SPY	ETF	278.91	278.91	278.91	278.91	1265.0
2020-04-14 04:31:00	SPY	ETF	278.93	278.93	278.93	278.93	463.0
2020-04-14 04:32:00	SPY	ETF	278.87	278.87	278.8	278.8	350.0
2020-04-14 04:33:00	SPY	ETF	278.86	278.96	278.86	278.96	700.0
2020-04-14 04:34:00	SPY	ETF	278.86	278.86	278.86	278.86	500.0
2020-04-14 04:35:00	SPY	ETF	279.06	279.06	279.06	279.06	162.0
2020-04-14 04:36:00	SPY	ETF	279.06	279.06	279.06	279.06	100.0
2020-04-14 04:37:00	SPY	ETF	279.03	279.03	279.03	279.03	200.0
2020-04-14 04:38:00	SPY	ETF	279.05	279.05	279.05	279.05	220.0
2020-04-14 04:39:00	SPY	ETF	279.11	279.2	279.08	279.08	1005.0
2020-04-14 04:40:00	SPY	ETF	279.13	279.22	279.13	279.22	1720.0
2020-04-14 04:43:00	SPY	ETF	278.97	278.97	278.97	278.97	300.0
2020-04-14 04:45:00	SPY	ETF	278.99	278.99	278.99	278.99	500.0
2020-04-14 04:49:00	SPY	ETF	278.84	278.86	278.84	278.86	1125.0
2020-04-14 04:51:00	SPY	ETF	278.76	278.76	278.76	278.76	940.0
2020-04-14 04:52:00	SPY	ETF	278.76	278.76	278.76	278.76	418.0
2020-04-14 04:53:00	SPY	ETF	278.65	278.65	278.65	278.65	400.0
2020-04-14 04:54:00	SPY	ETF	278.68	278.68	278.6	278.6	1101.0
2020-04-14 04:55:00	SPY	ETF	278.58	278.58	278.51	278.56	2203.0
2020-04-14 04:57:00	SPY	ETF	278.61	278.61	278.61	278.61	340.0
2020-04-14 04:58:00	SPY	ETF	278.62	278.62	278.62	278.62	270.0
2020-04-14 04:59:00	SPY	ETF	278.64	278.64	278.64	278.64	200.0
2020-04-14 05:02:00	SPY	ETF	278.71	278.71	278.62	278.65	5200.0
2020-04-14 05:03:00	SPY	ETF	278.65	278.66	278.61	278.64	9600.0
2020-04-14 05:04:00	SPY	ETF	278.63	278.69	278.61	278.69	5000.0
2020-04-14 05:05:00	SPY	ETF	278.68	278.68	278.64	278.65	12000.0
2020-04-14 05:06:00	SPY	ETF	278.82	278.82	278.82	278.82	1058.0
2020-04-14 05:07:00	SPY	ETF	278.94	278.97	278.94	278.96	3360.0
2020-04-14 05:08:00	SPY	ETF	279.02	279.1	279.02	279.08	14050.0

> showing 50 of 234,132 rows — these rows as CSV

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