PREVIEW / stock_1min / 2018-03-29

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-29.parquet
  size:    15.5 MB
  rows:    1,107,482
  symbols: 2,403

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-03-29 04:03:00	AAPL	Stock	41.95	41.95	41.95	41.95	1920.0
2018-03-29 04:04:00	AAPL	Stock	41.925	41.925	41.925	41.925	400.0
2018-03-29 04:05:00	AAPL	Stock	41.875	41.875	41.875	41.875	800.0
2018-03-29 04:25:00	AAPL	Stock	41.87	41.87	41.87	41.87	400.0
2018-03-29 04:44:00	AAPL	Stock	41.875	41.875	41.875	41.875	2000.0
2018-03-29 04:50:00	AAPL	Stock	41.87	41.87	41.87	41.87	400.0
2018-03-29 05:04:00	AAPL	Stock	41.9225	41.9225	41.9225	41.9225	7208.0
2018-03-29 05:26:00	AAPL	Stock	41.9	41.925	41.9	41.925	2012.0
2018-03-29 05:35:00	AAPL	Stock	41.9125	41.925	41.9125	41.925	800.0
2018-03-29 05:46:00	AAPL	Stock	41.925	41.925	41.925	41.925	1600.0
2018-03-29 05:54:00	AAPL	Stock	41.9725	41.9725	41.9725	41.9725	400.0
2018-03-29 06:22:00	AAPL	Stock	42.0175	42.0175	42.0175	42.0175	400.0
2018-03-29 06:39:00	AAPL	Stock	41.9325	41.9325	41.9325	41.9325	400.0
2018-03-29 06:46:00	AAPL	Stock	41.9625	41.9625	41.9625	41.9625	400.0
2018-03-29 06:50:00	AAPL	Stock	41.9375	41.9375	41.9375	41.9375	400.0
2018-03-29 06:53:00	AAPL	Stock	41.9625	41.9625	41.9625	41.9625	600.0
2018-03-29 07:00:00	AAPL	Stock	41.875	41.96	41.7775	41.9475	33432.0
2018-03-29 07:01:00	AAPL	Stock	41.9125	41.915	41.9125	41.9125	2800.0
2018-03-29 07:02:00	AAPL	Stock	41.9125	41.9125	41.9	41.9	7400.0
2018-03-29 07:03:00	AAPL	Stock	41.88	41.88	41.88	41.88	1200.0
2018-03-29 07:04:00	AAPL	Stock	41.91	41.915	41.91	41.915	8440.0
2018-03-29 07:05:00	AAPL	Stock	41.9325	41.9325	41.915	41.915	800.0
2018-03-29 07:06:00	AAPL	Stock	41.9125	41.9125	41.9125	41.9125	4800.0
2018-03-29 07:07:00	AAPL	Stock	41.9125	41.915	41.9125	41.915	2300.0
2018-03-29 07:08:00	AAPL	Stock	41.9	41.9	41.9	41.9	560.0
2018-03-29 07:09:00	AAPL	Stock	41.925	41.925	41.9	41.9	2420.0
2018-03-29 07:10:00	AAPL	Stock	41.9025	41.9025	41.9025	41.9025	1220.0
2018-03-29 07:11:00	AAPL	Stock	41.9125	41.9125	41.9	41.9	8320.0
2018-03-29 07:12:00	AAPL	Stock	41.9	41.9	41.9	41.9	3680.0
2018-03-29 07:13:00	AAPL	Stock	41.9325	41.9325	41.9325	41.9325	2900.0
2018-03-29 07:16:00	AAPL	Stock	41.9	41.9	41.9	41.9	800.0
2018-03-29 07:19:00	AAPL	Stock	41.9225	41.9225	41.9225	41.9225	400.0
2018-03-29 07:22:00	AAPL	Stock	41.9	41.9	41.9	41.9	1420.0
2018-03-29 07:23:00	AAPL	Stock	41.9	41.9	41.9	41.9	2580.0
2018-03-29 07:25:00	AAPL	Stock	41.9325	41.935	41.88	41.88	8644.0
2018-03-29 07:30:00	AAPL	Stock	41.89	41.89	41.89	41.89	800.0
2018-03-29 07:31:00	AAPL	Stock	41.9	41.9	41.8875	41.8875	6776.0
2018-03-29 07:34:00	AAPL	Stock	41.885	41.8875	41.885	41.8875	2000.0
2018-03-29 07:36:00	AAPL	Stock	41.9125	41.9125	41.9125	41.9125	400.0
2018-03-29 07:38:00	AAPL	Stock	41.9125	41.9125	41.9125	41.9125	1200.0
2018-03-29 07:39:00	AAPL	Stock	41.92	41.925	41.92	41.925	7836.0
2018-03-29 07:40:00	AAPL	Stock	41.935	41.9625	41.935	41.9625	21180.0
2018-03-29 07:41:00	AAPL	Stock	41.96	42.0	41.96	42.0	12800.0
2018-03-29 07:42:00	AAPL	Stock	42.0	42.0375	42.0	42.0375	5200.0
2018-03-29 07:43:00	AAPL	Stock	42.0375	42.0375	42.0375	42.0375	1200.0
2018-03-29 07:44:00	AAPL	Stock	42.025	42.035	42.025	42.035	2400.0
2018-03-29 07:45:00	AAPL	Stock	42.025	42.025	42.025	42.025	3000.0
2018-03-29 07:47:00	AAPL	Stock	41.975	42.0	41.975	42.0	3096.0
2018-03-29 07:49:00	AAPL	Stock	42.0	42.0125	42.0	42.0125	8256.0
2018-03-29 07:51:00	AAPL	Stock	42.0125	42.0175	42.0125	42.0175	4904.0

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

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