PREVIEW / stock_1min / 2019-08-08

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-08.parquet
  size:    16.4 MB
  rows:    1,140,403
  symbols: 2,180

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-08-08 04:00:00	AAPL	Stock	49.9	50.075	49.9	50.075	1280.0
2019-08-08 04:09:00	AAPL	Stock	50.025	50.025	50.0	50.0	1400.0
2019-08-08 04:11:00	AAPL	Stock	50.0	50.0	49.9875	49.9875	2076.0
2019-08-08 04:12:00	AAPL	Stock	49.9625	49.9625	49.9475	49.9475	2400.0
2019-08-08 04:14:00	AAPL	Stock	49.9125	49.9125	49.9125	49.9125	2000.0
2019-08-08 04:17:00	AAPL	Stock	49.8375	49.8625	49.8375	49.8625	1920.0
2019-08-08 04:27:00	AAPL	Stock	49.995	49.995	49.995	49.995	1380.0
2019-08-08 04:28:00	AAPL	Stock	50.0125	50.0125	50.0125	50.0125	2000.0
2019-08-08 04:33:00	AAPL	Stock	50.0125	50.0125	50.0125	50.0125	2796.0
2019-08-08 04:35:00	AAPL	Stock	50.025	50.025	50.025	50.025	1700.0
2019-08-08 04:40:00	AAPL	Stock	49.9775	49.9775	49.9775	49.9775	572.0
2019-08-08 04:45:00	AAPL	Stock	50.025	50.025	50.025	50.025	1256.0
2019-08-08 04:46:00	AAPL	Stock	50.065	50.0675	50.065	50.0675	800.0
2019-08-08 04:47:00	AAPL	Stock	50.06	50.06	50.06	50.06	800.0
2019-08-08 04:48:00	AAPL	Stock	50.06	50.06	50.06	50.06	400.0
2019-08-08 05:09:00	AAPL	Stock	50.0	50.0	50.0	50.0	1200.0
2019-08-08 05:16:00	AAPL	Stock	50.06	50.06	50.06	50.06	1212.0
2019-08-08 05:21:00	AAPL	Stock	50.06	50.06	50.06	50.06	2480.0
2019-08-08 05:23:00	AAPL	Stock	50.06	50.06	50.06	50.06	4800.0
2019-08-08 05:26:00	AAPL	Stock	50.0125	50.0125	50.0125	50.0125	1272.0
2019-08-08 05:29:00	AAPL	Stock	50.0325	50.0325	50.0325	50.0325	1280.0
2019-08-08 05:32:00	AAPL	Stock	50.035	50.035	50.035	50.035	400.0
2019-08-08 05:35:00	AAPL	Stock	50.0125	50.025	50.0125	50.025	3812.0
2019-08-08 05:37:00	AAPL	Stock	50.015	50.015	50.015	50.015	400.0
2019-08-08 05:38:00	AAPL	Stock	50.015	50.02	50.015	50.02	4104.0
2019-08-08 05:54:00	AAPL	Stock	50.015	50.015	50.015	50.015	3600.0
2019-08-08 05:55:00	AAPL	Stock	50.0125	50.0125	50.0	50.0	2400.0
2019-08-08 05:56:00	AAPL	Stock	50.0275	50.0275	50.0275	50.0275	4000.0
2019-08-08 06:01:00	AAPL	Stock	50.0375	50.0375	50.0375	50.0375	740.0
2019-08-08 06:02:00	AAPL	Stock	50.06	50.06	50.06	50.06	400.0
2019-08-08 06:08:00	AAPL	Stock	50.1125	50.1125	50.1125	50.1125	800.0
2019-08-08 06:09:00	AAPL	Stock	50.16	50.16	50.16	50.16	400.0
2019-08-08 06:20:00	AAPL	Stock	50.155	50.155	50.155	50.155	1200.0
2019-08-08 06:27:00	AAPL	Stock	50.12	50.12	50.12	50.12	3600.0
2019-08-08 06:35:00	AAPL	Stock	50.0825	50.0825	50.0825	50.0825	1252.0
2019-08-08 06:38:00	AAPL	Stock	50.0825	50.0825	50.0525	50.0525	2000.0
2019-08-08 06:39:00	AAPL	Stock	50.04	50.04	50.0	50.0	4860.0
2019-08-08 06:40:00	AAPL	Stock	49.9875	49.9925	49.9875	49.9925	2400.0
2019-08-08 06:46:00	AAPL	Stock	49.975	49.975	49.975	49.975	400.0
2019-08-08 06:47:00	AAPL	Stock	50.0	50.0	50.0	50.0	14400.0
2019-08-08 06:48:00	AAPL	Stock	50.0	50.0	50.0	50.0	1488.0
2019-08-08 06:54:00	AAPL	Stock	49.9375	49.9625	49.915	49.9625	5496.0
2019-08-08 06:58:00	AAPL	Stock	49.9625	49.9625	49.9625	49.9625	800.0
2019-08-08 06:59:00	AAPL	Stock	49.9625	49.9625	49.9625	49.9625	800.0
2019-08-08 07:00:00	AAPL	Stock	49.98	50.05	49.93	49.9675	14844.0
2019-08-08 07:01:00	AAPL	Stock	49.975	49.9875	49.975	49.9875	2480.0
2019-08-08 07:02:00	AAPL	Stock	49.9875	49.9875	49.9875	49.9875	400.0
2019-08-08 07:03:00	AAPL	Stock	49.9975	49.9975	49.955	49.955	3816.0
2019-08-08 07:06:00	AAPL	Stock	49.975	49.975	49.975	49.975	400.0
2019-08-08 07:08:00	AAPL	Stock	49.99	49.99	49.9775	49.9775	4000.0

> showing 50 of 1,140,403 rows — these rows as CSV

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