PREVIEW / stock_5min / 2017-10-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-09.parquet
  size:    5.2 MB
  rows:    341,851
  symbols: 2,931

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-09 04:05:00	AAPL	Stock	38.7675	38.7675	38.7625	38.7625	3600.0
2017-10-09 04:10:00	AAPL	Stock	38.7625	38.7625	38.7625	38.7625	3680.0
2017-10-09 04:30:00	AAPL	Stock	38.7575	38.7575	38.7575	38.7575	512.0
2017-10-09 05:15:00	AAPL	Stock	38.8125	38.8375	38.8125	38.8375	2196.0
2017-10-09 05:30:00	AAPL	Stock	38.835	38.835	38.835	38.835	2000.0
2017-10-09 05:35:00	AAPL	Stock	38.8375	38.95	38.8375	38.95	5320.0
2017-10-09 05:40:00	AAPL	Stock	38.925	38.925	38.925	38.925	4800.0
2017-10-09 05:50:00	AAPL	Stock	38.9	38.9	38.9	38.9	600.0
2017-10-09 06:05:00	AAPL	Stock	38.9	38.915	38.9	38.915	2544.0
2017-10-09 06:15:00	AAPL	Stock	38.9	38.9	38.9	38.9	400.0
2017-10-09 06:20:00	AAPL	Stock	38.9	38.9	38.9	38.9	2000.0
2017-10-09 06:25:00	AAPL	Stock	38.9	38.9	38.9	38.9	11600.0
2017-10-09 06:30:00	AAPL	Stock	38.9	38.9	38.9	38.9	400.0
2017-10-09 06:40:00	AAPL	Stock	38.9	38.9125	38.9	38.9125	1140.0
2017-10-09 06:45:00	AAPL	Stock	38.9375	38.9375	38.9375	38.9375	4000.0
2017-10-09 07:00:00	AAPL	Stock	38.9	38.9375	38.8875	38.9375	13236.0
2017-10-09 07:10:00	AAPL	Stock	38.9125	38.9125	38.9	38.9	9200.0
2017-10-09 07:15:00	AAPL	Stock	38.9	38.9	38.8875	38.8875	20452.0
2017-10-09 07:20:00	AAPL	Stock	38.9175	38.9175	38.9175	38.9175	400.0
2017-10-09 07:25:00	AAPL	Stock	38.9175	38.9575	38.9175	38.9575	18312.0
2017-10-09 07:30:00	AAPL	Stock	38.955	38.955	38.9475	38.95	4400.0
2017-10-09 07:35:00	AAPL	Stock	38.9375	38.945	38.9275	38.9425	15800.0
2017-10-09 07:40:00	AAPL	Stock	38.95	38.955	38.945	38.95	20904.0
2017-10-09 07:45:00	AAPL	Stock	38.955	38.975	38.955	38.975	21452.0
2017-10-09 07:50:00	AAPL	Stock	38.975	38.9975	38.975	38.9975	8068.0
2017-10-09 07:55:00	AAPL	Stock	38.9825	38.9825	38.975	38.975	13000.0
2017-10-09 08:00:00	AAPL	Stock	38.95	38.9975	38.9	38.96	39580.0
2017-10-09 08:05:00	AAPL	Stock	38.9625	38.985	38.96	38.985	16364.0
2017-10-09 08:10:00	AAPL	Stock	38.98	38.98	38.9625	38.9625	5896.0
2017-10-09 08:15:00	AAPL	Stock	38.9625	38.97	38.9625	38.97	6100.0
2017-10-09 08:20:00	AAPL	Stock	38.9625	38.97	38.96	38.97	6880.0
2017-10-09 08:25:00	AAPL	Stock	38.97	38.97	38.9625	38.97	8076.0
2017-10-09 08:30:00	AAPL	Stock	38.965	38.9875	38.965	38.9825	35768.0
2017-10-09 08:35:00	AAPL	Stock	38.97	38.9875	38.9425	38.97	54472.0
2017-10-09 08:40:00	AAPL	Stock	38.97	38.97	38.9475	38.9475	3600.0
2017-10-09 08:45:00	AAPL	Stock	38.9625	38.965	38.9625	38.965	800.0
2017-10-09 08:50:00	AAPL	Stock	38.9625	38.965	38.9625	38.9625	8936.0
2017-10-09 08:55:00	AAPL	Stock	38.965	38.9725	38.9575	38.9575	8220.0
2017-10-09 09:00:00	AAPL	Stock	38.9725	38.9725	38.9725	38.9725	800.0
2017-10-09 09:05:00	AAPL	Stock	38.96	38.9725	38.9575	38.9725	24284.0
2017-10-09 09:10:00	AAPL	Stock	38.9725	38.98	38.9725	38.9725	3000.0
2017-10-09 09:15:00	AAPL	Stock	38.97	38.98	38.9675	38.97	22244.0
2017-10-09 09:20:00	AAPL	Stock	38.9675	38.9775	38.9525	38.9525	15240.0
2017-10-09 09:25:00	AAPL	Stock	38.9675	38.975	38.94	38.965	42244.0
2017-10-09 09:30:00	AAPL	Stock	38.955	38.98	38.8775	38.9275	2551184.0
2017-10-09 09:35:00	AAPL	Stock	38.91	38.9825	38.9	38.93	1238804.0
2017-10-09 09:40:00	AAPL	Stock	38.9325	38.9825	38.903	38.945	1244408.0
2017-10-09 09:45:00	AAPL	Stock	38.9475	38.9625	38.8825	38.8875	1161336.0
2017-10-09 09:50:00	AAPL	Stock	38.8825	38.9625	38.8713	38.96	922200.0
2017-10-09 09:55:00	AAPL	Stock	38.9625	39.07	38.94	39.0518	2988140.0

> showing 50 of 341,851 rows — these rows as CSV

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