PREVIEW / stock_5min / 2020-07-31

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-31.parquet
  size:    6.6 MB
  rows:    417,219
  symbols: 2,464

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-07-31 04:00:00	AAPL	Stock	102.335	102.375	102.23	102.24	28520.0
2020-07-31 04:05:00	AAPL	Stock	102.165	102.165	102.0375	102.1	2128.0
2020-07-31 04:10:00	AAPL	Stock	102.025	102.06	102.005	102.01	11684.0
2020-07-31 04:15:00	AAPL	Stock	102.01	102.01	101.8325	101.8625	26672.0
2020-07-31 04:20:00	AAPL	Stock	101.925	102.1	101.925	102.1	6328.0
2020-07-31 04:25:00	AAPL	Stock	102.1	102.2475	102.1	102.2475	11160.0
2020-07-31 04:30:00	AAPL	Stock	102.195	102.255	102.195	102.21	8112.0
2020-07-31 04:35:00	AAPL	Stock	102.1	102.1925	101.75	102.1525	45072.0
2020-07-31 04:40:00	AAPL	Stock	102.2175	102.2175	102.2175	102.2175	956.0
2020-07-31 04:45:00	AAPL	Stock	102.2475	102.25	102.2	102.2	3640.0
2020-07-31 04:50:00	AAPL	Stock	102.275	102.2975	102.2175	102.2975	2400.0
2020-07-31 04:55:00	AAPL	Stock	102.23	102.39	102.0475	102.135	43212.0
2020-07-31 05:00:00	AAPL	Stock	102.1575	102.1775	102.1425	102.1775	4276.0
2020-07-31 05:05:00	AAPL	Stock	102.225	102.255	102.225	102.255	1320.0
2020-07-31 05:10:00	AAPL	Stock	102.2625	102.2625	102.2625	102.2625	400.0
2020-07-31 05:15:00	AAPL	Stock	102.26	102.26	102.225	102.225	5900.0
2020-07-31 05:30:00	AAPL	Stock	102.25	102.275	102.2225	102.275	2704.0
2020-07-31 05:35:00	AAPL	Stock	102.2475	102.2475	102.2475	102.2475	400.0
2020-07-31 05:40:00	AAPL	Stock	102.15	102.15	102.1325	102.15	2668.0
2020-07-31 05:45:00	AAPL	Stock	102.22	102.225	102.2125	102.2125	2780.0
2020-07-31 05:50:00	AAPL	Stock	102.2625	102.2625	102.125	102.125	6588.0
2020-07-31 05:55:00	AAPL	Stock	102.09	102.115	102.0875	102.115	5104.0
2020-07-31 06:00:00	AAPL	Stock	102.0975	102.0975	101.95	101.95	2000.0
2020-07-31 06:05:00	AAPL	Stock	102.0	102.035	101.9325	101.9725	16388.0
2020-07-31 06:10:00	AAPL	Stock	101.9425	102.0075	101.9425	102.0075	3688.0
2020-07-31 06:15:00	AAPL	Stock	101.9525	102.0	101.9525	102.0	1600.0
2020-07-31 06:20:00	AAPL	Stock	102.0025	102.0025	101.9825	101.985	2000.0
2020-07-31 06:25:00	AAPL	Stock	101.9925	102.175	101.975	102.175	4080.0
2020-07-31 06:30:00	AAPL	Stock	102.1275	102.1375	102.035	102.1125	5608.0
2020-07-31 06:35:00	AAPL	Stock	102.195	102.195	102.195	102.195	400.0
2020-07-31 06:40:00	AAPL	Stock	102.015	102.075	102.015	102.075	1200.0
2020-07-31 06:45:00	AAPL	Stock	102.125	102.125	101.9925	102.0	13420.0
2020-07-31 06:50:00	AAPL	Stock	101.965	102.0125	101.965	102.0	16228.0
2020-07-31 06:55:00	AAPL	Stock	102.0	102.235	102.0	102.1375	11420.0
2020-07-31 07:00:00	AAPL	Stock	102.125	102.83	102.125	102.8	340488.0
2020-07-31 07:05:00	AAPL	Stock	102.8425	103.0825	102.72	102.875	220940.0
2020-07-31 07:10:00	AAPL	Stock	102.9125	103.18	102.895	103.175	147176.0
2020-07-31 07:15:00	AAPL	Stock	103.17	103.47	103.08	103.25	223068.0
2020-07-31 07:20:00	AAPL	Stock	103.235	103.4875	103.15	103.45	194076.0
2020-07-31 07:25:00	AAPL	Stock	103.45	103.4675	103.1875	103.245	192032.0
2020-07-31 07:30:00	AAPL	Stock	103.225	103.345	103.025	103.025	164256.0
2020-07-31 07:35:00	AAPL	Stock	103.09	103.2125	103.03	103.15	86540.0
2020-07-31 07:40:00	AAPL	Stock	103.1575	103.2	103.0775	103.1125	112884.0
2020-07-31 07:45:00	AAPL	Stock	103.1	103.35	103.0525	103.295	171724.0
2020-07-31 07:50:00	AAPL	Stock	103.32	103.3248	103.1625	103.2725	92796.0
2020-07-31 07:55:00	AAPL	Stock	103.27	103.35	103.0775	103.2925	260532.0
2020-07-31 08:00:00	AAPL	Stock	103.175	103.4925	102.25	102.8625	929868.0
2020-07-31 08:05:00	AAPL	Stock	102.8625	103.0	102.8625	102.9925	89880.0
2020-07-31 08:10:00	AAPL	Stock	102.995	103.2375	102.995	103.235	154768.0
2020-07-31 08:15:00	AAPL	Stock	103.2175	103.35	103.0875	103.2475	233992.0

> showing 50 of 417,219 rows — these rows as CSV

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