PREVIEW / stock_5min / 2013-10-24

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-10-24.parquet
  size:    5.3 MB
  rows:    346,418
  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
2013-10-24 04:05:00	AAPL	Stock	18.7857	18.7857	18.7857	18.7857	4900.0
2013-10-24 04:10:00	AAPL	Stock	18.7857	18.7857	18.7857	18.7857	4900.0
2013-10-24 04:15:00	AAPL	Stock	18.8036	18.8179	18.8036	18.8179	8400.0
2013-10-24 05:00:00	AAPL	Stock	18.8036	18.8036	18.8036	18.8036	14000.0
2013-10-24 05:30:00	AAPL	Stock	18.8232	18.8461	18.8232	18.8461	8400.0
2013-10-24 05:40:00	AAPL	Stock	18.8532	18.8532	18.8532	18.8532	2800.0
2013-10-24 05:45:00	AAPL	Stock	18.8389	18.8389	18.8389	18.8389	2800.0
2013-10-24 05:50:00	AAPL	Stock	18.8279	18.8279	18.8125	18.8125	6356.0
2013-10-24 06:00:00	AAPL	Stock	18.8393	18.8393	18.8325	18.8325	19600.0
2013-10-24 06:05:00	AAPL	Stock	18.8175	18.8393	18.8175	18.8393	14000.0
2013-10-24 06:10:00	AAPL	Stock	18.8393	18.8393	18.8393	18.8393	2800.0
2013-10-24 06:15:00	AAPL	Stock	18.8393	18.8393	18.8393	18.8393	14980.0
2013-10-24 06:45:00	AAPL	Stock	18.8357	18.8393	18.8357	18.8393	18984.0
2013-10-24 06:50:00	AAPL	Stock	18.8393	18.8557	18.8393	18.8557	44240.0
2013-10-24 07:00:00	AAPL	Stock	18.8721	18.8829	18.8571	18.8571	143920.0
2013-10-24 07:05:00	AAPL	Stock	18.8393	18.8571	18.8393	18.8571	7280.0
2013-10-24 07:10:00	AAPL	Stock	18.8489	18.8571	18.8332	18.8571	68824.0
2013-10-24 07:15:00	AAPL	Stock	18.8536	18.8536	18.8461	18.8461	63560.0
2013-10-24 07:20:00	AAPL	Stock	18.8304	18.8464	18.8304	18.8464	31640.0
2013-10-24 07:25:00	AAPL	Stock	18.8464	18.8464	18.8271	18.8271	7280.0
2013-10-24 07:30:00	AAPL	Stock	18.8293	18.8321	18.8214	18.8214	46760.0
2013-10-24 07:35:00	AAPL	Stock	18.8214	18.8214	18.8125	18.8125	14840.0
2013-10-24 07:40:00	AAPL	Stock	18.8214	18.8214	18.8214	18.8214	50960.0
2013-10-24 07:45:00	AAPL	Stock	18.8182	18.8214	18.8179	18.8211	29120.0
2013-10-24 07:50:00	AAPL	Stock	18.8171	18.8179	18.7868	18.7868	51800.0
2013-10-24 07:55:00	AAPL	Stock	18.8021	18.8021	18.7839	18.7839	79352.0
2013-10-24 08:00:00	AAPL	Stock	18.7686	18.8571	18.7321	18.7971	215040.0
2013-10-24 08:05:00	AAPL	Stock	18.7893	18.8211	18.7893	18.8211	68656.0
2013-10-24 08:10:00	AAPL	Stock	18.8214	18.8286	18.8	18.8	191100.0
2013-10-24 08:15:00	AAPL	Stock	18.7929	18.8007	18.7843	18.8007	127484.0
2013-10-24 08:20:00	AAPL	Stock	18.8007	18.8036	18.7946	18.8036	109116.0
2013-10-24 08:25:00	AAPL	Stock	18.7946	18.7979	18.7821	18.7857	126420.0
2013-10-24 08:30:00	AAPL	Stock	18.7871	18.8036	18.7871	18.7946	80584.0
2013-10-24 08:35:00	AAPL	Stock	18.7904	18.795	18.7718	18.7718	192220.0
2013-10-24 08:40:00	AAPL	Stock	18.7714	18.7736	18.7604	18.7714	166376.0
2013-10-24 08:45:00	AAPL	Stock	18.7804	18.7804	18.7411	18.75	249396.0
2013-10-24 08:50:00	AAPL	Stock	18.7525	18.7571	18.7411	18.7482	193592.0
2013-10-24 08:55:00	AAPL	Stock	18.7493	18.7675	18.7436	18.7643	422968.0
2013-10-24 09:00:00	AAPL	Stock	18.75	18.81	18.75	18.7929	909272.0
2013-10-24 09:05:00	AAPL	Stock	18.7925	18.8282	18.7857	18.8071	573776.0
2013-10-24 09:10:00	AAPL	Stock	18.8029	18.8107	18.7625	18.7843	505512.0
2013-10-24 09:15:00	AAPL	Stock	18.7618	18.7839	18.7411	18.75	345436.0
2013-10-24 09:20:00	AAPL	Stock	18.7493	18.7496	18.7218	18.7418	242340.0
2013-10-24 09:25:00	AAPL	Stock	18.7414	18.7618	18.7379	18.7496	288708.0
2013-10-24 09:30:00	AAPL	Stock	18.75	18.7857	18.6964	18.7386	14895076.0
2013-10-24 09:35:00	AAPL	Stock	18.7311	18.7525	18.6893	18.7075	8219176.0
2013-10-24 09:40:00	AAPL	Stock	18.7068	18.7082	18.6589	18.6882	8783040.0
2013-10-24 09:45:00	AAPL	Stock	18.6886	18.725	18.6814	18.7194	4106816.0
2013-10-24 09:50:00	AAPL	Stock	18.7164	18.7179	18.6811	18.6943	3473736.0
2013-10-24 09:55:00	AAPL	Stock	18.6943	18.7229	18.6893	18.7089	3304364.0

> showing 50 of 346,418 rows — these rows as CSV

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