PREVIEW / stock_5min / 2014-05-23

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-05-23.parquet
  size:    5.1 MB
  rows:    345,912
  symbols: 3,534

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-05-23 04:35:00	AAPL	Stock	21.6804	21.6839	21.6804	21.6839	16800.0
2014-05-23 05:55:00	AAPL	Stock	21.6914	21.6925	21.6914	21.6925	5600.0
2014-05-23 06:00:00	AAPL	Stock	21.6993	21.6993	21.6993	21.6993	2800.0
2014-05-23 07:05:00	AAPL	Stock	21.6907	21.6907	21.6907	21.6907	14000.0
2014-05-23 07:10:00	AAPL	Stock	21.6893	21.6893	21.6875	21.6875	14000.0
2014-05-23 07:20:00	AAPL	Stock	21.6875	21.6875	21.6875	21.6875	2800.0
2014-05-23 07:35:00	AAPL	Stock	21.6861	21.6861	21.6861	21.6861	5600.0
2014-05-23 07:50:00	AAPL	Stock	21.6761	21.6761	21.6761	21.6761	2800.0
2014-05-23 08:00:00	AAPL	Stock	21.6786	21.6964	21.6743	21.6743	60200.0
2014-05-23 08:05:00	AAPL	Stock	21.6764	21.6764	21.6764	21.6764	14000.0
2014-05-23 08:10:00	AAPL	Stock	21.6768	21.6768	21.6768	21.6768	2800.0
2014-05-23 08:15:00	AAPL	Stock	21.6711	21.6711	21.6514	21.6514	40544.0
2014-05-23 08:20:00	AAPL	Stock	21.6607	21.6607	21.6607	21.6607	16800.0
2014-05-23 08:30:00	AAPL	Stock	21.6714	21.6714	21.6714	21.6714	33600.0
2014-05-23 08:45:00	AAPL	Stock	21.6636	21.6696	21.6636	21.6664	16688.0
2014-05-23 08:50:00	AAPL	Stock	21.6679	21.6679	21.6661	21.6679	39564.0
2014-05-23 08:55:00	AAPL	Stock	21.6725	21.6729	21.6657	21.6657	22288.0
2014-05-23 09:00:00	AAPL	Stock	21.6639	21.6639	21.6571	21.6607	113036.0
2014-05-23 09:05:00	AAPL	Stock	21.67	21.6711	21.6693	21.6711	16800.0
2014-05-23 09:15:00	AAPL	Stock	21.6679	21.6679	21.6679	21.6679	2800.0
2014-05-23 09:20:00	AAPL	Stock	21.6693	21.6693	21.6693	21.6693	8400.0
2014-05-23 09:25:00	AAPL	Stock	21.6696	21.6939	21.6696	21.6875	278096.0
2014-05-23 09:30:00	AAPL	Stock	21.6875	21.7236	21.6729	21.7129	7116676.0
2014-05-23 09:35:00	AAPL	Stock	21.7139	21.7225	21.68	21.6994	2977576.0
2014-05-23 09:40:00	AAPL	Stock	21.7011	21.7064	21.6786	21.7032	9483544.0
2014-05-23 09:45:00	AAPL	Stock	21.7036	21.7318	21.6982	21.7136	5033840.0
2014-05-23 09:50:00	AAPL	Stock	21.7154	21.7407	21.7143	21.7314	2767128.0
2014-05-23 09:55:00	AAPL	Stock	21.7304	21.7475	21.725	21.7268	3193036.0
2014-05-23 10:00:00	AAPL	Stock	21.7339	21.7393	21.7143	21.7325	2651768.0
2014-05-23 10:05:00	AAPL	Stock	21.7348	21.7439	21.7146	21.7146	2956016.0
2014-05-23 10:10:00	AAPL	Stock	21.7143	21.7239	21.6989	21.7134	3585568.0
2014-05-23 10:15:00	AAPL	Stock	21.7129	21.7179	21.6968	21.7121	1966160.0
2014-05-23 10:20:00	AAPL	Stock	21.7125	21.7162	21.7007	21.715	1263360.0
2014-05-23 10:25:00	AAPL	Stock	21.715	21.7171	21.6984	21.7057	1226960.0
2014-05-23 10:30:00	AAPL	Stock	21.7057	21.7071	21.6821	21.6884	3284932.0
2014-05-23 10:35:00	AAPL	Stock	21.6879	21.6907	21.6596	21.6736	3197992.0
2014-05-23 10:40:00	AAPL	Stock	21.6718	21.6929	21.6718	21.6911	2140852.0
2014-05-23 10:45:00	AAPL	Stock	21.6921	21.6929	21.6829	21.685	1934156.0
2014-05-23 10:50:00	AAPL	Stock	21.6886	21.7032	21.685	21.6964	1962436.0
2014-05-23 10:55:00	AAPL	Stock	21.6979	21.7032	21.6832	21.7011	1908648.0
2014-05-23 11:00:00	AAPL	Stock	21.7029	21.7164	21.6979	21.7157	1774444.0
2014-05-23 11:05:00	AAPL	Stock	21.715	21.7232	21.7114	21.72	1751904.0
2014-05-23 11:10:00	AAPL	Stock	21.7207	21.7243	21.6993	21.7032	1887004.0
2014-05-23 11:15:00	AAPL	Stock	21.7039	21.7186	21.7004	21.7118	914984.0
2014-05-23 11:20:00	AAPL	Stock	21.7114	21.7157	21.7075	21.7111	1028328.0
2014-05-23 11:25:00	AAPL	Stock	21.7114	21.7246	21.71	21.7218	1871884.0
2014-05-23 11:30:00	AAPL	Stock	21.7221	21.7221	21.6993	21.7071	1104824.0
2014-05-23 11:35:00	AAPL	Stock	21.7071	21.715	21.7025	21.7093	794304.0
2014-05-23 11:40:00	AAPL	Stock	21.7143	21.7225	21.7111	21.7221	1200080.0
2014-05-23 11:45:00	AAPL	Stock	21.7221	21.7336	21.7147	21.7336	1612324.0

> showing 50 of 345,912 rows — these rows as CSV

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