PREVIEW / stock_1min / 2018-07-18

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-18.parquet
  size:    14.4 MB
  rows:    1,038,294
  symbols: 2,350

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-07-18 04:00:00	AAPL	Stock	48.0125	48.0125	48.0125	48.0125	7200.0
2018-07-18 04:07:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	448.0
2018-07-18 04:08:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	520.0
2018-07-18 04:11:00	AAPL	Stock	48.0	48.0	48.0	48.0	14600.0
2018-07-18 04:12:00	AAPL	Stock	48.0	48.0	48.0	48.0	1600.0
2018-07-18 04:14:00	AAPL	Stock	47.9875	48.0	47.9875	48.0	1436.0
2018-07-18 04:18:00	AAPL	Stock	48.0	48.0	48.0	48.0	1200.0
2018-07-18 04:38:00	AAPL	Stock	48.0	48.0	48.0	48.0	800.0
2018-07-18 04:41:00	AAPL	Stock	47.9875	47.9875	47.9875	47.9875	1600.0
2018-07-18 04:45:00	AAPL	Stock	48.02	48.02	48.02	48.02	1500.0
2018-07-18 04:46:00	AAPL	Stock	48.0225	48.0225	48.0225	48.0225	2684.0
2018-07-18 04:47:00	AAPL	Stock	48.0375	48.0375	48.035	48.035	1168.0
2018-07-18 04:49:00	AAPL	Stock	48.0375	48.0375	48.0375	48.0375	2840.0
2018-07-18 05:03:00	AAPL	Stock	48.0475	48.0475	48.0475	48.0475	400.0
2018-07-18 05:04:00	AAPL	Stock	48.04	48.04	48.04	48.04	424.0
2018-07-18 05:10:00	AAPL	Stock	48.0525	48.0525	48.0525	48.0525	532.0
2018-07-18 05:43:00	AAPL	Stock	48.05	48.05	48.05	48.05	800.0
2018-07-18 05:59:00	AAPL	Stock	48.05	48.1	48.05	48.1	2000.0
2018-07-18 06:04:00	AAPL	Stock	48.0975	48.0975	48.0975	48.0975	1040.0
2018-07-18 06:08:00	AAPL	Stock	48.0625	48.09	48.0625	48.09	2476.0
2018-07-18 06:39:00	AAPL	Stock	48.05	48.05	48.05	48.05	3548.0
2018-07-18 06:58:00	AAPL	Stock	48.0725	48.075	48.0725	48.075	1600.0
2018-07-18 07:00:00	AAPL	Stock	48.045	48.05	48.03	48.03	5260.0
2018-07-18 07:02:00	AAPL	Stock	48.0275	48.0275	48.0275	48.0275	400.0
2018-07-18 07:04:00	AAPL	Stock	48.0375	48.0375	48.0375	48.0375	400.0
2018-07-18 07:05:00	AAPL	Stock	48.0375	48.0375	48.0375	48.0375	400.0
2018-07-18 07:06:00	AAPL	Stock	48.0375	48.05	48.0375	48.05	1600.0
2018-07-18 07:09:00	AAPL	Stock	48.05	48.05	48.05	48.05	1152.0
2018-07-18 07:10:00	AAPL	Stock	48.05	48.0525	48.05	48.0525	2800.0
2018-07-18 07:13:00	AAPL	Stock	48.05	48.05	48.0375	48.0375	800.0
2018-07-18 07:16:00	AAPL	Stock	48.0375	48.0375	48.035	48.035	1816.0
2018-07-18 07:18:00	AAPL	Stock	48.035	48.0475	48.035	48.0475	800.0
2018-07-18 07:19:00	AAPL	Stock	48.0475	48.0475	48.0475	48.0475	400.0
2018-07-18 07:20:00	AAPL	Stock	48.05	48.05	48.05	48.05	2000.0
2018-07-18 07:28:00	AAPL	Stock	48.03	48.03	48.0275	48.0275	4068.0
2018-07-18 07:29:00	AAPL	Stock	48.0275	48.0275	48.0025	48.0025	11056.0
2018-07-18 07:30:00	AAPL	Stock	48.0025	48.0025	48.0	48.0025	20508.0
2018-07-18 07:31:00	AAPL	Stock	48.0025	48.025	48.0025	48.0225	4240.0
2018-07-18 07:33:00	AAPL	Stock	48.025	48.03	48.025	48.03	2400.0
2018-07-18 07:34:00	AAPL	Stock	48.0375	48.0375	48.0375	48.0375	400.0
2018-07-18 07:37:00	AAPL	Stock	48.05	48.05	48.05	48.05	1600.0
2018-07-18 07:38:00	AAPL	Stock	48.0625	48.0625	48.0475	48.0475	888.0
2018-07-18 07:39:00	AAPL	Stock	48.0475	48.0475	48.0375	48.0375	5200.0
2018-07-18 07:42:00	AAPL	Stock	48.04	48.04	48.0375	48.0375	800.0
2018-07-18 07:43:00	AAPL	Stock	48.0375	48.0375	48.0375	48.0375	4380.0
2018-07-18 07:44:00	AAPL	Stock	48.0375	48.0475	48.0375	48.0475	3800.0
2018-07-18 07:45:00	AAPL	Stock	48.04	48.04	48.04	48.04	400.0
2018-07-18 07:47:00	AAPL	Stock	48.0325	48.0325	48.0325	48.0325	400.0
2018-07-18 07:48:00	AAPL	Stock	48.045	48.05	48.045	48.05	1800.0
2018-07-18 07:50:00	AAPL	Stock	48.0375	48.0375	48.025	48.025	2452.0

> showing 50 of 1,038,294 rows — these rows as CSV

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