PREVIEW / stock_1min / 2020-08-24

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-08-24.parquet
  size:    20.5 MB
  rows:    1,269,140
  symbols: 2,070

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-08-24 04:00:00	AAPL	Stock	126.525	126.75	126.525	126.75	18820.0
2020-08-24 04:01:00	AAPL	Stock	126.65	126.74	126.61	126.61	18924.0
2020-08-24 04:02:00	AAPL	Stock	126.415	126.625	126.415	126.4325	8236.0
2020-08-24 04:03:00	AAPL	Stock	126.5	126.5	126.5	126.5	1580.0
2020-08-24 04:04:00	AAPL	Stock	126.5	126.5	126.5	126.5	1200.0
2020-08-24 04:05:00	AAPL	Stock	126.5	126.5	126.495	126.495	18764.0
2020-08-24 04:06:00	AAPL	Stock	126.44	126.44	126.4	126.435	6696.0
2020-08-24 04:07:00	AAPL	Stock	126.4	126.4	126.375	126.395	4760.0
2020-08-24 04:08:00	AAPL	Stock	126.3375	126.36	126.25	126.25	11968.0
2020-08-24 04:09:00	AAPL	Stock	126.2	126.2	126.1875	126.1875	800.0
2020-08-24 04:10:00	AAPL	Stock	126.2525	126.2525	126.2525	126.2525	452.0
2020-08-24 04:11:00	AAPL	Stock	126.2175	126.2175	126.1875	126.2	7056.0
2020-08-24 04:12:00	AAPL	Stock	126.1875	126.19	126.1875	126.1875	11520.0
2020-08-24 04:13:00	AAPL	Stock	126.2475	126.2475	126.2475	126.2475	1600.0
2020-08-24 04:14:00	AAPL	Stock	126.205	126.205	126.1875	126.1875	800.0
2020-08-24 04:15:00	AAPL	Stock	126.1875	126.1875	126.1875	126.1875	400.0
2020-08-24 04:16:00	AAPL	Stock	126.2025	126.2025	126.1875	126.1875	5228.0
2020-08-24 04:17:00	AAPL	Stock	126.145	126.15	126.13	126.15	1600.0
2020-08-24 04:18:00	AAPL	Stock	126.1275	126.1275	126.1275	126.1275	2700.0
2020-08-24 04:19:00	AAPL	Stock	126.1875	126.22	126.1875	126.1875	7840.0
2020-08-24 04:20:00	AAPL	Stock	126.1875	126.1875	126.1875	126.1875	1928.0
2020-08-24 04:22:00	AAPL	Stock	126.1875	126.1875	126.1875	126.1875	4424.0
2020-08-24 04:23:00	AAPL	Stock	126.1875	126.2025	126.1875	126.1875	4460.0
2020-08-24 04:24:00	AAPL	Stock	126.185	126.1875	126.185	126.1875	1288.0
2020-08-24 04:25:00	AAPL	Stock	126.23	126.2825	126.23	126.2825	1928.0
2020-08-24 04:26:00	AAPL	Stock	126.325	126.34	126.325	126.325	2000.0
2020-08-24 04:27:00	AAPL	Stock	126.34	126.34	126.34	126.34	880.0
2020-08-24 04:29:00	AAPL	Stock	126.425	126.425	126.425	126.425	800.0
2020-08-24 04:30:00	AAPL	Stock	126.4	126.4	126.25	126.25	4428.0
2020-08-24 04:31:00	AAPL	Stock	126.4	126.4225	126.4	126.4225	3560.0
2020-08-24 04:32:00	AAPL	Stock	126.6125	126.6125	126.6125	126.6125	456.0
2020-08-24 04:33:00	AAPL	Stock	126.5925	126.6	126.55	126.6	2192.0
2020-08-24 04:34:00	AAPL	Stock	126.5925	126.5925	126.5925	126.5925	400.0
2020-08-24 04:36:00	AAPL	Stock	126.625	126.625	126.625	126.625	1200.0
2020-08-24 04:37:00	AAPL	Stock	126.7325	126.7325	126.7025	126.7025	1080.0
2020-08-24 04:38:00	AAPL	Stock	126.6275	126.6275	126.6125	126.6125	2152.0
2020-08-24 04:40:00	AAPL	Stock	126.6025	126.65	126.6025	126.65	1920.0
2020-08-24 04:42:00	AAPL	Stock	126.6975	126.775	126.6975	126.775	3884.0
2020-08-24 04:43:00	AAPL	Stock	126.79	126.86	126.79	126.86	2000.0
2020-08-24 04:44:00	AAPL	Stock	126.965	126.965	126.875	126.875	13144.0
2020-08-24 04:45:00	AAPL	Stock	126.8525	126.92	126.8525	126.88	3200.0
2020-08-24 04:46:00	AAPL	Stock	126.95	126.9675	126.95	126.9675	1200.0
2020-08-24 04:47:00	AAPL	Stock	126.9625	126.9625	126.9625	126.9625	3308.0
2020-08-24 04:49:00	AAPL	Stock	127.0125	127.085	127.0125	127.085	4668.0
2020-08-24 04:50:00	AAPL	Stock	127.1125	127.15	127.1125	127.1275	3312.0
2020-08-24 04:51:00	AAPL	Stock	127.1	127.1	127.04	127.09	4488.0
2020-08-24 04:52:00	AAPL	Stock	127.02	127.02	127.02	127.02	400.0
2020-08-24 04:53:00	AAPL	Stock	127.035	127.075	127.035	127.075	2000.0
2020-08-24 04:54:00	AAPL	Stock	127.075	127.08	127.075	127.08	836.0
2020-08-24 04:56:00	AAPL	Stock	127.0975	127.0975	127.0975	127.0975	400.0

> showing 50 of 1,269,140 rows — these rows as CSV

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