PREVIEW / stock_5min / 2020-04-28

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-28.parquet
  size:    6.5 MB
  rows:    408,594
  symbols: 2,390

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-28 04:00:00	AAPL	Stock	71.125	71.125	71.125	71.125	540.0
2020-04-28 04:40:00	AAPL	Stock	71.0	71.0	71.0	71.0	800.0
2020-04-28 05:00:00	AAPL	Stock	70.9725	70.9725	70.9725	70.9725	400.0
2020-04-28 05:15:00	AAPL	Stock	71.025	71.025	71.025	71.025	3588.0
2020-04-28 05:20:00	AAPL	Stock	71.1925	71.3	71.1925	71.3	1672.0
2020-04-28 05:25:00	AAPL	Stock	71.315	71.3175	71.315	71.3175	1300.0
2020-04-28 06:00:00	AAPL	Stock	71.55	71.625	71.55	71.625	800.0
2020-04-28 06:05:00	AAPL	Stock	71.625	71.6625	71.625	71.6625	3416.0
2020-04-28 06:10:00	AAPL	Stock	71.7025	71.7325	71.69	71.69	3740.0
2020-04-28 06:20:00	AAPL	Stock	71.515	71.515	71.5025	71.5025	2400.0
2020-04-28 06:30:00	AAPL	Stock	71.5225	71.5225	71.5225	71.5225	400.0
2020-04-28 07:00:00	AAPL	Stock	71.5275	71.5525	71.29	71.3375	32964.0
2020-04-28 07:05:00	AAPL	Stock	71.335	71.4675	71.335	71.4675	8864.0
2020-04-28 07:10:00	AAPL	Stock	71.46	71.5	71.445	71.445	4520.0
2020-04-28 07:15:00	AAPL	Stock	71.4725	71.5525	71.4675	71.5	29732.0
2020-04-28 07:25:00	AAPL	Stock	71.525	71.55	71.525	71.55	3236.0
2020-04-28 07:30:00	AAPL	Stock	71.55	71.55	71.4	71.4	24176.0
2020-04-28 07:35:00	AAPL	Stock	71.4	71.445	71.3775	71.4	5016.0
2020-04-28 07:40:00	AAPL	Stock	71.4575	71.4575	71.4	71.4	4076.0
2020-04-28 07:45:00	AAPL	Stock	71.4425	71.4475	71.3775	71.3775	2800.0
2020-04-28 07:50:00	AAPL	Stock	71.4125	71.475	71.385	71.43	7344.0
2020-04-28 07:55:00	AAPL	Stock	71.4725	71.475	71.4125	71.4675	2780.0
2020-04-28 08:00:00	AAPL	Stock	71.42	71.55	71.3	71.3425	122620.0
2020-04-28 08:05:00	AAPL	Stock	71.3312	71.3375	71.3	71.3375	31188.0
2020-04-28 08:10:00	AAPL	Stock	71.325	71.325	71.2625	71.275	14880.0
2020-04-28 08:15:00	AAPL	Stock	71.3	71.3	71.25	71.25	15660.0
2020-04-28 08:20:00	AAPL	Stock	71.2428	71.33	71.225	71.33	29084.0
2020-04-28 08:25:00	AAPL	Stock	71.325	71.325	71.21	71.2575	11924.0
2020-04-28 08:30:00	AAPL	Stock	71.25	71.295	71.225	71.2275	23488.0
2020-04-28 08:35:00	AAPL	Stock	71.2175	71.275	71.205	71.275	14144.0
2020-04-28 08:40:00	AAPL	Stock	71.265	71.285	71.2275	71.285	16812.0
2020-04-28 08:45:00	AAPL	Stock	71.2825	71.3	71.2525	71.3	11396.0
2020-04-28 08:50:00	AAPL	Stock	71.275	71.325	71.275	71.3225	9192.0
2020-04-28 08:55:00	AAPL	Stock	71.3125	71.33	71.3	71.3225	17860.0
2020-04-28 09:00:00	AAPL	Stock	71.2875	71.33	71.2742	71.2825	37344.0
2020-04-28 09:05:00	AAPL	Stock	71.32	71.32	71.26	71.275	8228.0
2020-04-28 09:10:00	AAPL	Stock	71.2925	71.2975	71.2625	71.275	19432.0
2020-04-28 09:15:00	AAPL	Stock	71.2775	71.2925	71.225	71.225	48404.0
2020-04-28 09:20:00	AAPL	Stock	71.225	71.31	71.225	71.2875	25676.0
2020-04-28 09:25:00	AAPL	Stock	71.2925	71.31	71.2375	71.2375	46020.0
2020-04-28 09:30:00	AAPL	Stock	71.2475	71.42	71.145	71.385	4319180.0
2020-04-28 09:35:00	AAPL	Stock	71.3975	71.4575	71.07	71.115	2048848.0
2020-04-28 09:40:00	AAPL	Stock	71.115	71.2095	71.0575	71.1725	1272956.0
2020-04-28 09:45:00	AAPL	Stock	71.17	71.3475	71.1675	71.2355	1574360.0
2020-04-28 09:50:00	AAPL	Stock	71.23	71.41	71.17	71.3488	1408444.0
2020-04-28 09:55:00	AAPL	Stock	71.34	71.3775	71.08	71.175	1522968.0
2020-04-28 10:00:00	AAPL	Stock	71.17	71.23	70.945	71.092	1872848.0
2020-04-28 10:05:00	AAPL	Stock	71.0825	71.2775	71.0825	71.2175	1427712.0
2020-04-28 10:10:00	AAPL	Stock	71.225	71.3525	71.19	71.25	1320208.0
2020-04-28 10:15:00	AAPL	Stock	71.2538	71.2675	71.0075	71.0327	1392828.0

> showing 50 of 408,594 rows — these rows as CSV

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