PREVIEW / stock_1min / 2019-04-01

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-04-01.parquet
  size:    16.7 MB
  rows:    1,144,493
  symbols: 2,220

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-04-01 04:00:00	AAPL	Stock	47.885	47.9525	47.885	47.9525	15404.0
2019-04-01 04:01:00	AAPL	Stock	48.025	48.025	48.025	48.025	1200.0
2019-04-01 04:04:00	AAPL	Stock	48.07	48.07	48.07	48.07	1200.0
2019-04-01 04:07:00	AAPL	Stock	48.0075	48.0075	48.0075	48.0075	944.0
2019-04-01 04:08:00	AAPL	Stock	47.99	47.99	47.99	47.99	1200.0
2019-04-01 04:10:00	AAPL	Stock	47.905	47.905	47.905	47.905	3808.0
2019-04-01 04:40:00	AAPL	Stock	48.025	48.025	48.025	48.025	576.0
2019-04-01 04:45:00	AAPL	Stock	48.0	48.0	48.0	48.0	800.0
2019-04-01 04:47:00	AAPL	Stock	48.0675	48.0675	48.0	48.0	800.0
2019-04-01 04:53:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	1200.0
2019-04-01 04:56:00	AAPL	Stock	47.995	48.0125	47.995	48.0125	15176.0
2019-04-01 05:10:00	AAPL	Stock	48.0	48.0	48.0	48.0	400.0
2019-04-01 05:11:00	AAPL	Stock	48.0	48.0	48.0	48.0	2800.0
2019-04-01 05:28:00	AAPL	Stock	47.955	47.955	47.955	47.955	540.0
2019-04-01 05:32:00	AAPL	Stock	47.975	47.975	47.975	47.975	448.0
2019-04-01 05:34:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	400.0
2019-04-01 05:36:00	AAPL	Stock	48.035	48.0375	48.035	48.0375	1392.0
2019-04-01 05:39:00	AAPL	Stock	48.0	48.0	48.0	48.0	960.0
2019-04-01 05:43:00	AAPL	Stock	48.02	48.02	48.02	48.02	400.0
2019-04-01 05:54:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	420.0
2019-04-01 06:18:00	AAPL	Stock	48.0	48.0	48.0	48.0	1040.0
2019-04-01 06:20:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	488.0
2019-04-01 06:22:00	AAPL	Stock	47.955	47.955	47.955	47.955	848.0
2019-04-01 06:38:00	AAPL	Stock	47.985	47.985	47.985	47.985	400.0
2019-04-01 06:50:00	AAPL	Stock	47.965	47.965	47.965	47.965	1520.0
2019-04-01 06:55:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	1436.0
2019-04-01 06:56:00	AAPL	Stock	47.9975	48.035	47.9975	48.035	5744.0
2019-04-01 06:57:00	AAPL	Stock	48.035	48.035	48.035	48.035	5184.0
2019-04-01 07:00:00	AAPL	Stock	48.005	48.0375	47.95	47.95	10092.0
2019-04-01 07:02:00	AAPL	Stock	47.95	47.95	47.925	47.925	8156.0
2019-04-01 07:03:00	AAPL	Stock	47.9125	47.9125	47.9125	47.9125	400.0
2019-04-01 07:05:00	AAPL	Stock	47.93	47.93	47.93	47.93	400.0
2019-04-01 07:07:00	AAPL	Stock	47.925	47.925	47.925	47.925	7800.0
2019-04-01 07:08:00	AAPL	Stock	47.9425	47.9425	47.9425	47.9425	800.0
2019-04-01 07:09:00	AAPL	Stock	47.95	47.975	47.95	47.975	6240.0
2019-04-01 07:10:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	420.0
2019-04-01 07:11:00	AAPL	Stock	47.95	47.975	47.95	47.975	1200.0
2019-04-01 07:12:00	AAPL	Stock	47.975	47.975	47.975	47.975	1040.0
2019-04-01 07:13:00	AAPL	Stock	47.975	47.9775	47.975	47.9775	9360.0
2019-04-01 07:15:00	AAPL	Stock	47.9775	47.9775	47.975	47.975	800.0
2019-04-01 07:16:00	AAPL	Stock	47.95	47.9525	47.89	47.89	8116.0
2019-04-01 07:17:00	AAPL	Stock	47.975	47.975	47.975	47.975	400.0
2019-04-01 07:18:00	AAPL	Stock	47.975	47.975	47.975	47.975	400.0
2019-04-01 07:20:00	AAPL	Stock	47.9725	47.9725	47.9725	47.9725	400.0
2019-04-01 07:21:00	AAPL	Stock	47.95	47.95	47.925	47.95	1600.0
2019-04-01 07:23:00	AAPL	Stock	47.925	47.925	47.925	47.925	400.0
2019-04-01 07:25:00	AAPL	Stock	47.9475	47.9475	47.9475	47.9475	400.0
2019-04-01 07:29:00	AAPL	Stock	47.9475	47.9475	47.9475	47.9475	400.0
2019-04-01 07:31:00	AAPL	Stock	47.925	47.925	47.925	47.925	1600.0
2019-04-01 07:34:00	AAPL	Stock	47.925	47.9375	47.925	47.9375	7756.0

> showing 50 of 1,144,493 rows — these rows as CSV

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