PREVIEW / stock_5min / 2014-03-17

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-17.parquet
  size:    5.5 MB
  rows:    366,929
  symbols: 3,544

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-03-17 04:20:00	AAPL	Stock	18.795	18.7961	18.795	18.7961	14000.0
2014-03-17 05:20:00	AAPL	Stock	18.8646	18.8814	18.8646	18.8814	5600.0
2014-03-17 06:05:00	AAPL	Stock	18.8482	18.8482	18.8482	18.8482	2800.0
2014-03-17 06:15:00	AAPL	Stock	18.8279	18.8279	18.8279	18.8279	2800.0
2014-03-17 06:45:00	AAPL	Stock	18.8471	18.8536	18.8471	18.8536	14000.0
2014-03-17 07:00:00	AAPL	Stock	18.8304	18.8393	18.8304	18.8393	5600.0
2014-03-17 07:10:00	AAPL	Stock	18.8529	18.8757	18.8482	18.8664	48580.0
2014-03-17 07:15:00	AAPL	Stock	18.8714	18.8714	18.8664	18.8664	16800.0
2014-03-17 07:20:00	AAPL	Stock	18.8507	18.8507	18.8507	18.8507	2800.0
2014-03-17 07:25:00	AAPL	Stock	18.8529	18.8529	18.85	18.85	21952.0
2014-03-17 07:35:00	AAPL	Stock	18.8529	18.8561	18.8529	18.8561	7364.0
2014-03-17 07:40:00	AAPL	Stock	18.8482	18.8482	18.8482	18.8482	8400.0
2014-03-17 07:45:00	AAPL	Stock	18.8529	18.8529	18.8482	18.8521	25200.0
2014-03-17 07:55:00	AAPL	Stock	18.8511	18.8511	18.8393	18.8393	5600.0
2014-03-17 08:00:00	AAPL	Stock	18.8421	18.8571	18.8275	18.8275	111496.0
2014-03-17 08:05:00	AAPL	Stock	18.8393	18.8739	18.8393	18.8739	222096.0
2014-03-17 08:10:00	AAPL	Stock	18.86	18.8818	18.8582	18.8582	100800.0
2014-03-17 08:15:00	AAPL	Stock	18.8764	18.8857	18.875	18.8768	218484.0
2014-03-17 08:20:00	AAPL	Stock	18.8811	18.8811	18.8629	18.8632	105140.0
2014-03-17 08:25:00	AAPL	Stock	18.8739	18.8821	18.865	18.8654	58324.0
2014-03-17 08:30:00	AAPL	Stock	18.8732	18.8732	18.8625	18.8629	105560.0
2014-03-17 08:35:00	AAPL	Stock	18.8632	18.8714	18.8632	18.8679	14000.0
2014-03-17 08:40:00	AAPL	Stock	18.8679	18.8746	18.8679	18.8746	50400.0
2014-03-17 08:45:00	AAPL	Stock	18.8657	18.8657	18.8571	18.8571	84000.0
2014-03-17 08:50:00	AAPL	Stock	18.8571	18.8571	18.855	18.8571	55776.0
2014-03-17 08:55:00	AAPL	Stock	18.8546	18.8546	18.8357	18.8357	63672.0
2014-03-17 09:00:00	AAPL	Stock	18.8336	18.8392	18.8286	18.8311	24612.0
2014-03-17 09:05:00	AAPL	Stock	18.8389	18.8429	18.8318	18.8429	75656.0
2014-03-17 09:10:00	AAPL	Stock	18.8518	18.8564	18.8518	18.8564	26572.0
2014-03-17 09:15:00	AAPL	Stock	18.8475	18.855	18.8457	18.85	11200.0
2014-03-17 09:20:00	AAPL	Stock	18.8564	18.8564	18.8357	18.8357	75208.0
2014-03-17 09:25:00	AAPL	Stock	18.8393	18.8468	18.8279	18.8468	209748.0
2014-03-17 09:30:00	AAPL	Stock	18.8304	18.8782	18.8112	18.8543	8663676.0
2014-03-17 09:35:00	AAPL	Stock	18.8571	18.9071	18.8518	18.9071	6602148.0
2014-03-17 09:40:00	AAPL	Stock	18.9082	18.9175	18.88	18.9129	4936484.0
2014-03-17 09:45:00	AAPL	Stock	18.9129	18.9186	18.8929	18.9057	3896704.0
2014-03-17 09:50:00	AAPL	Stock	18.9088	18.9275	18.8993	18.9007	3981600.0
2014-03-17 09:55:00	AAPL	Stock	18.9007	18.9193	18.8718	18.8718	3767540.0
2014-03-17 10:00:00	AAPL	Stock	18.8704	18.9105	18.8671	18.8978	2812880.0
2014-03-17 10:05:00	AAPL	Stock	18.8989	18.9036	18.8714	18.8725	2060212.0
2014-03-17 10:10:00	AAPL	Stock	18.8725	18.8861	18.8571	18.8629	3493952.0
2014-03-17 10:15:00	AAPL	Stock	18.8625	18.8643	18.8336	18.8382	3105900.0
2014-03-17 10:20:00	AAPL	Stock	18.8379	18.8571	18.8236	18.8514	2346932.0
2014-03-17 10:25:00	AAPL	Stock	18.855	18.8571	18.8293	18.833	1602580.0
2014-03-17 10:30:00	AAPL	Stock	18.8329	18.85	18.8218	18.8279	2199848.0
2014-03-17 10:35:00	AAPL	Stock	18.8264	18.8361	18.7979	18.8115	3193064.0
2014-03-17 10:40:00	AAPL	Stock	18.8125	18.8343	18.7969	18.8046	2834776.0
2014-03-17 10:45:00	AAPL	Stock	18.8036	18.8054	18.7804	18.8043	2469208.0
2014-03-17 10:50:00	AAPL	Stock	18.8043	18.84	18.8007	18.8282	2717988.0
2014-03-17 10:55:00	AAPL	Stock	18.825	18.8393	18.8104	18.8314	1596728.0

> showing 50 of 366,929 rows — these rows as CSV

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