PREVIEW / stock_5min / 2020-01-27

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-01-27.parquet
  size:    6.0 MB
  rows:    374,955
  symbols: 2,459

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-01-27 04:00:00	AAPL	Stock	78.475	78.475	78.25	78.2975	50264.0
2020-01-27 04:05:00	AAPL	Stock	78.3475	78.3475	78.1475	78.2	22764.0
2020-01-27 04:10:00	AAPL	Stock	78.2	78.3025	78.165	78.2425	17232.0
2020-01-27 04:15:00	AAPL	Stock	78.195	78.22	78.08	78.1375	17076.0
2020-01-27 04:20:00	AAPL	Stock	78.115	78.1525	78.115	78.1525	1332.0
2020-01-27 04:25:00	AAPL	Stock	78.1275	78.14	78.0	78.05	25700.0
2020-01-27 04:30:00	AAPL	Stock	78.05	78.05	78.05	78.05	400.0
2020-01-27 04:35:00	AAPL	Stock	78.065	78.065	77.96	77.96	9528.0
2020-01-27 04:40:00	AAPL	Stock	77.965	77.995	77.9325	77.955	7788.0
2020-01-27 04:45:00	AAPL	Stock	77.955	77.955	77.9125	77.925	4864.0
2020-01-27 04:50:00	AAPL	Stock	77.9025	78.0	77.8975	78.0	18348.0
2020-01-27 04:55:00	AAPL	Stock	78.02	78.05	78.0	78.0225	4000.0
2020-01-27 05:00:00	AAPL	Stock	78.0225	78.025	78.0	78.0	18580.0
2020-01-27 05:10:00	AAPL	Stock	77.875	77.875	77.7775	77.815	10660.0
2020-01-27 05:15:00	AAPL	Stock	77.875	77.8975	77.555	77.555	62712.0
2020-01-27 05:20:00	AAPL	Stock	77.5675	77.5675	77.3775	77.5	64376.0
2020-01-27 05:25:00	AAPL	Stock	77.525	77.675	77.4425	77.675	20508.0
2020-01-27 05:30:00	AAPL	Stock	77.7225	77.7225	77.575	77.575	8768.0
2020-01-27 05:35:00	AAPL	Stock	77.575	77.6125	77.5275	77.575	5144.0
2020-01-27 05:40:00	AAPL	Stock	77.595	77.6	77.4025	77.4675	12728.0
2020-01-27 05:45:00	AAPL	Stock	77.48	77.5075	77.48	77.5075	2784.0
2020-01-27 05:50:00	AAPL	Stock	77.475	77.525	77.46	77.525	13660.0
2020-01-27 05:55:00	AAPL	Stock	77.525	77.545	77.375	77.375	16572.0
2020-01-27 06:00:00	AAPL	Stock	77.3175	77.3975	77.17	77.25	46828.0
2020-01-27 06:05:00	AAPL	Stock	77.25	77.25	77.1475	77.22	21592.0
2020-01-27 06:10:00	AAPL	Stock	77.2	77.3475	77.1475	77.3475	55420.0
2020-01-27 06:15:00	AAPL	Stock	77.25	77.375	77.25	77.3	17876.0
2020-01-27 06:20:00	AAPL	Stock	77.385	77.525	77.385	77.5	28408.0
2020-01-27 06:25:00	AAPL	Stock	77.4375	77.575	77.4375	77.575	27924.0
2020-01-27 06:30:00	AAPL	Stock	77.6	77.6875	77.6	77.6	10028.0
2020-01-27 06:35:00	AAPL	Stock	77.6025	77.6025	77.5125	77.6025	6824.0
2020-01-27 06:40:00	AAPL	Stock	77.515	77.5875	77.5	77.5375	17332.0
2020-01-27 06:45:00	AAPL	Stock	77.5	77.5	77.36	77.4375	17004.0
2020-01-27 06:50:00	AAPL	Stock	77.435	77.555	77.435	77.5025	69584.0
2020-01-27 06:55:00	AAPL	Stock	77.535	77.575	77.535	77.575	10060.0
2020-01-27 07:00:00	AAPL	Stock	77.6375	77.875	77.5375	77.795	200568.0
2020-01-27 07:05:00	AAPL	Stock	77.8125	77.9575	77.8125	77.9575	49288.0
2020-01-27 07:10:00	AAPL	Stock	77.96	77.985	77.85	77.85	60344.0
2020-01-27 07:15:00	AAPL	Stock	77.88	77.95	77.85	77.95	30588.0
2020-01-27 07:20:00	AAPL	Stock	77.975	78.075	77.9375	78.0375	85516.0
2020-01-27 07:25:00	AAPL	Stock	78.0275	78.0975	78.0	78.0	40264.0
2020-01-27 07:30:00	AAPL	Stock	77.9975	78.03	77.925	77.9625	56992.0
2020-01-27 07:35:00	AAPL	Stock	77.95	77.9575	77.875	77.9	25528.0
2020-01-27 07:40:00	AAPL	Stock	77.95	78.0875	77.95	78.0425	43020.0
2020-01-27 07:45:00	AAPL	Stock	78.0	78.0	77.955	77.975	7916.0
2020-01-27 07:50:00	AAPL	Stock	77.975	77.975	77.8475	77.86	43780.0
2020-01-27 07:55:00	AAPL	Stock	77.8575	77.865	77.8	77.8125	48428.0
2020-01-27 08:00:00	AAPL	Stock	77.8	78.1	77.655	77.855	303208.0
2020-01-27 08:05:00	AAPL	Stock	77.8375	77.875	77.755	77.7792	90372.0
2020-01-27 08:10:00	AAPL	Stock	77.8	77.825	77.75	77.7825	155656.0

> showing 50 of 374,955 rows — these rows as CSV

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