PREVIEW / etf_1min / 2020-05-27

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-27.parquet
  size:    4.1 MB
  rows:    222,412

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-27 04:00:00	SPY	ETF	301.86	302.0	301.86	301.91	9027.0
2020-05-27 04:01:00	SPY	ETF	301.89	302.05	301.89	302.05	2734.0
2020-05-27 04:02:00	SPY	ETF	302.02	302.05	302.02	302.05	659.0
2020-05-27 04:04:00	SPY	ETF	302.0	302.09	302.0	302.09	1368.0
2020-05-27 04:05:00	SPY	ETF	302.13	302.15	302.06	302.06	1005.0
2020-05-27 04:06:00	SPY	ETF	302.09	302.09	302.09	302.09	118.0
2020-05-27 04:07:00	SPY	ETF	302.11	302.17	302.1	302.1	3492.0
2020-05-27 04:10:00	SPY	ETF	301.99	302.04	301.98	302.04	2565.0
2020-05-27 04:11:00	SPY	ETF	301.99	302.16	301.99	302.16	4851.0
2020-05-27 04:12:00	SPY	ETF	302.12	302.12	302.09	302.09	1510.0
2020-05-27 04:14:00	SPY	ETF	302.14	302.14	302.12	302.12	1420.0
2020-05-27 04:15:00	SPY	ETF	302.02	302.09	302.02	302.09	660.0
2020-05-27 04:16:00	SPY	ETF	302.06	302.09	302.06	302.06	1780.0
2020-05-27 04:17:00	SPY	ETF	302.09	302.09	302.09	302.09	110.0
2020-05-27 04:18:00	SPY	ETF	302.15	302.24	302.15	302.24	2520.0
2020-05-27 04:19:00	SPY	ETF	302.19	302.19	302.19	302.19	100.0
2020-05-27 04:20:00	SPY	ETF	302.12	302.16	302.12	302.16	950.0
2020-05-27 04:22:00	SPY	ETF	302.18	302.23	302.18	302.23	253.0
2020-05-27 04:23:00	SPY	ETF	302.24	302.24	302.24	302.24	230.0
2020-05-27 04:24:00	SPY	ETF	302.21	302.21	302.17	302.17	1662.0
2020-05-27 04:25:00	SPY	ETF	302.1	302.14	302.1	302.1	1010.0
2020-05-27 04:26:00	SPY	ETF	302.06	302.06	301.92	301.92	2585.0
2020-05-27 04:27:00	SPY	ETF	301.87	301.95	301.84	301.95	1314.0
2020-05-27 04:28:00	SPY	ETF	301.82	301.9	301.79	301.9	1690.0
2020-05-27 04:30:00	SPY	ETF	301.99	302.2	301.99	302.16	2469.0
2020-05-27 04:31:00	SPY	ETF	302.14	302.14	302.14	302.14	465.0
2020-05-27 04:32:00	SPY	ETF	302.01	302.01	302.01	302.01	1000.0
2020-05-27 04:33:00	SPY	ETF	302.04	302.07	302.04	302.07	1000.0
2020-05-27 04:36:00	SPY	ETF	302.2	302.2	302.2	302.2	423.0
2020-05-27 04:37:00	SPY	ETF	302.33	302.4	302.31	302.31	7886.0
2020-05-27 04:38:00	SPY	ETF	302.37	302.39	302.31	302.31	5480.0
2020-05-27 04:39:00	SPY	ETF	302.44	302.6	302.44	302.52	6679.0
2020-05-27 04:40:00	SPY	ETF	302.42	302.5	302.42	302.5	637.0
2020-05-27 04:41:00	SPY	ETF	302.47	302.54	302.47	302.53	500.0
2020-05-27 04:42:00	SPY	ETF	302.57	302.57	302.57	302.57	907.0
2020-05-27 04:43:00	SPY	ETF	302.56	302.59	302.56	302.59	404.0
2020-05-27 04:44:00	SPY	ETF	302.57	302.57	302.54	302.54	1573.0
2020-05-27 04:45:00	SPY	ETF	302.53	302.58	302.53	302.58	315.0
2020-05-27 04:48:00	SPY	ETF	302.5	302.55	302.5	302.54	2207.0
2020-05-27 04:49:00	SPY	ETF	302.6	302.67	302.55	302.67	16404.0
2020-05-27 04:50:00	SPY	ETF	302.69	302.69	302.69	302.69	139.0
2020-05-27 04:52:00	SPY	ETF	302.64	302.64	302.64	302.64	500.0
2020-05-27 04:54:00	SPY	ETF	302.59	302.59	302.57	302.59	2552.0
2020-05-27 04:55:00	SPY	ETF	302.6	302.6	302.6	302.6	2100.0
2020-05-27 04:56:00	SPY	ETF	302.64	302.64	302.64	302.64	235.0
2020-05-27 04:57:00	SPY	ETF	302.62	302.63	302.62	302.63	300.0
2020-05-27 04:58:00	SPY	ETF	302.6	302.6	302.6	302.6	100.0
2020-05-27 04:59:00	SPY	ETF	302.65	302.71	302.64	302.64	1600.0
2020-05-27 05:01:00	SPY	ETF	302.71	302.71	302.71	302.71	483.0
2020-05-27 05:02:00	SPY	ETF	302.7	302.7	302.69	302.69	5415.0

> showing 50 of 222,412 rows — these rows as CSV

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