PREVIEW / stock_5min / 2017-07-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-20.parquet
  size:    5.2 MB
  rows:    340,998
  symbols: 2,978

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-07-20 04:00:00	AAPL	Stock	37.7625	37.7625	37.7625	37.7625	1360.0
2017-07-20 04:05:00	AAPL	Stock	37.75	37.75	37.7275	37.7275	800.0
2017-07-20 05:00:00	AAPL	Stock	37.755	37.755	37.755	37.755	800.0
2017-07-20 05:05:00	AAPL	Stock	37.75	37.75	37.7375	37.7375	800.0
2017-07-20 05:10:00	AAPL	Stock	37.6625	37.6625	37.65	37.65	1128.0
2017-07-20 06:10:00	AAPL	Stock	37.675	37.675	37.675	37.675	400.0
2017-07-20 06:25:00	AAPL	Stock	37.745	37.745	37.745	37.745	400.0
2017-07-20 06:30:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	800.0
2017-07-20 06:45:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	400.0
2017-07-20 07:00:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	600.0
2017-07-20 07:20:00	AAPL	Stock	37.7275	37.7275	37.7275	37.7275	400.0
2017-07-20 07:30:00	AAPL	Stock	37.775	37.775	37.775	37.775	2560.0
2017-07-20 07:35:00	AAPL	Stock	37.7725	37.8	37.7725	37.8	20656.0
2017-07-20 07:45:00	AAPL	Stock	37.785	37.8475	37.785	37.8325	2360.0
2017-07-20 07:50:00	AAPL	Stock	37.8225	37.8225	37.8225	37.8225	400.0
2017-07-20 08:00:00	AAPL	Stock	37.795	37.855	37.795	37.85	27100.0
2017-07-20 08:05:00	AAPL	Stock	37.86	37.86	37.8375	37.84	16936.0
2017-07-20 08:10:00	AAPL	Stock	37.8375	37.8375	37.835	37.8375	14724.0
2017-07-20 08:15:00	AAPL	Stock	37.8525	37.8625	37.8525	37.8625	10200.0
2017-07-20 08:20:00	AAPL	Stock	37.855	37.875	37.8475	37.8475	14300.0
2017-07-20 08:25:00	AAPL	Stock	37.85	37.85	37.85	37.85	400.0
2017-07-20 08:30:00	AAPL	Stock	37.85	37.8625	37.8475	37.855	12996.0
2017-07-20 08:35:00	AAPL	Stock	37.8575	37.86	37.8275	37.83	9356.0
2017-07-20 08:40:00	AAPL	Stock	37.84	37.84	37.815	37.815	38240.0
2017-07-20 08:45:00	AAPL	Stock	37.815	37.815	37.795	37.795	8800.0
2017-07-20 08:50:00	AAPL	Stock	37.82	37.82	37.82	37.82	400.0
2017-07-20 08:55:00	AAPL	Stock	37.82	37.8225	37.805	37.805	4400.0
2017-07-20 09:00:00	AAPL	Stock	37.82	37.82	37.82	37.82	960.0
2017-07-20 09:05:00	AAPL	Stock	37.8375	37.845	37.8375	37.845	3376.0
2017-07-20 09:10:00	AAPL	Stock	37.8275	37.86	37.825	37.86	25704.0
2017-07-20 09:15:00	AAPL	Stock	37.84	37.85	37.815	37.815	6400.0
2017-07-20 09:20:00	AAPL	Stock	37.8475	37.8475	37.795	37.8375	19084.0
2017-07-20 09:25:00	AAPL	Stock	37.845	37.92	37.845	37.875	80296.0
2017-07-20 09:30:00	AAPL	Stock	37.8625	37.935	37.7875	37.8	3511760.0
2017-07-20 09:35:00	AAPL	Stock	37.7975	37.8378	37.765	37.8013	1461828.0
2017-07-20 09:40:00	AAPL	Stock	37.8025	37.822	37.725	37.7688	1660992.0
2017-07-20 09:45:00	AAPL	Stock	37.77	37.81	37.7425	37.775	1301188.0
2017-07-20 09:50:00	AAPL	Stock	37.7762	37.7812	37.735	37.7775	1290736.0
2017-07-20 09:55:00	AAPL	Stock	37.7788	37.7925	37.75	37.7775	910088.0
2017-07-20 10:00:00	AAPL	Stock	37.7775	37.785	37.7388	37.745	1046828.0
2017-07-20 10:05:00	AAPL	Stock	37.745	37.76	37.73	37.745	997140.0
2017-07-20 10:10:00	AAPL	Stock	37.745	37.7525	37.6975	37.7125	832736.0
2017-07-20 10:15:00	AAPL	Stock	37.7125	37.7175	37.6125	37.6625	1661136.0
2017-07-20 10:20:00	AAPL	Stock	37.6612	37.7225	37.6525	37.69	871784.0
2017-07-20 10:25:00	AAPL	Stock	37.6902	37.7475	37.6825	37.7398	583760.0
2017-07-20 10:30:00	AAPL	Stock	37.74	37.771	37.585	37.5925	1905844.0
2017-07-20 10:35:00	AAPL	Stock	37.59	37.63	37.555	37.57	1470384.0
2017-07-20 10:40:00	AAPL	Stock	37.57	37.6575	37.5475	37.609	1039972.0
2017-07-20 10:45:00	AAPL	Stock	37.6075	37.6275	37.5925	37.6225	737564.0
2017-07-20 10:50:00	AAPL	Stock	37.625	37.6325	37.6025	37.6175	492384.0

> showing 50 of 340,998 rows — these rows as CSV

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