PREVIEW / stock_1min / 2019-07-16

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-16.parquet
  size:    15.2 MB
  rows:    1,077,214
  symbols: 2,185

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-07-16 04:00:00	AAPL	Stock	51.25	51.25	51.25	51.25	3000.0
2019-07-16 04:06:00	AAPL	Stock	51.345	51.36	51.345	51.36	2360.0
2019-07-16 04:08:00	AAPL	Stock	51.305	51.305	51.305	51.305	400.0
2019-07-16 04:14:00	AAPL	Stock	51.275	51.275	51.275	51.275	400.0
2019-07-16 05:33:00	AAPL	Stock	51.2625	51.2625	51.2625	51.2625	5012.0
2019-07-16 05:36:00	AAPL	Stock	51.2625	51.2625	51.2625	51.2625	400.0
2019-07-16 05:51:00	AAPL	Stock	51.295	51.295	51.295	51.295	568.0
2019-07-16 06:49:00	AAPL	Stock	51.2475	51.2475	51.2475	51.2475	1600.0
2019-07-16 06:50:00	AAPL	Stock	51.2475	51.2475	51.2475	51.2475	1332.0
2019-07-16 06:52:00	AAPL	Stock	51.2475	51.2475	51.2475	51.2475	400.0
2019-07-16 06:55:00	AAPL	Stock	51.275	51.275	51.275	51.275	400.0
2019-07-16 06:56:00	AAPL	Stock	51.275	51.275	51.275	51.275	4004.0
2019-07-16 06:57:00	AAPL	Stock	51.285	51.285	51.285	51.285	800.0
2019-07-16 06:58:00	AAPL	Stock	51.275	51.275	51.275	51.275	1808.0
2019-07-16 07:00:00	AAPL	Stock	51.285	51.2875	51.285	51.285	24916.0
2019-07-16 07:03:00	AAPL	Stock	51.2975	51.2975	51.2975	51.2975	600.0
2019-07-16 07:11:00	AAPL	Stock	51.295	51.31	51.2925	51.31	19948.0
2019-07-16 07:16:00	AAPL	Stock	51.3025	51.3025	51.3025	51.3025	776.0
2019-07-16 07:17:00	AAPL	Stock	51.3125	51.345	51.3125	51.34	6080.0
2019-07-16 07:18:00	AAPL	Stock	51.3375	51.3375	51.3	51.3225	6320.0
2019-07-16 07:19:00	AAPL	Stock	51.3225	51.3225	51.3225	51.3225	1600.0
2019-07-16 07:25:00	AAPL	Stock	51.33	51.3375	51.33	51.3375	800.0
2019-07-16 07:30:00	AAPL	Stock	51.36	51.36	51.36	51.36	1800.0
2019-07-16 07:31:00	AAPL	Stock	51.35	51.35	51.35	51.35	1800.0
2019-07-16 07:32:00	AAPL	Stock	51.35	51.35	51.35	51.35	1200.0
2019-07-16 07:33:00	AAPL	Stock	51.3525	51.3525	51.3525	51.3525	800.0
2019-07-16 07:35:00	AAPL	Stock	51.3625	51.3625	51.3625	51.3625	400.0
2019-07-16 07:36:00	AAPL	Stock	51.3625	51.3625	51.3625	51.3625	1200.0
2019-07-16 07:40:00	AAPL	Stock	51.37	51.375	51.37	51.375	5668.0
2019-07-16 07:41:00	AAPL	Stock	51.38	51.38	51.38	51.38	4540.0
2019-07-16 07:45:00	AAPL	Stock	51.375	51.375	51.375	51.375	800.0
2019-07-16 07:46:00	AAPL	Stock	51.37	51.37	51.3525	51.3525	1200.0
2019-07-16 07:47:00	AAPL	Stock	51.345	51.345	51.345	51.345	400.0
2019-07-16 07:48:00	AAPL	Stock	51.345	51.345	51.3375	51.3375	4596.0
2019-07-16 07:49:00	AAPL	Stock	51.3625	51.375	51.3275	51.3275	3016.0
2019-07-16 07:50:00	AAPL	Stock	51.34	51.34	51.34	51.34	2040.0
2019-07-16 07:51:00	AAPL	Stock	51.3475	51.3475	51.3475	51.3475	564.0
2019-07-16 07:52:00	AAPL	Stock	51.36	51.36	51.36	51.36	1920.0
2019-07-16 07:53:00	AAPL	Stock	51.36	51.3675	51.36	51.3675	1660.0
2019-07-16 07:54:00	AAPL	Stock	51.3725	51.3725	51.35	51.35	1000.0
2019-07-16 08:00:00	AAPL	Stock	51.38	51.3825	51.2775	51.35	51796.0
2019-07-16 08:01:00	AAPL	Stock	51.34	51.34	51.34	51.34	1000.0
2019-07-16 08:02:00	AAPL	Stock	51.35	51.37	51.35	51.3625	10880.0
2019-07-16 08:03:00	AAPL	Stock	51.3625	51.3625	51.3625	51.3625	520.0
2019-07-16 08:04:00	AAPL	Stock	51.37	51.37	51.37	51.37	1920.0
2019-07-16 08:06:00	AAPL	Stock	51.3625	51.3625	51.3625	51.3625	1784.0
2019-07-16 08:08:00	AAPL	Stock	51.35	51.35	51.35	51.35	824.0
2019-07-16 08:10:00	AAPL	Stock	51.355	51.355	51.355	51.355	800.0
2019-07-16 08:12:00	AAPL	Stock	51.36	51.3625	51.36	51.3625	2680.0
2019-07-16 08:13:00	AAPL	Stock	51.3575	51.3575	51.3575	51.3575	2040.0

> showing 50 of 1,077,214 rows — these rows as CSV

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