PREVIEW / stock_5min / 2018-07-23

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-23.parquet
  size:    5.4 MB
  rows:    347,465
  symbols: 2,802

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-23 04:05:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	400.0
2018-07-23 04:30:00	AAPL	Stock	47.675	47.675	47.675	47.675	1228.0
2018-07-23 07:00:00	AAPL	Stock	47.6975	47.6975	47.675	47.675	2160.0
2018-07-23 07:05:00	AAPL	Stock	47.6875	47.715	47.675	47.675	19264.0
2018-07-23 07:10:00	AAPL	Stock	47.675	47.675	47.65	47.675	8896.0
2018-07-23 07:15:00	AAPL	Stock	47.6875	47.6875	47.6575	47.675	6400.0
2018-07-23 07:20:00	AAPL	Stock	47.675	47.675	47.65	47.65	4000.0
2018-07-23 07:25:00	AAPL	Stock	47.6725	47.6875	47.6725	47.6875	12924.0
2018-07-23 07:30:00	AAPL	Stock	47.6875	47.715	47.6625	47.6775	19408.0
2018-07-23 07:35:00	AAPL	Stock	47.725	47.7375	47.7125	47.7375	3820.0
2018-07-23 07:40:00	AAPL	Stock	47.7025	47.7025	47.7	47.7	1832.0
2018-07-23 07:45:00	AAPL	Stock	47.705	47.705	47.705	47.705	1200.0
2018-07-23 07:50:00	AAPL	Stock	47.7025	47.7325	47.7	47.7325	3668.0
2018-07-23 07:55:00	AAPL	Stock	47.75	47.75	47.7375	47.75	13792.0
2018-07-23 08:00:00	AAPL	Stock	47.6575	47.965	47.6575	47.965	38264.0
2018-07-23 08:05:00	AAPL	Stock	47.79	47.79	47.79	47.79	400.0
2018-07-23 08:10:00	AAPL	Stock	47.775	47.775	47.755	47.7725	14896.0
2018-07-23 08:15:00	AAPL	Stock	47.745	47.76	47.73	47.73	6564.0
2018-07-23 08:20:00	AAPL	Stock	47.7325	47.755	47.7325	47.75	3200.0
2018-07-23 08:25:00	AAPL	Stock	47.775	47.7875	47.775	47.7875	11696.0
2018-07-23 08:30:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0
2018-07-23 08:35:00	AAPL	Stock	47.7575	47.86	47.755	47.755	256232.0
2018-07-23 08:40:00	AAPL	Stock	47.755	47.7575	47.7525	47.7525	3184.0
2018-07-23 08:45:00	AAPL	Stock	47.7525	47.755	47.7525	47.755	3484.0
2018-07-23 08:50:00	AAPL	Stock	47.7725	47.7725	47.7625	47.7625	2552.0
2018-07-23 08:55:00	AAPL	Stock	47.77	47.7775	47.76	47.7625	16348.0
2018-07-23 09:00:00	AAPL	Stock	47.7625	47.7625	47.7525	47.7525	4412.0
2018-07-23 09:05:00	AAPL	Stock	47.7725	47.7825	47.7725	47.7825	10804.0
2018-07-23 09:15:00	AAPL	Stock	47.765	47.78	47.7575	47.78	3800.0
2018-07-23 09:20:00	AAPL	Stock	47.7725	47.7725	47.765	47.765	16040.0
2018-07-23 09:25:00	AAPL	Stock	47.7775	47.78	47.625	47.6675	78204.0
2018-07-23 09:30:00	AAPL	Stock	47.6675	47.75	47.6025	47.6025	2524872.0
2018-07-23 09:35:00	AAPL	Stock	47.6025	47.6025	47.475	47.4775	1871140.0
2018-07-23 09:40:00	AAPL	Stock	47.4775	47.575	47.4625	47.565	1281788.0
2018-07-23 09:45:00	AAPL	Stock	47.5625	47.565	47.44	47.4425	1266532.0
2018-07-23 09:50:00	AAPL	Stock	47.445	47.5028	47.4175	47.44	1094352.0
2018-07-23 09:55:00	AAPL	Stock	47.44	47.5525	47.415	47.52	1178260.0
2018-07-23 10:00:00	AAPL	Stock	47.52	47.585	47.4875	47.543	938376.0
2018-07-23 10:05:00	AAPL	Stock	47.545	47.5675	47.51	47.5525	645320.0
2018-07-23 10:10:00	AAPL	Stock	47.5475	47.5575	47.5	47.5225	665592.0
2018-07-23 10:15:00	AAPL	Stock	47.525	47.53	47.4825	47.4845	903704.0
2018-07-23 10:20:00	AAPL	Stock	47.485	47.485	47.425	47.4725	782028.0
2018-07-23 10:25:00	AAPL	Stock	47.4725	47.485	47.42	47.4362	885856.0
2018-07-23 10:30:00	AAPL	Stock	47.44	47.46	47.39	47.455	1097452.0
2018-07-23 10:35:00	AAPL	Stock	47.4538	47.545	47.4425	47.5362	907780.0
2018-07-23 10:40:00	AAPL	Stock	47.535	47.5815	47.53	47.5675	746716.0
2018-07-23 10:45:00	AAPL	Stock	47.57	47.575	47.5325	47.535	484300.0
2018-07-23 10:50:00	AAPL	Stock	47.54	47.59	47.5375	47.56	568656.0
2018-07-23 10:55:00	AAPL	Stock	47.5625	47.5662	47.5225	47.5325	479404.0
2018-07-23 11:00:00	AAPL	Stock	47.535	47.57	47.53	47.545	484324.0

> showing 50 of 347,465 rows — these rows as CSV

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