PREVIEW / stock_5min / 2018-07-12

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-12.parquet
  size:    5.5 MB
  rows:    355,659
  symbols: 2,829

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-07-12 04:00:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	400.0
2018-07-12 04:05:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1200.0
2018-07-12 04:15:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1756.0
2018-07-12 04:30:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1200.0
2018-07-12 04:55:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	2432.0
2018-07-12 05:15:00	AAPL	Stock	47.15	47.15	47.15	47.15	2800.0
2018-07-12 06:05:00	AAPL	Stock	47.0875	47.0875	47.0875	47.0875	400.0
2018-07-12 06:30:00	AAPL	Stock	47.23	47.23	47.23	47.23	1200.0
2018-07-12 06:50:00	AAPL	Stock	47.235	47.25	47.235	47.25	1400.0
2018-07-12 06:55:00	AAPL	Stock	47.25	47.2625	47.25	47.2625	2100.0
2018-07-12 07:00:00	AAPL	Stock	47.2625	47.29	47.25	47.29	13388.0
2018-07-12 07:05:00	AAPL	Stock	47.2575	47.285	47.255	47.285	6108.0
2018-07-12 07:10:00	AAPL	Stock	47.2775	47.285	47.27	47.27	6040.0
2018-07-12 07:15:00	AAPL	Stock	47.2825	47.2825	47.28	47.28	6900.0
2018-07-12 07:20:00	AAPL	Stock	47.285	47.29	47.285	47.2875	14444.0
2018-07-12 07:25:00	AAPL	Stock	47.2975	47.2975	47.2625	47.2625	3800.0
2018-07-12 07:30:00	AAPL	Stock	47.2675	47.2825	47.2675	47.2825	2480.0
2018-07-12 07:35:00	AAPL	Stock	47.2725	47.2775	47.2725	47.2775	888.0
2018-07-12 07:40:00	AAPL	Stock	47.2775	47.2875	47.2725	47.2725	10200.0
2018-07-12 07:50:00	AAPL	Stock	47.27	47.29	47.27	47.29	7516.0
2018-07-12 07:55:00	AAPL	Stock	47.3	47.3	47.3	47.3	400.0
2018-07-12 08:00:00	AAPL	Stock	47.2675	47.3125	47.2525	47.28	63664.0
2018-07-12 08:05:00	AAPL	Stock	47.2925	47.325	47.2875	47.2875	63860.0
2018-07-12 08:10:00	AAPL	Stock	47.2775	47.2775	47.2625	47.2625	6060.0
2018-07-12 08:15:00	AAPL	Stock	47.2775	47.2775	47.2775	47.2775	468.0
2018-07-12 08:20:00	AAPL	Stock	47.2925	47.31	47.2925	47.3	7740.0
2018-07-12 08:25:00	AAPL	Stock	47.3	47.3	47.265	47.3	5592.0
2018-07-12 08:30:00	AAPL	Stock	47.2875	47.31	47.285	47.31	29620.0
2018-07-12 08:35:00	AAPL	Stock	47.31	47.325	47.31	47.32	35016.0
2018-07-12 08:40:00	AAPL	Stock	47.3225	47.3225	47.315	47.3225	7600.0
2018-07-12 08:45:00	AAPL	Stock	47.3175	47.3375	47.3125	47.3375	12276.0
2018-07-12 08:50:00	AAPL	Stock	47.33	47.3525	47.325	47.3325	42836.0
2018-07-12 08:55:00	AAPL	Stock	47.3125	47.3425	47.31	47.3375	21292.0
2018-07-12 09:00:00	AAPL	Stock	47.3375	47.35	47.325	47.35	27100.0
2018-07-12 09:05:00	AAPL	Stock	47.3475	47.3575	47.325	47.3525	41636.0
2018-07-12 09:10:00	AAPL	Stock	47.345	47.345	47.3225	47.34	43320.0
2018-07-12 09:15:00	AAPL	Stock	47.345	47.3525	47.305	47.305	35932.0
2018-07-12 09:20:00	AAPL	Stock	47.3025	47.3175	47.2925	47.3125	12924.0
2018-07-12 09:25:00	AAPL	Stock	47.32	47.385	47.32	47.3675	35208.0
2018-07-12 09:30:00	AAPL	Stock	47.3825	47.5675	47.3275	47.5575	3808212.0
2018-07-12 09:35:00	AAPL	Stock	47.5575	47.5925	47.4825	47.485	1844372.0
2018-07-12 09:40:00	AAPL	Stock	47.4875	47.5	47.4375	47.4475	1126988.0
2018-07-12 09:45:00	AAPL	Stock	47.4475	47.48	47.3825	47.476	807444.0
2018-07-12 09:50:00	AAPL	Stock	47.485	47.5588	47.485	47.5278	1245468.0
2018-07-12 09:55:00	AAPL	Stock	47.53	47.5428	47.48	47.505	876356.0
2018-07-12 10:00:00	AAPL	Stock	47.5025	47.545	47.5	47.535	816412.0
2018-07-12 10:05:00	AAPL	Stock	47.535	47.63	47.52	47.62	1206672.0
2018-07-12 10:10:00	AAPL	Stock	47.6222	47.63	47.5775	47.5925	834024.0
2018-07-12 10:15:00	AAPL	Stock	47.5875	47.64	47.575	47.605	671888.0
2018-07-12 10:20:00	AAPL	Stock	47.6075	47.615	47.55	47.565	570936.0

> showing 50 of 355,659 rows — these rows as CSV

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