PREVIEW / stock_5min / 2017-09-14

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-14.parquet
  size:    5.3 MB
  rows:    349,994
  symbols: 2,967

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-09-14 04:00:00	AAPL	Stock	39.8725	39.9225	39.8725	39.8925	6932.0
2017-09-14 04:10:00	AAPL	Stock	39.875	39.875	39.8625	39.8625	5596.0
2017-09-14 04:20:00	AAPL	Stock	39.8625	39.8625	39.8625	39.8625	1204.0
2017-09-14 04:25:00	AAPL	Stock	39.8625	39.8625	39.85	39.85	800.0
2017-09-14 04:50:00	AAPL	Stock	39.85	39.85	39.85	39.85	3540.0
2017-09-14 05:00:00	AAPL	Stock	39.85	39.85	39.85	39.85	1040.0
2017-09-14 05:05:00	AAPL	Stock	39.85	39.85	39.85	39.85	880.0
2017-09-14 05:20:00	AAPL	Stock	39.85	39.85	39.85	39.85	596.0
2017-09-14 05:50:00	AAPL	Stock	39.85	39.85	39.85	39.85	844.0
2017-09-14 05:55:00	AAPL	Stock	39.85	39.85	39.85	39.85	1516.0
2017-09-14 06:05:00	AAPL	Stock	39.85	39.85	39.85	39.85	3996.0
2017-09-14 06:10:00	AAPL	Stock	39.85	39.85	39.85	39.85	424.0
2017-09-14 06:15:00	AAPL	Stock	39.895	39.895	39.85	39.85	2704.0
2017-09-14 06:35:00	AAPL	Stock	39.825	39.845	39.825	39.845	3976.0
2017-09-14 07:00:00	AAPL	Stock	39.83	39.83	39.825	39.825	4052.0
2017-09-14 07:05:00	AAPL	Stock	39.82	39.82	39.82	39.82	3948.0
2017-09-14 07:10:00	AAPL	Stock	39.82	39.82	39.82	39.82	400.0
2017-09-14 07:15:00	AAPL	Stock	39.825	39.825	39.825	39.825	2832.0
2017-09-14 07:20:00	AAPL	Stock	39.83	39.83	39.815	39.815	2904.0
2017-09-14 07:25:00	AAPL	Stock	39.825	39.83	39.815	39.815	3000.0
2017-09-14 07:30:00	AAPL	Stock	39.8125	39.825	39.795	39.825	9940.0
2017-09-14 07:35:00	AAPL	Stock	39.8025	39.8125	39.8025	39.8025	4600.0
2017-09-14 07:40:00	AAPL	Stock	39.8025	39.8025	39.7825	39.79	6152.0
2017-09-14 07:45:00	AAPL	Stock	39.79	39.79	39.75	39.75	16476.0
2017-09-14 07:50:00	AAPL	Stock	39.75	39.7725	39.7475	39.75	17772.0
2017-09-14 07:55:00	AAPL	Stock	39.75	39.75	39.75	39.75	8024.0
2017-09-14 08:00:00	AAPL	Stock	39.8025	39.8425	39.725	39.745	97380.0
2017-09-14 08:05:00	AAPL	Stock	39.725	39.755	39.725	39.755	68176.0
2017-09-14 08:10:00	AAPL	Stock	39.74	39.7425	39.725	39.73	25564.0
2017-09-14 08:15:00	AAPL	Stock	39.75	39.7925	39.75	39.7925	29784.0
2017-09-14 08:20:00	AAPL	Stock	39.775	39.7875	39.7275	39.7275	34596.0
2017-09-14 08:25:00	AAPL	Stock	39.7525	39.775	39.7388	39.75	71392.0
2017-09-14 08:30:00	AAPL	Stock	39.75	39.765	39.735	39.75	94060.0
2017-09-14 08:35:00	AAPL	Stock	39.7575	39.76	39.75	39.7575	18016.0
2017-09-14 08:40:00	AAPL	Stock	39.75	39.75	39.715	39.7425	95212.0
2017-09-14 08:45:00	AAPL	Stock	39.7425	39.75	39.7375	39.75	6492.0
2017-09-14 08:50:00	AAPL	Stock	39.7275	39.7525	39.725	39.73	15840.0
2017-09-14 08:55:00	AAPL	Stock	39.745	39.8025	39.745	39.765	30856.0
2017-09-14 09:00:00	AAPL	Stock	39.7825	39.7875	39.765	39.7875	19672.0
2017-09-14 09:05:00	AAPL	Stock	39.765	39.7875	39.765	39.7875	23128.0
2017-09-14 09:10:00	AAPL	Stock	39.765	39.8025	39.765	39.775	59040.0
2017-09-14 09:15:00	AAPL	Stock	39.8075	39.8075	39.775	39.78	11012.0
2017-09-14 09:20:00	AAPL	Stock	39.78	39.795	39.775	39.775	97712.0
2017-09-14 09:25:00	AAPL	Stock	39.775	39.785	39.75	39.755	27200.0
2017-09-14 09:30:00	AAPL	Stock	39.7475	39.8075	39.715	39.715	4714908.0
2017-09-14 09:35:00	AAPL	Stock	39.715	39.77	39.62	39.7	2841516.0
2017-09-14 09:40:00	AAPL	Stock	39.7012	39.7575	39.69	39.72	1345032.0
2017-09-14 09:45:00	AAPL	Stock	39.7212	39.825	39.72	39.7625	2345028.0
2017-09-14 09:50:00	AAPL	Stock	39.7625	39.85	39.7618	39.8485	1862600.0
2017-09-14 09:55:00	AAPL	Stock	39.85	39.85	39.7702	39.7975	1372556.0

> showing 50 of 349,994 rows — these rows as CSV

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