PREVIEW / stock_5min / 2017-10-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-06.parquet
  size:    5.3 MB
  rows:    347,752
  symbols: 2,961

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-10-06 04:00:00	AAPL	Stock	38.825	38.825	38.825	38.825	964.0
2017-10-06 04:25:00	AAPL	Stock	38.75	38.78	38.75	38.78	1200.0
2017-10-06 04:40:00	AAPL	Stock	38.8225	38.8225	38.8225	38.8225	400.0
2017-10-06 04:45:00	AAPL	Stock	38.76	38.76	38.75	38.75	1200.0
2017-10-06 05:00:00	AAPL	Stock	38.7475	38.7475	38.7475	38.7475	1200.0
2017-10-06 05:45:00	AAPL	Stock	38.76	38.76	38.7575	38.7575	2088.0
2017-10-06 05:50:00	AAPL	Stock	38.7625	38.7625	38.7625	38.7625	500.0
2017-10-06 06:10:00	AAPL	Stock	38.76	38.76	38.76	38.76	592.0
2017-10-06 06:50:00	AAPL	Stock	38.775	38.7775	38.775	38.775	19600.0
2017-10-06 06:55:00	AAPL	Stock	38.8125	38.8175	38.8125	38.8175	2000.0
2017-10-06 07:00:00	AAPL	Stock	38.7875	38.82	38.7675	38.785	11860.0
2017-10-06 07:05:00	AAPL	Stock	38.8	38.8	38.775	38.775	10368.0
2017-10-06 07:10:00	AAPL	Stock	38.775	38.81	38.775	38.81	4788.0
2017-10-06 07:30:00	AAPL	Stock	38.765	38.765	38.765	38.765	2504.0
2017-10-06 07:35:00	AAPL	Stock	38.7625	38.7625	38.7625	38.7625	720.0
2017-10-06 07:40:00	AAPL	Stock	38.765	38.765	38.7525	38.755	4000.0
2017-10-06 07:45:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	800.0
2017-10-06 07:50:00	AAPL	Stock	38.77	38.77	38.77	38.77	800.0
2017-10-06 07:55:00	AAPL	Stock	38.77	38.77	38.75	38.75	15408.0
2017-10-06 08:00:00	AAPL	Stock	38.805	38.93	38.705	38.7875	95460.0
2017-10-06 08:05:00	AAPL	Stock	38.75	38.7575	38.7275	38.75	32712.0
2017-10-06 08:10:00	AAPL	Stock	38.75	38.75	38.7275	38.74	26488.0
2017-10-06 08:15:00	AAPL	Stock	38.7425	38.7425	38.7275	38.7325	23200.0
2017-10-06 08:20:00	AAPL	Stock	38.7275	38.7425	38.7225	38.7425	48324.0
2017-10-06 08:25:00	AAPL	Stock	38.7375	38.7375	38.7175	38.7175	9064.0
2017-10-06 08:30:00	AAPL	Stock	38.715	38.75	38.7025	38.74	42920.0
2017-10-06 08:35:00	AAPL	Stock	38.74	38.74	38.7025	38.705	21080.0
2017-10-06 08:40:00	AAPL	Stock	38.705	38.725	38.7025	38.725	8940.0
2017-10-06 08:45:00	AAPL	Stock	38.725	38.7275	38.7025	38.7125	32064.0
2017-10-06 08:50:00	AAPL	Stock	38.7025	38.72	38.7025	38.7075	25256.0
2017-10-06 08:55:00	AAPL	Stock	38.7025	38.7025	38.665	38.6675	119260.0
2017-10-06 09:00:00	AAPL	Stock	38.665	38.685	38.6625	38.6725	23892.0
2017-10-06 09:05:00	AAPL	Stock	38.675	38.7075	38.675	38.68	25028.0
2017-10-06 09:10:00	AAPL	Stock	38.68	38.6825	38.655	38.655	28664.0
2017-10-06 09:15:00	AAPL	Stock	38.655	38.66	38.655	38.66	47284.0
2017-10-06 09:20:00	AAPL	Stock	38.6725	38.7	38.6725	38.675	52304.0
2017-10-06 09:25:00	AAPL	Stock	38.675	38.75	38.675	38.75	49816.0
2017-10-06 09:30:00	AAPL	Stock	38.7425	38.8725	38.7075	38.81	3666764.0
2017-10-06 09:35:00	AAPL	Stock	38.8075	38.8125	38.7448	38.79	1441032.0
2017-10-06 09:40:00	AAPL	Stock	38.7925	38.7925	38.71	38.724	1155612.0
2017-10-06 09:45:00	AAPL	Stock	38.7225	38.7373	38.64	38.7125	1696336.0
2017-10-06 09:50:00	AAPL	Stock	38.715	38.7475	38.675	38.6962	883028.0
2017-10-06 09:55:00	AAPL	Stock	38.6962	38.7225	38.6825	38.685	751980.0
2017-10-06 10:00:00	AAPL	Stock	38.6825	38.7425	38.6825	38.7352	975048.0
2017-10-06 10:05:00	AAPL	Stock	38.735	38.7625	38.7125	38.7525	758260.0
2017-10-06 10:10:00	AAPL	Stock	38.7507	38.7632	38.7375	38.7475	572324.0
2017-10-06 10:15:00	AAPL	Stock	38.7465	38.7468	38.6905	38.705	838504.0
2017-10-06 10:20:00	AAPL	Stock	38.7062	38.748	38.695	38.7475	567516.0
2017-10-06 10:25:00	AAPL	Stock	38.7475	38.79	38.745	38.7725	623636.0
2017-10-06 10:30:00	AAPL	Stock	38.77	38.775	38.735	38.7455	479060.0

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

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