PREVIEW / stock_5min / 2017-06-12

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-12.parquet
  size:    5.5 MB
  rows:    361,940
  symbols: 3,033

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
2017-06-12 04:00:00	AAPL	Stock	36.9725	36.9825	36.875	36.9	11392.0
2017-06-12 04:05:00	AAPL	Stock	36.9	36.915	36.9	36.915	4952.0
2017-06-12 04:10:00	AAPL	Stock	36.8825	36.8825	36.84	36.84	12448.0
2017-06-12 04:15:00	AAPL	Stock	36.84	36.8475	36.8375	36.8475	7756.0
2017-06-12 04:20:00	AAPL	Stock	36.845	36.845	36.575	36.625	65716.0
2017-06-12 04:25:00	AAPL	Stock	36.665	36.665	36.5625	36.5625	12532.0
2017-06-12 04:30:00	AAPL	Stock	36.525	36.5625	36.425	36.425	25320.0
2017-06-12 04:35:00	AAPL	Stock	36.4275	36.4275	36.275	36.365	59536.0
2017-06-12 04:40:00	AAPL	Stock	36.385	36.385	36.3375	36.3375	16444.0
2017-06-12 04:45:00	AAPL	Stock	36.33	36.375	36.305	36.375	4072.0
2017-06-12 04:50:00	AAPL	Stock	36.3025	36.3025	36.3025	36.3025	400.0
2017-06-12 04:55:00	AAPL	Stock	36.3	36.325	36.3	36.325	1376.0
2017-06-12 05:00:00	AAPL	Stock	36.3425	36.3425	36.325	36.325	3600.0
2017-06-12 05:05:00	AAPL	Stock	36.3525	36.41	36.3525	36.3775	23168.0
2017-06-12 05:10:00	AAPL	Stock	36.425	36.425	36.425	36.425	1660.0
2017-06-12 05:20:00	AAPL	Stock	36.4475	36.4475	36.4475	36.4475	400.0
2017-06-12 05:25:00	AAPL	Stock	36.4425	36.4475	36.4425	36.4475	10512.0
2017-06-12 05:30:00	AAPL	Stock	36.4475	36.4475	36.4475	36.4475	2416.0
2017-06-12 05:35:00	AAPL	Stock	36.41	36.435	36.41	36.435	1192.0
2017-06-12 05:40:00	AAPL	Stock	36.43	36.4325	36.4225	36.4225	8996.0
2017-06-12 05:45:00	AAPL	Stock	36.4225	36.425	36.4225	36.425	2396.0
2017-06-12 05:50:00	AAPL	Stock	36.425	36.4275	36.415	36.4275	14500.0
2017-06-12 06:00:00	AAPL	Stock	36.4275	36.4875	36.425	36.4625	10476.0
2017-06-12 06:05:00	AAPL	Stock	36.4925	36.5375	36.4925	36.535	7904.0
2017-06-12 06:10:00	AAPL	Stock	36.535	36.5575	36.525	36.535	20504.0
2017-06-12 06:15:00	AAPL	Stock	36.535	36.535	36.535	36.535	800.0
2017-06-12 06:20:00	AAPL	Stock	36.5425	36.56	36.5425	36.56	5200.0
2017-06-12 06:25:00	AAPL	Stock	36.56	36.56	36.56	36.56	1200.0
2017-06-12 06:30:00	AAPL	Stock	36.56	36.56	36.545	36.545	2600.0
2017-06-12 06:35:00	AAPL	Stock	36.56	36.56	36.5425	36.56	4332.0
2017-06-12 06:40:00	AAPL	Stock	36.585	36.6125	36.58	36.5925	2400.0
2017-06-12 06:45:00	AAPL	Stock	36.575	36.575	36.5475	36.5475	3200.0
2017-06-12 06:50:00	AAPL	Stock	36.55	36.5675	36.515	36.515	1200.0
2017-06-12 06:55:00	AAPL	Stock	36.5275	36.5275	36.515	36.515	2000.0
2017-06-12 07:00:00	AAPL	Stock	36.5375	36.5725	36.52	36.535	23764.0
2017-06-12 07:05:00	AAPL	Stock	36.54	36.55	36.515	36.525	36456.0
2017-06-12 07:10:00	AAPL	Stock	36.505	36.6075	36.46	36.575	99316.0
2017-06-12 07:15:00	AAPL	Stock	36.575	36.575	36.5325	36.5325	14284.0
2017-06-12 07:20:00	AAPL	Stock	36.55	36.55	36.4775	36.5	25808.0
2017-06-12 07:25:00	AAPL	Stock	36.5	36.5275	36.475	36.52	35180.0
2017-06-12 07:30:00	AAPL	Stock	36.5175	36.5175	36.4525	36.475	22336.0
2017-06-12 07:35:00	AAPL	Stock	36.4525	36.475	36.45	36.475	23320.0
2017-06-12 07:40:00	AAPL	Stock	36.4675	36.47	36.425	36.4375	32328.0
2017-06-12 07:45:00	AAPL	Stock	36.425	36.4275	36.4	36.4	25756.0
2017-06-12 07:50:00	AAPL	Stock	36.415	36.425	36.4	36.4	40704.0
2017-06-12 07:55:00	AAPL	Stock	36.4	36.4375	36.375	36.42	56400.0
2017-06-12 08:00:00	AAPL	Stock	36.42	36.575	36.35	36.35	378548.0
2017-06-12 08:05:00	AAPL	Stock	36.3462	36.415	36.3425	36.3825	156452.0
2017-06-12 08:10:00	AAPL	Stock	36.385	36.4375	36.3525	36.4075	144952.0
2017-06-12 08:15:00	AAPL	Stock	36.435	36.4375	36.36	36.3675	58116.0

> showing 50 of 361,940 rows — these rows as CSV

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