PREVIEW / etf_1min / 2020-06-11

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-06-11.parquet
  size:    4.8 MB
  rows:    258,639

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-06-11 04:00:00	SPY	ETF	313.45	313.45	312.8	312.81	27335.0
2020-06-11 04:01:00	SPY	ETF	312.84	312.98	312.81	312.98	4694.0
2020-06-11 04:02:00	SPY	ETF	312.98	313.17	312.98	313.13	9063.0
2020-06-11 04:03:00	SPY	ETF	313.06	313.06	312.97	312.97	5727.0
2020-06-11 04:04:00	SPY	ETF	312.94	313.0	312.94	312.96	1474.0
2020-06-11 04:05:00	SPY	ETF	313.13	313.15	313.01	313.12	2478.0
2020-06-11 04:06:00	SPY	ETF	313.07	313.4	313.04	313.4	6279.0
2020-06-11 04:07:00	SPY	ETF	313.41	313.5	313.4	313.5	3777.0
2020-06-11 04:08:00	SPY	ETF	313.45	313.54	313.37	313.37	7847.0
2020-06-11 04:09:00	SPY	ETF	313.35	313.39	313.35	313.39	12550.0
2020-06-11 04:10:00	SPY	ETF	313.48	313.53	313.42	313.53	2133.0
2020-06-11 04:11:00	SPY	ETF	313.55	313.6	313.49	313.49	5102.0
2020-06-11 04:12:00	SPY	ETF	313.4	313.4	313.33	313.37	1774.0
2020-06-11 04:13:00	SPY	ETF	313.58	313.7	313.58	313.62	2470.0
2020-06-11 04:14:00	SPY	ETF	313.62	313.8	313.62	313.64	821.0
2020-06-11 04:15:00	SPY	ETF	313.56	313.56	313.56	313.56	187.0
2020-06-11 04:16:00	SPY	ETF	313.48	313.51	313.47	313.51	2000.0
2020-06-11 04:17:00	SPY	ETF	313.46	313.62	313.44	313.62	5170.0
2020-06-11 04:18:00	SPY	ETF	313.69	313.69	313.69	313.69	437.0
2020-06-11 04:19:00	SPY	ETF	313.71	313.71	313.6	313.6	1120.0
2020-06-11 04:20:00	SPY	ETF	313.63	313.63	313.63	313.63	130.0
2020-06-11 04:21:00	SPY	ETF	313.56	313.56	313.56	313.56	145.0
2020-06-11 04:22:00	SPY	ETF	313.55	313.59	313.55	313.59	1331.0
2020-06-11 04:24:00	SPY	ETF	313.6	313.67	313.6	313.61	3794.0
2020-06-11 04:25:00	SPY	ETF	313.67	313.67	313.67	313.67	125.0
2020-06-11 04:26:00	SPY	ETF	313.69	313.72	313.63	313.64	5200.0
2020-06-11 04:29:00	SPY	ETF	313.4	313.4	313.3	313.3	5241.0
2020-06-11 04:30:00	SPY	ETF	313.32	313.32	313.27	313.27	399.0
2020-06-11 04:31:00	SPY	ETF	313.48	313.48	313.48	313.48	225.0
2020-06-11 04:32:00	SPY	ETF	313.49	313.52	313.49	313.52	450.0
2020-06-11 04:33:00	SPY	ETF	313.7	313.74	313.7	313.74	5520.0
2020-06-11 04:34:00	SPY	ETF	313.71	313.71	313.67	313.67	1160.0
2020-06-11 04:35:00	SPY	ETF	313.7	313.87	313.7	313.87	5302.0
2020-06-11 04:36:00	SPY	ETF	313.84	313.84	313.79	313.83	2850.0
2020-06-11 04:37:00	SPY	ETF	313.84	313.87	313.82	313.82	6652.0
2020-06-11 04:38:00	SPY	ETF	313.74	313.74	313.68	313.73	7323.0
2020-06-11 04:39:00	SPY	ETF	313.61	313.61	313.61	313.61	353.0
2020-06-11 04:40:00	SPY	ETF	313.44	313.5	313.37	313.37	7580.0
2020-06-11 04:41:00	SPY	ETF	313.13	313.18	313.12	313.15	1913.0
2020-06-11 04:42:00	SPY	ETF	313.08	313.08	312.92	312.92	813.0
2020-06-11 04:43:00	SPY	ETF	312.87	312.92	312.8	312.92	1312.0
2020-06-11 04:44:00	SPY	ETF	312.93	312.93	312.85	312.92	2300.0
2020-06-11 04:45:00	SPY	ETF	312.82	312.83	312.82	312.83	1325.0
2020-06-11 04:46:00	SPY	ETF	312.82	312.82	312.57	312.57	1943.0
2020-06-11 04:47:00	SPY	ETF	312.64	312.72	312.61	312.61	2997.0
2020-06-11 04:48:00	SPY	ETF	312.62	312.7	312.6	312.7	10406.0
2020-06-11 04:49:00	SPY	ETF	312.72	312.77	312.68	312.74	3812.0
2020-06-11 04:50:00	SPY	ETF	312.6	312.62	312.57	312.61	1401.0
2020-06-11 04:51:00	SPY	ETF	312.5	312.5	312.37	312.39	9543.0
2020-06-11 04:52:00	SPY	ETF	312.34	312.63	312.34	312.61	18431.0

> showing 50 of 258,639 rows — these rows as CSV

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