PREVIEW / stock_5min / 2011-09-30

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-30.parquet
  size:    4.9 MB
  rows:    329,738
  symbols: 3,520

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-30 04:00:00	AAPL	Stock	13.9932	13.9932	13.9325	13.9325	5600.0
2011-09-30 04:30:00	AAPL	Stock	13.9071	13.9071	13.9071	13.9071	2800.0
2011-09-30 05:10:00	AAPL	Stock	13.8518	13.8518	13.8393	13.8393	5600.0
2011-09-30 05:20:00	AAPL	Stock	13.8536	13.8536	13.8536	13.8536	2800.0
2011-09-30 05:30:00	AAPL	Stock	13.8536	13.8536	13.8536	13.8536	2800.0
2011-09-30 05:40:00	AAPL	Stock	13.8661	13.8661	13.8661	13.8661	2800.0
2011-09-30 05:45:00	AAPL	Stock	13.865	13.865	13.865	13.865	2800.0
2011-09-30 06:00:00	AAPL	Stock	13.8468	13.8468	13.8468	13.8468	4172.0
2011-09-30 06:10:00	AAPL	Stock	13.8714	13.8714	13.8714	13.8714	5600.0
2011-09-30 06:20:00	AAPL	Stock	13.8525	13.8525	13.8286	13.8286	11200.0
2011-09-30 06:25:00	AAPL	Stock	13.8254	13.83	13.8254	13.83	8400.0
2011-09-30 06:45:00	AAPL	Stock	13.8357	13.8357	13.8357	13.8357	2800.0
2011-09-30 06:50:00	AAPL	Stock	13.8196	13.8196	13.8171	13.8171	5600.0
2011-09-30 07:00:00	AAPL	Stock	13.8393	13.8639	13.8393	13.8639	23800.0
2011-09-30 07:05:00	AAPL	Stock	13.8639	13.8639	13.8393	13.8393	62440.0
2011-09-30 07:10:00	AAPL	Stock	13.8311	13.8429	13.8275	13.8429	62440.0
2011-09-30 07:15:00	AAPL	Stock	13.8393	13.8407	13.8304	13.8304	96740.0
2011-09-30 07:20:00	AAPL	Stock	13.8393	13.8557	13.8393	13.8557	11200.0
2011-09-30 07:25:00	AAPL	Stock	13.8554	13.8554	13.8393	13.8393	80360.0
2011-09-30 07:30:00	AAPL	Stock	13.8286	13.8396	13.8286	13.8396	14700.0
2011-09-30 07:35:00	AAPL	Stock	13.8393	13.8571	13.8393	13.8571	58800.0
2011-09-30 07:40:00	AAPL	Stock	13.8571	13.8607	13.8504	13.8504	119336.0
2011-09-30 07:45:00	AAPL	Stock	13.8604	13.8643	13.8557	13.8571	119700.0
2011-09-30 07:50:00	AAPL	Stock	13.8571	13.8571	13.85	13.85	33600.0
2011-09-30 07:55:00	AAPL	Stock	13.8489	13.8489	13.8393	13.8393	13440.0
2011-09-30 08:00:00	AAPL	Stock	13.8525	13.8893	13.8461	13.8693	431396.0
2011-09-30 08:05:00	AAPL	Stock	13.8661	13.9096	13.865	13.9	214928.0
2011-09-30 08:10:00	AAPL	Stock	13.9007	13.9196	13.8886	13.8996	170324.0
2011-09-30 08:15:00	AAPL	Stock	13.8886	13.9104	13.8796	13.9032	119868.0
2011-09-30 08:20:00	AAPL	Stock	13.8929	13.9089	13.8886	13.9029	65856.0
2011-09-30 08:25:00	AAPL	Stock	13.8975	13.9061	13.8936	13.9018	98280.0
2011-09-30 08:30:00	AAPL	Stock	13.8982	13.9121	13.8886	13.9086	246932.0
2011-09-30 08:35:00	AAPL	Stock	13.9075	13.9075	13.8721	13.8839	153748.0
2011-09-30 08:40:00	AAPL	Stock	13.8793	13.8804	13.8679	13.8714	123564.0
2011-09-30 08:45:00	AAPL	Stock	13.875	13.875	13.8429	13.8514	320460.0
2011-09-30 08:50:00	AAPL	Stock	13.8511	13.8571	13.8393	13.8518	378252.0
2011-09-30 08:55:00	AAPL	Stock	13.8493	13.8493	13.8325	13.8393	269472.0
2011-09-30 09:00:00	AAPL	Stock	13.8339	13.8393	13.8271	13.8393	160664.0
2011-09-30 09:05:00	AAPL	Stock	13.8393	13.8393	13.8	13.8064	398272.0
2011-09-30 09:10:00	AAPL	Stock	13.8036	13.8393	13.8036	13.8286	289884.0
2011-09-30 09:15:00	AAPL	Stock	13.8304	13.8357	13.8257	13.8261	128576.0
2011-09-30 09:20:00	AAPL	Stock	13.8289	13.8329	13.8236	13.8236	46200.0
2011-09-30 09:25:00	AAPL	Stock	13.8346	13.8346	13.8236	13.8243	124376.0
2011-09-30 09:30:00	AAPL	Stock	13.8277	13.835	13.7232	13.7821	28643356.0
2011-09-30 09:35:00	AAPL	Stock	13.7857	13.8132	13.6964	13.7154	16327220.0
2011-09-30 09:40:00	AAPL	Stock	13.7111	13.8029	13.6943	13.7664	15432228.0
2011-09-30 09:45:00	AAPL	Stock	13.7632	13.7896	13.6504	13.6768	17009412.0
2011-09-30 09:50:00	AAPL	Stock	13.6757	13.75	13.6539	13.7286	12371380.0
2011-09-30 09:55:00	AAPL	Stock	13.735	13.7611	13.6893	13.7039	11399164.0
2011-09-30 10:00:00	AAPL	Stock	13.7039	13.7771	13.6789	13.7454	12097372.0

> showing 50 of 329,738 rows — these rows as CSV

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