PREVIEW / stock_5min / 2020-04-13

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-13.parquet
  size:    6.3 MB
  rows:    400,577
  symbols: 2,382

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-13 04:00:00	AAPL	Stock	66.375	66.375	66.375	66.375	1200.0
2020-04-13 04:05:00	AAPL	Stock	66.45	66.45	66.1975	66.28	7148.0
2020-04-13 04:10:00	AAPL	Stock	66.25	66.25	66.25	66.25	1156.0
2020-04-13 04:25:00	AAPL	Stock	66.3025	66.3025	66.2625	66.2625	5576.0
2020-04-13 04:30:00	AAPL	Stock	66.2625	66.2625	66.25	66.25	2524.0
2020-04-13 04:45:00	AAPL	Stock	66.125	66.125	66.125	66.125	400.0
2020-04-13 05:15:00	AAPL	Stock	66.5125	66.5125	66.5125	66.5125	400.0
2020-04-13 05:25:00	AAPL	Stock	66.625	66.625	66.625	66.625	400.0
2020-04-13 05:30:00	AAPL	Stock	66.6125	66.6225	66.6125	66.6225	800.0
2020-04-13 05:35:00	AAPL	Stock	66.5125	66.5125	66.5025	66.5025	800.0
2020-04-13 05:45:00	AAPL	Stock	66.5125	66.5125	66.425	66.4525	1212.0
2020-04-13 06:05:00	AAPL	Stock	66.5	66.5	66.5	66.5	1072.0
2020-04-13 06:35:00	AAPL	Stock	66.475	66.4875	66.475	66.475	2800.0
2020-04-13 06:45:00	AAPL	Stock	66.6	66.6	66.6	66.6	400.0
2020-04-13 06:50:00	AAPL	Stock	66.605	66.605	66.605	66.605	400.0
2020-04-13 07:00:00	AAPL	Stock	66.6	66.7375	66.475	66.705	45220.0
2020-04-13 07:05:00	AAPL	Stock	66.72	66.7575	66.72	66.7575	39864.0
2020-04-13 07:10:00	AAPL	Stock	66.7625	66.7775	66.675	66.7225	27532.0
2020-04-13 07:15:00	AAPL	Stock	66.7075	66.75	66.65	66.7475	23092.0
2020-04-13 07:20:00	AAPL	Stock	66.8375	66.9025	66.8	66.9025	23192.0
2020-04-13 07:25:00	AAPL	Stock	66.8725	66.895	66.8625	66.875	12612.0
2020-04-13 07:30:00	AAPL	Stock	66.93	66.985	66.905	66.95	26212.0
2020-04-13 07:35:00	AAPL	Stock	66.975	66.975	66.91	66.9325	13440.0
2020-04-13 07:40:00	AAPL	Stock	66.9	66.905	66.8125	66.8125	23860.0
2020-04-13 07:45:00	AAPL	Stock	66.79	66.875	66.7825	66.87	9260.0
2020-04-13 07:50:00	AAPL	Stock	66.8675	67.0	66.8675	67.0	33372.0
2020-04-13 07:55:00	AAPL	Stock	67.0375	67.0375	66.9425	67.0	23460.0
2020-04-13 08:00:00	AAPL	Stock	66.7032	67.0625	66.5625	66.915	123176.0
2020-04-13 08:05:00	AAPL	Stock	66.935	67.0675	66.9125	67.0675	19204.0
2020-04-13 08:10:00	AAPL	Stock	67.1	67.275	67.0625	67.2	39464.0
2020-04-13 08:15:00	AAPL	Stock	67.1675	67.275	67.095	67.095	104792.0
2020-04-13 08:20:00	AAPL	Stock	67.12	67.15	66.8775	67.015	33336.0
2020-04-13 08:25:00	AAPL	Stock	67.095	67.125	67.025	67.025	16560.0
2020-04-13 08:30:00	AAPL	Stock	67.0625	67.1575	67.0425	67.1425	16380.0
2020-04-13 08:35:00	AAPL	Stock	67.1125	67.1375	67.0625	67.135	12000.0
2020-04-13 08:40:00	AAPL	Stock	67.135	67.16	67.0	67.0375	56924.0
2020-04-13 08:45:00	AAPL	Stock	67.0225	67.1425	67.0225	67.1425	18724.0
2020-04-13 08:50:00	AAPL	Stock	67.15	67.1875	67.0975	67.15	21980.0
2020-04-13 08:55:00	AAPL	Stock	67.1472	67.1472	67.0025	67.0825	53408.0
2020-04-13 09:00:00	AAPL	Stock	67.0132	67.125	67.0125	67.1075	20352.0
2020-04-13 09:05:00	AAPL	Stock	67.125	67.1667	67.06	67.0692	12860.0
2020-04-13 09:10:00	AAPL	Stock	67.0975	67.1275	67.0975	67.1125	9152.0
2020-04-13 09:15:00	AAPL	Stock	67.1125	67.23	67.1	67.225	56964.0
2020-04-13 09:20:00	AAPL	Stock	67.2075	67.2575	67.2	67.25	27544.0
2020-04-13 09:25:00	AAPL	Stock	67.2475	67.2475	67.0025	67.0775	121404.0
2020-04-13 09:30:00	AAPL	Stock	67.0775	67.1975	66.923	67.06	4054280.0
2020-04-13 09:35:00	AAPL	Stock	67.065	67.43	67.0338	67.3838	2770416.0
2020-04-13 09:40:00	AAPL	Stock	67.3875	67.3975	67.02	67.04	1756516.0
2020-04-13 09:45:00	AAPL	Stock	67.0425	67.09	66.7525	66.8612	2033984.0
2020-04-13 09:50:00	AAPL	Stock	66.865	66.97	66.79	66.795	1318572.0

> showing 50 of 400,577 rows — these rows as CSV

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