PREVIEW / stock_5min / 2018-03-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-09.parquet
  size:    5.7 MB
  rows:    365,338
  symbols: 2,868

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
2018-03-09 04:00:00	AAPL	Stock	44.2675	44.2675	44.2675	44.2675	972.0
2018-03-09 04:35:00	AAPL	Stock	44.335	44.335	44.335	44.335	400.0
2018-03-09 05:05:00	AAPL	Stock	44.2375	44.2375	44.2375	44.2375	4000.0
2018-03-09 05:20:00	AAPL	Stock	44.3475	44.3475	44.335	44.335	2172.0
2018-03-09 05:30:00	AAPL	Stock	44.235	44.235	44.235	44.235	2000.0
2018-03-09 05:35:00	AAPL	Stock	44.235	44.235	44.235	44.235	2200.0
2018-03-09 06:25:00	AAPL	Stock	44.2475	44.2475	44.2475	44.2475	1600.0
2018-03-09 06:30:00	AAPL	Stock	44.2475	44.2475	44.235	44.235	800.0
2018-03-09 07:00:00	AAPL	Stock	44.23	44.3	44.23	44.28	37436.0
2018-03-09 07:05:00	AAPL	Stock	44.3	44.3	44.3	44.3	16852.0
2018-03-09 07:10:00	AAPL	Stock	44.295	44.3	44.28	44.28	18768.0
2018-03-09 07:15:00	AAPL	Stock	44.3	44.3125	44.3	44.3	2468.0
2018-03-09 07:20:00	AAPL	Stock	44.3	44.305	44.3	44.305	4188.0
2018-03-09 07:25:00	AAPL	Stock	44.3	44.3175	44.3	44.3175	22136.0
2018-03-09 07:30:00	AAPL	Stock	44.3	44.3	44.3	44.3	8440.0
2018-03-09 07:35:00	AAPL	Stock	44.29	44.29	44.2625	44.2775	8000.0
2018-03-09 07:40:00	AAPL	Stock	44.2875	44.2875	44.2675	44.2675	3968.0
2018-03-09 07:45:00	AAPL	Stock	44.275	44.275	44.275	44.275	800.0
2018-03-09 07:50:00	AAPL	Stock	44.2675	44.275	44.2575	44.275	7900.0
2018-03-09 07:55:00	AAPL	Stock	44.275	44.275	44.275	44.275	600.0
2018-03-09 08:00:00	AAPL	Stock	44.275	44.3025	44.2375	44.2375	64956.0
2018-03-09 08:05:00	AAPL	Stock	44.235	44.2625	44.205	44.25	21912.0
2018-03-09 08:10:00	AAPL	Stock	44.2125	44.215	44.175	44.19	14896.0
2018-03-09 08:15:00	AAPL	Stock	44.21	44.21	44.155	44.2	3500.0
2018-03-09 08:20:00	AAPL	Stock	44.2	44.2	44.175	44.18	11980.0
2018-03-09 08:25:00	AAPL	Stock	44.175	44.175	44.15	44.15	73424.0
2018-03-09 08:30:00	AAPL	Stock	44.1425	44.475	44.125	44.4625	239548.0
2018-03-09 08:35:00	AAPL	Stock	44.4625	44.5375	44.4625	44.5125	176004.0
2018-03-09 08:40:00	AAPL	Stock	44.5	44.5125	44.425	44.425	65128.0
2018-03-09 08:45:00	AAPL	Stock	44.4675	44.5125	44.4425	44.5125	42800.0
2018-03-09 08:50:00	AAPL	Stock	44.5025	44.525	44.475	44.5	62116.0
2018-03-09 08:55:00	AAPL	Stock	44.5025	44.535	44.5	44.525	74388.0
2018-03-09 09:00:00	AAPL	Stock	44.5125	44.5475	44.5025	44.5475	61736.0
2018-03-09 09:05:00	AAPL	Stock	44.54	44.5475	44.5	44.5025	33020.0
2018-03-09 09:10:00	AAPL	Stock	44.525	44.525	44.4825	44.4825	9208.0
2018-03-09 09:15:00	AAPL	Stock	44.475	44.505	44.475	44.4875	41768.0
2018-03-09 09:20:00	AAPL	Stock	44.48	44.52	44.45	44.505	48492.0
2018-03-09 09:25:00	AAPL	Stock	44.525	44.525	44.42	44.4425	118300.0
2018-03-09 09:30:00	AAPL	Stock	44.49	44.61	44.4425	44.4475	5503400.0
2018-03-09 09:35:00	AAPL	Stock	44.4475	44.4955	44.3475	44.4162	2905244.0
2018-03-09 09:40:00	AAPL	Stock	44.42	44.51	44.37	44.4275	2018400.0
2018-03-09 09:45:00	AAPL	Stock	44.4275	44.4825	44.375	44.48	1597960.0
2018-03-09 09:50:00	AAPL	Stock	44.485	44.51	44.4375	44.4462	1565680.0
2018-03-09 09:55:00	AAPL	Stock	44.4475	44.5025	44.445	44.495	1227636.0
2018-03-09 10:00:00	AAPL	Stock	44.495	44.5598	44.485	44.555	1688524.0
2018-03-09 10:05:00	AAPL	Stock	44.5525	44.575	44.5225	44.5438	1300320.0
2018-03-09 10:10:00	AAPL	Stock	44.5438	44.6	44.5225	44.5975	1499608.0
2018-03-09 10:15:00	AAPL	Stock	44.5975	44.625	44.58	44.6178	2423600.0
2018-03-09 10:20:00	AAPL	Stock	44.6188	44.6825	44.6	44.63	1899596.0
2018-03-09 10:25:00	AAPL	Stock	44.635	44.665	44.6025	44.6612	1063136.0

> showing 50 of 365,338 rows — these rows as CSV

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