PREVIEW / stock_5min / 2020-03-23

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-23.parquet
  size:    6.7 MB
  rows:    427,675
  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-03-23 04:00:00	AAPL	Stock	56.22	56.22	55.5	55.75	43272.0
2020-03-23 04:05:00	AAPL	Stock	55.75	55.975	55.5	55.625	23340.0
2020-03-23 04:10:00	AAPL	Stock	55.6	55.6	55.6	55.6	400.0
2020-03-23 04:15:00	AAPL	Stock	55.55	55.5525	55.37	55.45	36476.0
2020-03-23 04:20:00	AAPL	Stock	55.4475	55.5375	55.425	55.4625	27612.0
2020-03-23 04:25:00	AAPL	Stock	55.475	55.75	55.475	55.75	4428.0
2020-03-23 04:30:00	AAPL	Stock	55.75	55.86	55.6675	55.675	8020.0
2020-03-23 04:35:00	AAPL	Stock	55.7925	55.875	55.6875	55.6875	10564.0
2020-03-23 04:40:00	AAPL	Stock	55.625	55.87	55.625	55.75	5548.0
2020-03-23 04:45:00	AAPL	Stock	55.8725	55.875	55.8725	55.875	5468.0
2020-03-23 04:50:00	AAPL	Stock	55.8125	55.875	55.75	55.75	9480.0
2020-03-23 04:55:00	AAPL	Stock	55.775	55.8	55.655	55.6875	7288.0
2020-03-23 05:00:00	AAPL	Stock	55.75	55.975	55.7	55.975	6848.0
2020-03-23 05:05:00	AAPL	Stock	56.095	56.095	55.9475	55.9475	5172.0
2020-03-23 05:10:00	AAPL	Stock	55.9	55.975	55.875	55.875	2672.0
2020-03-23 05:15:00	AAPL	Stock	55.75	55.75	55.75	55.75	512.0
2020-03-23 05:20:00	AAPL	Stock	56.0	56.0	55.8875	55.8875	3536.0
2020-03-23 05:25:00	AAPL	Stock	55.83	55.83	55.7	55.7	2000.0
2020-03-23 05:30:00	AAPL	Stock	56.0325	56.0325	56.0325	56.0325	400.0
2020-03-23 05:35:00	AAPL	Stock	56.075	56.1	56.0075	56.0075	1500.0
2020-03-23 05:40:00	AAPL	Stock	56.235	56.235	56.0	56.0	19192.0
2020-03-23 05:45:00	AAPL	Stock	56.25	56.375	55.95	56.12	61408.0
2020-03-23 05:50:00	AAPL	Stock	56.05	56.05	55.9375	55.9375	3552.0
2020-03-23 05:55:00	AAPL	Stock	56.025	56.175	56.015	56.1	6664.0
2020-03-23 06:00:00	AAPL	Stock	56.0375	56.0375	56.0375	56.0375	400.0
2020-03-23 06:05:00	AAPL	Stock	56.08	56.4375	56.08	56.375	21020.0
2020-03-23 06:10:00	AAPL	Stock	56.3425	56.3425	56.1375	56.2475	24160.0
2020-03-23 06:15:00	AAPL	Stock	56.1325	56.135	56.0425	56.0425	2180.0
2020-03-23 06:20:00	AAPL	Stock	56.0625	56.1	56.0625	56.1	1168.0
2020-03-23 06:25:00	AAPL	Stock	56.15	56.225	56.15	56.225	800.0
2020-03-23 06:30:00	AAPL	Stock	56.25	56.2525	56.25	56.25	8988.0
2020-03-23 06:35:00	AAPL	Stock	56.305	56.5275	56.305	56.5275	15716.0
2020-03-23 06:40:00	AAPL	Stock	56.525	56.525	56.3875	56.4325	3320.0
2020-03-23 06:45:00	AAPL	Stock	56.4875	56.6975	56.4875	56.6975	4400.0
2020-03-23 06:50:00	AAPL	Stock	56.75	56.75	56.5925	56.5925	6380.0
2020-03-23 06:55:00	AAPL	Stock	56.625	56.75	56.625	56.75	8556.0
2020-03-23 07:00:00	AAPL	Stock	56.7425	56.7425	56.2725	56.2725	104760.0
2020-03-23 07:05:00	AAPL	Stock	56.3225	56.425	56.235	56.3775	90172.0
2020-03-23 07:10:00	AAPL	Stock	56.4	56.6	56.3025	56.595	29056.0
2020-03-23 07:15:00	AAPL	Stock	56.55	56.5875	56.3025	56.33	40420.0
2020-03-23 07:20:00	AAPL	Stock	56.325	56.3875	56.315	56.375	24580.0
2020-03-23 07:25:00	AAPL	Stock	56.375	56.375	56.05	56.0725	97892.0
2020-03-23 07:30:00	AAPL	Stock	56.0725	56.075	55.8875	55.8875	59280.0
2020-03-23 07:35:00	AAPL	Stock	55.8325	55.9725	55.65	55.6525	37476.0
2020-03-23 07:40:00	AAPL	Stock	55.65	56.1	55.625	55.825	78428.0
2020-03-23 07:45:00	AAPL	Stock	55.725	55.8075	55.7	55.78	46724.0
2020-03-23 07:50:00	AAPL	Stock	55.765	55.825	55.6375	55.6375	86356.0
2020-03-23 07:55:00	AAPL	Stock	55.6675	55.7875	55.6275	55.75	42420.0
2020-03-23 08:00:00	AAPL	Stock	56.3738	56.8	55.63	56.8	638932.0
2020-03-23 08:05:00	AAPL	Stock	56.85	56.99	56.375	56.9725	280680.0

> showing 50 of 427,675 rows — these rows as CSV

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