PREVIEW / stock_1min / 2020-04-07

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-04-07.parquet
  size:    20.0 MB
  rows:    1,335,165
  symbols: 2,025

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-07 04:00:00	AAPL	Stock	67.25	67.25	67.0075	67.0075	7540.0
2020-04-07 04:01:00	AAPL	Stock	67.0025	67.005	67.0	67.0	10240.0
2020-04-07 04:02:00	AAPL	Stock	66.9825	67.0	66.9825	67.0	5924.0
2020-04-07 04:03:00	AAPL	Stock	66.9975	66.9975	66.9975	66.9975	440.0
2020-04-07 04:04:00	AAPL	Stock	67.0	67.0	66.7625	66.7625	4548.0
2020-04-07 04:05:00	AAPL	Stock	66.9625	67.0725	66.9625	67.0725	14068.0
2020-04-07 04:06:00	AAPL	Stock	67.055	67.0625	67.0	67.0	4588.0
2020-04-07 04:07:00	AAPL	Stock	67.0	67.0225	67.0	67.0	8240.0
2020-04-07 04:08:00	AAPL	Stock	66.9	66.95	66.9	66.9025	1468.0
2020-04-07 04:09:00	AAPL	Stock	67.0	67.0	67.0	67.0	1900.0
2020-04-07 04:10:00	AAPL	Stock	67.0	67.1	67.0	67.1	1696.0
2020-04-07 04:11:00	AAPL	Stock	67.125	67.125	67.125	67.125	1200.0
2020-04-07 04:12:00	AAPL	Stock	67.15	67.15	67.09	67.15	2800.0
2020-04-07 04:13:00	AAPL	Stock	67.1675	67.1675	67.1675	67.1675	800.0
2020-04-07 04:14:00	AAPL	Stock	67.1925	67.1925	67.125	67.125	7224.0
2020-04-07 04:15:00	AAPL	Stock	67.05	67.125	67.05	67.125	12748.0
2020-04-07 04:17:00	AAPL	Stock	67.13	67.13	67.125	67.125	1568.0
2020-04-07 04:19:00	AAPL	Stock	67.1425	67.1425	67.1425	67.1425	400.0
2020-04-07 04:22:00	AAPL	Stock	67.25	67.25	67.25	67.25	1856.0
2020-04-07 04:24:00	AAPL	Stock	67.3325	67.375	67.3325	67.375	2000.0
2020-04-07 04:25:00	AAPL	Stock	67.445	67.45	67.375	67.375	8300.0
2020-04-07 04:26:00	AAPL	Stock	67.375	67.38	67.3725	67.375	4256.0
2020-04-07 04:27:00	AAPL	Stock	67.37	67.375	67.3	67.375	3520.0
2020-04-07 04:28:00	AAPL	Stock	67.435	67.435	67.3625	67.3625	1188.0
2020-04-07 04:29:00	AAPL	Stock	67.455	67.4625	67.3725	67.3725	1600.0
2020-04-07 04:30:00	AAPL	Stock	67.3825	67.3825	67.3825	67.3825	400.0
2020-04-07 04:31:00	AAPL	Stock	67.375	67.38	67.375	67.38	1400.0
2020-04-07 04:32:00	AAPL	Stock	67.365	67.365	67.365	67.365	800.0
2020-04-07 04:33:00	AAPL	Stock	67.3075	67.345	67.25	67.345	5188.0
2020-04-07 04:34:00	AAPL	Stock	67.25	67.25	67.25	67.25	604.0
2020-04-07 04:37:00	AAPL	Stock	67.2775	67.375	67.25	67.375	8292.0
2020-04-07 04:38:00	AAPL	Stock	67.375	67.375	67.35	67.35	4208.0
2020-04-07 04:39:00	AAPL	Stock	67.2925	67.2925	67.2925	67.2925	400.0
2020-04-07 04:40:00	AAPL	Stock	67.315	67.315	67.315	67.315	1980.0
2020-04-07 04:42:00	AAPL	Stock	67.375	67.375	67.375	67.375	600.0
2020-04-07 04:43:00	AAPL	Stock	67.3075	67.315	67.3075	67.315	800.0
2020-04-07 04:44:00	AAPL	Stock	67.34	67.34	67.34	67.34	400.0
2020-04-07 04:48:00	AAPL	Stock	67.25	67.2525	67.25	67.2525	2240.0
2020-04-07 04:53:00	AAPL	Stock	67.25	67.25	67.25	67.25	400.0
2020-04-07 04:54:00	AAPL	Stock	67.245	67.25	67.245	67.25	1480.0
2020-04-07 04:55:00	AAPL	Stock	67.2475	67.2475	67.2475	67.2475	400.0
2020-04-07 04:56:00	AAPL	Stock	67.15	67.15	67.15	67.15	400.0
2020-04-07 04:57:00	AAPL	Stock	67.2375	67.2375	67.2375	67.2375	400.0
2020-04-07 04:59:00	AAPL	Stock	67.13	67.13	67.075	67.075	2492.0
2020-04-07 05:00:00	AAPL	Stock	67.125	67.125	67.125	67.125	2320.0
2020-04-07 05:09:00	AAPL	Stock	67.1975	67.2	67.1425	67.2	4392.0
2020-04-07 05:11:00	AAPL	Stock	67.1975	67.2125	67.1975	67.2125	912.0
2020-04-07 05:12:00	AAPL	Stock	67.1825	67.1825	67.1825	67.1825	800.0
2020-04-07 05:15:00	AAPL	Stock	67.065	67.1075	67.0	67.1075	6008.0
2020-04-07 05:16:00	AAPL	Stock	67.1075	67.1075	67.0475	67.0475	1872.0

> showing 50 of 1,335,165 rows — these rows as CSV

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