PREVIEW / stock_5min / 2017-01-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-13.parquet
  size:    5.2 MB
  rows:    343,107
  symbols: 3,137

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-01-13 06:50:00	AAPL	Stock	29.795	29.795	29.7775	29.7775	4400.0
2017-01-13 07:05:00	AAPL	Stock	29.795	29.81	29.795	29.81	2796.0
2017-01-13 07:25:00	AAPL	Stock	29.805	29.805	29.805	29.805	800.0
2017-01-13 07:30:00	AAPL	Stock	29.8025	29.8025	29.8025	29.8025	400.0
2017-01-13 07:40:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	6144.0
2017-01-13 07:50:00	AAPL	Stock	29.8	29.8	29.8	29.8	2400.0
2017-01-13 08:00:00	AAPL	Stock	29.8	29.835	29.8	29.835	40876.0
2017-01-13 08:05:00	AAPL	Stock	29.8325	29.8325	29.8325	29.8325	400.0
2017-01-13 08:10:00	AAPL	Stock	29.8125	29.8125	29.81	29.8125	10112.0
2017-01-13 08:15:00	AAPL	Stock	29.81	29.8125	29.8	29.8	17872.0
2017-01-13 08:20:00	AAPL	Stock	29.8	29.805	29.7875	29.805	21128.0
2017-01-13 08:25:00	AAPL	Stock	29.7975	29.7975	29.7975	29.7975	2696.0
2017-01-13 08:30:00	AAPL	Stock	29.7875	29.805	29.7875	29.7875	14484.0
2017-01-13 08:40:00	AAPL	Stock	29.7875	29.7875	29.7775	29.7775	23000.0
2017-01-13 08:45:00	AAPL	Stock	29.7775	29.7875	29.7775	29.7875	1852.0
2017-01-13 08:50:00	AAPL	Stock	29.785	29.795	29.785	29.795	7000.0
2017-01-13 08:55:00	AAPL	Stock	29.785	29.785	29.78	29.78	1932.0
2017-01-13 09:00:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	800.0
2017-01-13 09:05:00	AAPL	Stock	29.785	29.785	29.78	29.78	9072.0
2017-01-13 09:10:00	AAPL	Stock	29.775	29.775	29.7625	29.7625	6956.0
2017-01-13 09:15:00	AAPL	Stock	29.7675	29.7675	29.7675	29.7675	500.0
2017-01-13 09:20:00	AAPL	Stock	29.7875	29.7925	29.7875	29.79	25596.0
2017-01-13 09:25:00	AAPL	Stock	29.79	29.8075	29.745	29.78	118652.0
2017-01-13 09:30:00	AAPL	Stock	29.7775	29.8975	29.775	29.8825	5383092.0
2017-01-13 09:35:00	AAPL	Stock	29.8825	29.905	29.8375	29.8425	2597348.0
2017-01-13 09:40:00	AAPL	Stock	29.8425	29.8675	29.805	29.811	2751536.0
2017-01-13 09:45:00	AAPL	Stock	29.8125	29.87	29.8025	29.87	2317364.0
2017-01-13 09:50:00	AAPL	Stock	29.87	29.895	29.8575	29.865	1942528.0
2017-01-13 09:55:00	AAPL	Stock	29.865	29.8675	29.78	29.806	1906484.0
2017-01-13 10:00:00	AAPL	Stock	29.805	29.8125	29.7575	29.7675	1419684.0
2017-01-13 10:05:00	AAPL	Stock	29.77	29.7975	29.76	29.795	1017672.0
2017-01-13 10:10:00	AAPL	Stock	29.795	29.84	29.795	29.82	1298788.0
2017-01-13 10:15:00	AAPL	Stock	29.8202	29.8425	29.7975	29.7975	1109716.0
2017-01-13 10:20:00	AAPL	Stock	29.7988	29.8125	29.7925	29.81	608372.0
2017-01-13 10:25:00	AAPL	Stock	29.8125	29.8175	29.775	29.78	988688.0
2017-01-13 10:30:00	AAPL	Stock	29.7795	29.7875	29.7625	29.765	1083796.0
2017-01-13 10:35:00	AAPL	Stock	29.765	29.7725	29.7425	29.7425	1314476.0
2017-01-13 10:40:00	AAPL	Stock	29.745	29.7475	29.715	29.7375	1406524.0
2017-01-13 10:45:00	AAPL	Stock	29.7375	29.7502	29.73	29.73	1067644.0
2017-01-13 10:50:00	AAPL	Stock	29.73	29.76	29.725	29.75	1263880.0
2017-01-13 10:55:00	AAPL	Stock	29.748	29.75	29.73	29.7442	625488.0
2017-01-13 11:00:00	AAPL	Stock	29.745	29.75	29.74	29.7425	687416.0
2017-01-13 11:05:00	AAPL	Stock	29.7412	29.75	29.72	29.7475	1056964.0
2017-01-13 11:10:00	AAPL	Stock	29.7475	29.75	29.7325	29.7475	525064.0
2017-01-13 11:15:00	AAPL	Stock	29.7475	29.7525	29.7425	29.75	652668.0
2017-01-13 11:20:00	AAPL	Stock	29.75	29.775	29.7475	29.7738	1077200.0
2017-01-13 11:25:00	AAPL	Stock	29.775	29.7775	29.7625	29.7688	821448.0
2017-01-13 11:30:00	AAPL	Stock	29.77	29.775	29.7625	29.7662	581808.0
2017-01-13 11:35:00	AAPL	Stock	29.765	29.7762	29.765	29.775	690204.0
2017-01-13 11:40:00	AAPL	Stock	29.7725	29.7875	29.77	29.7788	1234100.0

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

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