PREVIEW / stock_5min / 2013-08-26

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-08-26.parquet
  size:    5.1 MB
  rows:    338,243
  symbols: 3,527

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
2013-08-26 04:00:00	AAPL	Stock	17.9971	17.9982	17.9893	17.9893	22400.0
2013-08-26 04:15:00	AAPL	Stock	17.9864	17.9864	17.9864	17.9864	7756.0
2013-08-26 04:30:00	AAPL	Stock	17.9618	17.9618	17.9618	17.9618	5600.0
2013-08-26 05:10:00	AAPL	Stock	17.9643	17.9643	17.9643	17.9643	14000.0
2013-08-26 05:50:00	AAPL	Stock	17.9561	17.9561	17.9561	17.9561	2800.0
2013-08-26 06:00:00	AAPL	Stock	17.9561	17.9561	17.9561	17.9561	2800.0
2013-08-26 06:50:00	AAPL	Stock	17.9411	17.9411	17.9411	17.9411	2800.0
2013-08-26 07:05:00	AAPL	Stock	17.9411	17.9411	17.9411	17.9411	5600.0
2013-08-26 07:20:00	AAPL	Stock	17.9361	17.9361	17.9361	17.9361	2800.0
2013-08-26 07:30:00	AAPL	Stock	17.9321	17.9321	17.9286	17.9286	7588.0
2013-08-26 07:35:00	AAPL	Stock	17.9286	17.9286	17.9286	17.9286	2800.0
2013-08-26 07:40:00	AAPL	Stock	17.9271	17.9275	17.9271	17.9275	5600.0
2013-08-26 07:45:00	AAPL	Stock	17.9196	17.9196	17.9107	17.9125	67760.0
2013-08-26 07:50:00	AAPL	Stock	17.9125	17.9268	17.9107	17.9261	41440.0
2013-08-26 07:55:00	AAPL	Stock	17.9189	17.9189	17.9071	17.9175	150360.0
2013-08-26 08:00:00	AAPL	Stock	17.9429	17.9429	17.8882	17.9068	292572.0
2013-08-26 08:05:00	AAPL	Stock	17.9075	17.9125	17.8968	17.9007	40320.0
2013-08-26 08:10:00	AAPL	Stock	17.9007	17.9154	17.9	17.9154	58800.0
2013-08-26 08:15:00	AAPL	Stock	17.9175	17.9261	17.9071	17.9143	130200.0
2013-08-26 08:20:00	AAPL	Stock	17.9239	17.9261	17.9171	17.9171	86688.0
2013-08-26 08:25:00	AAPL	Stock	17.9125	17.9125	17.9125	17.9125	13748.0
2013-08-26 08:30:00	AAPL	Stock	17.9107	17.92	17.9071	17.9157	126084.0
2013-08-26 08:35:00	AAPL	Stock	17.9125	17.9286	17.9111	17.9214	152628.0
2013-08-26 08:40:00	AAPL	Stock	17.9146	17.9179	17.9129	17.9179	28000.0
2013-08-26 08:45:00	AAPL	Stock	17.9171	17.9207	17.9107	17.9107	92708.0
2013-08-26 08:50:00	AAPL	Stock	17.9018	17.9136	17.9018	17.9136	19600.0
2013-08-26 08:55:00	AAPL	Stock	17.9161	17.9161	17.9043	17.9043	41720.0
2013-08-26 09:00:00	AAPL	Stock	17.9107	17.9107	17.9057	17.9071	30072.0
2013-08-26 09:05:00	AAPL	Stock	17.9093	17.9093	17.9004	17.9004	46144.0
2013-08-26 09:10:00	AAPL	Stock	17.9011	17.9025	17.8996	17.9025	15064.0
2013-08-26 09:15:00	AAPL	Stock	17.9036	17.9157	17.9021	17.9025	46200.0
2013-08-26 09:20:00	AAPL	Stock	17.9096	17.9146	17.9071	17.9107	83048.0
2013-08-26 09:25:00	AAPL	Stock	17.9182	17.9182	17.8839	17.885	191800.0
2013-08-26 09:30:00	AAPL	Stock	17.8875	18.0204	17.875	18.0007	18599196.0
2013-08-26 09:35:00	AAPL	Stock	18.0039	18.0229	17.9682	18.0229	8541652.0
2013-08-26 09:40:00	AAPL	Stock	18.0211	18.0486	18.0015	18.0418	8566124.0
2013-08-26 09:45:00	AAPL	Stock	18.0418	18.067	18.0321	18.0491	6406344.0
2013-08-26 09:50:00	AAPL	Stock	18.0518	18.0536	18.02	18.0239	5672940.0
2013-08-26 09:55:00	AAPL	Stock	18.0212	18.0314	17.9882	18.0279	5576480.0
2013-08-26 10:00:00	AAPL	Stock	18.0279	18.0321	18.0068	18.0068	2811564.0
2013-08-26 10:05:00	AAPL	Stock	18.0071	18.0164	17.9871	18.0111	7318444.0
2013-08-26 10:10:00	AAPL	Stock	18.0125	18.0196	17.9968	18.0089	4161248.0
2013-08-26 10:15:00	AAPL	Stock	18.0107	18.0346	18.0061	18.0275	3102904.0
2013-08-26 10:20:00	AAPL	Stock	18.0279	18.0432	18.0179	18.0321	3630480.0
2013-08-26 10:25:00	AAPL	Stock	18.0332	18.0514	18.0264	18.035	3345888.0
2013-08-26 10:30:00	AAPL	Stock	18.0379	18.0493	18.0254	18.0275	2923368.0
2013-08-26 10:35:00	AAPL	Stock	18.0264	18.0393	18.0221	18.0361	2056992.0
2013-08-26 10:40:00	AAPL	Stock	18.0379	18.0393	18.0193	18.0311	1600340.0
2013-08-26 10:45:00	AAPL	Stock	18.0307	18.0429	18.0271	18.0421	1630412.0
2013-08-26 10:50:00	AAPL	Stock	18.0421	18.0464	18.0329	18.0414	1791076.0

> showing 50 of 338,243 rows — these rows as CSV

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