PREVIEW / stock_5min / 2020-03-17

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-17.parquet
  size:    6.8 MB
  rows:    422,974
  symbols: 2,454

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-17 04:00:00	AAPL	Stock	63.35	64.415	63.35	64.29	38808.0
2020-03-17 04:05:00	AAPL	Stock	64.2525	64.7	64.2525	64.6275	18420.0
2020-03-17 04:10:00	AAPL	Stock	64.625	64.6275	64.2575	64.4525	70844.0
2020-03-17 04:15:00	AAPL	Stock	64.585	64.6	64.28	64.4375	17732.0
2020-03-17 04:20:00	AAPL	Stock	64.32	64.3275	63.975	64.0725	15044.0
2020-03-17 04:25:00	AAPL	Stock	63.9925	63.9925	63.3125	63.58	31664.0
2020-03-17 04:30:00	AAPL	Stock	63.6	63.75	63.475	63.6075	27592.0
2020-03-17 04:35:00	AAPL	Stock	63.5925	63.6475	63.3275	63.3275	9464.0
2020-03-17 04:40:00	AAPL	Stock	63.34	63.34	62.8875	63.0	11808.0
2020-03-17 04:45:00	AAPL	Stock	63.1	63.1	62.9	62.9	6340.0
2020-03-17 04:50:00	AAPL	Stock	62.7575	62.7725	62.455	62.455	46408.0
2020-03-17 04:55:00	AAPL	Stock	62.5025	62.625	62.0125	62.125	33308.0
2020-03-17 05:00:00	AAPL	Stock	62.23	62.625	62.025	62.625	37184.0
2020-03-17 05:05:00	AAPL	Stock	62.625	62.625	62.05	62.05	11996.0
2020-03-17 05:10:00	AAPL	Stock	62.2375	62.2375	62.125	62.125	3464.0
2020-03-17 05:15:00	AAPL	Stock	62.125	62.125	61.915	62.125	19420.0
2020-03-17 05:20:00	AAPL	Stock	62.125	62.125	61.875	61.9675	5376.0
2020-03-17 05:25:00	AAPL	Stock	61.9625	61.9625	61.55	61.75	23080.0
2020-03-17 05:30:00	AAPL	Stock	61.7025	61.7025	60.95	61.1	19416.0
2020-03-17 05:35:00	AAPL	Stock	60.8	60.95	60.64	60.95	11200.0
2020-03-17 05:45:00	AAPL	Stock	61.25	61.7	61.25	61.7	11192.0
2020-03-17 05:50:00	AAPL	Stock	61.7125	61.715	61.3975	61.3975	1688.0
2020-03-17 05:55:00	AAPL	Stock	61.375	61.585	61.375	61.585	3556.0
2020-03-17 06:00:00	AAPL	Stock	61.4	61.7625	61.3825	61.7625	10936.0
2020-03-17 06:05:00	AAPL	Stock	61.875	61.875	61.745	61.745	2788.0
2020-03-17 06:10:00	AAPL	Stock	61.755	62.2125	61.625	62.2125	36332.0
2020-03-17 06:15:00	AAPL	Stock	62.0	62.0025	61.75	61.75	13356.0
2020-03-17 06:20:00	AAPL	Stock	62.01	62.5975	61.9975	62.0625	41304.0
2020-03-17 06:25:00	AAPL	Stock	62.45	62.5	62.4325	62.5	2804.0
2020-03-17 06:30:00	AAPL	Stock	62.6225	62.6425	62.1875	62.42	11176.0
2020-03-17 06:35:00	AAPL	Stock	62.1875	62.4875	62.1875	62.375	3620.0
2020-03-17 06:40:00	AAPL	Stock	62.255	62.255	61.8375	62.0	18460.0
2020-03-17 06:45:00	AAPL	Stock	61.9975	62.1875	61.9975	62.1875	3828.0
2020-03-17 06:50:00	AAPL	Stock	62.375	62.625	62.375	62.625	4068.0
2020-03-17 06:55:00	AAPL	Stock	62.625	63.0625	62.625	63.0125	16328.0
2020-03-17 07:00:00	AAPL	Stock	62.7775	63.0625	62.515	62.63	80960.0
2020-03-17 07:05:00	AAPL	Stock	62.6825	62.8675	62.6825	62.75	27584.0
2020-03-17 07:10:00	AAPL	Stock	62.83	62.83	62.5575	62.7875	81156.0
2020-03-17 07:15:00	AAPL	Stock	62.815	62.815	62.655	62.75	19756.0
2020-03-17 07:20:00	AAPL	Stock	62.725	62.725	62.3225	62.5	64096.0
2020-03-17 07:25:00	AAPL	Stock	62.5	62.57	62.2525	62.325	20532.0
2020-03-17 07:30:00	AAPL	Stock	62.32	62.3975	61.75	61.75	64036.0
2020-03-17 07:35:00	AAPL	Stock	61.75	61.845	61.55	61.845	90412.0
2020-03-17 07:40:00	AAPL	Stock	61.8175	61.8175	61.5025	61.505	35808.0
2020-03-17 07:45:00	AAPL	Stock	61.5375	61.975	61.5375	61.82	27876.0
2020-03-17 07:50:00	AAPL	Stock	61.8225	61.9875	61.8125	61.8625	29232.0
2020-03-17 07:55:00	AAPL	Stock	61.86	61.9075	61.5775	61.59	42328.0
2020-03-17 08:00:00	AAPL	Stock	62.515	62.9375	61.5	61.75	219636.0
2020-03-17 08:05:00	AAPL	Stock	61.725	61.8475	61.5625	61.565	51528.0
2020-03-17 08:10:00	AAPL	Stock	61.595	62.04	61.565	61.82	59748.0

> showing 50 of 422,974 rows — these rows as CSV

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