PREVIEW / stock_5min / 2018-08-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-20.parquet
  size:    5.4 MB
  rows:    344,511
  symbols: 2,797

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-08-20 04:00:00	AAPL	Stock	54.5625	54.8375	54.5625	54.75	9492.0
2018-08-20 04:05:00	AAPL	Stock	54.8	54.8	54.7875	54.8	2316.0
2018-08-20 04:10:00	AAPL	Stock	54.75	54.75	54.75	54.75	1600.0
2018-08-20 04:15:00	AAPL	Stock	54.695	54.7275	54.695	54.7275	5160.0
2018-08-20 04:20:00	AAPL	Stock	54.75	54.75	54.75	54.75	2000.0
2018-08-20 04:25:00	AAPL	Stock	54.695	54.695	54.695	54.695	400.0
2018-08-20 04:30:00	AAPL	Stock	54.7375	54.7375	54.7375	54.7375	4320.0
2018-08-20 04:35:00	AAPL	Stock	54.7375	54.7375	54.725	54.725	2400.0
2018-08-20 04:40:00	AAPL	Stock	54.785	54.785	54.75	54.75	6404.0
2018-08-20 04:45:00	AAPL	Stock	54.785	54.785	54.7575	54.7575	1028.0
2018-08-20 04:50:00	AAPL	Stock	54.8125	54.825	54.7975	54.825	3200.0
2018-08-20 05:00:00	AAPL	Stock	54.81	54.81	54.795	54.795	10324.0
2018-08-20 05:05:00	AAPL	Stock	54.8	54.8	54.795	54.795	7588.0
2018-08-20 05:10:00	AAPL	Stock	54.7775	54.7775	54.7775	54.7775	420.0
2018-08-20 05:15:00	AAPL	Stock	54.7775	54.7775	54.7775	54.7775	400.0
2018-08-20 05:20:00	AAPL	Stock	54.7725	54.7725	54.725	54.725	33388.0
2018-08-20 05:30:00	AAPL	Stock	54.7675	54.775	54.7675	54.775	2704.0
2018-08-20 05:35:00	AAPL	Stock	54.775	54.775	54.775	54.775	400.0
2018-08-20 05:45:00	AAPL	Stock	54.75	54.75	54.7275	54.7275	1648.0
2018-08-20 05:50:00	AAPL	Stock	54.745	54.7625	54.7375	54.7625	4796.0
2018-08-20 05:55:00	AAPL	Stock	54.7625	54.7625	54.7625	54.7625	1400.0
2018-08-20 06:00:00	AAPL	Stock	54.75	54.75	54.7375	54.7375	800.0
2018-08-20 06:05:00	AAPL	Stock	54.7375	54.7375	54.695	54.695	15100.0
2018-08-20 06:10:00	AAPL	Stock	54.68	54.705	54.675	54.675	12204.0
2018-08-20 06:15:00	AAPL	Stock	54.6525	54.675	54.65	54.6525	23036.0
2018-08-20 06:20:00	AAPL	Stock	54.685	54.685	54.685	54.685	400.0
2018-08-20 06:25:00	AAPL	Stock	54.655	54.6625	54.65	54.6625	3680.0
2018-08-20 06:35:00	AAPL	Stock	54.6625	54.6625	54.6625	54.6625	400.0
2018-08-20 06:40:00	AAPL	Stock	54.6725	54.675	54.6725	54.675	9100.0
2018-08-20 06:45:00	AAPL	Stock	54.685	54.685	54.685	54.685	3460.0
2018-08-20 06:50:00	AAPL	Stock	54.6775	54.6775	54.6775	54.6775	3864.0
2018-08-20 07:00:00	AAPL	Stock	54.645	54.6725	54.6275	54.66	29468.0
2018-08-20 07:05:00	AAPL	Stock	54.67	54.7	54.67	54.67	38528.0
2018-08-20 07:10:00	AAPL	Stock	54.675	54.7	54.6625	54.7	27236.0
2018-08-20 07:15:00	AAPL	Stock	54.7075	54.7225	54.6975	54.6975	30796.0
2018-08-20 07:20:00	AAPL	Stock	54.685	54.685	54.6125	54.625	72740.0
2018-08-20 07:25:00	AAPL	Stock	54.6325	54.65	54.6075	54.6075	62616.0
2018-08-20 07:30:00	AAPL	Stock	54.6075	54.6075	54.535	54.535	89808.0
2018-08-20 07:35:00	AAPL	Stock	54.5375	54.54	54.51	54.515	101232.0
2018-08-20 07:40:00	AAPL	Stock	54.525	54.55	54.475	54.505	110928.0
2018-08-20 07:45:00	AAPL	Stock	54.4925	54.5125	54.485	54.5	23892.0
2018-08-20 07:50:00	AAPL	Stock	54.4675	54.4925	54.465	54.48	16112.0
2018-08-20 07:55:00	AAPL	Stock	54.4925	54.5375	54.49	54.5	25936.0
2018-08-20 08:00:00	AAPL	Stock	54.66	54.725	54.485	54.505	162144.0
2018-08-20 08:05:00	AAPL	Stock	54.51	54.5475	54.5	54.505	47904.0
2018-08-20 08:10:00	AAPL	Stock	54.545	54.55	54.5225	54.525	45616.0
2018-08-20 08:15:00	AAPL	Stock	54.53	54.545	54.5025	54.52	24260.0
2018-08-20 08:20:00	AAPL	Stock	54.52	54.525	54.505	54.5075	20800.0
2018-08-20 08:25:00	AAPL	Stock	54.5225	54.5225	54.475	54.475	73972.0
2018-08-20 08:30:00	AAPL	Stock	54.4925	54.5025	54.465	54.495	51176.0

> showing 50 of 344,511 rows — these rows as CSV

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