PREVIEW / stock_5min / 2017-05-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-18.parquet
  size:    5.5 MB
  rows:    357,963
  symbols: 3,030

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-05-18 04:15:00	AAPL	Stock	37.625	37.625	37.625	37.625	640.0
2017-05-18 04:20:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	504.0
2017-05-18 04:25:00	AAPL	Stock	37.6125	37.6175	37.6125	37.6175	4356.0
2017-05-18 04:30:00	AAPL	Stock	37.6175	37.6175	37.6175	37.6175	1644.0
2017-05-18 04:40:00	AAPL	Stock	37.625	37.625	37.625	37.625	3900.0
2017-05-18 04:55:00	AAPL	Stock	37.655	37.655	37.655	37.655	800.0
2017-05-18 05:00:00	AAPL	Stock	37.655	37.655	37.6075	37.6075	3200.0
2017-05-18 05:05:00	AAPL	Stock	37.5875	37.5875	37.5375	37.5375	1600.0
2017-05-18 05:15:00	AAPL	Stock	37.6	37.6075	37.5	37.5	1852.0
2017-05-18 05:25:00	AAPL	Stock	37.5	37.5	37.5	37.5	400.0
2017-05-18 05:30:00	AAPL	Stock	37.475	37.475	37.475	37.475	800.0
2017-05-18 05:35:00	AAPL	Stock	37.43	37.475	37.43	37.475	5600.0
2017-05-18 05:40:00	AAPL	Stock	37.475	37.5175	37.4625	37.4625	13532.0
2017-05-18 05:45:00	AAPL	Stock	37.45	37.45	37.45	37.45	8000.0
2017-05-18 05:55:00	AAPL	Stock	37.435	37.45	37.435	37.45	2000.0
2017-05-18 06:00:00	AAPL	Stock	37.4625	37.4625	37.4375	37.4375	15956.0
2017-05-18 06:05:00	AAPL	Stock	37.4375	37.4375	37.4275	37.4275	3580.0
2017-05-18 06:10:00	AAPL	Stock	37.4625	37.4625	37.4375	37.4375	5916.0
2017-05-18 06:15:00	AAPL	Stock	37.4375	37.4625	37.4375	37.4625	13200.0
2017-05-18 06:20:00	AAPL	Stock	37.4625	37.4625	37.4625	37.4625	400.0
2017-05-18 06:25:00	AAPL	Stock	37.4825	37.4825	37.4375	37.4375	25840.0
2017-05-18 06:30:00	AAPL	Stock	37.475	37.475	37.44	37.4625	3760.0
2017-05-18 06:35:00	AAPL	Stock	37.4925	37.4925	37.45	37.45	1600.0
2017-05-18 06:40:00	AAPL	Stock	37.45	37.45	37.45	37.45	400.0
2017-05-18 06:50:00	AAPL	Stock	37.45	37.45	37.4025	37.4025	30620.0
2017-05-18 06:55:00	AAPL	Stock	37.425	37.425	37.425	37.425	800.0
2017-05-18 07:00:00	AAPL	Stock	37.425	37.43	37.425	37.425	5600.0
2017-05-18 07:05:00	AAPL	Stock	37.425	37.43	37.425	37.4275	2700.0
2017-05-18 07:10:00	AAPL	Stock	37.4275	37.43	37.4275	37.43	4000.0
2017-05-18 07:15:00	AAPL	Stock	37.43	37.525	37.43	37.4875	24396.0
2017-05-18 07:20:00	AAPL	Stock	37.525	37.525	37.525	37.525	5940.0
2017-05-18 07:25:00	AAPL	Stock	37.5475	37.5625	37.5	37.5575	24232.0
2017-05-18 07:30:00	AAPL	Stock	37.5575	37.6	37.5575	37.6	15940.0
2017-05-18 07:35:00	AAPL	Stock	37.6125	37.685	37.6125	37.65	28464.0
2017-05-18 07:40:00	AAPL	Stock	37.65	37.6625	37.65	37.6625	4980.0
2017-05-18 07:45:00	AAPL	Stock	37.6625	37.6625	37.615	37.6225	13028.0
2017-05-18 07:50:00	AAPL	Stock	37.645	37.645	37.61	37.625	11344.0
2017-05-18 07:55:00	AAPL	Stock	37.645	37.645	37.6425	37.645	5048.0
2017-05-18 08:00:00	AAPL	Stock	37.6275	37.7175	37.4025	37.7025	100476.0
2017-05-18 08:05:00	AAPL	Stock	37.7025	37.7275	37.68	37.68	82412.0
2017-05-18 08:10:00	AAPL	Stock	37.6875	37.7	37.6575	37.6575	41464.0
2017-05-18 08:15:00	AAPL	Stock	37.645	37.675	37.6375	37.645	55336.0
2017-05-18 08:20:00	AAPL	Stock	37.64	37.64	37.565	37.605	74524.0
2017-05-18 08:25:00	AAPL	Stock	37.6	37.6375	37.5875	37.635	24796.0
2017-05-18 08:30:00	AAPL	Stock	37.6225	37.715	37.6225	37.695	26796.0
2017-05-18 08:35:00	AAPL	Stock	37.695	37.8	37.695	37.775	77880.0
2017-05-18 08:40:00	AAPL	Stock	37.77	37.79	37.75	37.7625	90260.0
2017-05-18 08:45:00	AAPL	Stock	37.7625	37.8	37.7425	37.8	39648.0
2017-05-18 08:50:00	AAPL	Stock	37.7925	37.815	37.76	37.7875	104816.0
2017-05-18 08:55:00	AAPL	Stock	37.7875	37.7925	37.75	37.765	30936.0

> showing 50 of 357,963 rows — these rows as CSV

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