PREVIEW / stock_5min / 2017-07-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-07.parquet
  size:    5.2 MB
  rows:    343,852
  symbols: 3,000

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-07 04:10:00	AAPL	Stock	35.6	35.6	35.6	35.6	3784.0
2017-07-07 06:10:00	AAPL	Stock	35.7	35.7	35.7	35.7	2000.0
2017-07-07 06:20:00	AAPL	Stock	35.7	35.7	35.7	35.7	400.0
2017-07-07 06:25:00	AAPL	Stock	35.7075	35.7075	35.7075	35.7075	1600.0
2017-07-07 06:40:00	AAPL	Stock	35.7	35.7	35.7	35.7	3040.0
2017-07-07 07:10:00	AAPL	Stock	35.6625	35.6625	35.6625	35.6625	3220.0
2017-07-07 07:20:00	AAPL	Stock	35.6625	35.6875	35.6625	35.6875	4628.0
2017-07-07 07:25:00	AAPL	Stock	35.6725	35.6725	35.6725	35.6725	400.0
2017-07-07 07:30:00	AAPL	Stock	35.675	35.675	35.675	35.675	400.0
2017-07-07 08:00:00	AAPL	Stock	35.665	35.69	35.665	35.69	1300.0
2017-07-07 08:05:00	AAPL	Stock	35.68	35.68	35.68	35.68	4000.0
2017-07-07 08:10:00	AAPL	Stock	35.7	35.7	35.7	35.7	1992.0
2017-07-07 08:15:00	AAPL	Stock	35.69	35.69	35.69	35.69	1996.0
2017-07-07 08:20:00	AAPL	Stock	35.705	35.705	35.7	35.7	1600.0
2017-07-07 08:25:00	AAPL	Stock	35.7125	35.75	35.71	35.75	13596.0
2017-07-07 08:30:00	AAPL	Stock	35.7275	35.8375	35.725	35.8375	73936.0
2017-07-07 08:35:00	AAPL	Stock	35.8425	35.8725	35.8375	35.8625	43736.0
2017-07-07 08:40:00	AAPL	Stock	35.855	35.855	35.7925	35.8375	71772.0
2017-07-07 08:45:00	AAPL	Stock	35.8375	35.84	35.825	35.825	15124.0
2017-07-07 08:50:00	AAPL	Stock	35.8425	35.87	35.825	35.87	50260.0
2017-07-07 08:55:00	AAPL	Stock	35.8625	35.8625	35.815	35.8175	73644.0
2017-07-07 09:00:00	AAPL	Stock	35.8175	35.8325	35.8175	35.8325	3108.0
2017-07-07 09:05:00	AAPL	Stock	35.8425	35.8425	35.8325	35.8325	8048.0
2017-07-07 09:10:00	AAPL	Stock	35.835	35.835	35.8125	35.8125	11552.0
2017-07-07 09:15:00	AAPL	Stock	35.825	35.825	35.7775	35.8	33376.0
2017-07-07 09:20:00	AAPL	Stock	35.795	35.8	35.765	35.7975	36676.0
2017-07-07 09:25:00	AAPL	Stock	35.795	35.8	35.725	35.725	191504.0
2017-07-07 09:30:00	AAPL	Stock	35.7275	35.9	35.725	35.875	4194776.0
2017-07-07 09:35:00	AAPL	Stock	35.8675	35.9375	35.8525	35.9325	1913584.0
2017-07-07 09:40:00	AAPL	Stock	35.935	35.9625	35.8625	35.8975	1515500.0
2017-07-07 09:45:00	AAPL	Stock	35.9025	35.9425	35.88	35.9175	1236892.0
2017-07-07 09:50:00	AAPL	Stock	35.9175	36.0225	35.9175	36.02	1932828.0
2017-07-07 09:55:00	AAPL	Stock	36.0175	36.035	35.947	36.0037	1674060.0
2017-07-07 10:00:00	AAPL	Stock	36.0025	36.0225	35.9575	36.005	1055404.0
2017-07-07 10:05:00	AAPL	Stock	36.0025	36.005	35.9375	35.955	953164.0
2017-07-07 10:10:00	AAPL	Stock	35.95	36.0225	35.93	36.02	882008.0
2017-07-07 10:15:00	AAPL	Stock	36.0175	36.0175	35.89	35.895	820152.0
2017-07-07 10:20:00	AAPL	Stock	35.8928	35.965	35.875	35.9125	931388.0
2017-07-07 10:25:00	AAPL	Stock	35.9125	35.9625	35.9125	35.95	532888.0
2017-07-07 10:30:00	AAPL	Stock	35.9525	36.0175	35.9525	36.0025	775748.0
2017-07-07 10:35:00	AAPL	Stock	36.0012	36.0148	35.9775	35.9925	610936.0
2017-07-07 10:40:00	AAPL	Stock	35.9875	36.0325	35.9775	36.005	1148568.0
2017-07-07 10:45:00	AAPL	Stock	36.0062	36.01	35.97	35.985	451404.0
2017-07-07 10:50:00	AAPL	Stock	35.985	35.9925	35.9525	35.9525	313512.0
2017-07-07 10:55:00	AAPL	Stock	35.9525	35.9775	35.945	35.959	395680.0
2017-07-07 11:00:00	AAPL	Stock	35.9575	35.9775	35.945	35.9738	472948.0
2017-07-07 11:05:00	AAPL	Stock	35.9738	35.995	35.9625	35.9675	502780.0
2017-07-07 11:10:00	AAPL	Stock	35.97	35.98	35.9475	35.9675	448404.0
2017-07-07 11:15:00	AAPL	Stock	35.9675	35.9675	35.925	35.9312	669192.0
2017-07-07 11:20:00	AAPL	Stock	35.9325	35.95	35.92	35.9448	398916.0

> showing 50 of 343,852 rows — these rows as CSV

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