PREVIEW / stock_5min / 2019-12-20

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-12-20.parquet
  size:    6.0 MB
  rows:    373,300
  symbols: 2,494

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
2019-12-20 04:00:00	AAPL	Stock	70.025	70.025	70.025	70.025	2000.0
2019-12-20 04:30:00	AAPL	Stock	70.005	70.005	70.0	70.0	1008.0
2019-12-20 05:30:00	AAPL	Stock	70.0825	70.0825	70.0825	70.0825	1692.0
2019-12-20 05:50:00	AAPL	Stock	70.12	70.12	70.12	70.12	1316.0
2019-12-20 06:00:00	AAPL	Stock	70.115	70.115	70.115	70.115	1000.0
2019-12-20 06:05:00	AAPL	Stock	70.1	70.1	70.1	70.1	1600.0
2019-12-20 06:15:00	AAPL	Stock	70.085	70.085	70.085	70.085	2444.0
2019-12-20 06:20:00	AAPL	Stock	70.1675	70.1675	70.1675	70.1675	400.0
2019-12-20 06:25:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	1200.0
2019-12-20 06:40:00	AAPL	Stock	70.1125	70.1125	70.1125	70.1125	3600.0
2019-12-20 06:55:00	AAPL	Stock	70.1	70.1	70.075	70.075	2400.0
2019-12-20 07:00:00	AAPL	Stock	70.075	70.085	70.07	70.075	13568.0
2019-12-20 07:05:00	AAPL	Stock	70.0575	70.0575	70.0375	70.0375	3280.0
2019-12-20 07:10:00	AAPL	Stock	70.0325	70.07	70.0325	70.04	4356.0
2019-12-20 07:20:00	AAPL	Stock	70.0525	70.0525	70.0375	70.0375	7064.0
2019-12-20 07:25:00	AAPL	Stock	70.0425	70.0625	70.0425	70.0625	2740.0
2019-12-20 07:30:00	AAPL	Stock	70.06	70.06	70.055	70.055	2852.0
2019-12-20 07:35:00	AAPL	Stock	70.0625	70.2	70.0625	70.2	46560.0
2019-12-20 07:40:00	AAPL	Stock	70.2	70.2	70.15	70.15	8768.0
2019-12-20 07:45:00	AAPL	Stock	70.1375	70.1375	70.1375	70.1375	1180.0
2019-12-20 07:50:00	AAPL	Stock	70.1625	70.2175	70.1625	70.21	12892.0
2019-12-20 07:55:00	AAPL	Stock	70.2225	70.25	70.22	70.2475	8340.0
2019-12-20 08:00:00	AAPL	Stock	70.07	70.25	70.04	70.2375	26004.0
2019-12-20 08:05:00	AAPL	Stock	70.245	70.275	70.235	70.245	28816.0
2019-12-20 08:10:00	AAPL	Stock	70.27	70.2775	70.25	70.2775	29320.0
2019-12-20 08:15:00	AAPL	Stock	70.2625	70.2925	70.25	70.25	28648.0
2019-12-20 08:20:00	AAPL	Stock	70.2575	70.2875	70.25	70.2625	42860.0
2019-12-20 08:25:00	AAPL	Stock	70.275	70.2775	70.255	70.2575	15360.0
2019-12-20 08:30:00	AAPL	Stock	70.25	70.285	70.2375	70.255	27952.0
2019-12-20 08:35:00	AAPL	Stock	70.2575	70.285	70.2575	70.2625	26908.0
2019-12-20 08:40:00	AAPL	Stock	70.27	70.3	70.265	70.3	40900.0
2019-12-20 08:45:00	AAPL	Stock	70.29	70.3	70.285	70.2875	15708.0
2019-12-20 08:50:00	AAPL	Stock	70.2875	70.3	70.2625	70.2625	30868.0
2019-12-20 08:55:00	AAPL	Stock	70.2625	70.275	70.25	70.2525	30920.0
2019-12-20 09:00:00	AAPL	Stock	70.2625	70.2625	70.2125	70.2175	49824.0
2019-12-20 09:05:00	AAPL	Stock	70.2375	70.25	70.215	70.25	29396.0
2019-12-20 09:10:00	AAPL	Stock	70.2425	70.25	70.2	70.2125	21532.0
2019-12-20 09:15:00	AAPL	Stock	70.2	70.275	70.2	70.26	95616.0
2019-12-20 09:20:00	AAPL	Stock	70.275	70.3525	70.2525	70.3525	84516.0
2019-12-20 09:25:00	AAPL	Stock	70.35	70.885	70.3375	70.5525	1710816.0
2019-12-20 09:30:00	AAPL	Stock	70.5575	70.6625	70.305	70.435	28125168.0
2019-12-20 09:35:00	AAPL	Stock	70.43	70.5625	70.3125	70.345	2852144.0
2019-12-20 09:40:00	AAPL	Stock	70.345	70.3975	70.255	70.33	1616320.0
2019-12-20 09:45:00	AAPL	Stock	70.33	70.3725	70.215	70.2925	1982448.0
2019-12-20 09:50:00	AAPL	Stock	70.29	70.395	70.285	70.395	1441340.0
2019-12-20 09:55:00	AAPL	Stock	70.39	70.4238	70.23	70.2475	1299028.0
2019-12-20 10:00:00	AAPL	Stock	70.2488	70.4175	70.2275	70.3882	1347532.0
2019-12-20 10:05:00	AAPL	Stock	70.39	70.43	70.33	70.3825	904104.0
2019-12-20 10:10:00	AAPL	Stock	70.3835	70.4575	70.28	70.315	1243864.0
2019-12-20 10:15:00	AAPL	Stock	70.315	70.3475	70.265	70.265	920356.0

> showing 50 of 373,300 rows — these rows as CSV

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