PREVIEW / stock_5min / 2017-08-14

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-14.parquet
  size:    5.3 MB
  rows:    348,837
  symbols: 2,994

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-08-14 04:00:00	AAPL	Stock	39.65	39.65	39.65	39.65	400.0
2017-08-14 04:05:00	AAPL	Stock	39.6625	39.6625	39.65	39.65	17276.0
2017-08-14 04:15:00	AAPL	Stock	39.65	39.65	39.65	39.65	1852.0
2017-08-14 04:20:00	AAPL	Stock	39.65	39.65	39.65	39.65	3604.0
2017-08-14 04:25:00	AAPL	Stock	39.65	39.65	39.65	39.65	6852.0
2017-08-14 04:30:00	AAPL	Stock	39.65	39.65	39.65	39.65	3100.0
2017-08-14 04:35:00	AAPL	Stock	39.5875	39.605	39.5875	39.6	8396.0
2017-08-14 04:45:00	AAPL	Stock	39.625	39.625	39.625	39.625	3576.0
2017-08-14 04:50:00	AAPL	Stock	39.65	39.65	39.6175	39.6175	15148.0
2017-08-14 04:55:00	AAPL	Stock	39.6125	39.65	39.6	39.65	8636.0
2017-08-14 05:00:00	AAPL	Stock	39.6525	39.6525	39.6525	39.6525	400.0
2017-08-14 05:05:00	AAPL	Stock	39.6725	39.6725	39.65	39.65	2400.0
2017-08-14 05:10:00	AAPL	Stock	39.6625	39.6725	39.6625	39.6725	800.0
2017-08-14 05:15:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	800.0
2017-08-14 05:20:00	AAPL	Stock	39.6625	39.6725	39.6625	39.6725	7100.0
2017-08-14 05:25:00	AAPL	Stock	39.6625	39.6625	39.6625	39.6625	1988.0
2017-08-14 05:30:00	AAPL	Stock	39.675	39.675	39.675	39.675	1560.0
2017-08-14 05:35:00	AAPL	Stock	39.6925	39.6925	39.6925	39.6925	400.0
2017-08-14 05:40:00	AAPL	Stock	39.7225	39.7225	39.6875	39.6875	1200.0
2017-08-14 05:45:00	AAPL	Stock	39.725	39.725	39.725	39.725	3600.0
2017-08-14 05:55:00	AAPL	Stock	39.7075	39.7075	39.7075	39.7075	11580.0
2017-08-14 06:00:00	AAPL	Stock	39.7	39.7325	39.6725	39.6725	27360.0
2017-08-14 06:05:00	AAPL	Stock	39.6725	39.6725	39.6725	39.6725	2564.0
2017-08-14 06:25:00	AAPL	Stock	39.7	39.725	39.6875	39.6875	5000.0
2017-08-14 06:30:00	AAPL	Stock	39.7	39.7	39.7	39.7	1600.0
2017-08-14 06:40:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	800.0
2017-08-14 06:45:00	AAPL	Stock	39.7125	39.72	39.7125	39.715	1600.0
2017-08-14 06:50:00	AAPL	Stock	39.715	39.715	39.7125	39.7125	880.0
2017-08-14 06:55:00	AAPL	Stock	39.7075	39.7075	39.7	39.705	10136.0
2017-08-14 07:00:00	AAPL	Stock	39.7125	39.7225	39.7125	39.7225	20928.0
2017-08-14 07:05:00	AAPL	Stock	39.7225	39.7375	39.7225	39.7375	6940.0
2017-08-14 07:10:00	AAPL	Stock	39.745	39.775	39.7325	39.75	49920.0
2017-08-14 07:15:00	AAPL	Stock	39.75	39.7525	39.7225	39.7225	46160.0
2017-08-14 07:20:00	AAPL	Stock	39.745	39.7625	39.74	39.7625	7688.0
2017-08-14 07:25:00	AAPL	Stock	39.785	39.785	39.785	39.785	400.0
2017-08-14 07:30:00	AAPL	Stock	39.75	39.75	39.7275	39.7275	6168.0
2017-08-14 07:35:00	AAPL	Stock	39.725	39.7375	39.7075	39.7075	2736.0
2017-08-14 07:40:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	3800.0
2017-08-14 07:45:00	AAPL	Stock	39.705	39.735	39.69	39.735	18440.0
2017-08-14 07:50:00	AAPL	Stock	39.725	39.7325	39.7125	39.725	10832.0
2017-08-14 07:55:00	AAPL	Stock	39.725	39.735	39.72	39.72	21076.0
2017-08-14 08:00:00	AAPL	Stock	39.7175	39.7875	39.6275	39.7125	141700.0
2017-08-14 08:05:00	AAPL	Stock	39.7125	39.725	39.7125	39.725	32432.0
2017-08-14 08:10:00	AAPL	Stock	39.735	39.755	39.725	39.755	33904.0
2017-08-14 08:15:00	AAPL	Stock	39.755	39.775	39.74	39.7725	35004.0
2017-08-14 08:20:00	AAPL	Stock	39.7725	39.7725	39.75	39.77	42072.0
2017-08-14 08:25:00	AAPL	Stock	39.77	39.7775	39.7625	39.7625	45076.0
2017-08-14 08:30:00	AAPL	Stock	39.7575	39.765	39.7575	39.7575	14528.0
2017-08-14 08:35:00	AAPL	Stock	39.755	39.765	39.7525	39.7525	14172.0
2017-08-14 08:40:00	AAPL	Stock	39.7525	39.7525	39.72	39.7275	115748.0

> showing 50 of 348,837 rows — these rows as CSV

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