PREVIEW / stock_5min / 2020-03-25

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-25.parquet
  size:    6.8 MB
  rows:    426,783
  symbols: 2,448

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
2020-03-25 04:00:00	AAPL	Stock	63.75	63.75	63.25	63.2775	52212.0
2020-03-25 04:05:00	AAPL	Stock	63.225	63.75	63.0075	63.605	43120.0
2020-03-25 04:10:00	AAPL	Stock	63.7425	63.965	63.625	63.75	23584.0
2020-03-25 04:15:00	AAPL	Stock	63.775	63.8475	63.6475	63.75	11136.0
2020-03-25 04:20:00	AAPL	Stock	63.8375	63.975	63.8375	63.975	14704.0
2020-03-25 04:25:00	AAPL	Stock	63.8825	63.975	63.875	63.975	16728.0
2020-03-25 04:30:00	AAPL	Stock	64.1075	64.245	64.0	64.16	3196.0
2020-03-25 04:35:00	AAPL	Stock	64.225	64.225	63.9875	64.0	5984.0
2020-03-25 04:40:00	AAPL	Stock	64.0	64.375	64.0	64.375	8828.0
2020-03-25 04:45:00	AAPL	Stock	64.2575	64.375	64.0	64.075	17524.0
2020-03-25 04:50:00	AAPL	Stock	64.075	64.37	63.75	64.25	12936.0
2020-03-25 04:55:00	AAPL	Stock	64.245	64.3575	64.245	64.25	13988.0
2020-03-25 05:00:00	AAPL	Stock	64.245	64.495	64.1775	64.495	14276.0
2020-03-25 05:05:00	AAPL	Stock	64.4	64.75	64.4	64.6825	8308.0
2020-03-25 05:10:00	AAPL	Stock	64.685	64.95	64.6825	64.75	14964.0
2020-03-25 05:15:00	AAPL	Stock	64.7375	64.7375	64.7	64.7	1000.0
2020-03-25 05:20:00	AAPL	Stock	64.7175	64.875	64.7175	64.875	3676.0
2020-03-25 05:25:00	AAPL	Stock	64.9375	64.975	64.9375	64.975	7840.0
2020-03-25 05:30:00	AAPL	Stock	64.9	64.9725	64.7175	64.875	6000.0
2020-03-25 05:35:00	AAPL	Stock	64.755	64.755	64.64	64.69	4920.0
2020-03-25 05:40:00	AAPL	Stock	64.75	64.75	64.5	64.5	22268.0
2020-03-25 05:45:00	AAPL	Stock	64.6975	64.75	64.495	64.495	12216.0
2020-03-25 05:50:00	AAPL	Stock	64.45	64.45	64.05	64.0875	7884.0
2020-03-25 05:55:00	AAPL	Stock	64.06	64.1825	64.02	64.1825	6568.0
2020-03-25 06:00:00	AAPL	Stock	64.2875	64.2875	64.0	64.1625	15788.0
2020-03-25 06:05:00	AAPL	Stock	64.1625	64.1625	63.8075	63.8075	18384.0
2020-03-25 06:10:00	AAPL	Stock	63.8	63.82	63.5025	63.5525	18728.0
2020-03-25 06:15:00	AAPL	Stock	63.5525	63.7125	63.3275	63.375	13884.0
2020-03-25 06:20:00	AAPL	Stock	63.275	63.3225	63.15	63.3	13432.0
2020-03-25 06:25:00	AAPL	Stock	63.255	63.4375	63.0625	63.125	17588.0
2020-03-25 06:30:00	AAPL	Stock	63.075	63.1875	63.05	63.05	12848.0
2020-03-25 06:35:00	AAPL	Stock	63.0625	63.0625	62.75	62.9075	9912.0
2020-03-25 06:40:00	AAPL	Stock	62.9175	62.9175	62.625	62.6925	34288.0
2020-03-25 06:45:00	AAPL	Stock	62.6925	62.925	62.4325	62.7775	76608.0
2020-03-25 06:50:00	AAPL	Stock	62.7775	62.7775	62.0375	62.125	44968.0
2020-03-25 06:55:00	AAPL	Stock	62.0375	62.375	61.8275	61.8275	25036.0
2020-03-25 07:00:00	AAPL	Stock	62.0625	62.5025	62.0	62.5	215948.0
2020-03-25 07:05:00	AAPL	Stock	62.5	62.875	62.44	62.44	143936.0
2020-03-25 07:10:00	AAPL	Stock	62.5	62.5	62.0	62.45	51692.0
2020-03-25 07:15:00	AAPL	Stock	62.48	62.7475	62.375	62.5	85736.0
2020-03-25 07:20:00	AAPL	Stock	62.545	62.75	62.3375	62.75	85776.0
2020-03-25 07:25:00	AAPL	Stock	62.7475	62.7875	62.5025	62.52	50908.0
2020-03-25 07:30:00	AAPL	Stock	62.575	62.6225	61.8125	61.8125	164228.0
2020-03-25 07:35:00	AAPL	Stock	61.8125	62.05	61.795	61.8875	57768.0
2020-03-25 07:40:00	AAPL	Stock	61.9975	62.125	61.8475	62.0875	103180.0
2020-03-25 07:45:00	AAPL	Stock	62.005	62.105	61.875	62.06	21572.0
2020-03-25 07:50:00	AAPL	Stock	62.075	62.095	61.7875	61.7875	34640.0
2020-03-25 07:55:00	AAPL	Stock	61.775	62.1025	61.6375	62.1025	86192.0
2020-03-25 08:00:00	AAPL	Stock	62.4825	62.875	61.625	62.44	336288.0
2020-03-25 08:05:00	AAPL	Stock	62.425	62.5225	62.2175	62.4775	172032.0

> showing 50 of 426,783 rows — these rows as CSV

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