PREVIEW / stock_5min / 2017-05-04

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-04.parquet
  size:    5.5 MB
  rows:    355,912
  symbols: 3,052

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-04 04:00:00	AAPL	Stock	36.72	36.72	36.72	36.72	400.0
2017-05-04 04:25:00	AAPL	Stock	36.7125	36.7125	36.7125	36.7125	400.0
2017-05-04 05:00:00	AAPL	Stock	36.7425	36.7425	36.7425	36.7425	400.0
2017-05-04 05:05:00	AAPL	Stock	36.7275	36.7275	36.7275	36.7275	400.0
2017-05-04 05:20:00	AAPL	Stock	36.7425	36.7425	36.7425	36.7425	3172.0
2017-05-04 05:50:00	AAPL	Stock	36.775	36.775	36.775	36.775	3748.0
2017-05-04 06:05:00	AAPL	Stock	36.8225	36.8225	36.8225	36.8225	472.0
2017-05-04 06:10:00	AAPL	Stock	36.8225	36.8225	36.8225	36.8225	3600.0
2017-05-04 06:15:00	AAPL	Stock	36.81	36.81	36.81	36.81	2000.0
2017-05-04 06:20:00	AAPL	Stock	36.8225	36.8225	36.8225	36.8225	1232.0
2017-05-04 06:25:00	AAPL	Stock	36.8125	36.8125	36.8125	36.8125	1600.0
2017-05-04 06:30:00	AAPL	Stock	36.7875	36.825	36.7875	36.825	1244.0
2017-05-04 06:35:00	AAPL	Stock	36.825	36.8375	36.825	36.8375	4000.0
2017-05-04 06:40:00	AAPL	Stock	36.8375	36.8375	36.8375	36.8375	2000.0
2017-05-04 06:45:00	AAPL	Stock	36.8025	36.8025	36.8025	36.8025	800.0
2017-05-04 06:55:00	AAPL	Stock	36.84	36.84	36.84	36.84	400.0
2017-05-04 07:00:00	AAPL	Stock	36.8475	36.8625	36.82	36.82	18200.0
2017-05-04 07:10:00	AAPL	Stock	36.8125	36.8125	36.7725	36.7725	28128.0
2017-05-04 07:15:00	AAPL	Stock	36.79	36.79	36.79	36.79	800.0
2017-05-04 07:20:00	AAPL	Stock	36.7875	36.8125	36.7825	36.8125	12684.0
2017-05-04 07:25:00	AAPL	Stock	36.8125	36.8125	36.775	36.775	15476.0
2017-05-04 07:30:00	AAPL	Stock	36.78	36.835	36.78	36.835	24220.0
2017-05-04 07:35:00	AAPL	Stock	36.835	36.835	36.8125	36.8125	3160.0
2017-05-04 07:40:00	AAPL	Stock	36.8125	36.8125	36.8125	36.8125	9400.0
2017-05-04 07:45:00	AAPL	Stock	36.815	36.8175	36.815	36.8175	6196.0
2017-05-04 07:50:00	AAPL	Stock	36.8025	36.8025	36.8	36.8	21160.0
2017-05-04 07:55:00	AAPL	Stock	36.81	36.81	36.795	36.795	2800.0
2017-05-04 08:00:00	AAPL	Stock	36.8475	36.85	36.7675	36.7875	77320.0
2017-05-04 08:05:00	AAPL	Stock	36.7875	36.7875	36.765	36.775	35272.0
2017-05-04 08:10:00	AAPL	Stock	36.77	36.775	36.77	36.775	9180.0
2017-05-04 08:15:00	AAPL	Stock	36.75	36.775	36.75	36.7525	26852.0
2017-05-04 08:20:00	AAPL	Stock	36.75	36.7525	36.7275	36.7375	15792.0
2017-05-04 08:25:00	AAPL	Stock	36.73	36.73	36.6875	36.7025	41804.0
2017-05-04 08:30:00	AAPL	Stock	36.73	36.7375	36.7	36.7	19844.0
2017-05-04 08:35:00	AAPL	Stock	36.6975	36.7	36.6875	36.6875	32388.0
2017-05-04 08:40:00	AAPL	Stock	36.675	36.675	36.6375	36.67	16620.0
2017-05-04 08:45:00	AAPL	Stock	36.6725	36.695	36.65	36.65	11908.0
2017-05-04 08:50:00	AAPL	Stock	36.6725	36.675	36.65	36.6625	11336.0
2017-05-04 08:55:00	AAPL	Stock	36.6575	36.66	36.635	36.635	17884.0
2017-05-04 09:00:00	AAPL	Stock	36.635	36.6625	36.635	36.655	21748.0
2017-05-04 09:05:00	AAPL	Stock	36.67	36.6875	36.67	36.675	38128.0
2017-05-04 09:10:00	AAPL	Stock	36.675	36.685	36.675	36.685	17504.0
2017-05-04 09:15:00	AAPL	Stock	36.685	36.685	36.6575	36.6575	22000.0
2017-05-04 09:20:00	AAPL	Stock	36.6625	36.6625	36.6375	36.6375	26432.0
2017-05-04 09:25:00	AAPL	Stock	36.63	36.6625	36.62	36.6325	125816.0
2017-05-04 09:30:00	AAPL	Stock	36.6375	36.785	36.6275	36.635	5428660.0
2017-05-04 09:35:00	AAPL	Stock	36.63	36.6347	36.46	36.4678	3172704.0
2017-05-04 09:40:00	AAPL	Stock	36.4675	36.5875	36.4625	36.54	3042872.0
2017-05-04 09:45:00	AAPL	Stock	36.5412	36.6175	36.53	36.535	2319920.0
2017-05-04 09:50:00	AAPL	Stock	36.5342	36.54	36.46	36.4675	2122204.0

> showing 50 of 355,912 rows — these rows as CSV

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