PREVIEW / stock_5min / 2011-03-01

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-03-01.parquet
  size:    5.1 MB
  rows:    343,020
  symbols: 3,536

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-03-01 04:00:00	AAPL	Stock	12.6793	12.7054	12.6793	12.7054	5600.0
2011-03-01 04:40:00	AAPL	Stock	12.7179	12.7179	12.7179	12.7179	2800.0
2011-03-01 05:05:00	AAPL	Stock	12.6964	12.6964	12.6964	12.6964	5600.0
2011-03-01 05:10:00	AAPL	Stock	12.6964	12.6964	12.6964	12.6964	14000.0
2011-03-01 05:15:00	AAPL	Stock	12.6964	12.6964	12.6964	12.6964	2800.0
2011-03-01 06:15:00	AAPL	Stock	12.7111	12.7139	12.7111	12.7139	5600.0
2011-03-01 06:25:00	AAPL	Stock	12.6954	12.6954	12.6786	12.6786	41440.0
2011-03-01 06:35:00	AAPL	Stock	12.6782	12.6786	12.6782	12.6786	5600.0
2011-03-01 06:40:00	AAPL	Stock	12.6782	12.6786	12.6782	12.6786	14140.0
2011-03-01 06:50:00	AAPL	Stock	12.6786	12.6786	12.6786	12.6786	2800.0
2011-03-01 07:00:00	AAPL	Stock	12.6936	12.6936	12.675	12.675	27580.0
2011-03-01 07:05:00	AAPL	Stock	12.6786	12.6893	12.6786	12.6786	38024.0
2011-03-01 07:10:00	AAPL	Stock	12.6757	12.6757	12.6607	12.6607	72800.0
2011-03-01 07:15:00	AAPL	Stock	12.6511	12.6511	12.6482	12.6482	28000.0
2011-03-01 07:20:00	AAPL	Stock	12.6607	12.6607	12.6504	12.6504	11200.0
2011-03-01 07:25:00	AAPL	Stock	12.6496	12.6504	12.6304	12.6375	82768.0
2011-03-01 07:30:00	AAPL	Stock	12.6375	12.6375	12.6375	12.6375	14392.0
2011-03-01 07:35:00	AAPL	Stock	12.6375	12.6375	12.6371	12.6375	50400.0
2011-03-01 07:40:00	AAPL	Stock	12.6329	12.6329	12.6254	12.6318	36400.0
2011-03-01 07:45:00	AAPL	Stock	12.6375	12.6429	12.6375	12.6429	39592.0
2011-03-01 07:50:00	AAPL	Stock	12.6593	12.6593	12.6593	12.6593	2800.0
2011-03-01 07:55:00	AAPL	Stock	12.6593	12.6593	12.6536	12.6536	35280.0
2011-03-01 08:00:00	AAPL	Stock	12.6536	12.6964	12.6532	12.6604	306992.0
2011-03-01 08:05:00	AAPL	Stock	12.6486	12.6571	12.6464	12.6571	78568.0
2011-03-01 08:10:00	AAPL	Stock	12.6579	12.6589	12.6521	12.6571	106400.0
2011-03-01 08:15:00	AAPL	Stock	12.6571	12.6571	12.6521	12.6521	118972.0
2011-03-01 08:20:00	AAPL	Stock	12.6518	12.6554	12.6518	12.6554	26880.0
2011-03-01 08:25:00	AAPL	Stock	12.6568	12.6625	12.6554	12.6625	142828.0
2011-03-01 08:30:00	AAPL	Stock	12.6618	12.6618	12.6554	12.66	37212.0
2011-03-01 08:35:00	AAPL	Stock	12.6557	12.6621	12.6557	12.66	70728.0
2011-03-01 08:40:00	AAPL	Stock	12.6596	12.6618	12.6596	12.6607	54040.0
2011-03-01 08:45:00	AAPL	Stock	12.6607	12.6618	12.6579	12.6604	43400.0
2011-03-01 08:50:00	AAPL	Stock	12.6604	12.6614	12.6604	12.6604	74200.0
2011-03-01 08:55:00	AAPL	Stock	12.6604	12.6661	12.6586	12.6661	156688.0
2011-03-01 09:00:00	AAPL	Stock	12.6664	12.6811	12.6146	12.6764	421792.0
2011-03-01 09:05:00	AAPL	Stock	12.675	12.6757	12.6607	12.6607	194432.0
2011-03-01 09:10:00	AAPL	Stock	12.6607	12.6739	12.6593	12.6732	142884.0
2011-03-01 09:15:00	AAPL	Stock	12.6711	12.6732	12.6664	12.6732	101584.0
2011-03-01 09:20:00	AAPL	Stock	12.6725	12.6736	12.6696	12.6736	135800.0
2011-03-01 09:25:00	AAPL	Stock	12.6746	12.6954	12.6607	12.6954	767200.0
2011-03-01 09:30:00	AAPL	Stock	12.6964	12.7043	12.6329	12.652	12246164.0
2011-03-01 09:35:00	AAPL	Stock	12.6489	12.6493	12.6154	12.6371	10987340.0
2011-03-01 09:40:00	AAPL	Stock	12.6334	12.6375	12.5889	12.5968	11537792.0
2011-03-01 09:45:00	AAPL	Stock	12.5979	12.625	12.5714	12.6204	10973816.0
2011-03-01 09:50:00	AAPL	Stock	12.6193	12.625	12.5971	12.6189	5926676.0
2011-03-01 09:55:00	AAPL	Stock	12.6172	12.6321	12.6014	12.6207	5774440.0
2011-03-01 10:00:00	AAPL	Stock	12.6257	12.6339	12.5936	12.6029	7163156.0
2011-03-01 10:05:00	AAPL	Stock	12.6036	12.606	12.5646	12.5937	10447528.0
2011-03-01 10:10:00	AAPL	Stock	12.5928	12.5966	12.5793	12.5954	4258996.0
2011-03-01 10:15:00	AAPL	Stock	12.5954	12.6243	12.5775	12.5786	9056180.0

> showing 50 of 343,020 rows — these rows as CSV

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