PREVIEW / stock_1min / 2019-04-17

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-04-17.parquet
  size:    15.8 MB
  rows:    1,099,588
  symbols: 2,218

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-17 04:00:00	AAPL	Stock	49.725	49.725	49.7	49.7	5200.0
2019-04-17 04:01:00	AAPL	Stock	49.675	49.675	49.6725	49.6725	800.0
2019-04-17 04:03:00	AAPL	Stock	49.695	49.7	49.695	49.7	8000.0
2019-04-17 04:10:00	AAPL	Stock	49.695	49.695	49.695	49.695	400.0
2019-04-17 04:13:00	AAPL	Stock	49.6925	49.7	49.6925	49.7	8200.0
2019-04-17 04:14:00	AAPL	Stock	49.725	49.725	49.725	49.725	4000.0
2019-04-17 04:53:00	AAPL	Stock	49.745	49.745	49.745	49.745	400.0
2019-04-17 05:04:00	AAPL	Stock	49.75	49.75	49.75	49.75	3836.0
2019-04-17 05:35:00	AAPL	Stock	49.775	49.775	49.775	49.775	3812.0
2019-04-17 05:48:00	AAPL	Stock	49.78	49.78	49.78	49.78	800.0
2019-04-17 05:50:00	AAPL	Stock	49.78	49.78	49.78	49.78	800.0
2019-04-17 05:57:00	AAPL	Stock	49.795	49.8	49.795	49.8	4168.0
2019-04-17 05:58:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	1768.0
2019-04-17 05:59:00	AAPL	Stock	49.825	49.825	49.825	49.825	2000.0
2019-04-17 06:02:00	AAPL	Stock	49.85	49.85	49.85	49.85	5836.0
2019-04-17 06:03:00	AAPL	Stock	49.87	49.875	49.87	49.875	2080.0
2019-04-17 06:04:00	AAPL	Stock	49.875	49.875	49.87	49.87	4932.0
2019-04-17 06:18:00	AAPL	Stock	49.8775	49.8775	49.8775	49.8775	3608.0
2019-04-17 06:22:00	AAPL	Stock	49.8575	49.8575	49.8575	49.8575	400.0
2019-04-17 06:32:00	AAPL	Stock	49.85	49.85	49.85	49.85	2000.0
2019-04-17 06:35:00	AAPL	Stock	49.8325	49.8325	49.8325	49.8325	1204.0
2019-04-17 06:36:00	AAPL	Stock	49.8325	49.8325	49.8325	49.8325	400.0
2019-04-17 06:38:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	544.0
2019-04-17 06:55:00	AAPL	Stock	49.8725	49.8725	49.8725	49.8725	2000.0
2019-04-17 07:00:00	AAPL	Stock	49.8175	49.875	49.8125	49.8675	7652.0
2019-04-17 07:05:00	AAPL	Stock	49.8275	49.83	49.8275	49.83	3200.0
2019-04-17 07:06:00	AAPL	Stock	49.83	49.855	49.83	49.855	1744.0
2019-04-17 07:10:00	AAPL	Stock	49.8375	49.8375	49.8375	49.8375	800.0
2019-04-17 07:11:00	AAPL	Stock	49.8375	49.8375	49.8375	49.8375	3200.0
2019-04-17 07:12:00	AAPL	Stock	49.86	49.8825	49.86	49.875	5680.0
2019-04-17 07:13:00	AAPL	Stock	49.875	49.875	49.875	49.875	1696.0
2019-04-17 07:14:00	AAPL	Stock	49.8775	49.8775	49.875	49.875	2884.0
2019-04-17 07:15:00	AAPL	Stock	49.9	49.9	49.9	49.9	400.0
2019-04-17 07:16:00	AAPL	Stock	49.8875	49.8875	49.8875	49.8875	400.0
2019-04-17 07:17:00	AAPL	Stock	49.8875	49.8875	49.87	49.8875	5860.0
2019-04-17 07:18:00	AAPL	Stock	49.9125	49.9175	49.9125	49.9175	14000.0
2019-04-17 07:20:00	AAPL	Stock	49.925	49.925	49.925	49.925	400.0
2019-04-17 07:22:00	AAPL	Stock	49.9175	49.9175	49.9175	49.9175	4000.0
2019-04-17 07:23:00	AAPL	Stock	49.9175	49.9175	49.9175	49.9175	1200.0
2019-04-17 07:24:00	AAPL	Stock	49.9175	49.9175	49.9175	49.9175	1472.0
2019-04-17 07:25:00	AAPL	Stock	49.9175	49.95	49.9175	49.95	13196.0
2019-04-17 07:26:00	AAPL	Stock	49.975	50.0	49.975	50.0	19056.0
2019-04-17 07:27:00	AAPL	Stock	49.9975	49.9975	49.9975	49.9975	468.0
2019-04-17 07:28:00	AAPL	Stock	49.95	49.95	49.9325	49.9475	5384.0
2019-04-17 07:31:00	AAPL	Stock	49.975	50.01	49.975	50.01	5344.0
2019-04-17 07:33:00	AAPL	Stock	49.9975	50.0	49.9975	50.0	4776.0
2019-04-17 07:34:00	AAPL	Stock	49.9925	50.0	49.9925	50.0	2000.0
2019-04-17 07:38:00	AAPL	Stock	50.0	50.0	50.0	50.0	14000.0
2019-04-17 07:39:00	AAPL	Stock	50.0	50.0025	49.9625	50.0	4400.0
2019-04-17 07:40:00	AAPL	Stock	49.9625	49.9625	49.9625	49.9625	400.0

> showing 50 of 1,099,588 rows — these rows as CSV

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