PREVIEW / stock_5min / 2019-12-03

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-12-03.parquet
  size:    5.9 MB
  rows:    371,345
  symbols: 2,481

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-12-03 04:00:00	AAPL	Stock	66.2475	66.25	66.2	66.225	1956.0
2019-12-03 04:05:00	AAPL	Stock	66.225	66.225	66.2	66.2	2000.0
2019-12-03 04:10:00	AAPL	Stock	66.2075	66.2075	66.2	66.2	5364.0
2019-12-03 04:15:00	AAPL	Stock	66.13	66.13	66.105	66.105	4992.0
2019-12-03 04:25:00	AAPL	Stock	66.1	66.1	66.1	66.1	800.0
2019-12-03 04:30:00	AAPL	Stock	66.095	66.095	66.0675	66.0675	4400.0
2019-12-03 04:35:00	AAPL	Stock	66.075	66.075	66.075	66.075	4000.0
2019-12-03 04:40:00	AAPL	Stock	66.0375	66.0375	66.0375	66.0375	1720.0
2019-12-03 04:55:00	AAPL	Stock	66.0375	66.0375	66.0375	66.0375	1680.0
2019-12-03 05:10:00	AAPL	Stock	66.02	66.0225	66.0	66.0125	10540.0
2019-12-03 05:15:00	AAPL	Stock	65.7625	65.775	65.5	65.62	7380.0
2019-12-03 05:20:00	AAPL	Stock	65.625	65.625	65.5	65.55	12444.0
2019-12-03 05:25:00	AAPL	Stock	65.61	65.61	65.435	65.435	42296.0
2019-12-03 05:30:00	AAPL	Stock	65.495	65.5825	65.495	65.5	8784.0
2019-12-03 05:35:00	AAPL	Stock	65.55	65.55	65.5	65.5	6560.0
2019-12-03 05:45:00	AAPL	Stock	65.5	65.525	65.475	65.475	29492.0
2019-12-03 05:50:00	AAPL	Stock	65.5	65.5	65.5	65.5	6000.0
2019-12-03 05:55:00	AAPL	Stock	65.5025	65.5025	65.5025	65.5025	440.0
2019-12-03 06:00:00	AAPL	Stock	65.5025	65.5025	65.5	65.5	2104.0
2019-12-03 06:05:00	AAPL	Stock	65.5025	65.5025	65.4975	65.5	9588.0
2019-12-03 06:10:00	AAPL	Stock	65.51	65.51	65.51	65.51	612.0
2019-12-03 06:20:00	AAPL	Stock	65.5125	65.5625	65.5	65.5625	6196.0
2019-12-03 06:35:00	AAPL	Stock	65.575	65.6	65.575	65.6	1200.0
2019-12-03 06:40:00	AAPL	Stock	65.6125	65.67	65.6125	65.65	7380.0
2019-12-03 06:45:00	AAPL	Stock	65.65	65.65	65.65	65.65	1520.0
2019-12-03 06:50:00	AAPL	Stock	65.65	65.67	65.65	65.67	2800.0
2019-12-03 06:55:00	AAPL	Stock	65.65	65.65	65.65	65.65	1616.0
2019-12-03 07:00:00	AAPL	Stock	65.635	65.6875	65.575	65.575	29984.0
2019-12-03 07:05:00	AAPL	Stock	65.5625	65.5625	65.5	65.52	22728.0
2019-12-03 07:10:00	AAPL	Stock	65.52	65.5275	65.465	65.465	41016.0
2019-12-03 07:15:00	AAPL	Stock	65.475	65.52	65.465	65.4775	26980.0
2019-12-03 07:20:00	AAPL	Stock	65.4775	65.5275	65.4325	65.5	32020.0
2019-12-03 07:25:00	AAPL	Stock	65.525	65.525	65.5	65.5025	10884.0
2019-12-03 07:30:00	AAPL	Stock	65.5225	65.5275	65.4775	65.51	11800.0
2019-12-03 07:35:00	AAPL	Stock	65.5275	65.5275	65.47	65.4775	14536.0
2019-12-03 07:40:00	AAPL	Stock	65.4775	65.5175	65.375	65.375	49156.0
2019-12-03 07:45:00	AAPL	Stock	65.375	65.4	65.3375	65.3575	31220.0
2019-12-03 07:50:00	AAPL	Stock	65.3375	65.3375	65.2025	65.2075	80408.0
2019-12-03 07:55:00	AAPL	Stock	65.2075	65.2575	65.165	65.1825	42524.0
2019-12-03 08:00:00	AAPL	Stock	65.525	65.6375	65.2	65.245	107108.0
2019-12-03 08:05:00	AAPL	Stock	65.2125	65.245	65.125	65.175	38200.0
2019-12-03 08:10:00	AAPL	Stock	65.1825	65.2225	65.03	65.0625	82288.0
2019-12-03 08:15:00	AAPL	Stock	65.065	65.08	65.025	65.0625	59828.0
2019-12-03 08:20:00	AAPL	Stock	65.0625	65.1175	65.02	65.0625	69908.0
2019-12-03 08:25:00	AAPL	Stock	65.0625	65.0625	64.75	64.895	253344.0
2019-12-03 08:30:00	AAPL	Stock	64.875	64.9025	64.7675	64.78	96200.0
2019-12-03 08:35:00	AAPL	Stock	64.78	64.9	64.72	64.7625	171888.0
2019-12-03 08:40:00	AAPL	Stock	64.7725	64.895	64.765	64.875	60484.0
2019-12-03 08:45:00	AAPL	Stock	64.8675	64.8675	64.775	64.8125	69892.0
2019-12-03 08:50:00	AAPL	Stock	64.8	64.8225	64.7525	64.795	78804.0

> showing 50 of 371,345 rows — these rows as CSV

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