PREVIEW / stock_5min / 2011-09-20

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-20.parquet
  size:    4.8 MB
  rows:    323,528
  symbols: 3,518

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
2011-09-20 04:00:00	AAPL	Stock	14.6429	14.7736	14.6429	14.7736	30800.0
2011-09-20 04:05:00	AAPL	Stock	14.7704	14.7711	14.7704	14.7711	11200.0
2011-09-20 04:10:00	AAPL	Stock	14.78	14.78	14.78	14.78	5600.0
2011-09-20 04:15:00	AAPL	Stock	14.7804	14.8018	14.7804	14.8018	19600.0
2011-09-20 04:35:00	AAPL	Stock	14.7496	14.7496	14.7496	14.7496	2800.0
2011-09-20 05:00:00	AAPL	Stock	14.7796	14.7796	14.7796	14.7796	2800.0
2011-09-20 05:05:00	AAPL	Stock	14.7796	14.7796	14.7796	14.7796	5600.0
2011-09-20 05:25:00	AAPL	Stock	14.7893	14.7893	14.7893	14.7893	2800.0
2011-09-20 05:35:00	AAPL	Stock	14.8214	14.8214	14.8214	14.8214	16660.0
2011-09-20 05:40:00	AAPL	Stock	14.8214	14.8214	14.8125	14.8214	126000.0
2011-09-20 05:45:00	AAPL	Stock	14.8321	14.8321	14.8321	14.8321	14000.0
2011-09-20 05:50:00	AAPL	Stock	14.8679	14.8679	14.8654	14.8654	5600.0
2011-09-20 05:55:00	AAPL	Stock	14.8661	14.8661	14.8661	14.8661	2800.0
2011-09-20 06:05:00	AAPL	Stock	14.8661	14.8661	14.8661	14.8661	5600.0
2011-09-20 06:20:00	AAPL	Stock	14.8657	14.8657	14.8657	14.8657	8400.0
2011-09-20 06:25:00	AAPL	Stock	14.8629	14.8929	14.8629	14.875	43400.0
2011-09-20 06:45:00	AAPL	Stock	14.8668	14.8675	14.8589	14.8589	18480.0
2011-09-20 07:00:00	AAPL	Stock	14.8443	14.8586	14.8232	14.8536	125832.0
2011-09-20 07:05:00	AAPL	Stock	14.8561	14.8879	14.8411	14.8411	70000.0
2011-09-20 07:10:00	AAPL	Stock	14.8411	14.8468	14.8393	14.8446	28000.0
2011-09-20 07:15:00	AAPL	Stock	14.8482	14.8482	14.8371	14.8446	105868.0
2011-09-20 07:20:00	AAPL	Stock	14.8446	14.8482	14.8361	14.8407	142072.0
2011-09-20 07:25:00	AAPL	Stock	14.8421	14.8421	14.8304	14.8393	121380.0
2011-09-20 07:30:00	AAPL	Stock	14.8375	14.8379	14.8293	14.8343	77112.0
2011-09-20 07:35:00	AAPL	Stock	14.8314	14.8357	14.8268	14.8268	92736.0
2011-09-20 07:40:00	AAPL	Stock	14.8225	14.8286	14.8146	14.825	214592.0
2011-09-20 07:45:00	AAPL	Stock	14.82	14.845	14.82	14.8393	290640.0
2011-09-20 07:50:00	AAPL	Stock	14.8418	14.8418	14.8261	14.8268	48412.0
2011-09-20 07:55:00	AAPL	Stock	14.8329	14.8336	14.8214	14.8336	47600.0
2011-09-20 08:00:00	AAPL	Stock	14.8289	14.8361	14.8193	14.8357	622188.0
2011-09-20 08:05:00	AAPL	Stock	14.8332	14.8568	14.8304	14.8529	992096.0
2011-09-20 08:10:00	AAPL	Stock	14.8532	14.8557	14.8429	14.8429	534212.0
2011-09-20 08:15:00	AAPL	Stock	14.8482	14.85	14.8429	14.8482	134400.0
2011-09-20 08:20:00	AAPL	Stock	14.8482	14.8571	14.8468	14.8521	126140.0
2011-09-20 08:25:00	AAPL	Stock	14.8536	14.8554	14.8414	14.8532	279076.0
2011-09-20 08:30:00	AAPL	Stock	14.8536	14.8543	14.8214	14.8289	684852.0
2011-09-20 08:35:00	AAPL	Stock	14.8289	14.8432	14.8257	14.8336	367948.0
2011-09-20 08:40:00	AAPL	Stock	14.8321	14.8464	14.8318	14.8339	269276.0
2011-09-20 08:45:00	AAPL	Stock	14.8339	14.8393	14.8271	14.8343	142604.0
2011-09-20 08:50:00	AAPL	Stock	14.8311	14.8357	14.8304	14.8321	131964.0
2011-09-20 08:55:00	AAPL	Stock	14.8357	14.8393	14.8196	14.8321	453572.0
2011-09-20 09:00:00	AAPL	Stock	14.8321	14.8321	14.8082	14.8125	802928.0
2011-09-20 09:05:00	AAPL	Stock	14.8143	14.8179	14.7954	14.8036	339052.0
2011-09-20 09:10:00	AAPL	Stock	14.8029	14.8214	14.8029	14.8196	340816.0
2011-09-20 09:15:00	AAPL	Stock	14.8186	14.8214	14.7975	14.7975	356356.0
2011-09-20 09:20:00	AAPL	Stock	14.7989	14.8071	14.7929	14.7957	291256.0
2011-09-20 09:25:00	AAPL	Stock	14.7957	14.8393	14.7904	14.8339	1451520.0
2011-09-20 09:30:00	AAPL	Stock	14.8346	14.9236	14.8036	14.9007	32547396.0
2011-09-20 09:35:00	AAPL	Stock	14.8982	14.9143	14.8507	14.8679	21777448.0
2011-09-20 09:40:00	AAPL	Stock	14.8679	14.8804	14.8489	14.8803	19505164.0

> showing 50 of 323,528 rows — these rows as CSV

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