PREVIEW / stock_5min / 2014-03-20

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-20.parquet
  size:    5.4 MB
  rows:    361,195
  symbols: 3,538

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
2014-03-20 06:00:00	AAPL	Stock	18.9114	18.9114	18.9114	18.9114	8400.0
2014-03-20 06:10:00	AAPL	Stock	18.9032	18.9032	18.9032	18.9032	5600.0
2014-03-20 06:15:00	AAPL	Stock	18.9061	18.9061	18.9061	18.9061	11200.0
2014-03-20 06:20:00	AAPL	Stock	18.9132	18.9132	18.9132	18.9132	5600.0
2014-03-20 07:15:00	AAPL	Stock	18.9061	18.9061	18.9061	18.9061	2800.0
2014-03-20 07:30:00	AAPL	Stock	18.9107	18.9107	18.9107	18.9107	5600.0
2014-03-20 07:35:00	AAPL	Stock	18.9214	18.9214	18.9214	18.9214	2800.0
2014-03-20 07:40:00	AAPL	Stock	18.9218	18.9218	18.9214	18.9214	8400.0
2014-03-20 07:45:00	AAPL	Stock	18.9282	18.9286	18.9282	18.9286	14000.0
2014-03-20 07:50:00	AAPL	Stock	18.9446	18.9554	18.9446	18.9554	19600.0
2014-03-20 07:55:00	AAPL	Stock	18.9643	18.965	18.9643	18.965	8400.0
2014-03-20 08:00:00	AAPL	Stock	18.88	18.9643	18.8789	18.9464	93800.0
2014-03-20 08:05:00	AAPL	Stock	18.9464	18.9643	18.9464	18.9643	67200.0
2014-03-20 08:10:00	AAPL	Stock	18.9471	18.9639	18.9464	18.9639	18200.0
2014-03-20 08:25:00	AAPL	Stock	18.9357	18.9357	18.9357	18.9357	5600.0
2014-03-20 08:30:00	AAPL	Stock	18.9375	18.9571	18.9286	18.9286	85932.0
2014-03-20 08:35:00	AAPL	Stock	18.925	18.9286	18.925	18.9286	10080.0
2014-03-20 08:55:00	AAPL	Stock	18.9393	18.9393	18.9393	18.9393	2800.0
2014-03-20 09:00:00	AAPL	Stock	18.9464	18.9571	18.9204	18.9307	181188.0
2014-03-20 09:05:00	AAPL	Stock	18.9268	18.9393	18.9268	18.9393	7588.0
2014-03-20 09:10:00	AAPL	Stock	18.9428	18.9428	18.9286	18.9286	28000.0
2014-03-20 09:15:00	AAPL	Stock	18.9286	18.9293	18.9286	18.9293	46172.0
2014-03-20 09:20:00	AAPL	Stock	18.9429	18.9429	18.9286	18.9286	19600.0
2014-03-20 09:25:00	AAPL	Stock	18.9296	18.9436	18.9096	18.9229	486444.0
2014-03-20 09:30:00	AAPL	Stock	18.9246	19.0239	18.9089	18.9943	11828152.0
2014-03-20 09:35:00	AAPL	Stock	18.9925	18.9946	18.9543	18.9671	4526032.0
2014-03-20 09:40:00	AAPL	Stock	18.9661	18.975	18.9021	18.9179	4838400.0
2014-03-20 09:45:00	AAPL	Stock	18.9193	18.9225	18.8725	18.8811	3772720.0
2014-03-20 09:50:00	AAPL	Stock	18.8811	18.8846	18.8446	18.87	6227816.0
2014-03-20 09:55:00	AAPL	Stock	18.8664	18.9121	18.8664	18.9107	4245388.0
2014-03-20 10:00:00	AAPL	Stock	18.91	18.9196	18.8721	18.8804	3045504.0
2014-03-20 10:05:00	AAPL	Stock	18.88	18.9393	18.8782	18.9282	3284596.0
2014-03-20 10:10:00	AAPL	Stock	18.9264	18.9539	18.9161	18.9393	3285660.0
2014-03-20 10:15:00	AAPL	Stock	18.9371	18.9711	18.9332	18.9396	3094700.0
2014-03-20 10:20:00	AAPL	Stock	18.9379	18.9593	18.9314	18.9436	1787968.0
2014-03-20 10:25:00	AAPL	Stock	18.9411	18.9571	18.9289	18.9304	1845284.0
2014-03-20 10:30:00	AAPL	Stock	18.9332	18.9475	18.9293	18.9329	1157044.0
2014-03-20 10:35:00	AAPL	Stock	18.9329	18.9344	18.88	18.8832	3488016.0
2014-03-20 10:40:00	AAPL	Stock	18.8871	18.9079	18.875	18.9004	2342620.0
2014-03-20 10:45:00	AAPL	Stock	18.8986	18.9107	18.8929	18.8979	1215788.0
2014-03-20 10:50:00	AAPL	Stock	18.895	18.9061	18.8754	18.89	1985368.0
2014-03-20 10:55:00	AAPL	Stock	18.8868	18.8979	18.875	18.8889	1396724.0
2014-03-20 11:00:00	AAPL	Stock	18.8882	18.9025	18.875	18.8886	1486072.0
2014-03-20 11:05:00	AAPL	Stock	18.8891	18.8925	18.8721	18.8779	1703100.0
2014-03-20 11:10:00	AAPL	Stock	18.88	18.8804	18.8564	18.8679	2696680.0
2014-03-20 11:15:00	AAPL	Stock	18.8689	18.8793	18.8607	18.8614	1636936.0
2014-03-20 11:20:00	AAPL	Stock	18.8629	18.8746	18.845	18.8571	1989792.0
2014-03-20 11:25:00	AAPL	Stock	18.86	18.8868	18.86	18.8761	1921080.0
2014-03-20 11:30:00	AAPL	Stock	18.8768	18.8768	18.8339	18.8439	2704520.0
2014-03-20 11:35:00	AAPL	Stock	18.8496	18.8611	18.8375	18.8482	1566124.0

> showing 50 of 361,195 rows — these rows as CSV

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