PREVIEW / stock_5min / 2020-04-07

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-07.parquet
  size:    6.5 MB
  rows:    412,551
  symbols: 2,392

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-04-07 04:00:00	AAPL	Stock	67.25	67.25	66.7625	66.7625	28692.0
2020-04-07 04:05:00	AAPL	Stock	66.9625	67.0725	66.9	67.0	30264.0
2020-04-07 04:10:00	AAPL	Stock	67.0	67.1925	67.0	67.125	13720.0
2020-04-07 04:15:00	AAPL	Stock	67.05	67.1425	67.05	67.1425	14716.0
2020-04-07 04:20:00	AAPL	Stock	67.25	67.375	67.25	67.375	3856.0
2020-04-07 04:25:00	AAPL	Stock	67.445	67.4625	67.3	67.3725	18864.0
2020-04-07 04:30:00	AAPL	Stock	67.3825	67.3825	67.25	67.25	8392.0
2020-04-07 04:35:00	AAPL	Stock	67.2775	67.375	67.25	67.2925	12900.0
2020-04-07 04:40:00	AAPL	Stock	67.315	67.375	67.3075	67.34	3780.0
2020-04-07 04:45:00	AAPL	Stock	67.25	67.2525	67.25	67.2525	2240.0
2020-04-07 04:50:00	AAPL	Stock	67.25	67.25	67.245	67.25	1880.0
2020-04-07 04:55:00	AAPL	Stock	67.2475	67.2475	67.075	67.075	3692.0
2020-04-07 05:00:00	AAPL	Stock	67.125	67.125	67.125	67.125	2320.0
2020-04-07 05:05:00	AAPL	Stock	67.1975	67.2	67.1425	67.2	4392.0
2020-04-07 05:10:00	AAPL	Stock	67.1975	67.2125	67.1825	67.1825	1712.0
2020-04-07 05:15:00	AAPL	Stock	67.065	67.1075	67.0	67.0125	13816.0
2020-04-07 05:20:00	AAPL	Stock	67.0125	67.1175	66.97	67.1175	7096.0
2020-04-07 05:25:00	AAPL	Stock	67.08	67.08	67.08	67.08	400.0
2020-04-07 05:30:00	AAPL	Stock	67.11	67.16	67.11	67.16	5260.0
2020-04-07 05:55:00	AAPL	Stock	67.095	67.15	67.05	67.1475	7664.0
2020-04-07 06:00:00	AAPL	Stock	67.1375	67.345	67.075	67.345	11144.0
2020-04-07 06:05:00	AAPL	Stock	67.375	67.375	67.2425	67.325	7712.0
2020-04-07 06:10:00	AAPL	Stock	67.37	67.37	67.2825	67.2825	812.0
2020-04-07 06:15:00	AAPL	Stock	67.5	67.5975	67.5	67.5975	6624.0
2020-04-07 06:20:00	AAPL	Stock	67.5975	67.65	67.55	67.5875	21784.0
2020-04-07 06:25:00	AAPL	Stock	67.5625	67.575	67.4625	67.4625	11128.0
2020-04-07 06:30:00	AAPL	Stock	67.43	67.475	67.41	67.475	7616.0
2020-04-07 06:35:00	AAPL	Stock	67.405	67.425	67.375	67.4	8936.0
2020-04-07 06:40:00	AAPL	Stock	67.4925	67.5	67.4925	67.5	1200.0
2020-04-07 06:45:00	AAPL	Stock	67.5	67.5975	67.5	67.5975	2308.0
2020-04-07 06:50:00	AAPL	Stock	67.59	67.59	67.59	67.59	532.0
2020-04-07 06:55:00	AAPL	Stock	67.605	67.625	67.5275	67.61	8868.0
2020-04-07 07:00:00	AAPL	Stock	67.54	67.625	67.45	67.57	171548.0
2020-04-07 07:05:00	AAPL	Stock	67.575	67.6	67.25	67.3675	176788.0
2020-04-07 07:10:00	AAPL	Stock	67.2925	67.2925	67.125	67.205	170720.0
2020-04-07 07:15:00	AAPL	Stock	67.245	67.3625	67.18	67.225	83840.0
2020-04-07 07:20:00	AAPL	Stock	67.225	67.255	66.9975	67.125	147640.0
2020-04-07 07:25:00	AAPL	Stock	67.125	67.3225	67.125	67.205	42364.0
2020-04-07 07:30:00	AAPL	Stock	67.2025	67.31	67.2	67.2875	32764.0
2020-04-07 07:35:00	AAPL	Stock	67.3	67.375	67.1225	67.2375	79400.0
2020-04-07 07:40:00	AAPL	Stock	67.18	67.215	66.995	67.0625	53904.0
2020-04-07 07:45:00	AAPL	Stock	67.0025	67.15	67.0	67.15	37220.0
2020-04-07 07:50:00	AAPL	Stock	67.15	67.2	67.1075	67.1075	26088.0
2020-04-07 07:55:00	AAPL	Stock	67.09	67.1475	67.0125	67.1	43188.0
2020-04-07 08:00:00	AAPL	Stock	67.4055	67.61	67.0	67.1542	408096.0
2020-04-07 08:05:00	AAPL	Stock	67.1575	67.2125	67.0975	67.1975	26040.0
2020-04-07 08:10:00	AAPL	Stock	67.2	67.3125	67.1575	67.2775	146400.0
2020-04-07 08:15:00	AAPL	Stock	67.2775	67.4475	67.2775	67.4225	112740.0
2020-04-07 08:20:00	AAPL	Stock	67.4475	67.47	67.295	67.375	222196.0
2020-04-07 08:25:00	AAPL	Stock	67.3975	67.415	67.2875	67.29	50916.0

> showing 50 of 412,551 rows — these rows as CSV

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