PREVIEW / stock_1min / 2019-01-09

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-01-09.parquet
  size:    16.0 MB
  rows:    1,126,457
  symbols: 2,270

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
2019-01-09 04:00:00	AAPL	Stock	37.8	37.8	37.8	37.8	1136.0
2019-01-09 04:02:00	AAPL	Stock	37.8775	37.8775	37.875	37.875	3920.0
2019-01-09 04:04:00	AAPL	Stock	37.97	37.975	37.97	37.975	3408.0
2019-01-09 04:05:00	AAPL	Stock	37.9375	37.975	37.9375	37.975	800.0
2019-01-09 04:09:00	AAPL	Stock	37.95	37.9975	37.95	37.975	5920.0
2019-01-09 04:10:00	AAPL	Stock	37.9975	37.9975	37.9975	37.9975	996.0
2019-01-09 04:14:00	AAPL	Stock	37.9875	37.9925	37.9875	37.9925	800.0
2019-01-09 04:15:00	AAPL	Stock	37.9975	38.0	37.9975	38.0	1528.0
2019-01-09 04:18:00	AAPL	Stock	38.025	38.025	38.025	38.025	400.0
2019-01-09 04:24:00	AAPL	Stock	38.11	38.11	38.11	38.11	400.0
2019-01-09 04:29:00	AAPL	Stock	38.1	38.1	38.0875	38.0875	1704.0
2019-01-09 04:33:00	AAPL	Stock	38.1	38.1	38.1	38.1	600.0
2019-01-09 04:34:00	AAPL	Stock	38.0975	38.1	38.0975	38.1	2424.0
2019-01-09 04:35:00	AAPL	Stock	38.07	38.1	38.07	38.1	2356.0
2019-01-09 04:38:00	AAPL	Stock	38.1	38.1	38.1	38.1	1340.0
2019-01-09 04:41:00	AAPL	Stock	38.0525	38.1	38.05	38.1	4336.0
2019-01-09 04:43:00	AAPL	Stock	38.095	38.095	38.095	38.095	1128.0
2019-01-09 04:44:00	AAPL	Stock	38.095	38.095	38.095	38.095	400.0
2019-01-09 04:46:00	AAPL	Stock	38.1	38.1	38.0625	38.0625	2172.0
2019-01-09 04:49:00	AAPL	Stock	38.095	38.095	38.095	38.095	468.0
2019-01-09 04:51:00	AAPL	Stock	38.0625	38.0625	38.055	38.055	2800.0
2019-01-09 04:52:00	AAPL	Stock	38.055	38.055	38.055	38.055	800.0
2019-01-09 04:54:00	AAPL	Stock	38.05	38.05	38.025	38.0375	2408.0
2019-01-09 04:55:00	AAPL	Stock	38.0375	38.0375	38.0375	38.0375	1416.0
2019-01-09 04:56:00	AAPL	Stock	38.035	38.0375	38.035	38.0375	4000.0
2019-01-09 05:00:00	AAPL	Stock	38.075	38.08	38.075	38.08	3652.0
2019-01-09 05:01:00	AAPL	Stock	38.055	38.055	38.0425	38.0425	1896.0
2019-01-09 05:02:00	AAPL	Stock	38.0425	38.0425	38.0375	38.0375	3212.0
2019-01-09 05:03:00	AAPL	Stock	38.095	38.095	38.095	38.095	1352.0
2019-01-09 05:04:00	AAPL	Stock	38.0975	38.1	38.0975	38.1	10000.0
2019-01-09 05:07:00	AAPL	Stock	38.0725	38.0725	38.0725	38.0725	1320.0
2019-01-09 05:08:00	AAPL	Stock	38.095	38.1	38.0675	38.0675	3840.0
2019-01-09 05:09:00	AAPL	Stock	38.095	38.1	38.095	38.095	6100.0
2019-01-09 05:10:00	AAPL	Stock	38.1	38.1	38.1	38.1	5652.0
2019-01-09 05:11:00	AAPL	Stock	38.1	38.1	38.1	38.1	3200.0
2019-01-09 05:12:00	AAPL	Stock	38.12	38.12	38.12	38.12	400.0
2019-01-09 05:15:00	AAPL	Stock	38.1325	38.1325	38.1325	38.1325	800.0
2019-01-09 05:17:00	AAPL	Stock	38.195	38.2	38.1375	38.2	7736.0
2019-01-09 05:18:00	AAPL	Stock	38.225	38.225	38.2125	38.2125	3600.0
2019-01-09 05:19:00	AAPL	Stock	38.225	38.25	38.225	38.25	24880.0
2019-01-09 05:20:00	AAPL	Stock	38.25	38.25	38.2025	38.2025	15456.0
2019-01-09 05:21:00	AAPL	Stock	38.1575	38.175	38.1575	38.175	1076.0
2019-01-09 05:23:00	AAPL	Stock	38.2	38.2	38.2	38.2	400.0
2019-01-09 05:25:00	AAPL	Stock	38.2	38.22	38.2	38.22	800.0
2019-01-09 05:26:00	AAPL	Stock	38.2	38.2	38.1575	38.1575	4460.0
2019-01-09 05:27:00	AAPL	Stock	38.1575	38.1575	38.1375	38.1375	5440.0
2019-01-09 05:28:00	AAPL	Stock	38.1375	38.2	38.1375	38.2	9716.0
2019-01-09 05:30:00	AAPL	Stock	38.1825	38.1825	38.1825	38.1825	400.0
2019-01-09 05:31:00	AAPL	Stock	38.15	38.15	38.15	38.15	1696.0
2019-01-09 05:32:00	AAPL	Stock	38.1525	38.1525	38.1525	38.1525	800.0

> showing 50 of 1,126,457 rows — these rows as CSV

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