PREVIEW / stock_1min / 2019-08-07

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-07.parquet
  size:    16.6 MB
  rows:    1,153,624
  symbols: 2,180

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-08-07 04:00:00	AAPL	Stock	49.25	49.25	49.25	49.25	400.0
2019-08-07 04:06:00	AAPL	Stock	49.4525	49.4525	49.4525	49.4525	800.0
2019-08-07 04:07:00	AAPL	Stock	49.465	49.465	49.4425	49.4425	1028.0
2019-08-07 04:16:00	AAPL	Stock	49.475	49.475	49.475	49.475	560.0
2019-08-07 04:27:00	AAPL	Stock	49.47	49.475	49.47	49.475	7600.0
2019-08-07 04:37:00	AAPL	Stock	49.44	49.44	49.44	49.44	400.0
2019-08-07 04:42:00	AAPL	Stock	49.535	49.535	49.535	49.535	1520.0
2019-08-07 04:48:00	AAPL	Stock	49.5775	49.58	49.5775	49.58	1200.0
2019-08-07 04:55:00	AAPL	Stock	49.5775	49.58	49.5775	49.58	2000.0
2019-08-07 05:10:00	AAPL	Stock	49.57	49.57	49.57	49.57	400.0
2019-08-07 05:11:00	AAPL	Stock	49.58	49.58	49.58	49.58	7836.0
2019-08-07 05:15:00	AAPL	Stock	49.61	49.61	49.61	49.61	400.0
2019-08-07 05:16:00	AAPL	Stock	49.5925	49.5925	49.5925	49.5925	4400.0
2019-08-07 05:19:00	AAPL	Stock	49.6075	49.6075	49.6075	49.6075	400.0
2019-08-07 05:20:00	AAPL	Stock	49.545	49.545	49.545	49.545	400.0
2019-08-07 05:29:00	AAPL	Stock	49.58	49.585	49.58	49.585	800.0
2019-08-07 05:30:00	AAPL	Stock	49.585	49.585	49.585	49.585	1104.0
2019-08-07 05:37:00	AAPL	Stock	49.58	49.58	49.58	49.58	804.0
2019-08-07 05:41:00	AAPL	Stock	49.62	49.62	49.62	49.62	400.0
2019-08-07 05:42:00	AAPL	Stock	49.625	49.635	49.625	49.635	1600.0
2019-08-07 05:48:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	800.0
2019-08-07 05:52:00	AAPL	Stock	49.67	49.67	49.67	49.67	400.0
2019-08-07 05:53:00	AAPL	Stock	49.67	49.67	49.67	49.67	1200.0
2019-08-07 06:00:00	AAPL	Stock	49.67	49.67	49.67	49.67	400.0
2019-08-07 06:02:00	AAPL	Stock	49.675	49.675	49.675	49.675	1824.0
2019-08-07 06:04:00	AAPL	Stock	49.6825	49.6825	49.6825	49.6825	2000.0
2019-08-07 06:08:00	AAPL	Stock	49.6525	49.6525	49.6525	49.6525	400.0
2019-08-07 06:13:00	AAPL	Stock	49.675	49.675	49.675	49.675	580.0
2019-08-07 06:17:00	AAPL	Stock	49.635	49.635	49.63	49.63	800.0
2019-08-07 06:35:00	AAPL	Stock	49.66	49.675	49.66	49.6725	3964.0
2019-08-07 06:36:00	AAPL	Stock	49.675	49.675	49.675	49.675	1664.0
2019-08-07 06:37:00	AAPL	Stock	49.6875	49.6975	49.6875	49.6975	996.0
2019-08-07 06:40:00	AAPL	Stock	49.7	49.7	49.7	49.7	3200.0
2019-08-07 06:41:00	AAPL	Stock	49.7	49.7	49.7	49.7	1600.0
2019-08-07 06:45:00	AAPL	Stock	49.655	49.655	49.6425	49.6425	4456.0
2019-08-07 06:49:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	400.0
2019-08-07 06:52:00	AAPL	Stock	49.6875	49.7	49.625	49.685	6864.0
2019-08-07 06:53:00	AAPL	Stock	49.685	49.685	49.6275	49.675	14896.0
2019-08-07 06:54:00	AAPL	Stock	49.625	49.625	49.6	49.625	1368.0
2019-08-07 06:58:00	AAPL	Stock	49.605	49.605	49.5875	49.5875	7372.0
2019-08-07 06:59:00	AAPL	Stock	49.5425	49.5425	49.5125	49.5125	3308.0
2019-08-07 07:00:00	AAPL	Stock	49.5	49.6125	49.5	49.5825	31008.0
2019-08-07 07:01:00	AAPL	Stock	49.5825	49.5875	49.5825	49.5875	3596.0
2019-08-07 07:02:00	AAPL	Stock	49.5825	49.6125	49.5825	49.5825	6976.0
2019-08-07 07:03:00	AAPL	Stock	49.585	49.585	49.5375	49.5375	12068.0
2019-08-07 07:04:00	AAPL	Stock	49.575	49.5825	49.575	49.5825	2400.0
2019-08-07 07:05:00	AAPL	Stock	49.5875	49.5875	49.5625	49.5625	800.0
2019-08-07 07:06:00	AAPL	Stock	49.555	49.555	49.555	49.555	800.0
2019-08-07 07:07:00	AAPL	Stock	49.55	49.55	49.55	49.55	800.0
2019-08-07 07:08:00	AAPL	Stock	49.55	49.55	49.55	49.55	4908.0

> showing 50 of 1,153,624 rows — these rows as CSV

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