PREVIEW / stock_1min / 2018-01-29

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-29.parquet
  size:    16.7 MB
  rows:    1,109,934
  symbols: 2,426

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-01-29 04:00:00	AAPL	Stock	42.8725	43.0	42.8725	42.925	3168.0
2018-01-29 04:03:00	AAPL	Stock	42.925	42.925	42.92	42.92	800.0
2018-01-29 04:04:00	AAPL	Stock	42.8875	42.8875	42.8875	42.8875	800.0
2018-01-29 04:05:00	AAPL	Stock	42.8875	42.8875	42.8875	42.8875	600.0
2018-01-29 04:07:00	AAPL	Stock	42.92	42.925	42.92	42.925	7468.0
2018-01-29 04:09:00	AAPL	Stock	42.925	42.925	42.925	42.925	428.0
2018-01-29 04:12:00	AAPL	Stock	43.0	43.0	43.0	43.0	4400.0
2018-01-29 04:16:00	AAPL	Stock	43.0	43.0025	43.0	43.0025	1000.0
2018-01-29 04:20:00	AAPL	Stock	43.0125	43.0375	43.0125	43.0375	4600.0
2018-01-29 04:23:00	AAPL	Stock	43.0575	43.1	43.0575	43.065	8928.0
2018-01-29 04:28:00	AAPL	Stock	43.115	43.1225	43.115	43.1225	5056.0
2018-01-29 04:30:00	AAPL	Stock	43.1275	43.14	43.1275	43.14	2200.0
2018-01-29 04:31:00	AAPL	Stock	43.14	43.14	43.14	43.14	400.0
2018-01-29 04:32:00	AAPL	Stock	43.15	43.15	43.15	43.15	8000.0
2018-01-29 04:33:00	AAPL	Stock	43.14	43.15	43.14	43.14	11932.0
2018-01-29 04:35:00	AAPL	Stock	43.135	43.135	43.135	43.135	3996.0
2018-01-29 04:36:00	AAPL	Stock	43.135	43.14	43.125	43.125	9600.0
2018-01-29 04:37:00	AAPL	Stock	43.0625	43.0625	43.0625	43.0625	2716.0
2018-01-29 04:38:00	AAPL	Stock	43.0625	43.0625	43.0625	43.0625	4000.0
2018-01-29 04:44:00	AAPL	Stock	43.0025	43.0025	43.0025	43.0025	3996.0
2018-01-29 04:50:00	AAPL	Stock	43.0025	43.0025	42.95	42.95	13208.0
2018-01-29 04:57:00	AAPL	Stock	42.9975	42.9975	42.9975	42.9975	800.0
2018-01-29 05:01:00	AAPL	Stock	42.9525	42.9525	42.95	42.95	14328.0
2018-01-29 05:02:00	AAPL	Stock	42.95	42.95	42.95	42.95	400.0
2018-01-29 05:05:00	AAPL	Stock	43.045	43.05	43.045	43.05	800.0
2018-01-29 05:06:00	AAPL	Stock	43.01	43.01	43.01	43.01	564.0
2018-01-29 05:07:00	AAPL	Stock	42.9025	42.955	42.895	42.895	10912.0
2018-01-29 05:09:00	AAPL	Stock	42.92	42.9275	42.92	42.92	32756.0
2018-01-29 05:10:00	AAPL	Stock	42.92	42.9475	42.92	42.9475	968.0
2018-01-29 05:11:00	AAPL	Stock	42.9275	42.9275	42.9275	42.9275	2400.0
2018-01-29 05:12:00	AAPL	Stock	42.875	42.875	42.8	42.8	3580.0
2018-01-29 05:13:00	AAPL	Stock	42.7575	42.85	42.7525	42.765	14912.0
2018-01-29 05:15:00	AAPL	Stock	42.775	42.775	42.775	42.775	11232.0
2018-01-29 05:16:00	AAPL	Stock	42.75	42.775	42.75	42.775	7996.0
2018-01-29 05:22:00	AAPL	Stock	42.8	42.8	42.8	42.8	532.0
2018-01-29 05:40:00	AAPL	Stock	42.795	42.795	42.795	42.795	2800.0
2018-01-29 05:41:00	AAPL	Stock	42.795	42.795	42.75	42.7525	10056.0
2018-01-29 05:44:00	AAPL	Stock	42.705	42.705	42.705	42.705	400.0
2018-01-29 05:49:00	AAPL	Stock	42.7075	42.7075	42.7075	42.7075	4000.0
2018-01-29 05:50:00	AAPL	Stock	42.7075	42.7075	42.7075	42.7075	2196.0
2018-01-29 05:51:00	AAPL	Stock	42.7475	42.7525	42.7475	42.7525	4964.0
2018-01-29 05:55:00	AAPL	Stock	42.7275	42.7325	42.7275	42.7325	7672.0
2018-01-29 05:56:00	AAPL	Stock	42.7275	42.7275	42.7275	42.7275	500.0
2018-01-29 06:02:00	AAPL	Stock	42.7125	42.7125	42.695	42.695	3000.0
2018-01-29 06:12:00	AAPL	Stock	42.695	42.695	42.695	42.695	400.0
2018-01-29 06:13:00	AAPL	Stock	42.695	42.695	42.685	42.685	10376.0
2018-01-29 06:14:00	AAPL	Stock	42.6825	42.685	42.6825	42.685	7784.0
2018-01-29 06:17:00	AAPL	Stock	42.655	42.655	42.6375	42.6375	5200.0
2018-01-29 06:19:00	AAPL	Stock	42.645	42.645	42.62	42.62	4300.0
2018-01-29 06:24:00	AAPL	Stock	42.63	42.6375	42.63	42.6375	7800.0

> showing 50 of 1,109,934 rows — these rows as CSV

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