PREVIEW / stock_1min / 2020-04-20

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-04-20.parquet
  size:    19.8 MB
  rows:    1,275,716
  symbols: 2,031

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-20 04:00:00	AAPL	Stock	70.68	70.68	70.5	70.5	4188.0
2020-04-20 04:04:00	AAPL	Stock	70.375	70.425	70.375	70.425	1200.0
2020-04-20 04:06:00	AAPL	Stock	70.3	70.3	70.3	70.3	400.0
2020-04-20 04:09:00	AAPL	Stock	70.3725	70.3725	70.3725	70.3725	1288.0
2020-04-20 04:12:00	AAPL	Stock	70.26	70.26	70.26	70.26	860.0
2020-04-20 04:13:00	AAPL	Stock	70.25	70.25	70.25	70.25	980.0
2020-04-20 04:14:00	AAPL	Stock	70.25	70.25	70.25	70.25	1172.0
2020-04-20 04:18:00	AAPL	Stock	70.175	70.175	70.15	70.15	1044.0
2020-04-20 04:19:00	AAPL	Stock	70.125	70.1475	70.125	70.125	1600.0
2020-04-20 04:21:00	AAPL	Stock	70.125	70.125	70.125	70.125	1200.0
2020-04-20 04:22:00	AAPL	Stock	70.125	70.125	70.125	70.125	1864.0
2020-04-20 04:23:00	AAPL	Stock	70.1	70.1	70.1	70.1	2864.0
2020-04-20 04:24:00	AAPL	Stock	70.0	70.0	70.0	70.0	400.0
2020-04-20 04:32:00	AAPL	Stock	70.0025	70.0025	70.0025	70.0025	400.0
2020-04-20 04:36:00	AAPL	Stock	70.025	70.025	70.025	70.025	400.0
2020-04-20 04:37:00	AAPL	Stock	70.075	70.075	70.075	70.075	540.0
2020-04-20 04:39:00	AAPL	Stock	70.075	70.075	70.075	70.075	400.0
2020-04-20 04:43:00	AAPL	Stock	70.0875	70.0875	70.025	70.025	800.0
2020-04-20 04:46:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	400.0
2020-04-20 05:06:00	AAPL	Stock	70.25	70.25	70.09	70.105	3656.0
2020-04-20 05:16:00	AAPL	Stock	70.1575	70.1575	70.1575	70.1575	400.0
2020-04-20 05:33:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	532.0
2020-04-20 05:35:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	800.0
2020-04-20 05:42:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	696.0
2020-04-20 05:51:00	AAPL	Stock	70.075	70.075	70.075	70.075	1044.0
2020-04-20 06:07:00	AAPL	Stock	69.8775	69.8775	69.775	69.775	4364.0
2020-04-20 06:11:00	AAPL	Stock	69.775	69.775	69.75	69.75	1240.0
2020-04-20 06:16:00	AAPL	Stock	69.8175	69.8375	69.8175	69.8375	1120.0
2020-04-20 06:17:00	AAPL	Stock	69.7625	69.7625	69.7625	69.7625	400.0
2020-04-20 06:22:00	AAPL	Stock	69.6925	69.6925	69.6925	69.6925	400.0
2020-04-20 06:25:00	AAPL	Stock	69.575	69.575	69.575	69.575	1200.0
2020-04-20 06:27:00	AAPL	Stock	69.55	69.55	69.55	69.55	440.0
2020-04-20 06:30:00	AAPL	Stock	69.6175	69.6175	69.6175	69.6175	836.0
2020-04-20 06:31:00	AAPL	Stock	69.73	69.75	69.73	69.75	2072.0
2020-04-20 06:35:00	AAPL	Stock	69.8	69.8375	69.8	69.8375	1488.0
2020-04-20 06:36:00	AAPL	Stock	69.7975	69.7975	69.7975	69.7975	600.0
2020-04-20 06:37:00	AAPL	Stock	69.7975	69.7975	69.7975	69.7975	580.0
2020-04-20 06:38:00	AAPL	Stock	69.825	69.825	69.75	69.75	1600.0
2020-04-20 06:41:00	AAPL	Stock	69.855	69.855	69.855	69.855	800.0
2020-04-20 06:43:00	AAPL	Stock	69.7875	69.7875	69.7875	69.7875	776.0
2020-04-20 06:44:00	AAPL	Stock	69.7875	69.7875	69.7775	69.7775	828.0
2020-04-20 06:46:00	AAPL	Stock	69.75	69.75	69.75	69.75	800.0
2020-04-20 06:53:00	AAPL	Stock	69.69	69.69	69.69	69.69	1744.0
2020-04-20 06:59:00	AAPL	Stock	69.655	69.655	69.655	69.655	400.0
2020-04-20 07:00:00	AAPL	Stock	69.75	69.8125	69.65	69.7525	8776.0
2020-04-20 07:01:00	AAPL	Stock	69.7675	69.85	69.7525	69.85	11672.0
2020-04-20 07:02:00	AAPL	Stock	69.85	69.935	69.85	69.935	8012.0
2020-04-20 07:03:00	AAPL	Stock	69.9125	69.935	69.9125	69.935	5560.0
2020-04-20 07:04:00	AAPL	Stock	69.935	69.935	69.935	69.935	600.0
2020-04-20 07:05:00	AAPL	Stock	69.9125	69.935	69.88	69.88	5720.0

> showing 50 of 1,275,716 rows — these rows as CSV

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