PREVIEW / stock_5min / 2018-03-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-05.parquet
  size:    5.7 MB
  rows:    365,950
  symbols: 2,882

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-03-05 04:00:00	AAPL	Stock	44.025	44.025	44.0225	44.0225	2400.0
2018-03-05 04:05:00	AAPL	Stock	43.9275	43.9275	43.9275	43.9275	1200.0
2018-03-05 04:15:00	AAPL	Stock	43.9425	43.9425	43.9425	43.9425	400.0
2018-03-05 04:25:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	800.0
2018-03-05 04:30:00	AAPL	Stock	43.8825	43.8825	43.8575	43.8575	1200.0
2018-03-05 04:35:00	AAPL	Stock	43.8575	43.8825	43.85	43.8825	14760.0
2018-03-05 04:40:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	9460.0
2018-03-05 04:45:00	AAPL	Stock	43.9725	43.985	43.9725	43.985	5780.0
2018-03-05 04:50:00	AAPL	Stock	43.9875	44.0125	43.9875	43.9875	9600.0
2018-03-05 04:55:00	AAPL	Stock	43.9925	44.0025	43.9925	43.9975	16228.0
2018-03-05 05:10:00	AAPL	Stock	43.9975	43.9975	43.9975	43.9975	400.0
2018-03-05 05:15:00	AAPL	Stock	43.975	43.975	43.95	43.95	3600.0
2018-03-05 05:20:00	AAPL	Stock	43.9975	44.0	43.9975	43.9975	20780.0
2018-03-05 05:25:00	AAPL	Stock	43.9975	44.0	43.9975	44.0	20640.0
2018-03-05 05:30:00	AAPL	Stock	43.96	43.96	43.96	43.96	660.0
2018-03-05 05:35:00	AAPL	Stock	44.0	44.0	44.0	44.0	7596.0
2018-03-05 05:40:00	AAPL	Stock	44.0	44.0	44.0	44.0	2000.0
2018-03-05 05:45:00	AAPL	Stock	44.0375	44.0475	44.0375	44.0475	8400.0
2018-03-05 05:50:00	AAPL	Stock	44.0525	44.0525	44.0525	44.0525	1600.0
2018-03-05 06:00:00	AAPL	Stock	44.07	44.07	44.055	44.055	1972.0
2018-03-05 06:05:00	AAPL	Stock	44.0625	44.075	44.0625	44.0725	5784.0
2018-03-05 06:10:00	AAPL	Stock	44.03	44.03	43.975	43.975	13332.0
2018-03-05 06:20:00	AAPL	Stock	44.0	44.01	43.9975	44.01	1560.0
2018-03-05 06:25:00	AAPL	Stock	44.0025	44.01	44.0025	44.01	15088.0
2018-03-05 06:35:00	AAPL	Stock	43.9775	43.9775	43.9775	43.9775	400.0
2018-03-05 06:50:00	AAPL	Stock	44.01	44.01	44.01	44.01	400.0
2018-03-05 06:55:00	AAPL	Stock	44.0075	44.0125	43.995	44.005	4000.0
2018-03-05 07:00:00	AAPL	Stock	43.975	43.98	43.94	43.95	29968.0
2018-03-05 07:10:00	AAPL	Stock	43.975	43.9875	43.925	43.96	65364.0
2018-03-05 07:15:00	AAPL	Stock	43.95	43.975	43.9375	43.9375	26076.0
2018-03-05 07:20:00	AAPL	Stock	43.9525	43.9525	43.9525	43.9525	400.0
2018-03-05 07:25:00	AAPL	Stock	43.95	43.9975	43.9375	43.96	28192.0
2018-03-05 07:30:00	AAPL	Stock	43.935	43.9475	43.875	43.8875	55788.0
2018-03-05 07:35:00	AAPL	Stock	43.8675	43.91	43.865	43.8875	34064.0
2018-03-05 07:40:00	AAPL	Stock	43.8975	43.9	43.875	43.88	3000.0
2018-03-05 07:45:00	AAPL	Stock	43.875	43.875	43.875	43.875	11312.0
2018-03-05 07:50:00	AAPL	Stock	43.8425	43.8425	43.8375	43.8375	10000.0
2018-03-05 07:55:00	AAPL	Stock	43.83	43.85	43.8175	43.8375	13224.0
2018-03-05 08:00:00	AAPL	Stock	43.9875	43.9875	43.8375	43.9	51392.0
2018-03-05 08:05:00	AAPL	Stock	43.9175	43.95	43.915	43.925	17544.0
2018-03-05 08:10:00	AAPL	Stock	43.9375	43.985	43.925	43.975	18232.0
2018-03-05 08:15:00	AAPL	Stock	43.975	43.985	43.9625	43.975	20052.0
2018-03-05 08:20:00	AAPL	Stock	43.96	43.975	43.9525	43.975	6028.0
2018-03-05 08:25:00	AAPL	Stock	43.985	43.985	43.9575	43.9575	10204.0
2018-03-05 08:30:00	AAPL	Stock	43.965	44.0	43.9625	44.0	30652.0
2018-03-05 08:35:00	AAPL	Stock	43.9975	44.02	43.975	44.0	44736.0
2018-03-05 08:40:00	AAPL	Stock	43.995	43.9975	43.975	43.975	12400.0
2018-03-05 08:45:00	AAPL	Stock	43.9525	43.9575	43.95	43.95	2684.0
2018-03-05 08:50:00	AAPL	Stock	43.9575	43.965	43.915	43.915	54216.0
2018-03-05 08:55:00	AAPL	Stock	43.915	43.915	43.875	43.8875	33264.0

> showing 50 of 365,950 rows — these rows as CSV

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