PREVIEW / stock_1min / 2020-03-20

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-03-20.parquet
  size:    21.1 MB
  rows:    1,427,630
  symbols: 2,076

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-20 04:00:00	AAPL	Stock	63.525	64.18	63.275	64.1075	15492.0
2020-03-20 04:01:00	AAPL	Stock	64.1	64.1	63.8	63.8	5260.0
2020-03-20 04:02:00	AAPL	Stock	63.2575	63.75	63.25	63.75	3640.0
2020-03-20 04:03:00	AAPL	Stock	64.0	64.175	64.0	64.175	1600.0
2020-03-20 04:04:00	AAPL	Stock	64.175	64.25	64.13	64.25	8788.0
2020-03-20 04:05:00	AAPL	Stock	64.195	64.4975	64.195	64.4	17324.0
2020-03-20 04:06:00	AAPL	Stock	64.25	64.4	64.25	64.375	7856.0
2020-03-20 04:07:00	AAPL	Stock	64.375	64.375	64.375	64.375	404.0
2020-03-20 04:08:00	AAPL	Stock	64.3725	64.3725	64.3725	64.3725	400.0
2020-03-20 04:09:00	AAPL	Stock	64.37	64.37	64.3	64.3	1600.0
2020-03-20 04:10:00	AAPL	Stock	64.3725	64.3725	64.25	64.25	3520.0
2020-03-20 04:11:00	AAPL	Stock	64.3625	64.375	64.3625	64.375	1904.0
2020-03-20 04:12:00	AAPL	Stock	64.4225	64.43	64.4225	64.425	1600.0
2020-03-20 04:13:00	AAPL	Stock	64.4975	64.6	64.4975	64.6	4796.0
2020-03-20 04:14:00	AAPL	Stock	64.6	64.6	64.6	64.6	400.0
2020-03-20 04:15:00	AAPL	Stock	64.5	64.5	64.4025	64.4025	4000.0
2020-03-20 04:16:00	AAPL	Stock	64.49	64.5025	64.4125	64.4125	4472.0
2020-03-20 04:18:00	AAPL	Stock	64.475	64.475	64.475	64.475	1200.0
2020-03-20 04:19:00	AAPL	Stock	64.475	64.475	64.2775	64.375	5464.0
2020-03-20 04:20:00	AAPL	Stock	64.285	64.285	64.285	64.285	400.0
2020-03-20 04:22:00	AAPL	Stock	64.275	64.275	64.25	64.25	3292.0
2020-03-20 04:23:00	AAPL	Stock	64.245	64.275	64.245	64.275	2200.0
2020-03-20 04:24:00	AAPL	Stock	64.085	64.085	64.085	64.085	400.0
2020-03-20 04:26:00	AAPL	Stock	64.225	64.24	64.225	64.24	800.0
2020-03-20 04:27:00	AAPL	Stock	64.1275	64.1275	64.1275	64.1275	400.0
2020-03-20 04:28:00	AAPL	Stock	64.245	64.3	64.245	64.3	4224.0
2020-03-20 04:29:00	AAPL	Stock	64.25	64.25	64.25	64.25	1200.0
2020-03-20 04:30:00	AAPL	Stock	64.245	64.25	64.245	64.25	1696.0
2020-03-20 04:31:00	AAPL	Stock	64.1325	64.1325	64.1	64.1	4800.0
2020-03-20 04:32:00	AAPL	Stock	63.9875	63.9875	63.825	63.825	1364.0
2020-03-20 04:33:00	AAPL	Stock	63.7175	63.75	63.605	63.75	21288.0
2020-03-20 04:34:00	AAPL	Stock	63.75	63.7525	63.75	63.75	5848.0
2020-03-20 04:35:00	AAPL	Stock	63.8325	63.8325	63.8325	63.8325	464.0
2020-03-20 04:36:00	AAPL	Stock	63.795	63.795	63.755	63.755	1200.0
2020-03-20 04:37:00	AAPL	Stock	63.8125	63.85	63.8125	63.8475	2768.0
2020-03-20 04:38:00	AAPL	Stock	63.8325	63.8325	63.7625	63.7625	1120.0
2020-03-20 04:39:00	AAPL	Stock	63.8125	63.8125	63.75	63.75	1200.0
2020-03-20 04:40:00	AAPL	Stock	63.75	63.75	63.75	63.75	400.0
2020-03-20 04:42:00	AAPL	Stock	63.75	63.75	63.75	63.75	2080.0
2020-03-20 04:45:00	AAPL	Stock	63.7625	63.8375	63.7625	63.8375	800.0
2020-03-20 04:46:00	AAPL	Stock	63.7525	63.85	63.75	63.85	10400.0
2020-03-20 04:47:00	AAPL	Stock	63.945	63.955	63.945	63.95	2200.0
2020-03-20 04:48:00	AAPL	Stock	63.95	64.1	63.95	64.1	1200.0
2020-03-20 04:49:00	AAPL	Stock	64.1	64.1	64.1	64.1	3188.0
2020-03-20 04:50:00	AAPL	Stock	64.02	64.2125	64.0125	64.1625	3600.0
2020-03-20 04:51:00	AAPL	Stock	64.225	64.25	64.225	64.25	8384.0
2020-03-20 04:52:00	AAPL	Stock	64.295	64.2975	64.295	64.2975	800.0
2020-03-20 04:54:00	AAPL	Stock	64.175	64.175	64.1675	64.175	8008.0
2020-03-20 04:55:00	AAPL	Stock	64.2125	64.2125	64.2125	64.2125	892.0
2020-03-20 04:56:00	AAPL	Stock	64.2125	64.255	64.2125	64.25	4456.0

> showing 50 of 1,427,630 rows — these rows as CSV

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