PREVIEW / stock_5min / 2014-04-23

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-23.parquet
  size:    5.3 MB
  rows:    357,512
  symbols: 3,549

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-04-23 05:15:00	AAPL	Stock	18.975	18.975	18.975	18.975	3948.0
2014-04-23 07:00:00	AAPL	Stock	18.9804	18.9804	18.9786	18.9786	19600.0
2014-04-23 07:05:00	AAPL	Stock	18.9875	18.9875	18.9786	18.9839	11200.0
2014-04-23 07:15:00	AAPL	Stock	18.9839	18.9839	18.9821	18.9821	8400.0
2014-04-23 07:20:00	AAPL	Stock	18.9679	18.9764	18.9679	18.9764	5600.0
2014-04-23 07:25:00	AAPL	Stock	18.9804	18.9804	18.9804	18.9804	5600.0
2014-04-23 07:30:00	AAPL	Stock	18.9732	18.9732	18.9732	18.9732	2800.0
2014-04-23 07:35:00	AAPL	Stock	18.9643	18.9643	18.9643	18.9643	2800.0
2014-04-23 07:45:00	AAPL	Stock	18.975	18.975	18.975	18.975	18312.0
2014-04-23 07:55:00	AAPL	Stock	18.9454	18.9454	18.9204	18.9214	39200.0
2014-04-23 08:00:00	AAPL	Stock	18.9196	18.9821	18.9196	18.9764	73080.0
2014-04-23 08:05:00	AAPL	Stock	18.9464	18.9464	18.9321	18.9321	11200.0
2014-04-23 08:10:00	AAPL	Stock	18.9411	18.9493	18.9411	18.9493	16800.0
2014-04-23 08:15:00	AAPL	Stock	18.9357	18.9357	18.9214	18.9286	114408.0
2014-04-23 08:20:00	AAPL	Stock	18.9286	18.9286	18.9214	18.9214	50708.0
2014-04-23 08:25:00	AAPL	Stock	18.925	18.9286	18.9107	18.9196	65324.0
2014-04-23 08:30:00	AAPL	Stock	18.9125	18.9286	18.9107	18.9264	45696.0
2014-04-23 08:40:00	AAPL	Stock	18.9532	18.9532	18.9532	18.9532	7000.0
2014-04-23 08:45:00	AAPL	Stock	18.9375	18.9464	18.9375	18.9464	28504.0
2014-04-23 08:50:00	AAPL	Stock	18.9379	18.9379	18.9379	18.9379	2800.0
2014-04-23 09:00:00	AAPL	Stock	18.9364	18.9364	18.9307	18.9307	41692.0
2014-04-23 09:10:00	AAPL	Stock	18.935	18.9357	18.9286	18.9296	21560.0
2014-04-23 09:15:00	AAPL	Stock	18.9289	18.9307	18.9289	18.9307	5600.0
2014-04-23 09:20:00	AAPL	Stock	18.9307	18.9307	18.9286	18.9307	40488.0
2014-04-23 09:25:00	AAPL	Stock	18.9243	18.925	18.8893	18.8979	253708.0
2014-04-23 09:30:00	AAPL	Stock	18.895	18.9082	18.8482	18.895	9559452.0
2014-04-23 09:35:00	AAPL	Stock	18.8932	18.8939	18.8661	18.8779	3293248.0
2014-04-23 09:40:00	AAPL	Stock	18.8779	18.9514	18.8675	18.9507	5376644.0
2014-04-23 09:45:00	AAPL	Stock	18.9518	18.9554	18.9211	18.9301	4150216.0
2014-04-23 09:50:00	AAPL	Stock	18.9287	18.9643	18.9246	18.9634	3544212.0
2014-04-23 09:55:00	AAPL	Stock	18.9639	18.9689	18.9043	18.9193	4007276.0
2014-04-23 10:00:00	AAPL	Stock	18.9171	18.9193	18.8607	18.8629	4709992.0
2014-04-23 10:05:00	AAPL	Stock	18.8632	18.89	18.8614	18.8843	2997792.0
2014-04-23 10:10:00	AAPL	Stock	18.8832	18.8996	18.8682	18.8811	1959328.0
2014-04-23 10:15:00	AAPL	Stock	18.875	18.8954	18.8668	18.8786	2231208.0
2014-04-23 10:20:00	AAPL	Stock	18.8793	18.9018	18.8793	18.8976	2114476.0
2014-04-23 10:25:00	AAPL	Stock	18.8975	18.9104	18.8832	18.8964	2001104.0
2014-04-23 10:30:00	AAPL	Stock	18.8982	18.8982	18.875	18.8807	1800624.0
2014-04-23 10:35:00	AAPL	Stock	18.8784	18.9219	18.8775	18.9132	2521960.0
2014-04-23 10:40:00	AAPL	Stock	18.9129	18.9221	18.8993	18.9057	1789676.0
2014-04-23 10:45:00	AAPL	Stock	18.9057	18.9189	18.8968	18.9157	2441040.0
2014-04-23 10:50:00	AAPL	Stock	18.9154	18.9182	18.8969	18.9068	2331392.0
2014-04-23 10:55:00	AAPL	Stock	18.9061	18.9132	18.8982	18.9046	1557276.0
2014-04-23 11:00:00	AAPL	Stock	18.9046	18.9153	18.8907	18.9146	2862916.0
2014-04-23 11:05:00	AAPL	Stock	18.9139	18.9164	18.9006	18.9064	1630384.0
2014-04-23 11:10:00	AAPL	Stock	18.9061	18.9061	18.8736	18.8814	2808792.0
2014-04-23 11:15:00	AAPL	Stock	18.8836	18.8996	18.8771	18.8893	2515772.0
2014-04-23 11:20:00	AAPL	Stock	18.8893	18.8975	18.8832	18.8875	1631056.0
2014-04-23 11:25:00	AAPL	Stock	18.8877	18.8939	18.8768	18.8904	2098992.0
2014-04-23 11:30:00	AAPL	Stock	18.8889	18.8989	18.8839	18.8875	1821960.0

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

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