PREVIEW / stock_1min / 2019-07-01

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-01.parquet
  size:    16.6 MB
  rows:    1,169,007
  symbols: 2,196

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-07-01 04:00:00	AAPL	Stock	50.37	50.5	50.37	50.5	13588.0
2019-07-01 04:02:00	AAPL	Stock	50.4875	50.55	50.4875	50.55	1200.0
2019-07-01 04:03:00	AAPL	Stock	50.5625	50.6225	50.5625	50.6225	8984.0
2019-07-01 04:04:00	AAPL	Stock	50.6625	50.6625	50.6	50.6	2056.0
2019-07-01 04:06:00	AAPL	Stock	50.65	50.6525	50.625	50.625	3220.0
2019-07-01 04:07:00	AAPL	Stock	50.625	50.625	50.625	50.625	2368.0
2019-07-01 04:08:00	AAPL	Stock	50.6275	50.6625	50.625	50.6625	4400.0
2019-07-01 04:09:00	AAPL	Stock	50.6725	50.6725	50.6725	50.6725	800.0
2019-07-01 04:10:00	AAPL	Stock	50.6725	50.6925	50.6725	50.6925	2152.0
2019-07-01 04:11:00	AAPL	Stock	50.6925	50.6925	50.6925	50.6925	588.0
2019-07-01 04:12:00	AAPL	Stock	50.655	50.655	50.655	50.655	1200.0
2019-07-01 04:13:00	AAPL	Stock	50.655	50.655	50.655	50.655	400.0
2019-07-01 04:15:00	AAPL	Stock	50.6525	50.7325	50.6525	50.7325	4412.0
2019-07-01 04:16:00	AAPL	Stock	50.7325	50.8125	50.7325	50.8125	10504.0
2019-07-01 04:17:00	AAPL	Stock	50.87	50.87	50.87	50.87	400.0
2019-07-01 04:18:00	AAPL	Stock	50.9225	50.9225	50.9125	50.9125	4628.0
2019-07-01 04:20:00	AAPL	Stock	50.845	50.845	50.8	50.8	12072.0
2019-07-01 04:22:00	AAPL	Stock	50.845	50.845	50.845	50.845	400.0
2019-07-01 04:23:00	AAPL	Stock	50.835	50.835	50.8325	50.8325	1960.0
2019-07-01 04:24:00	AAPL	Stock	50.835	50.835	50.835	50.835	520.0
2019-07-01 04:25:00	AAPL	Stock	50.845	50.875	50.845	50.875	7632.0
2019-07-01 04:26:00	AAPL	Stock	50.875	50.875	50.875	50.875	800.0
2019-07-01 04:27:00	AAPL	Stock	50.875	50.875	50.875	50.875	1680.0
2019-07-01 04:28:00	AAPL	Stock	50.875	50.875	50.875	50.875	400.0
2019-07-01 04:31:00	AAPL	Stock	50.8825	50.8825	50.8825	50.8825	3388.0
2019-07-01 04:33:00	AAPL	Stock	50.845	50.8625	50.845	50.8625	1460.0
2019-07-01 04:34:00	AAPL	Stock	50.8625	50.8625	50.8625	50.8625	400.0
2019-07-01 04:35:00	AAPL	Stock	50.85	50.85	50.85	50.85	1176.0
2019-07-01 04:36:00	AAPL	Stock	50.85	50.85	50.85	50.85	2000.0
2019-07-01 04:37:00	AAPL	Stock	50.805	50.805	50.805	50.805	400.0
2019-07-01 04:39:00	AAPL	Stock	50.8425	50.86	50.8425	50.86	4792.0
2019-07-01 04:40:00	AAPL	Stock	50.865	50.865	50.865	50.865	5140.0
2019-07-01 04:42:00	AAPL	Stock	50.815	50.815	50.815	50.815	1740.0
2019-07-01 04:43:00	AAPL	Stock	50.8475	50.85	50.8475	50.85	2400.0
2019-07-01 04:44:00	AAPL	Stock	50.865	50.8675	50.865	50.8675	1960.0
2019-07-01 04:47:00	AAPL	Stock	50.82	50.82	50.82	50.82	2380.0
2019-07-01 04:48:00	AAPL	Stock	50.8625	50.8625	50.8625	50.8625	400.0
2019-07-01 04:52:00	AAPL	Stock	50.7975	50.7975	50.7975	50.7975	800.0
2019-07-01 04:59:00	AAPL	Stock	50.7825	50.7825	50.7825	50.7825	400.0
2019-07-01 05:02:00	AAPL	Stock	50.83	50.8425	50.83	50.8425	1100.0
2019-07-01 05:14:00	AAPL	Stock	50.79	50.835	50.785	50.835	2948.0
2019-07-01 05:18:00	AAPL	Stock	50.805	50.83	50.805	50.83	4600.0
2019-07-01 05:23:00	AAPL	Stock	50.8075	50.8075	50.8075	50.8075	400.0
2019-07-01 05:25:00	AAPL	Stock	50.8	50.8	50.8	50.8	400.0
2019-07-01 05:29:00	AAPL	Stock	50.7925	50.7925	50.7925	50.7925	800.0
2019-07-01 05:31:00	AAPL	Stock	50.7875	50.7875	50.7875	50.7875	800.0
2019-07-01 05:32:00	AAPL	Stock	50.8	50.8	50.8	50.8	8396.0
2019-07-01 05:33:00	AAPL	Stock	50.8	50.8	50.8	50.8	7700.0
2019-07-01 05:34:00	AAPL	Stock	50.8	50.8	50.8	50.8	800.0
2019-07-01 05:35:00	AAPL	Stock	50.8	50.825	50.8	50.8	2896.0

> showing 50 of 1,169,007 rows — these rows as CSV

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