PREVIEW / stock_5min / 2011-06-08

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-08.parquet
  size:    4.9 MB
  rows:    333,739
  symbols: 3,570

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-06-08 04:00:00	AAPL	Stock	11.8464	11.8464	11.7729	11.7729	8540.0
2011-06-08 04:15:00	AAPL	Stock	11.8107	11.8107	11.8107	11.8107	5600.0
2011-06-08 04:50:00	AAPL	Stock	11.7857	11.7857	11.7857	11.7857	2800.0
2011-06-08 05:05:00	AAPL	Stock	11.7857	11.7857	11.7857	11.7857	2800.0
2011-06-08 05:10:00	AAPL	Stock	11.7857	11.7857	11.7857	11.7857	11200.0
2011-06-08 05:15:00	AAPL	Stock	11.7857	11.7857	11.7857	11.7857	2800.0
2011-06-08 05:25:00	AAPL	Stock	11.7843	11.7843	11.7843	11.7843	2800.0
2011-06-08 05:45:00	AAPL	Stock	11.8039	11.8039	11.8036	11.8036	5600.0
2011-06-08 05:50:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	2800.0
2011-06-08 06:00:00	AAPL	Stock	11.8061	11.8061	11.8061	11.8061	2800.0
2011-06-08 06:05:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	22400.0
2011-06-08 06:10:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	28000.0
2011-06-08 06:25:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	50400.0
2011-06-08 06:30:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	5600.0
2011-06-08 06:35:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	5600.0
2011-06-08 06:40:00	AAPL	Stock	11.8036	11.8036	11.8036	11.8036	14000.0
2011-06-08 06:45:00	AAPL	Stock	11.7918	11.7918	11.7918	11.7918	2800.0
2011-06-08 07:00:00	AAPL	Stock	11.8	11.8332	11.8	11.8268	368116.0
2011-06-08 07:05:00	AAPL	Stock	11.8121	11.8304	11.8036	11.8304	61600.0
2011-06-08 07:10:00	AAPL	Stock	11.82	11.8214	11.82	11.8214	14000.0
2011-06-08 07:15:00	AAPL	Stock	11.8336	11.8357	11.825	11.83	28000.0
2011-06-08 07:20:00	AAPL	Stock	11.8393	11.8429	11.8286	11.8429	30800.0
2011-06-08 07:25:00	AAPL	Stock	11.8393	11.8393	11.8389	11.8393	14000.0
2011-06-08 07:30:00	AAPL	Stock	11.8393	11.8393	11.8393	11.8393	2800.0
2011-06-08 07:35:00	AAPL	Stock	11.8357	11.8389	11.8304	11.8325	25200.0
2011-06-08 07:40:00	AAPL	Stock	11.8279	11.8304	11.8236	11.8236	42000.0
2011-06-08 07:45:00	AAPL	Stock	11.8221	11.8221	11.8214	11.8214	84000.0
2011-06-08 07:50:00	AAPL	Stock	11.8196	11.8214	11.8132	11.8132	26544.0
2011-06-08 07:55:00	AAPL	Stock	11.815	11.8214	11.815	11.8214	58800.0
2011-06-08 08:00:00	AAPL	Stock	11.8168	11.8304	11.8036	11.8036	202888.0
2011-06-08 08:05:00	AAPL	Stock	11.8046	11.8214	11.8036	11.8211	209440.0
2011-06-08 08:10:00	AAPL	Stock	11.8214	11.8214	11.8043	11.8043	96320.0
2011-06-08 08:15:00	AAPL	Stock	11.8043	11.8086	11.7961	11.8039	125468.0
2011-06-08 08:20:00	AAPL	Stock	11.8071	11.8196	11.8071	11.8161	34664.0
2011-06-08 08:25:00	AAPL	Stock	11.8207	11.8286	11.8164	11.8286	150500.0
2011-06-08 08:35:00	AAPL	Stock	11.8132	11.8207	11.81	11.8121	45612.0
2011-06-08 08:40:00	AAPL	Stock	11.8125	11.8286	11.8125	11.8239	51492.0
2011-06-08 08:45:00	AAPL	Stock	11.8268	11.8511	11.8264	11.8511	98000.0
2011-06-08 08:50:00	AAPL	Stock	11.8521	11.875	11.8521	11.8682	320908.0
2011-06-08 08:55:00	AAPL	Stock	11.8714	11.875	11.8482	11.8554	460488.0
2011-06-08 09:00:00	AAPL	Stock	11.8536	11.8586	11.8393	11.8454	209524.0
2011-06-08 09:05:00	AAPL	Stock	11.8411	11.8536	11.8411	11.8536	193760.0
2011-06-08 09:10:00	AAPL	Stock	11.8568	11.8707	11.8568	11.8661	254520.0
2011-06-08 09:15:00	AAPL	Stock	11.8604	11.8693	11.86	11.8607	65128.0
2011-06-08 09:20:00	AAPL	Stock	11.8671	11.8689	11.8611	11.8611	29372.0
2011-06-08 09:25:00	AAPL	Stock	11.8607	11.8643	11.85	11.8518	505232.0
2011-06-08 09:30:00	AAPL	Stock	11.8518	11.9061	11.8407	11.8614	16310280.0
2011-06-08 09:35:00	AAPL	Stock	11.8614	11.9236	11.8471	11.9125	12417300.0
2011-06-08 09:40:00	AAPL	Stock	11.9125	11.9225	11.8696	11.8696	8255352.0
2011-06-08 09:45:00	AAPL	Stock	11.8693	11.885	11.8471	11.8501	8424612.0

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

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