PREVIEW / stock_5min / 2011-07-07

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-07.parquet
  size:    5.0 MB
  rows:    342,398
  symbols: 3,548

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-07-07 05:20:00	AAPL	Stock	12.6089	12.6089	12.6089	12.6089	2800.0
2011-07-07 05:25:00	AAPL	Stock	12.6154	12.6154	12.6154	12.6154	2800.0
2011-07-07 06:15:00	AAPL	Stock	12.6107	12.6107	12.6107	12.6107	5600.0
2011-07-07 06:25:00	AAPL	Stock	12.6071	12.6071	12.6071	12.6071	8400.0
2011-07-07 06:50:00	AAPL	Stock	12.6046	12.6046	12.6046	12.6046	2800.0
2011-07-07 07:00:00	AAPL	Stock	12.6039	12.6039	12.5982	12.5982	5600.0
2011-07-07 07:05:00	AAPL	Stock	12.6043	12.6043	12.6043	12.6043	2800.0
2011-07-07 07:10:00	AAPL	Stock	12.5946	12.5946	12.5929	12.5929	5600.0
2011-07-07 07:15:00	AAPL	Stock	12.5893	12.5946	12.5889	12.5946	25200.0
2011-07-07 07:20:00	AAPL	Stock	12.5946	12.5946	12.5946	12.5946	8400.0
2011-07-07 07:25:00	AAPL	Stock	12.5946	12.5946	12.5889	12.5896	8400.0
2011-07-07 07:30:00	AAPL	Stock	12.5943	12.5943	12.575	12.5821	23240.0
2011-07-07 07:35:00	AAPL	Stock	12.5821	12.5821	12.5804	12.5804	11760.0
2011-07-07 07:45:00	AAPL	Stock	12.5964	12.5964	12.5964	12.5964	11200.0
2011-07-07 07:50:00	AAPL	Stock	12.5964	12.5964	12.5964	12.5964	2800.0
2011-07-07 08:00:00	AAPL	Stock	12.5964	12.5964	12.5718	12.58	132160.0
2011-07-07 08:05:00	AAPL	Stock	12.58	12.5821	12.5786	12.5821	25200.0
2011-07-07 08:10:00	AAPL	Stock	12.5829	12.5893	12.5829	12.5836	86492.0
2011-07-07 08:15:00	AAPL	Stock	12.5893	12.65	12.5886	12.6464	812980.0
2011-07-07 08:20:00	AAPL	Stock	12.65	12.6607	12.6429	12.6493	440216.0
2011-07-07 08:25:00	AAPL	Stock	12.6429	12.65	12.6382	12.6429	292796.0
2011-07-07 08:30:00	AAPL	Stock	12.65	12.6643	12.6489	12.66	392924.0
2011-07-07 08:35:00	AAPL	Stock	12.6582	12.6636	12.6429	12.6518	318612.0
2011-07-07 08:40:00	AAPL	Stock	12.6514	12.6536	12.6425	12.6536	217028.0
2011-07-07 08:45:00	AAPL	Stock	12.6536	12.6607	12.6536	12.6607	151200.0
2011-07-07 08:50:00	AAPL	Stock	12.6607	12.6732	12.6571	12.6714	176764.0
2011-07-07 08:55:00	AAPL	Stock	12.6668	12.6732	12.6629	12.6646	306320.0
2011-07-07 09:00:00	AAPL	Stock	12.6675	12.6746	12.6675	12.6732	393680.0
2011-07-07 09:05:00	AAPL	Stock	12.6679	12.6714	12.6679	12.6679	68824.0
2011-07-07 09:10:00	AAPL	Stock	12.6682	12.675	12.6661	12.6664	277060.0
2011-07-07 09:15:00	AAPL	Stock	12.6657	12.6714	12.6629	12.6714	133336.0
2011-07-07 09:20:00	AAPL	Stock	12.6654	12.6696	12.6632	12.6664	56000.0
2011-07-07 09:25:00	AAPL	Stock	12.6679	12.6736	12.6607	12.6736	212156.0
2011-07-07 09:30:00	AAPL	Stock	12.6696	12.7243	12.6429	12.7179	25731748.0
2011-07-07 09:35:00	AAPL	Stock	12.7175	12.7304	12.6821	12.7104	15107932.0
2011-07-07 09:40:00	AAPL	Stock	12.7109	12.7179	12.6911	12.6918	8569540.0
2011-07-07 09:45:00	AAPL	Stock	12.6911	12.7107	12.6839	12.6907	8625456.0
2011-07-07 09:50:00	AAPL	Stock	12.6909	12.7175	12.6904	12.705	8943144.0
2011-07-07 09:55:00	AAPL	Stock	12.7069	12.7175	12.7	12.7075	5659388.0
2011-07-07 10:00:00	AAPL	Stock	12.7082	12.7275	12.7064	12.7079	13211996.0
2011-07-07 10:05:00	AAPL	Stock	12.7079	12.7168	12.685	12.6961	8415652.0
2011-07-07 10:10:00	AAPL	Stock	12.6961	12.7114	12.6825	12.6993	9626288.0
2011-07-07 10:15:00	AAPL	Stock	12.6993	12.7207	12.6979	12.7154	6418860.0
2011-07-07 10:20:00	AAPL	Stock	12.7143	12.7171	12.7014	12.7171	3293192.0
2011-07-07 10:25:00	AAPL	Stock	12.717	12.7179	12.7021	12.7135	3171812.0
2011-07-07 10:30:00	AAPL	Stock	12.7107	12.7254	12.7068	12.7147	6796160.0
2011-07-07 10:35:00	AAPL	Stock	12.7175	12.7361	12.7143	12.7164	7509376.0
2011-07-07 10:40:00	AAPL	Stock	12.7161	12.7532	12.7146	12.7521	9769788.0
2011-07-07 10:45:00	AAPL	Stock	12.7514	12.7536	12.7379	12.7482	5576200.0
2011-07-07 10:50:00	AAPL	Stock	12.7464	12.7496	12.7325	12.7325	4286576.0

> showing 50 of 342,398 rows — these rows as CSV

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