PREVIEW / stock_5min / 2017-03-14

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-14.parquet
  size:    5.3 MB
  rows:    350,210
  symbols: 3,066

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-03-14 04:00:00	AAPL	Stock	34.75	34.75	34.75	34.75	1152.0
2017-03-14 05:25:00	AAPL	Stock	34.75	34.75	34.75	34.75	420.0
2017-03-14 05:35:00	AAPL	Stock	34.75	34.75	34.75	34.75	560.0
2017-03-14 06:50:00	AAPL	Stock	34.7875	34.7875	34.7875	34.7875	400.0
2017-03-14 07:10:00	AAPL	Stock	34.79	34.7925	34.79	34.7925	3600.0
2017-03-14 07:45:00	AAPL	Stock	34.78	34.78	34.7775	34.7775	1200.0
2017-03-14 07:55:00	AAPL	Stock	34.7675	34.7675	34.7675	34.7675	1200.0
2017-03-14 08:00:00	AAPL	Stock	34.8	34.8	34.7675	34.7875	36600.0
2017-03-14 08:05:00	AAPL	Stock	34.7525	34.7525	34.75	34.75	6400.0
2017-03-14 08:10:00	AAPL	Stock	34.73	34.7375	34.7125	34.7375	9912.0
2017-03-14 08:15:00	AAPL	Stock	34.7275	34.7275	34.7275	34.7275	400.0
2017-03-14 08:20:00	AAPL	Stock	34.7425	34.7475	34.735	34.735	5184.0
2017-03-14 08:25:00	AAPL	Stock	34.735	34.735	34.7125	34.7125	15272.0
2017-03-14 08:30:00	AAPL	Stock	34.735	34.735	34.725	34.725	6600.0
2017-03-14 08:50:00	AAPL	Stock	34.7475	34.7475	34.7475	34.7475	3204.0
2017-03-14 08:55:00	AAPL	Stock	34.7425	34.7425	34.7375	34.7375	2000.0
2017-03-14 09:00:00	AAPL	Stock	34.7475	34.7475	34.745	34.745	4872.0
2017-03-14 09:10:00	AAPL	Stock	34.775	34.7775	34.775	34.7775	800.0
2017-03-14 09:15:00	AAPL	Stock	34.765	34.775	34.765	34.765	9672.0
2017-03-14 09:20:00	AAPL	Stock	34.765	34.765	34.765	34.765	692.0
2017-03-14 09:25:00	AAPL	Stock	34.77	34.825	34.7675	34.8225	68456.0
2017-03-14 09:30:00	AAPL	Stock	34.825	34.9125	34.8237	34.855	4718640.0
2017-03-14 09:35:00	AAPL	Stock	34.8575	34.885	34.835	34.87	1254224.0
2017-03-14 09:40:00	AAPL	Stock	34.8725	34.895	34.8575	34.894	1022092.0
2017-03-14 09:45:00	AAPL	Stock	34.89	34.8975	34.8675	34.885	808044.0
2017-03-14 09:50:00	AAPL	Stock	34.886	34.89	34.825	34.865	1815176.0
2017-03-14 09:55:00	AAPL	Stock	34.8675	34.8725	34.8125	34.8625	1437740.0
2017-03-14 10:00:00	AAPL	Stock	34.8625	34.8625	34.82	34.8325	726568.0
2017-03-14 10:05:00	AAPL	Stock	34.8325	34.8425	34.805	34.8105	725844.0
2017-03-14 10:10:00	AAPL	Stock	34.81	34.8285	34.8038	34.8125	697424.0
2017-03-14 10:15:00	AAPL	Stock	34.815	34.8175	34.735	34.7375	1216164.0
2017-03-14 10:20:00	AAPL	Stock	34.74	34.7825	34.73	34.7625	966388.0
2017-03-14 10:25:00	AAPL	Stock	34.7612	34.8025	34.755	34.773	969852.0
2017-03-14 10:30:00	AAPL	Stock	34.7725	34.7788	34.75	34.7712	531596.0
2017-03-14 10:35:00	AAPL	Stock	34.77	34.775	34.7375	34.7375	695528.0
2017-03-14 10:40:00	AAPL	Stock	34.7385	34.7403	34.7162	34.7248	902896.0
2017-03-14 10:45:00	AAPL	Stock	34.725	34.7375	34.71	34.7252	666732.0
2017-03-14 10:50:00	AAPL	Stock	34.726	34.745	34.7175	34.7338	982300.0
2017-03-14 10:55:00	AAPL	Stock	34.7365	34.7625	34.725	34.76	695076.0
2017-03-14 11:00:00	AAPL	Stock	34.758	34.7625	34.7388	34.7525	624324.0
2017-03-14 11:05:00	AAPL	Stock	34.7512	34.7625	34.7425	34.745	556548.0
2017-03-14 11:10:00	AAPL	Stock	34.7425	34.755	34.725	34.731	554188.0
2017-03-14 11:15:00	AAPL	Stock	34.73	34.785	34.73	34.7625	815664.0
2017-03-14 11:20:00	AAPL	Stock	34.765	34.7848	34.75	34.755	571836.0
2017-03-14 11:25:00	AAPL	Stock	34.7575	34.785	34.7575	34.7575	637528.0
2017-03-14 11:30:00	AAPL	Stock	34.7575	34.79	34.7525	34.76	531204.0
2017-03-14 11:35:00	AAPL	Stock	34.7612	34.775	34.75	34.755	477948.0
2017-03-14 11:40:00	AAPL	Stock	34.755	34.7675	34.7325	34.7325	402112.0
2017-03-14 11:45:00	AAPL	Stock	34.7335	34.755	34.7325	34.7525	467708.0
2017-03-14 11:50:00	AAPL	Stock	34.7525	34.785	34.7525	34.7788	433268.0

> showing 50 of 350,210 rows — these rows as CSV

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