PREVIEW / stock_5min / 2017-03-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-27.parquet
  size:    5.4 MB
  rows:    353,069
  symbols: 3,080

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-27 04:00:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	1200.0
2017-03-27 04:20:00	AAPL	Stock	34.9275	34.9275	34.9275	34.9275	1200.0
2017-03-27 04:50:00	AAPL	Stock	34.9325	34.9325	34.9325	34.9325	1744.0
2017-03-27 05:05:00	AAPL	Stock	34.8925	34.8925	34.8925	34.8925	820.0
2017-03-27 05:25:00	AAPL	Stock	34.9225	34.9225	34.9225	34.9225	1548.0
2017-03-27 05:35:00	AAPL	Stock	34.885	34.885	34.885	34.885	420.0
2017-03-27 05:55:00	AAPL	Stock	34.875	34.875	34.875	34.875	508.0
2017-03-27 06:15:00	AAPL	Stock	34.91	34.9375	34.91	34.9375	14020.0
2017-03-27 06:20:00	AAPL	Stock	34.96	34.96	34.925	34.925	17200.0
2017-03-27 06:25:00	AAPL	Stock	34.9225	34.9225	34.9125	34.9125	9320.0
2017-03-27 06:30:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	10600.0
2017-03-27 06:40:00	AAPL	Stock	34.905	34.905	34.8975	34.9025	13800.0
2017-03-27 06:45:00	AAPL	Stock	34.9	34.9	34.875	34.875	19080.0
2017-03-27 06:50:00	AAPL	Stock	34.875	34.9075	34.87	34.9075	14800.0
2017-03-27 06:55:00	AAPL	Stock	34.9	34.9125	34.9	34.9125	4280.0
2017-03-27 07:00:00	AAPL	Stock	34.9125	34.9325	34.9	34.9175	28000.0
2017-03-27 07:05:00	AAPL	Stock	34.9325	34.9325	34.9225	34.9325	18780.0
2017-03-27 07:10:00	AAPL	Stock	34.9375	34.95	34.9375	34.95	10244.0
2017-03-27 07:15:00	AAPL	Stock	34.9375	34.9375	34.925	34.925	19472.0
2017-03-27 07:20:00	AAPL	Stock	34.925	34.925	34.925	34.925	19336.0
2017-03-27 07:25:00	AAPL	Stock	34.9225	34.925	34.9175	34.9175	11016.0
2017-03-27 07:30:00	AAPL	Stock	34.9125	34.9175	34.9125	34.9175	1320.0
2017-03-27 07:35:00	AAPL	Stock	34.9175	34.9175	34.915	34.915	2224.0
2017-03-27 07:40:00	AAPL	Stock	34.9125	34.9125	34.9125	34.9125	4224.0
2017-03-27 07:45:00	AAPL	Stock	34.9075	34.925	34.9075	34.925	5384.0
2017-03-27 07:50:00	AAPL	Stock	34.925	34.925	34.92	34.925	27192.0
2017-03-27 07:55:00	AAPL	Stock	34.9075	34.91	34.905	34.91	17600.0
2017-03-27 08:00:00	AAPL	Stock	34.91	34.9375	34.9025	34.905	38820.0
2017-03-27 08:05:00	AAPL	Stock	34.9125	34.9125	34.8775	34.8775	60068.0
2017-03-27 08:10:00	AAPL	Stock	34.8775	34.89	34.855	34.865	36900.0
2017-03-27 08:15:00	AAPL	Stock	34.87	34.9375	34.855	34.9325	73560.0
2017-03-27 08:20:00	AAPL	Stock	34.9375	34.9375	34.905	34.905	36704.0
2017-03-27 08:25:00	AAPL	Stock	34.9075	34.9125	34.8875	34.905	45716.0
2017-03-27 08:30:00	AAPL	Stock	34.905	34.905	34.905	34.905	2000.0
2017-03-27 08:35:00	AAPL	Stock	34.8875	34.8975	34.8775	34.8875	10840.0
2017-03-27 08:40:00	AAPL	Stock	34.8775	34.885	34.875	34.885	33900.0
2017-03-27 08:45:00	AAPL	Stock	34.885	34.8925	34.8625	34.875	34976.0
2017-03-27 08:50:00	AAPL	Stock	34.875	34.8875	34.875	34.875	14356.0
2017-03-27 08:55:00	AAPL	Stock	34.8775	34.8775	34.8525	34.8775	47812.0
2017-03-27 09:00:00	AAPL	Stock	34.8775	34.88	34.855	34.875	28668.0
2017-03-27 09:05:00	AAPL	Stock	34.865	34.865	34.81	34.8225	78360.0
2017-03-27 09:10:00	AAPL	Stock	34.8225	34.8325	34.8125	34.8125	42108.0
2017-03-27 09:15:00	AAPL	Stock	34.8175	34.82	34.79	34.8	22156.0
2017-03-27 09:20:00	AAPL	Stock	34.79	34.87	34.79	34.865	33384.0
2017-03-27 09:25:00	AAPL	Stock	34.855	34.8825	34.835	34.8475	84364.0
2017-03-27 09:30:00	AAPL	Stock	34.8475	34.9925	34.655	34.955	7514852.0
2017-03-27 09:35:00	AAPL	Stock	34.9575	34.9675	34.875	34.9225	1807272.0
2017-03-27 09:40:00	AAPL	Stock	34.92	34.935	34.835	34.855	2078428.0
2017-03-27 09:45:00	AAPL	Stock	34.855	34.9225	34.815	34.9075	2117660.0
2017-03-27 09:50:00	AAPL	Stock	34.91	35.0	34.905	34.905	2486192.0

> showing 50 of 353,069 rows — these rows as CSV

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