PREVIEW / stock_1min / 2018-05-03

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-05-03.parquet
  size:    15.6 MB
  rows:    1,107,600
  symbols: 2,359

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
2018-05-03 04:00:00	AAPL	Stock	44.06	44.0625	44.06	44.0625	4028.0
2018-05-03 04:01:00	AAPL	Stock	44.0025	44.005	44.0	44.005	5572.0
2018-05-03 04:10:00	AAPL	Stock	44.025	44.025	44.025	44.025	2400.0
2018-05-03 04:14:00	AAPL	Stock	44.0875	44.0875	44.0875	44.0875	1592.0
2018-05-03 04:15:00	AAPL	Stock	44.05	44.05	44.05	44.05	1200.0
2018-05-03 04:19:00	AAPL	Stock	44.0625	44.0625	44.0625	44.0625	3600.0
2018-05-03 04:21:00	AAPL	Stock	44.0875	44.0875	44.0875	44.0875	800.0
2018-05-03 04:22:00	AAPL	Stock	44.0625	44.0625	44.0625	44.0625	1600.0
2018-05-03 04:24:00	AAPL	Stock	44.0825	44.0825	44.0825	44.0825	400.0
2018-05-03 04:25:00	AAPL	Stock	44.0825	44.0825	44.0825	44.0825	400.0
2018-05-03 04:27:00	AAPL	Stock	44.0625	44.0625	44.0625	44.0625	4400.0
2018-05-03 04:42:00	AAPL	Stock	44.0125	44.0125	44.0125	44.0125	1200.0
2018-05-03 04:43:00	AAPL	Stock	44.0125	44.0125	44.0125	44.0125	1292.0
2018-05-03 04:45:00	AAPL	Stock	44.005	44.005	44.0	44.0	2800.0
2018-05-03 04:52:00	AAPL	Stock	44.0	44.0	44.0	44.0	1672.0
2018-05-03 04:58:00	AAPL	Stock	44.01	44.01	44.01	44.01	1188.0
2018-05-03 04:59:00	AAPL	Stock	44.01	44.01	44.01	44.01	708.0
2018-05-03 05:00:00	AAPL	Stock	44.01	44.01	44.0	44.0	5244.0
2018-05-03 05:04:00	AAPL	Stock	43.9625	43.9625	43.9625	43.9625	2000.0
2018-05-03 05:05:00	AAPL	Stock	43.94	44.0	43.94	44.0	4516.0
2018-05-03 05:06:00	AAPL	Stock	43.975	44.0	43.975	44.0	3992.0
2018-05-03 05:07:00	AAPL	Stock	44.0	44.0	44.0	44.0	2000.0
2018-05-03 05:20:00	AAPL	Stock	44.0575	44.0575	44.0575	44.0575	400.0
2018-05-03 05:21:00	AAPL	Stock	44.0575	44.0575	44.0575	44.0575	800.0
2018-05-03 05:23:00	AAPL	Stock	44.06	44.06	44.06	44.06	400.0
2018-05-03 05:39:00	AAPL	Stock	44.0	44.0	44.0	44.0	800.0
2018-05-03 05:40:00	AAPL	Stock	44.0	44.0	44.0	44.0	1992.0
2018-05-03 05:45:00	AAPL	Stock	44.0	44.0	44.0	44.0	400.0
2018-05-03 05:54:00	AAPL	Stock	44.0	44.0	44.0	44.0	6480.0
2018-05-03 05:56:00	AAPL	Stock	44.0	44.0	44.0	44.0	1600.0
2018-05-03 06:07:00	AAPL	Stock	44.02	44.02	44.0	44.0	1624.0
2018-05-03 06:08:00	AAPL	Stock	44.055	44.055	44.055	44.055	1200.0
2018-05-03 06:12:00	AAPL	Stock	44.05	44.05	44.05	44.05	400.0
2018-05-03 06:14:00	AAPL	Stock	44.025	44.025	44.025	44.025	1200.0
2018-05-03 06:15:00	AAPL	Stock	44.025	44.0275	44.025	44.025	2000.0
2018-05-03 06:20:00	AAPL	Stock	44.075	44.075	44.075	44.075	1440.0
2018-05-03 06:21:00	AAPL	Stock	44.075	44.075	44.075	44.075	1200.0
2018-05-03 06:25:00	AAPL	Stock	44.075	44.075	44.075	44.075	3008.0
2018-05-03 06:26:00	AAPL	Stock	44.075	44.075	44.075	44.075	400.0
2018-05-03 06:27:00	AAPL	Stock	44.0625	44.075	44.0625	44.075	3200.0
2018-05-03 06:28:00	AAPL	Stock	44.075	44.075	44.075	44.075	800.0
2018-05-03 06:32:00	AAPL	Stock	44.075	44.075	44.075	44.075	2000.0
2018-05-03 06:42:00	AAPL	Stock	44.0875	44.0875	44.0875	44.0875	2000.0
2018-05-03 06:44:00	AAPL	Stock	44.0925	44.0925	44.0925	44.0925	2000.0
2018-05-03 06:47:00	AAPL	Stock	44.075	44.075	44.075	44.075	1200.0
2018-05-03 06:50:00	AAPL	Stock	44.0625	44.0625	44.0625	44.0625	400.0
2018-05-03 06:51:00	AAPL	Stock	44.0625	44.0625	44.0625	44.0625	400.0
2018-05-03 06:55:00	AAPL	Stock	44.0675	44.0675	44.0675	44.0675	444.0
2018-05-03 06:56:00	AAPL	Stock	44.0625	44.0625	44.0525	44.0525	5208.0
2018-05-03 07:00:00	AAPL	Stock	44.0725	44.1125	44.0725	44.1125	20880.0

> showing 50 of 1,107,600 rows — these rows as CSV

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