PREVIEW / stock_5min / 2017-03-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-13.parquet
  size:    5.4 MB
  rows:    352,670
  symbols: 3,066

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-03-13 05:00:00	AAPL	Stock	34.73	34.73	34.73	34.73	576.0
2017-03-13 06:25:00	AAPL	Stock	34.7	34.7	34.7	34.7	2400.0
2017-03-13 06:40:00	AAPL	Stock	34.7	34.7	34.7	34.7	800.0
2017-03-13 07:10:00	AAPL	Stock	34.69	34.69	34.675	34.675	4000.0
2017-03-13 07:15:00	AAPL	Stock	34.69	34.69	34.68	34.68	4000.0
2017-03-13 07:25:00	AAPL	Stock	34.7	34.7	34.7	34.7	1600.0
2017-03-13 07:30:00	AAPL	Stock	34.7	34.7	34.7	34.7	1600.0
2017-03-13 07:40:00	AAPL	Stock	34.7	34.7	34.7	34.7	468.0
2017-03-13 07:45:00	AAPL	Stock	34.7	34.7	34.68	34.68	11704.0
2017-03-13 07:55:00	AAPL	Stock	34.6975	34.7	34.68	34.68	3996.0
2017-03-13 08:00:00	AAPL	Stock	34.655	34.7	34.655	34.7	15944.0
2017-03-13 08:05:00	AAPL	Stock	34.6875	34.7	34.6875	34.7	3200.0
2017-03-13 08:10:00	AAPL	Stock	34.7175	34.7175	34.7175	34.7175	400.0
2017-03-13 08:20:00	AAPL	Stock	34.7175	34.7175	34.7025	34.7025	6000.0
2017-03-13 08:25:00	AAPL	Stock	34.705	34.715	34.68	34.6875	16320.0
2017-03-13 08:35:00	AAPL	Stock	34.695	34.7	34.695	34.7	18432.0
2017-03-13 08:40:00	AAPL	Stock	34.71	34.7125	34.7075	34.71	16672.0
2017-03-13 08:45:00	AAPL	Stock	34.7125	34.7375	34.7125	34.725	37808.0
2017-03-13 08:50:00	AAPL	Stock	34.735	34.735	34.715	34.715	10800.0
2017-03-13 08:55:00	AAPL	Stock	34.715	34.725	34.715	34.715	11612.0
2017-03-13 09:00:00	AAPL	Stock	34.71	34.71	34.7	34.7	12804.0
2017-03-13 09:05:00	AAPL	Stock	34.705	34.705	34.7	34.7	14000.0
2017-03-13 09:10:00	AAPL	Stock	34.705	34.705	34.705	34.705	5600.0
2017-03-13 09:15:00	AAPL	Stock	34.7025	34.7025	34.695	34.7	13240.0
2017-03-13 09:20:00	AAPL	Stock	34.7	34.7025	34.6925	34.6925	25176.0
2017-03-13 09:25:00	AAPL	Stock	34.7025	34.715	34.7025	34.7075	33492.0
2017-03-13 09:30:00	AAPL	Stock	34.7125	34.835	34.705	34.7838	2712768.0
2017-03-13 09:35:00	AAPL	Stock	34.785	34.85	34.775	34.79	1582104.0
2017-03-13 09:40:00	AAPL	Stock	34.79	34.81	34.7188	34.7325	2040792.0
2017-03-13 09:45:00	AAPL	Stock	34.73	34.8115	34.73	34.8075	1215504.0
2017-03-13 09:50:00	AAPL	Stock	34.805	34.81	34.7725	34.8025	823624.0
2017-03-13 09:55:00	AAPL	Stock	34.8025	34.8052	34.765	34.7775	580652.0
2017-03-13 10:00:00	AAPL	Stock	34.7775	34.79	34.765	34.7725	747364.0
2017-03-13 10:05:00	AAPL	Stock	34.7725	34.785	34.75	34.7615	990884.0
2017-03-13 10:10:00	AAPL	Stock	34.7625	34.7825	34.76	34.7725	1239968.0
2017-03-13 10:15:00	AAPL	Stock	34.77	34.775	34.7375	34.7625	926980.0
2017-03-13 10:20:00	AAPL	Stock	34.7625	34.78	34.7362	34.7362	1241460.0
2017-03-13 10:25:00	AAPL	Stock	34.7362	34.7612	34.7225	34.7412	766532.0
2017-03-13 10:30:00	AAPL	Stock	34.7425	34.7675	34.735	34.7575	502716.0
2017-03-13 10:35:00	AAPL	Stock	34.7588	34.765	34.74	34.7552	646292.0
2017-03-13 10:40:00	AAPL	Stock	34.7575	34.7588	34.71	34.7275	898412.0
2017-03-13 10:45:00	AAPL	Stock	34.7275	34.7525	34.715	34.7525	722864.0
2017-03-13 10:50:00	AAPL	Stock	34.7525	34.7625	34.7475	34.7625	627596.0
2017-03-13 10:55:00	AAPL	Stock	34.76	34.7725	34.7525	34.7675	432060.0
2017-03-13 11:00:00	AAPL	Stock	34.7685	34.7725	34.75	34.7625	347660.0
2017-03-13 11:05:00	AAPL	Stock	34.7625	34.7625	34.7475	34.7612	314048.0
2017-03-13 11:10:00	AAPL	Stock	34.7625	34.7725	34.7525	34.7662	416804.0
2017-03-13 11:15:00	AAPL	Stock	34.7675	34.7675	34.735	34.74	449968.0
2017-03-13 11:20:00	AAPL	Stock	34.74	34.7525	34.735	34.7375	395616.0
2017-03-13 11:25:00	AAPL	Stock	34.7375	34.745	34.725	34.7325	376736.0

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

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