PREVIEW / etf_1min / 2019-08-08

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-08.parquet
  size:    3.4 MB
  rows:    179,298

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
2019-08-08 04:00:00	SPY	ETF	288.7	288.7	288.69	288.69	836.0
2019-08-08 04:01:00	SPY	ETF	288.68	288.7	288.68	288.68	7000.0
2019-08-08 04:02:00	SPY	ETF	288.71	288.71	288.71	288.71	120.0
2019-08-08 04:05:00	SPY	ETF	288.67	288.67	288.67	288.67	310.0
2019-08-08 04:07:00	SPY	ETF	288.58	288.58	288.58	288.58	121.0
2019-08-08 04:08:00	SPY	ETF	288.6	288.6	288.57	288.57	574.0
2019-08-08 04:12:00	SPY	ETF	288.23	288.23	288.23	288.23	272.0
2019-08-08 04:13:00	SPY	ETF	288.18	288.18	288.18	288.18	400.0
2019-08-08 04:15:00	SPY	ETF	287.89	287.89	287.88	287.88	1800.0
2019-08-08 04:16:00	SPY	ETF	287.97	287.97	287.97	287.97	120.0
2019-08-08 04:20:00	SPY	ETF	288.23	288.25	288.23	288.25	970.0
2019-08-08 04:22:00	SPY	ETF	288.3	288.3	288.3	288.3	500.0
2019-08-08 04:25:00	SPY	ETF	288.27	288.27	288.2	288.25	2210.0
2019-08-08 04:27:00	SPY	ETF	288.3	288.3	288.3	288.3	305.0
2019-08-08 04:28:00	SPY	ETF	288.35	288.35	288.35	288.35	170.0
2019-08-08 04:29:00	SPY	ETF	288.42	288.42	288.42	288.42	301.0
2019-08-08 04:33:00	SPY	ETF	288.55	288.55	288.55	288.55	224.0
2019-08-08 04:34:00	SPY	ETF	288.6	288.6	288.6	288.6	500.0
2019-08-08 04:40:00	SPY	ETF	288.4	288.4	288.4	288.4	300.0
2019-08-08 04:41:00	SPY	ETF	288.42	288.45	288.42	288.45	705.0
2019-08-08 04:43:00	SPY	ETF	288.49	288.49	288.49	288.49	500.0
2019-08-08 04:46:00	SPY	ETF	288.64	288.82	288.64	288.78	2253.0
2019-08-08 04:51:00	SPY	ETF	288.7	288.7	288.7	288.7	100.0
2019-08-08 04:54:00	SPY	ETF	288.55	288.63	288.55	288.63	1000.0
2019-08-08 05:00:00	SPY	ETF	288.62	288.62	288.62	288.62	100.0
2019-08-08 05:01:00	SPY	ETF	288.4	288.4	288.4	288.4	1005.0
2019-08-08 05:02:00	SPY	ETF	288.54	288.55	288.54	288.54	900.0
2019-08-08 05:05:00	SPY	ETF	288.7	288.72	288.7	288.72	2034.0
2019-08-08 05:06:00	SPY	ETF	288.86	288.86	288.8	288.85	3211.0
2019-08-08 05:08:00	SPY	ETF	288.82	288.82	288.82	288.82	1901.0
2019-08-08 05:11:00	SPY	ETF	288.71	288.71	288.71	288.71	300.0
2019-08-08 05:14:00	SPY	ETF	288.78	288.78	288.78	288.78	100.0
2019-08-08 05:15:00	SPY	ETF	288.79	288.79	288.79	288.79	610.0
2019-08-08 05:16:00	SPY	ETF	288.94	288.94	288.94	288.94	670.0
2019-08-08 05:17:00	SPY	ETF	288.75	288.75	288.75	288.75	900.0
2019-08-08 05:18:00	SPY	ETF	288.85	288.87	288.85	288.87	700.0
2019-08-08 05:20:00	SPY	ETF	288.95	289.0	288.95	289.0	314.0
2019-08-08 05:21:00	SPY	ETF	289.01	289.04	289.01	289.04	300.0
2019-08-08 05:22:00	SPY	ETF	289.0	289.0	289.0	289.0	496.0
2019-08-08 05:23:00	SPY	ETF	289.03	289.03	288.97	288.97	1252.0
2019-08-08 05:24:00	SPY	ETF	288.87	288.87	288.87	288.87	300.0
2019-08-08 05:26:00	SPY	ETF	288.74	288.74	288.6	288.6	815.0
2019-08-08 05:32:00	SPY	ETF	288.6	288.6	288.58	288.6	2000.0
2019-08-08 05:33:00	SPY	ETF	288.64	288.64	288.64	288.64	600.0
2019-08-08 05:34:00	SPY	ETF	288.63	288.63	288.63	288.63	300.0
2019-08-08 05:38:00	SPY	ETF	288.82	288.82	288.82	288.82	101.0
2019-08-08 05:42:00	SPY	ETF	288.9	288.9	288.9	288.9	100.0
2019-08-08 05:47:00	SPY	ETF	288.74	288.74	288.74	288.74	1100.0
2019-08-08 05:48:00	SPY	ETF	288.78	288.78	288.78	288.78	100.0
2019-08-08 05:50:00	SPY	ETF	288.79	288.8	288.79	288.8	1500.0

> showing 50 of 179,298 rows — these rows as CSV

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