PREVIEW / stock_5min / 2012-03-27

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-03-27.parquet
  size:    4.9 MB
  rows:    333,200
  symbols: 3,524

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
2012-03-27 04:15:00	AAPL	Stock	21.6879	21.6961	21.6879	21.6961	5600.0
2012-03-27 04:35:00	AAPL	Stock	21.6829	21.6829	21.6829	21.6829	8400.0
2012-03-27 04:40:00	AAPL	Stock	21.6786	21.6786	21.6786	21.6786	36568.0
2012-03-27 04:50:00	AAPL	Stock	21.6696	21.6696	21.6696	21.6696	14000.0
2012-03-27 04:55:00	AAPL	Stock	21.6682	21.6682	21.6679	21.6679	5600.0
2012-03-27 05:00:00	AAPL	Stock	21.6779	21.6779	21.6779	21.6779	2800.0
2012-03-27 05:10:00	AAPL	Stock	21.6929	21.6964	21.6875	21.6964	53200.0
2012-03-27 05:20:00	AAPL	Stock	21.6864	21.6864	21.6786	21.6786	33600.0
2012-03-27 05:35:00	AAPL	Stock	21.6679	21.6679	21.6679	21.6679	35000.0
2012-03-27 05:40:00	AAPL	Stock	21.6682	21.6682	21.6679	21.6679	14000.0
2012-03-27 06:00:00	AAPL	Stock	21.6679	21.6964	21.6679	21.6964	60060.0
2012-03-27 06:35:00	AAPL	Stock	21.6786	21.6786	21.6786	21.6786	7756.0
2012-03-27 06:45:00	AAPL	Stock	21.6782	21.6789	21.6782	21.6789	24920.0
2012-03-27 06:50:00	AAPL	Stock	21.6786	21.6786	21.6714	21.6714	5600.0
2012-03-27 07:00:00	AAPL	Stock	21.6782	21.6782	21.6589	21.6589	37408.0
2012-03-27 07:05:00	AAPL	Stock	21.6596	21.665	21.6596	21.665	28000.0
2012-03-27 07:10:00	AAPL	Stock	21.6657	21.6657	21.6607	21.6639	11200.0
2012-03-27 07:15:00	AAPL	Stock	21.6607	21.6707	21.6554	21.6707	78680.0
2012-03-27 07:20:00	AAPL	Stock	21.6707	21.6707	21.6707	21.6707	2800.0
2012-03-27 07:30:00	AAPL	Stock	21.6707	21.6707	21.6707	21.6707	5180.0
2012-03-27 07:40:00	AAPL	Stock	21.6536	21.6536	21.64	21.64	42840.0
2012-03-27 07:45:00	AAPL	Stock	21.6429	21.6561	21.6429	21.6561	14000.0
2012-03-27 07:50:00	AAPL	Stock	21.6432	21.6432	21.6232	21.6286	90832.0
2012-03-27 07:55:00	AAPL	Stock	21.6286	21.6389	21.595	21.6179	341964.0
2012-03-27 08:00:00	AAPL	Stock	21.6071	21.6743	21.6036	21.6286	404600.0
2012-03-27 08:05:00	AAPL	Stock	21.635	21.6429	21.615	21.6429	377888.0
2012-03-27 08:10:00	AAPL	Stock	21.6429	21.6561	21.6429	21.65	291872.0
2012-03-27 08:15:00	AAPL	Stock	21.645	21.645	21.6357	21.6364	159376.0
2012-03-27 08:20:00	AAPL	Stock	21.6361	21.6368	21.6214	21.6339	167300.0
2012-03-27 08:25:00	AAPL	Stock	21.6339	21.6421	21.6321	21.6357	58800.0
2012-03-27 08:30:00	AAPL	Stock	21.6425	21.6536	21.6421	21.6514	173236.0
2012-03-27 08:35:00	AAPL	Stock	21.6493	21.6682	21.6464	21.6554	371952.0
2012-03-27 08:40:00	AAPL	Stock	21.6557	21.6607	21.6536	21.6575	207536.0
2012-03-27 08:45:00	AAPL	Stock	21.6568	21.6721	21.6539	21.6721	175448.0
2012-03-27 08:50:00	AAPL	Stock	21.675	21.675	21.6596	21.6596	503664.0
2012-03-27 08:55:00	AAPL	Stock	21.6596	21.6621	21.6482	21.65	146300.0
2012-03-27 09:00:00	AAPL	Stock	21.6518	21.6621	21.6486	21.655	183624.0
2012-03-27 09:05:00	AAPL	Stock	21.655	21.6568	21.65	21.6507	282296.0
2012-03-27 09:10:00	AAPL	Stock	21.6504	21.6579	21.6429	21.6579	634508.0
2012-03-27 09:15:00	AAPL	Stock	21.6564	21.6564	21.6429	21.6446	86240.0
2012-03-27 09:20:00	AAPL	Stock	21.6436	21.6436	21.6311	21.6429	158340.0
2012-03-27 09:25:00	AAPL	Stock	21.6439	21.67	21.6411	21.6496	745584.0
2012-03-27 09:30:00	AAPL	Stock	21.6493	21.7604	21.645	21.7525	27956236.0
2012-03-27 09:35:00	AAPL	Stock	21.7527	21.7764	21.7411	21.7615	21708848.0
2012-03-27 09:40:00	AAPL	Stock	21.7623	21.8168	21.7461	21.815	25853912.0
2012-03-27 09:45:00	AAPL	Stock	21.8143	21.8696	21.6671	21.8457	22364916.0
2012-03-27 09:50:00	AAPL	Stock	21.8493	21.9011	21.6671	21.8721	17368036.0
2012-03-27 09:55:00	AAPL	Stock	21.8679	21.9071	21.8157	21.8354	18353804.0
2012-03-27 10:00:00	AAPL	Stock	21.8371	21.8657	21.8146	21.8471	13099044.0
2012-03-27 10:05:00	AAPL	Stock	21.8489	21.8771	21.8421	21.8682	8737176.0

> showing 50 of 333,200 rows — these rows as CSV

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