PREVIEW / stock_5min / 2014-01-22

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-01-22.parquet
  size:    5.5 MB
  rows:    357,459
  symbols: 3,538

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
2014-01-22 05:20:00	AAPL	Stock	19.575	19.575	19.5732	19.575	16800.0
2014-01-22 06:25:00	AAPL	Stock	19.575	19.575	19.575	19.575	2800.0
2014-01-22 06:30:00	AAPL	Stock	19.5757	19.5757	19.5757	19.5757	2800.0
2014-01-22 07:00:00	AAPL	Stock	19.5979	19.6107	19.5979	19.6107	28728.0
2014-01-22 07:10:00	AAPL	Stock	19.6271	19.6271	19.6271	19.6271	8400.0
2014-01-22 07:15:00	AAPL	Stock	19.6186	19.6186	19.6186	19.6186	3640.0
2014-01-22 07:20:00	AAPL	Stock	19.6182	19.6182	19.6179	19.6179	7280.0
2014-01-22 07:25:00	AAPL	Stock	19.6182	19.6411	19.6182	19.6329	52668.0
2014-01-22 07:30:00	AAPL	Stock	19.6389	19.6821	19.6389	19.6786	52388.0
2014-01-22 07:35:00	AAPL	Stock	19.6914	19.6914	19.6821	19.6893	19600.0
2014-01-22 07:40:00	AAPL	Stock	19.695	19.6954	19.6786	19.6786	65436.0
2014-01-22 07:45:00	AAPL	Stock	19.675	19.6854	19.675	19.6854	58800.0
2014-01-22 07:50:00	AAPL	Stock	19.685	19.685	19.6775	19.6775	8400.0
2014-01-22 07:55:00	AAPL	Stock	19.6646	19.6764	19.6646	19.6764	5600.0
2014-01-22 08:00:00	AAPL	Stock	19.6725	19.6954	19.6607	19.6696	199416.0
2014-01-22 08:05:00	AAPL	Stock	19.6696	19.6786	19.6654	19.6711	137732.0
2014-01-22 08:10:00	AAPL	Stock	19.6786	19.685	19.6668	19.6689	131880.0
2014-01-22 08:15:00	AAPL	Stock	19.6711	19.6786	19.6711	19.6782	18396.0
2014-01-22 08:20:00	AAPL	Stock	19.6768	19.6768	19.6696	19.6707	50400.0
2014-01-22 08:25:00	AAPL	Stock	19.6707	19.6714	19.6564	19.6564	91532.0
2014-01-22 08:30:00	AAPL	Stock	19.6589	19.6589	19.6557	19.6557	9408.0
2014-01-22 08:35:00	AAPL	Stock	19.6589	19.6643	19.6571	19.6643	65800.0
2014-01-22 08:40:00	AAPL	Stock	19.67	19.675	19.67	19.675	58856.0
2014-01-22 08:45:00	AAPL	Stock	19.6761	19.6918	19.6761	19.6889	134512.0
2014-01-22 08:50:00	AAPL	Stock	19.6918	19.6929	19.6879	19.6904	37408.0
2014-01-22 08:55:00	AAPL	Stock	19.6875	19.6921	19.6839	19.6921	185360.0
2014-01-22 09:00:00	AAPL	Stock	19.6929	19.6936	19.6893	19.6911	82600.0
2014-01-22 09:05:00	AAPL	Stock	19.6911	19.6946	19.684	19.6879	26600.0
2014-01-22 09:10:00	AAPL	Stock	19.6807	19.6807	19.6807	19.6807	8400.0
2014-01-22 09:15:00	AAPL	Stock	19.6793	19.6807	19.6664	19.6775	85120.0
2014-01-22 09:20:00	AAPL	Stock	19.6696	19.67	19.6643	19.6678	19600.0
2014-01-22 09:25:00	AAPL	Stock	19.6679	19.6775	19.6679	19.6714	135100.0
2014-01-22 09:30:00	AAPL	Stock	19.675	19.7136	19.5904	19.6729	14697564.0
2014-01-22 09:35:00	AAPL	Stock	19.6707	19.7357	19.6689	19.6979	7004592.0
2014-01-22 09:40:00	AAPL	Stock	19.6975	19.7007	19.635	19.6575	5048428.0
2014-01-22 09:45:00	AAPL	Stock	19.6596	19.6814	19.6172	19.6201	2998968.0
2014-01-22 09:50:00	AAPL	Stock	19.626	19.6386	19.5646	19.6027	6039516.0
2014-01-22 09:55:00	AAPL	Stock	19.6014	19.6786	19.5982	19.6414	4688712.0
2014-01-22 10:00:00	AAPL	Stock	19.6408	19.6786	19.6368	19.6593	2499168.0
2014-01-22 10:05:00	AAPL	Stock	19.6629	19.7236	19.66	19.697	5030788.0
2014-01-22 10:10:00	AAPL	Stock	19.7	19.7607	19.6911	19.7486	9000432.0
2014-01-22 10:15:00	AAPL	Stock	19.7499	19.7532	19.7193	19.7418	3531528.0
2014-01-22 10:20:00	AAPL	Stock	19.745	19.7475	19.7029	19.7175	3765580.0
2014-01-22 10:25:00	AAPL	Stock	19.7201	19.7561	19.7143	19.7418	3481464.0
2014-01-22 10:30:00	AAPL	Stock	19.7452	19.7814	19.7325	19.7554	4576096.0
2014-01-22 10:35:00	AAPL	Stock	19.753	19.7814	19.7268	19.7732	5616352.0
2014-01-22 10:40:00	AAPL	Stock	19.7782	19.8561	19.7689	19.8146	21856520.0
2014-01-22 10:45:00	AAPL	Stock	19.8139	19.85	19.7857	19.7996	9625476.0
2014-01-22 10:50:00	AAPL	Stock	19.8025	19.8571	19.7971	19.8564	6865908.0
2014-01-22 10:55:00	AAPL	Stock	19.8554	19.8725	19.8393	19.8646	7430500.0

> showing 50 of 357,459 rows — these rows as CSV

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