PREVIEW / stock_1min / 2019-05-01

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-05-01.parquet
  size:    16.1 MB
  rows:    1,103,572
  symbols: 2,210

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-05-01 04:00:00	AAPL	Stock	52.7	52.755	52.7	52.75	3864.0
2019-05-01 04:02:00	AAPL	Stock	52.76	52.8	52.75	52.8	13204.0
2019-05-01 04:03:00	AAPL	Stock	52.76	52.775	52.76	52.76	5432.0
2019-05-01 04:04:00	AAPL	Stock	52.775	52.775	52.775	52.775	2000.0
2019-05-01 04:06:00	AAPL	Stock	52.775	52.775	52.775	52.775	800.0
2019-05-01 04:08:00	AAPL	Stock	52.7725	52.7725	52.7725	52.7725	400.0
2019-05-01 04:11:00	AAPL	Stock	52.7625	52.7625	52.7625	52.7625	640.0
2019-05-01 04:15:00	AAPL	Stock	52.79	52.79	52.765	52.765	800.0
2019-05-01 04:16:00	AAPL	Stock	52.7725	52.7725	52.7675	52.7675	3840.0
2019-05-01 04:20:00	AAPL	Stock	52.8	52.8	52.8	52.8	1200.0
2019-05-01 04:30:00	AAPL	Stock	52.82	52.82	52.82	52.82	400.0
2019-05-01 04:48:00	AAPL	Stock	52.85	52.85	52.85	52.85	400.0
2019-05-01 04:59:00	AAPL	Stock	52.8	52.8	52.8	52.8	4800.0
2019-05-01 05:01:00	AAPL	Stock	52.7825	52.7825	52.7825	52.7825	2000.0
2019-05-01 05:03:00	AAPL	Stock	52.7825	52.7825	52.7825	52.7825	800.0
2019-05-01 05:04:00	AAPL	Stock	52.8425	52.8425	52.75	52.7825	10000.0
2019-05-01 05:05:00	AAPL	Stock	52.8425	52.8425	52.8425	52.8425	400.0
2019-05-01 05:08:00	AAPL	Stock	52.83	52.8375	52.83	52.8375	1200.0
2019-05-01 05:11:00	AAPL	Stock	52.765	52.765	52.765	52.765	560.0
2019-05-01 05:12:00	AAPL	Stock	52.8	52.8	52.8	52.8	400.0
2019-05-01 05:16:00	AAPL	Stock	52.8	52.8	52.8	52.8	800.0
2019-05-01 05:18:00	AAPL	Stock	52.835	52.835	52.835	52.835	2240.0
2019-05-01 05:19:00	AAPL	Stock	52.8325	52.875	52.8325	52.875	12008.0
2019-05-01 05:20:00	AAPL	Stock	52.875	52.875	52.875	52.875	400.0
2019-05-01 05:28:00	AAPL	Stock	52.9175	52.9175	52.9175	52.9175	4400.0
2019-05-01 05:32:00	AAPL	Stock	52.925	52.925	52.925	52.925	400.0
2019-05-01 05:36:00	AAPL	Stock	52.9325	52.9325	52.9325	52.9325	400.0
2019-05-01 05:38:00	AAPL	Stock	52.925	52.925	52.925	52.925	1200.0
2019-05-01 05:39:00	AAPL	Stock	52.9	52.9	52.9	52.9	800.0
2019-05-01 05:49:00	AAPL	Stock	52.9175	52.92	52.9175	52.92	1200.0
2019-05-01 05:54:00	AAPL	Stock	52.965	53.0	52.965	53.0	10012.0
2019-05-01 05:57:00	AAPL	Stock	53.0	53.0	53.0	53.0	800.0
2019-05-01 05:59:00	AAPL	Stock	52.9875	53.0	52.9875	53.0	2400.0
2019-05-01 06:02:00	AAPL	Stock	53.0	53.0	52.98	52.98	800.0
2019-05-01 06:04:00	AAPL	Stock	52.98	53.0	52.98	52.98	4420.0
2019-05-01 06:06:00	AAPL	Stock	52.975	52.975	52.975	52.975	400.0
2019-05-01 06:14:00	AAPL	Stock	52.995	53.0025	52.995	53.0025	6400.0
2019-05-01 06:15:00	AAPL	Stock	53.0	53.02	53.0	53.0	13576.0
2019-05-01 06:16:00	AAPL	Stock	53.0	53.0	53.0	53.0	1200.0
2019-05-01 06:17:00	AAPL	Stock	53.0	53.0	53.0	53.0	1712.0
2019-05-01 06:18:00	AAPL	Stock	53.025	53.025	53.025	53.025	400.0
2019-05-01 06:20:00	AAPL	Stock	53.025	53.0275	53.025	53.0275	800.0
2019-05-01 06:21:00	AAPL	Stock	53.025	53.025	53.025	53.025	400.0
2019-05-01 06:22:00	AAPL	Stock	53.0025	53.0025	53.0	53.0	2600.0
2019-05-01 06:24:00	AAPL	Stock	53.0	53.0	53.0	53.0	400.0
2019-05-01 06:25:00	AAPL	Stock	53.0	53.0	53.0	53.0	400.0
2019-05-01 06:26:00	AAPL	Stock	53.0	53.0	53.0	53.0	400.0
2019-05-01 06:27:00	AAPL	Stock	53.0	53.0	53.0	53.0	400.0
2019-05-01 06:28:00	AAPL	Stock	53.0	53.0	53.0	53.0	400.0
2019-05-01 06:29:00	AAPL	Stock	53.0	53.0	53.0	53.0	2000.0

> showing 50 of 1,103,572 rows — these rows as CSV

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