PREVIEW / stock_5min / 2020-03-13

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-13.parquet
  size:    6.9 MB
  rows:    428,890
  symbols: 2,465

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-13 04:00:00	AAPL	Stock	63.775	65.4225	63.775	65.25	58732.0
2020-03-13 04:05:00	AAPL	Stock	65.015	65.25	65.0125	65.05	19620.0
2020-03-13 04:10:00	AAPL	Stock	64.8	64.95	63.925	64.45	28252.0
2020-03-13 04:15:00	AAPL	Stock	64.485	64.55	63.975	64.0125	22184.0
2020-03-13 04:20:00	AAPL	Stock	63.8875	64.25	63.8875	64.025	7396.0
2020-03-13 04:25:00	AAPL	Stock	64.0025	64.3775	64.0025	64.3775	15964.0
2020-03-13 04:30:00	AAPL	Stock	64.1025	64.1025	63.75	63.8275	24516.0
2020-03-13 04:35:00	AAPL	Stock	63.875	63.9025	63.75	63.775	6832.0
2020-03-13 04:40:00	AAPL	Stock	63.775	63.775	63.5	63.5	20120.0
2020-03-13 04:45:00	AAPL	Stock	63.5975	63.675	63.5875	63.5875	6584.0
2020-03-13 04:50:00	AAPL	Stock	63.5075	63.8375	63.5075	63.825	2136.0
2020-03-13 04:55:00	AAPL	Stock	63.925	63.935	63.8025	63.8025	6564.0
2020-03-13 05:00:00	AAPL	Stock	63.895	63.9625	63.75	63.7775	8584.0
2020-03-13 05:05:00	AAPL	Stock	63.7775	63.7775	63.65	63.65	4692.0
2020-03-13 05:10:00	AAPL	Stock	63.65	63.95	63.575	63.95	5788.0
2020-03-13 05:15:00	AAPL	Stock	63.935	64.075	63.935	64.075	11480.0
2020-03-13 05:20:00	AAPL	Stock	64.0	64.3725	64.0	64.3725	7548.0
2020-03-13 05:25:00	AAPL	Stock	64.37	64.4975	64.1	64.25	11064.0
2020-03-13 05:30:00	AAPL	Stock	64.35	64.35	64.3375	64.3475	1316.0
2020-03-13 05:35:00	AAPL	Stock	64.25	64.3575	64.25	64.3575	800.0
2020-03-13 05:40:00	AAPL	Stock	64.35	64.35	64.35	64.35	800.0
2020-03-13 05:45:00	AAPL	Stock	64.375	64.39	64.375	64.39	800.0
2020-03-13 05:50:00	AAPL	Stock	64.375	64.5625	64.375	64.5125	6644.0
2020-03-13 05:55:00	AAPL	Stock	64.5525	64.7	64.5	64.6975	11132.0
2020-03-13 06:00:00	AAPL	Stock	64.625	64.87	64.6	64.775	4720.0
2020-03-13 06:05:00	AAPL	Stock	64.84	64.84	64.5	64.65	103836.0
2020-03-13 06:10:00	AAPL	Stock	64.775	64.8025	64.685	64.8	4800.0
2020-03-13 06:15:00	AAPL	Stock	64.8125	65.25	64.8125	65.1625	19628.0
2020-03-13 06:20:00	AAPL	Stock	65.25	65.3125	65.1	65.1125	103136.0
2020-03-13 06:25:00	AAPL	Stock	65.1125	65.15	64.8625	64.875	16296.0
2020-03-13 06:30:00	AAPL	Stock	64.8875	65.0	64.75	64.75	30340.0
2020-03-13 06:35:00	AAPL	Stock	64.755	64.755	64.665	64.735	9592.0
2020-03-13 06:40:00	AAPL	Stock	64.7675	64.85	64.7575	64.85	11008.0
2020-03-13 06:45:00	AAPL	Stock	64.7875	64.885	64.75	64.75	12308.0
2020-03-13 06:50:00	AAPL	Stock	64.825	64.9375	64.8	64.9375	11124.0
2020-03-13 06:55:00	AAPL	Stock	65.0	65.12	65.0	65.0075	5344.0
2020-03-13 07:00:00	AAPL	Stock	65.005	65.075	64.5	64.91	312572.0
2020-03-13 07:05:00	AAPL	Stock	64.9225	65.1375	64.8225	65.125	145096.0
2020-03-13 07:10:00	AAPL	Stock	65.0725	65.1875	65.0625	65.1875	50016.0
2020-03-13 07:15:00	AAPL	Stock	65.2	65.4125	65.1675	65.2875	75132.0
2020-03-13 07:20:00	AAPL	Stock	65.3	65.4125	65.2375	65.375	76760.0
2020-03-13 07:25:00	AAPL	Stock	65.375	65.375	65.3	65.35	51768.0
2020-03-13 07:30:00	AAPL	Stock	65.3275	65.47	65.3125	65.365	122940.0
2020-03-13 07:35:00	AAPL	Stock	65.41	65.5825	65.375	65.5825	122936.0
2020-03-13 07:40:00	AAPL	Stock	65.58	65.86	65.575	65.86	131744.0
2020-03-13 07:45:00	AAPL	Stock	65.86	65.86	65.715	65.7825	151772.0
2020-03-13 07:50:00	AAPL	Stock	65.75	65.815	65.72	65.7875	53136.0
2020-03-13 07:55:00	AAPL	Stock	65.8	66.0	65.6875	65.9	119236.0
2020-03-13 08:00:00	AAPL	Stock	64.8125	66.0825	64.5	66.0825	602928.0
2020-03-13 08:05:00	AAPL	Stock	66.0825	66.1975	66.0825	66.1425	158824.0

> showing 50 of 428,890 rows — these rows as CSV

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