PREVIEW / stock_1min / 2019-06-27

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-06-27.parquet
  size:    15.8 MB
  rows:    1,115,178
  symbols: 2,206

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-06-27 04:00:00	AAPL	Stock	50.2275	50.25	50.1875	50.25	2048.0
2019-06-27 04:06:00	AAPL	Stock	50.2825	50.2825	50.28	50.28	1996.0
2019-06-27 04:07:00	AAPL	Stock	50.305	50.305	50.305	50.305	796.0
2019-06-27 04:30:00	AAPL	Stock	50.275	50.275	50.275	50.275	400.0
2019-06-27 04:36:00	AAPL	Stock	50.3125	50.3125	50.3125	50.3125	1872.0
2019-06-27 04:39:00	AAPL	Stock	50.25	50.25	50.25	50.25	400.0
2019-06-27 04:43:00	AAPL	Stock	50.25	50.25	50.25	50.25	800.0
2019-06-27 04:47:00	AAPL	Stock	50.25	50.25	50.22	50.22	2892.0
2019-06-27 04:48:00	AAPL	Stock	50.22	50.22	50.22	50.22	400.0
2019-06-27 04:57:00	AAPL	Stock	50.245	50.245	50.245	50.245	800.0
2019-06-27 05:03:00	AAPL	Stock	50.2375	50.2375	50.2375	50.2375	400.0
2019-06-27 05:06:00	AAPL	Stock	50.2	50.2	50.2	50.2	1880.0
2019-06-27 05:27:00	AAPL	Stock	50.2625	50.3075	50.2625	50.3075	2000.0
2019-06-27 05:29:00	AAPL	Stock	50.2525	50.2525	50.2525	50.2525	400.0
2019-06-27 05:36:00	AAPL	Stock	50.325	50.3425	50.325	50.3425	13284.0
2019-06-27 05:37:00	AAPL	Stock	50.3425	50.3425	50.3425	50.3425	800.0
2019-06-27 05:41:00	AAPL	Stock	50.3575	50.36	50.3575	50.36	800.0
2019-06-27 05:43:00	AAPL	Stock	50.3375	50.3375	50.3375	50.3375	400.0
2019-06-27 05:44:00	AAPL	Stock	50.3375	50.3375	50.3175	50.3175	9600.0
2019-06-27 05:47:00	AAPL	Stock	50.3225	50.43	50.3225	50.43	6360.0
2019-06-27 05:49:00	AAPL	Stock	50.3675	50.3675	50.35	50.35	4800.0
2019-06-27 05:51:00	AAPL	Stock	50.315	50.315	50.285	50.3	6204.0
2019-06-27 05:52:00	AAPL	Stock	50.3	50.3	50.3	50.3	4408.0
2019-06-27 05:53:00	AAPL	Stock	50.225	50.225	50.225	50.225	3920.0
2019-06-27 05:54:00	AAPL	Stock	50.21	50.21	50.175	50.175	2408.0
2019-06-27 05:55:00	AAPL	Stock	50.1825	50.1825	50.1825	50.1825	800.0
2019-06-27 06:01:00	AAPL	Stock	50.165	50.165	50.16	50.16	2000.0
2019-06-27 06:02:00	AAPL	Stock	50.135	50.135	50.0725	50.0725	3640.0
2019-06-27 06:03:00	AAPL	Stock	50.075	50.075	50.075	50.075	800.0
2019-06-27 06:04:00	AAPL	Stock	50.0725	50.0725	50.025	50.025	12440.0
2019-06-27 06:05:00	AAPL	Stock	50.015	50.015	50.0	50.0	6400.0
2019-06-27 06:08:00	AAPL	Stock	50.0275	50.0275	50.0275	50.0275	1600.0
2019-06-27 06:11:00	AAPL	Stock	50.0275	50.0275	50.01	50.01	2000.0
2019-06-27 06:13:00	AAPL	Stock	50.05	50.05	50.05	50.05	800.0
2019-06-27 06:25:00	AAPL	Stock	50.125	50.125	50.125	50.125	400.0
2019-06-27 06:26:00	AAPL	Stock	50.125	50.125	50.125	50.125	400.0
2019-06-27 06:30:00	AAPL	Stock	50.1425	50.1425	50.1	50.1	800.0
2019-06-27 06:32:00	AAPL	Stock	50.1	50.1	50.0775	50.1	3600.0
2019-06-27 06:33:00	AAPL	Stock	50.1375	50.1375	50.1375	50.1375	400.0
2019-06-27 06:38:00	AAPL	Stock	50.0875	50.0875	50.0775	50.0775	2036.0
2019-06-27 06:45:00	AAPL	Stock	50.085	50.085	50.0775	50.0775	2792.0
2019-06-27 06:46:00	AAPL	Stock	50.0425	50.0475	50.0425	50.0475	800.0
2019-06-27 06:48:00	AAPL	Stock	50.075	50.075	50.075	50.075	400.0
2019-06-27 06:49:00	AAPL	Stock	50.0975	50.0975	50.0975	50.0975	2400.0
2019-06-27 06:50:00	AAPL	Stock	50.0975	50.0975	50.0975	50.0975	12300.0
2019-06-27 06:52:00	AAPL	Stock	50.0975	50.0975	50.0975	50.0975	13752.0
2019-06-27 06:59:00	AAPL	Stock	50.1	50.1175	50.1	50.1175	800.0
2019-06-27 07:00:00	AAPL	Stock	50.1025	50.1125	50.1	50.1125	6956.0
2019-06-27 07:03:00	AAPL	Stock	50.11	50.11	50.1	50.1	4236.0
2019-06-27 07:04:00	AAPL	Stock	50.11	50.11	50.11	50.11	10400.0

> showing 50 of 1,115,178 rows — these rows as CSV

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