PREVIEW / stock_1min / 2018-09-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-09-05.parquet
  size:    14.9 MB
  rows:    1,063,349
  symbols: 2,327

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-09-05 04:00:00	AAPL	Stock	57.0625	57.0625	56.9625	56.965	14128.0
2018-09-05 04:01:00	AAPL	Stock	57.0	57.0	57.0	57.0	400.0
2018-09-05 04:10:00	AAPL	Stock	57.125	57.125	57.125	57.125	772.0
2018-09-05 04:12:00	AAPL	Stock	57.02	57.02	57.02	57.02	400.0
2018-09-05 04:15:00	AAPL	Stock	57.0725	57.0775	57.0725	57.0775	1600.0
2018-09-05 04:16:00	AAPL	Stock	57.0725	57.0725	57.04	57.04	1468.0
2018-09-05 04:17:00	AAPL	Stock	57.0725	57.0725	57.0725	57.0725	2400.0
2018-09-05 04:18:00	AAPL	Stock	57.04	57.04	57.04	57.04	400.0
2018-09-05 04:29:00	AAPL	Stock	57.025	57.025	57.025	57.025	1588.0
2018-09-05 04:30:00	AAPL	Stock	57.0225	57.025	57.0	57.0	3600.0
2018-09-05 04:33:00	AAPL	Stock	57.005	57.005	57.005	57.005	400.0
2018-09-05 04:47:00	AAPL	Stock	57.0	57.0	57.0	57.0	540.0
2018-09-05 04:48:00	AAPL	Stock	57.025	57.025	57.025	57.025	400.0
2018-09-05 04:59:00	AAPL	Stock	57.0375	57.05	57.0375	57.05	4880.0
2018-09-05 05:02:00	AAPL	Stock	57.0475	57.0475	57.0475	57.0475	400.0
2018-09-05 05:03:00	AAPL	Stock	57.0475	57.0475	57.0475	57.0475	400.0
2018-09-05 05:10:00	AAPL	Stock	57.0425	57.0425	57.0425	57.0425	600.0
2018-09-05 05:12:00	AAPL	Stock	57.025	57.025	57.025	57.025	1888.0
2018-09-05 05:13:00	AAPL	Stock	57.0025	57.0025	57.0	57.0	2820.0
2018-09-05 05:15:00	AAPL	Stock	57.05	57.05	57.05	57.05	400.0
2018-09-05 05:17:00	AAPL	Stock	57.025	57.025	57.025	57.025	1996.0
2018-09-05 05:27:00	AAPL	Stock	57.0	57.0	57.0	57.0	532.0
2018-09-05 05:28:00	AAPL	Stock	57.0	57.0	57.0	57.0	1848.0
2018-09-05 05:32:00	AAPL	Stock	56.975	56.975	56.975	56.975	1440.0
2018-09-05 05:33:00	AAPL	Stock	56.975	56.975	56.9625	56.9625	5452.0
2018-09-05 05:38:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	1200.0
2018-09-05 05:47:00	AAPL	Stock	56.9475	56.9475	56.9475	56.9475	800.0
2018-09-05 05:56:00	AAPL	Stock	56.9475	56.95	56.9475	56.95	1952.0
2018-09-05 05:58:00	AAPL	Stock	56.95	56.9625	56.95	56.9625	11216.0
2018-09-05 06:01:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	1200.0
2018-09-05 06:03:00	AAPL	Stock	56.9375	56.9375	56.9375	56.9375	7600.0
2018-09-05 06:07:00	AAPL	Stock	56.9275	56.9275	56.9	56.9	800.0
2018-09-05 06:12:00	AAPL	Stock	56.935	56.935	56.935	56.935	400.0
2018-09-05 06:13:00	AAPL	Stock	56.9375	56.9375	56.9375	56.9375	676.0
2018-09-05 06:17:00	AAPL	Stock	56.9375	56.9375	56.9375	56.9375	400.0
2018-09-05 06:24:00	AAPL	Stock	56.935	56.935	56.935	56.935	1756.0
2018-09-05 06:25:00	AAPL	Stock	56.9475	56.9625	56.9475	56.9625	5168.0
2018-09-05 06:26:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	800.0
2018-09-05 06:27:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	572.0
2018-09-05 06:29:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	400.0
2018-09-05 06:35:00	AAPL	Stock	56.9725	56.985	56.9725	56.985	1040.0
2018-09-05 06:37:00	AAPL	Stock	57.0	57.0	57.0	57.0	1928.0
2018-09-05 06:39:00	AAPL	Stock	57.0175	57.0175	57.0175	57.0175	2000.0
2018-09-05 06:48:00	AAPL	Stock	57.0125	57.0125	57.0125	57.0125	480.0
2018-09-05 07:00:00	AAPL	Stock	57.02	57.025	57.02	57.02	3080.0
2018-09-05 07:01:00	AAPL	Stock	57.025	57.0275	57.025	57.025	3200.0
2018-09-05 07:02:00	AAPL	Stock	57.0275	57.0275	57.0275	57.0275	400.0
2018-09-05 07:03:00	AAPL	Stock	57.0275	57.0275	57.0275	57.0275	1240.0
2018-09-05 07:04:00	AAPL	Stock	57.0375	57.0375	57.0375	57.0375	3600.0
2018-09-05 07:05:00	AAPL	Stock	57.0375	57.0825	57.0375	57.0825	9464.0

> showing 50 of 1,063,349 rows — these rows as CSV

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