PREVIEW / stock_5min / 2018-04-12

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-12.parquet
  size:    5.4 MB
  rows:    352,167
  symbols: 2,849

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-04-12 04:40:00	AAPL	Stock	43.125	43.125	43.1225	43.1225	1200.0
2018-04-12 04:50:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	400.0
2018-04-12 05:25:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	600.0
2018-04-12 05:30:00	AAPL	Stock	43.05	43.05	43.05	43.05	1576.0
2018-04-12 05:45:00	AAPL	Stock	43.0525	43.0525	43.0525	43.0525	508.0
2018-04-12 06:00:00	AAPL	Stock	43.005	43.065	43.0	43.065	3220.0
2018-04-12 06:05:00	AAPL	Stock	43.1	43.1	43.1	43.1	400.0
2018-04-12 06:15:00	AAPL	Stock	43.1	43.175	43.1	43.175	800.0
2018-04-12 06:30:00	AAPL	Stock	43.175	43.175	43.175	43.175	800.0
2018-04-12 06:35:00	AAPL	Stock	43.2125	43.225	43.2125	43.225	3560.0
2018-04-12 06:50:00	AAPL	Stock	43.225	43.2625	43.225	43.2625	1936.0
2018-04-12 07:00:00	AAPL	Stock	43.25	43.3625	43.25	43.35	11472.0
2018-04-12 07:05:00	AAPL	Stock	43.33	43.5	43.33	43.3875	99044.0
2018-04-12 07:10:00	AAPL	Stock	43.375	43.5	43.375	43.4525	111968.0
2018-04-12 07:15:00	AAPL	Stock	43.4625	43.475	43.455	43.4575	4800.0
2018-04-12 07:20:00	AAPL	Stock	43.465	43.475	43.4325	43.45	12300.0
2018-04-12 07:25:00	AAPL	Stock	43.4325	43.4625	43.4325	43.4625	23828.0
2018-04-12 07:30:00	AAPL	Stock	43.47	43.475	43.47	43.475	12348.0
2018-04-12 07:35:00	AAPL	Stock	43.4625	43.4625	43.4275	43.4475	8300.0
2018-04-12 07:40:00	AAPL	Stock	43.4425	43.4425	43.4325	43.4325	12776.0
2018-04-12 07:45:00	AAPL	Stock	43.4275	43.4275	43.415	43.425	8512.0
2018-04-12 07:50:00	AAPL	Stock	43.4375	43.45	43.4375	43.45	7692.0
2018-04-12 07:55:00	AAPL	Stock	43.45	43.45	43.425	43.425	8368.0
2018-04-12 08:00:00	AAPL	Stock	43.45	43.48	43.3375	43.425	63388.0
2018-04-12 08:05:00	AAPL	Stock	43.4125	43.4225	43.39	43.39	8600.0
2018-04-12 08:10:00	AAPL	Stock	43.4125	43.445	43.4125	43.445	14468.0
2018-04-12 08:15:00	AAPL	Stock	43.425	43.425	43.4125	43.4125	11496.0
2018-04-12 08:20:00	AAPL	Stock	43.4395	43.4395	43.4	43.4	4100.0
2018-04-12 08:25:00	AAPL	Stock	43.39	43.39	43.375	43.375	12600.0
2018-04-12 08:30:00	AAPL	Stock	43.39	43.459	43.39	43.459	13992.0
2018-04-12 08:35:00	AAPL	Stock	43.4475	43.46	43.425	43.4275	24440.0
2018-04-12 08:40:00	AAPL	Stock	43.4275	43.4375	43.4275	43.4375	5484.0
2018-04-12 08:45:00	AAPL	Stock	43.4175	43.435	43.41	43.42	18084.0
2018-04-12 08:50:00	AAPL	Stock	43.41	43.43	43.38	43.4025	35500.0
2018-04-12 08:55:00	AAPL	Stock	43.4	43.425	43.3925	43.425	9584.0
2018-04-12 09:00:00	AAPL	Stock	43.4175	43.4625	43.4125	43.45	53736.0
2018-04-12 09:05:00	AAPL	Stock	43.4525	43.475	43.4525	43.475	54236.0
2018-04-12 09:10:00	AAPL	Stock	43.475	43.485	43.455	43.475	19392.0
2018-04-12 09:15:00	AAPL	Stock	43.475	43.485	43.45	43.47	20856.0
2018-04-12 09:20:00	AAPL	Stock	43.47	43.47	43.4625	43.4625	8168.0
2018-04-12 09:25:00	AAPL	Stock	43.47	43.48	43.3275	43.3275	98964.0
2018-04-12 09:30:00	AAPL	Stock	43.35	43.425	43.26	43.355	3756176.0
2018-04-12 09:35:00	AAPL	Stock	43.365	43.4375	43.3392	43.375	1942744.0
2018-04-12 09:40:00	AAPL	Stock	43.3775	43.4975	43.37	43.4875	2061512.0
2018-04-12 09:45:00	AAPL	Stock	43.4825	43.615	43.4775	43.5662	2797908.0
2018-04-12 09:50:00	AAPL	Stock	43.5675	43.5975	43.5225	43.5895	1536640.0
2018-04-12 09:55:00	AAPL	Stock	43.59	43.6325	43.5375	43.6175	1643264.0
2018-04-12 10:00:00	AAPL	Stock	43.62	43.6675	43.57	43.585	1452820.0
2018-04-12 10:05:00	AAPL	Stock	43.5825	43.615	43.549	43.602	1160184.0
2018-04-12 10:10:00	AAPL	Stock	43.6	43.6525	43.5625	43.6275	1003972.0

> showing 50 of 352,167 rows — these rows as CSV

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