PREVIEW / stock_1min / 2020-03-17

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-03-17.parquet
  size:    21.9 MB
  rows:    1,426,428
  symbols: 2,078

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-03-17 04:00:00	AAPL	Stock	63.35	64.0	63.35	63.925	4996.0
2020-03-17 04:01:00	AAPL	Stock	64.175	64.36	64.175	64.225	1300.0
2020-03-17 04:02:00	AAPL	Stock	64.15	64.415	64.05	64.125	7652.0
2020-03-17 04:03:00	AAPL	Stock	64.35	64.415	64.2925	64.2925	3432.0
2020-03-17 04:04:00	AAPL	Stock	64.0525	64.29	64.0525	64.29	21428.0
2020-03-17 04:05:00	AAPL	Stock	64.2525	64.255	64.2525	64.255	1572.0
2020-03-17 04:06:00	AAPL	Stock	64.255	64.255	64.255	64.255	400.0
2020-03-17 04:07:00	AAPL	Stock	64.415	64.525	64.415	64.525	3572.0
2020-03-17 04:08:00	AAPL	Stock	64.555	64.595	64.5	64.595	2476.0
2020-03-17 04:09:00	AAPL	Stock	64.625	64.7	64.625	64.6275	10400.0
2020-03-17 04:10:00	AAPL	Stock	64.625	64.6275	64.625	64.6275	35748.0
2020-03-17 04:11:00	AAPL	Stock	64.625	64.625	64.2575	64.2575	28948.0
2020-03-17 04:12:00	AAPL	Stock	64.3125	64.3125	64.3125	64.3125	400.0
2020-03-17 04:13:00	AAPL	Stock	64.3625	64.3625	64.3625	64.3625	400.0
2020-03-17 04:14:00	AAPL	Stock	64.575	64.625	64.4525	64.4525	5348.0
2020-03-17 04:15:00	AAPL	Stock	64.585	64.6	64.5	64.5	9684.0
2020-03-17 04:16:00	AAPL	Stock	64.5	64.5125	64.5	64.5125	1200.0
2020-03-17 04:17:00	AAPL	Stock	64.325	64.325	64.28	64.28	988.0
2020-03-17 04:19:00	AAPL	Stock	64.4375	64.4575	64.4375	64.4375	5860.0
2020-03-17 04:21:00	AAPL	Stock	64.32	64.3275	64.315	64.3275	4200.0
2020-03-17 04:22:00	AAPL	Stock	64.28	64.28	64.16	64.16	3800.0
2020-03-17 04:23:00	AAPL	Stock	64.0625	64.0725	63.975	64.0725	7044.0
2020-03-17 04:25:00	AAPL	Stock	63.9925	63.9925	63.75	63.75	2368.0
2020-03-17 04:26:00	AAPL	Stock	63.7525	63.755	63.3125	63.675	11720.0
2020-03-17 04:27:00	AAPL	Stock	63.5025	63.63	63.375	63.63	2200.0
2020-03-17 04:28:00	AAPL	Stock	63.625	63.8275	63.625	63.8225	2308.0
2020-03-17 04:29:00	AAPL	Stock	63.7575	63.7625	63.58	63.58	13068.0
2020-03-17 04:30:00	AAPL	Stock	63.6	63.63	63.475	63.5	12076.0
2020-03-17 04:31:00	AAPL	Stock	63.5	63.6	63.5	63.5	5200.0
2020-03-17 04:32:00	AAPL	Stock	63.625	63.75	63.625	63.75	2840.0
2020-03-17 04:33:00	AAPL	Stock	63.72	63.72	63.72	63.72	400.0
2020-03-17 04:34:00	AAPL	Stock	63.6125	63.7425	63.5	63.6075	7076.0
2020-03-17 04:35:00	AAPL	Stock	63.5925	63.5925	63.5925	63.5925	400.0
2020-03-17 04:36:00	AAPL	Stock	63.5575	63.5575	63.5575	63.5575	1448.0
2020-03-17 04:37:00	AAPL	Stock	63.6475	63.6475	63.39	63.39	5616.0
2020-03-17 04:38:00	AAPL	Stock	63.39	63.39	63.38	63.38	1600.0
2020-03-17 04:39:00	AAPL	Stock	63.3275	63.3275	63.3275	63.3275	400.0
2020-03-17 04:40:00	AAPL	Stock	63.34	63.34	63.15	63.25	4680.0
2020-03-17 04:42:00	AAPL	Stock	63.065	63.075	62.8875	62.8875	1928.0
2020-03-17 04:43:00	AAPL	Stock	62.9125	63.0575	62.9125	63.0575	2400.0
2020-03-17 04:44:00	AAPL	Stock	63.0	63.0	63.0	63.0	2800.0
2020-03-17 04:45:00	AAPL	Stock	63.1	63.1	63.1	63.1	400.0
2020-03-17 04:46:00	AAPL	Stock	62.95	62.95	62.95	62.95	1920.0
2020-03-17 04:47:00	AAPL	Stock	62.975	63.0375	62.975	63.0375	2820.0
2020-03-17 04:49:00	AAPL	Stock	62.975	62.975	62.9	62.9	1200.0
2020-03-17 04:50:00	AAPL	Stock	62.7575	62.7575	62.525	62.5375	2920.0
2020-03-17 04:51:00	AAPL	Stock	62.625	62.75	62.625	62.75	800.0
2020-03-17 04:52:00	AAPL	Stock	62.7725	62.7725	62.7725	62.7725	400.0
2020-03-17 04:53:00	AAPL	Stock	62.6025	62.6025	62.5825	62.5875	14356.0
2020-03-17 04:54:00	AAPL	Stock	62.5425	62.5425	62.455	62.455	27932.0

> showing 50 of 1,426,428 rows — these rows as CSV

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