PREVIEW / etf_1min / 2019-08-06

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-06.parquet
  size:    3.6 MB
  rows:    189,675

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-06 04:00:00	SPY	ETF	283.68	283.83	283.6	283.81	19970.0
2019-08-06 04:01:00	SPY	ETF	283.81	283.81	283.44	283.44	2595.0
2019-08-06 04:02:00	SPY	ETF	283.37	283.4	283.22	283.25	4291.0
2019-08-06 04:03:00	SPY	ETF	283.2	283.25	283.17	283.2	2289.0
2019-08-06 04:04:00	SPY	ETF	283.22	283.29	283.19	283.27	2800.0
2019-08-06 04:05:00	SPY	ETF	283.28	283.42	283.28	283.42	4300.0
2019-08-06 04:07:00	SPY	ETF	283.28	283.47	283.27	283.47	3000.0
2019-08-06 04:08:00	SPY	ETF	283.46	283.63	283.46	283.63	5461.0
2019-08-06 04:09:00	SPY	ETF	283.63	283.63	283.57	283.58	6050.0
2019-08-06 04:10:00	SPY	ETF	283.51	283.7	283.51	283.7	224.0
2019-08-06 04:11:00	SPY	ETF	283.64	283.65	283.64	283.65	2100.0
2019-08-06 04:12:00	SPY	ETF	283.5	283.52	283.5	283.52	5500.0
2019-08-06 04:15:00	SPY	ETF	283.65	283.65	283.57	283.61	600.0
2019-08-06 04:16:00	SPY	ETF	283.72	283.81	283.72	283.81	1000.0
2019-08-06 04:17:00	SPY	ETF	283.84	283.92	283.82	283.92	4000.0
2019-08-06 04:18:00	SPY	ETF	283.99	284.05	283.99	284.05	9420.0
2019-08-06 04:19:00	SPY	ETF	284.05	284.1	284.04	284.04	2145.0
2019-08-06 04:20:00	SPY	ETF	284.07	284.14	284.07	284.12	1034.0
2019-08-06 04:21:00	SPY	ETF	284.22	284.25	284.22	284.25	500.0
2019-08-06 04:23:00	SPY	ETF	284.35	284.35	284.35	284.35	150.0
2019-08-06 04:24:00	SPY	ETF	284.43	284.43	284.37	284.42	3170.0
2019-08-06 04:25:00	SPY	ETF	284.3	284.37	284.3	284.34	1308.0
2019-08-06 04:26:00	SPY	ETF	284.39	284.5	284.39	284.5	2338.0
2019-08-06 04:27:00	SPY	ETF	284.6	284.62	284.6	284.6	1300.0
2019-08-06 04:28:00	SPY	ETF	284.62	285.0	284.6	284.99	6993.0
2019-08-06 04:29:00	SPY	ETF	285.1	285.15	285.0	285.02	1614.0
2019-08-06 04:30:00	SPY	ETF	285.02	285.02	284.94	284.94	1883.0
2019-08-06 04:31:00	SPY	ETF	284.96	284.98	284.96	284.98	1330.0
2019-08-06 04:32:00	SPY	ETF	284.92	284.92	284.89	284.89	2214.0
2019-08-06 04:33:00	SPY	ETF	284.94	284.94	284.9	284.9	415.0
2019-08-06 04:34:00	SPY	ETF	284.98	284.98	284.8	284.8	580.0
2019-08-06 04:35:00	SPY	ETF	284.82	284.89	284.82	284.89	1470.0
2019-08-06 04:36:00	SPY	ETF	284.84	284.92	284.84	284.92	980.0
2019-08-06 04:37:00	SPY	ETF	284.96	284.96	284.96	284.96	435.0
2019-08-06 04:38:00	SPY	ETF	284.98	285.06	284.98	285.06	605.0
2019-08-06 04:39:00	SPY	ETF	285.07	285.12	285.06	285.08	4349.0
2019-08-06 04:40:00	SPY	ETF	285.13	285.13	285.13	285.13	655.0
2019-08-06 04:43:00	SPY	ETF	285.0	285.0	285.0	285.0	290.0
2019-08-06 04:44:00	SPY	ETF	284.97	285.03	284.93	285.03	1262.0
2019-08-06 04:45:00	SPY	ETF	285.13	285.18	285.13	285.15	2125.0
2019-08-06 04:47:00	SPY	ETF	285.03	285.03	285.03	285.03	490.0
2019-08-06 04:48:00	SPY	ETF	285.1	285.1	285.1	285.1	2041.0
2019-08-06 04:49:00	SPY	ETF	285.17	285.17	285.14	285.14	5075.0
2019-08-06 04:50:00	SPY	ETF	285.15	285.19	285.15	285.19	1161.0
2019-08-06 04:51:00	SPY	ETF	285.03	285.03	285.03	285.03	160.0
2019-08-06 04:52:00	SPY	ETF	285.05	285.15	285.05	285.15	1120.0
2019-08-06 04:53:00	SPY	ETF	285.06	285.07	285.06	285.06	3080.0
2019-08-06 04:54:00	SPY	ETF	285.07	285.07	285.07	285.07	2060.0
2019-08-06 04:55:00	SPY	ETF	285.06	285.12	285.06	285.12	1040.0
2019-08-06 04:56:00	SPY	ETF	285.04	285.04	285.04	285.04	100.0

> showing 50 of 189,675 rows — these rows as CSV

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