PREVIEW / stock_5min / 2013-07-09

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-09.parquet
  size:    5.2 MB
  rows:    345,034
  symbols: 3,519

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
2013-07-09 04:00:00	AAPL	Stock	14.8564	14.8564	14.8564	14.8564	2800.0
2013-07-09 04:05:00	AAPL	Stock	14.8432	14.8432	14.8432	14.8432	3388.0
2013-07-09 04:25:00	AAPL	Stock	14.8489	14.85	14.8489	14.85	14168.0
2013-07-09 05:00:00	AAPL	Stock	14.8482	14.8482	14.8482	14.8482	2800.0
2013-07-09 06:50:00	AAPL	Stock	14.8257	14.8257	14.8257	14.8257	2800.0
2013-07-09 06:55:00	AAPL	Stock	14.8286	14.8286	14.8146	14.8146	42476.0
2013-07-09 07:00:00	AAPL	Stock	14.8164	14.8282	14.8089	14.8089	24528.0
2013-07-09 07:05:00	AAPL	Stock	14.8089	14.8089	14.8089	14.8089	5600.0
2013-07-09 07:10:00	AAPL	Stock	14.8125	14.8143	14.8125	14.8143	5600.0
2013-07-09 07:15:00	AAPL	Stock	14.8125	14.8125	14.8054	14.8054	15120.0
2013-07-09 07:20:00	AAPL	Stock	14.8071	14.8071	14.8071	14.8071	2800.0
2013-07-09 07:25:00	AAPL	Stock	14.8071	14.8071	14.8071	14.8071	2800.0
2013-07-09 07:30:00	AAPL	Stock	14.8071	14.8082	14.8071	14.8082	19600.0
2013-07-09 07:35:00	AAPL	Stock	14.8007	14.8011	14.7986	14.7986	21224.0
2013-07-09 07:40:00	AAPL	Stock	14.7964	14.7964	14.7964	14.7964	2800.0
2013-07-09 07:45:00	AAPL	Stock	14.7929	14.7929	14.7793	14.7793	22400.0
2013-07-09 07:55:00	AAPL	Stock	14.7914	14.7964	14.7914	14.7964	50400.0
2013-07-09 08:00:00	AAPL	Stock	14.7975	14.8571	14.7818	14.8	160188.0
2013-07-09 08:05:00	AAPL	Stock	14.8	14.8143	14.8	14.8143	91784.0
2013-07-09 08:10:00	AAPL	Stock	14.8125	14.8125	14.805	14.805	25200.0
2013-07-09 08:15:00	AAPL	Stock	14.8089	14.8179	14.8075	14.8107	73500.0
2013-07-09 08:20:00	AAPL	Stock	14.8175	14.8282	14.81	14.81	122500.0
2013-07-09 08:25:00	AAPL	Stock	14.8111	14.8111	14.81	14.8107	19600.0
2013-07-09 08:30:00	AAPL	Stock	14.8204	14.8286	14.8125	14.8286	82656.0
2013-07-09 08:35:00	AAPL	Stock	14.8346	14.8393	14.8275	14.8361	51212.0
2013-07-09 08:40:00	AAPL	Stock	14.8393	14.8421	14.8321	14.8339	30100.0
2013-07-09 08:45:00	AAPL	Stock	14.8304	14.8461	14.8304	14.8343	39200.0
2013-07-09 08:50:00	AAPL	Stock	14.8393	14.8479	14.8343	14.8379	67480.0
2013-07-09 08:55:00	AAPL	Stock	14.8357	14.8393	14.8332	14.8389	16800.0
2013-07-09 09:00:00	AAPL	Stock	14.8414	14.8446	14.8364	14.8364	61432.0
2013-07-09 09:05:00	AAPL	Stock	14.8325	14.8386	14.8321	14.8386	16800.0
2013-07-09 09:10:00	AAPL	Stock	14.8321	14.8321	14.8286	14.8286	88088.0
2013-07-09 09:15:00	AAPL	Stock	14.8286	14.8286	14.8132	14.8196	90048.0
2013-07-09 09:20:00	AAPL	Stock	14.8118	14.8143	14.8018	14.8029	94920.0
2013-07-09 09:25:00	AAPL	Stock	14.8043	14.8139	14.7639	14.77	290136.0
2013-07-09 09:30:00	AAPL	Stock	14.7714	14.7821	14.7004	14.7307	14553504.0
2013-07-09 09:35:00	AAPL	Stock	14.7293	14.7314	14.6564	14.6829	10793804.0
2013-07-09 09:40:00	AAPL	Stock	14.6829	14.74	14.6661	14.7289	10059168.0
2013-07-09 09:45:00	AAPL	Stock	14.7314	14.7764	14.6954	14.7529	6763596.0
2013-07-09 09:50:00	AAPL	Stock	14.7561	14.8493	14.7343	14.8196	14866880.0
2013-07-09 09:55:00	AAPL	Stock	14.8211	14.8679	14.7957	14.8089	8835176.0
2013-07-09 10:00:00	AAPL	Stock	14.8096	14.86	14.79	14.8542	7385056.0
2013-07-09 10:05:00	AAPL	Stock	14.8525	14.8771	14.8275	14.8307	5986148.0
2013-07-09 10:10:00	AAPL	Stock	14.8343	14.885	14.8304	14.8643	7358540.0
2013-07-09 10:15:00	AAPL	Stock	14.8643	14.8646	14.8111	14.8179	7975996.0
2013-07-09 10:20:00	AAPL	Stock	14.8179	14.87	14.8121	14.8579	4738524.0
2013-07-09 10:25:00	AAPL	Stock	14.8582	14.8664	14.8004	14.8289	6379436.0
2013-07-09 10:30:00	AAPL	Stock	14.8286	14.8464	14.8137	14.8312	3127180.0
2013-07-09 10:35:00	AAPL	Stock	14.8334	14.8654	14.8304	14.8649	3040912.0
2013-07-09 10:40:00	AAPL	Stock	14.8654	14.8771	14.8489	14.8714	3554768.0

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

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