PREVIEW / stock_5min / 2011-04-05

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-05.parquet
  size:    4.9 MB
  rows:    329,218
  symbols: 3,545

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
2011-04-05 04:00:00	AAPL	Stock	11.9786	11.9786	11.85	11.85	37800.0
2011-04-05 04:05:00	AAPL	Stock	11.8554	11.8554	11.8543	11.8543	19040.0
2011-04-05 04:15:00	AAPL	Stock	11.8393	11.8393	11.8125	11.8125	46256.0
2011-04-05 04:20:00	AAPL	Stock	11.8125	11.8214	11.8079	11.8214	8960.0
2011-04-05 04:25:00	AAPL	Stock	11.8036	11.8036	11.7679	11.8036	14840.0
2011-04-05 04:30:00	AAPL	Stock	11.8214	11.8214	11.8214	11.8214	36260.0
2011-04-05 04:35:00	AAPL	Stock	11.8221	11.8221	11.8221	11.8221	11200.0
2011-04-05 04:40:00	AAPL	Stock	11.8393	11.8514	11.8221	11.8514	51408.0
2011-04-05 04:50:00	AAPL	Stock	11.8446	11.8446	11.8393	11.8393	15400.0
2011-04-05 04:55:00	AAPL	Stock	11.8382	11.8393	11.8382	11.8393	11200.0
2011-04-05 05:00:00	AAPL	Stock	11.8214	11.8214	11.8214	11.8214	19600.0
2011-04-05 05:05:00	AAPL	Stock	11.8357	11.8357	11.8357	11.8357	11200.0
2011-04-05 05:10:00	AAPL	Stock	11.8393	11.8529	11.8393	11.8482	59640.0
2011-04-05 05:15:00	AAPL	Stock	11.8382	11.85	11.8232	11.85	8400.0
2011-04-05 05:20:00	AAPL	Stock	11.8232	11.8232	11.8214	11.8214	20804.0
2011-04-05 05:25:00	AAPL	Stock	11.8179	11.8179	11.8179	11.8179	12264.0
2011-04-05 05:30:00	AAPL	Stock	11.8146	11.8146	11.8146	11.8146	7224.0
2011-04-05 05:35:00	AAPL	Stock	11.8175	11.8175	11.8146	11.8146	24528.0
2011-04-05 05:45:00	AAPL	Stock	11.8146	11.8146	11.8143	11.8143	15120.0
2011-04-05 05:50:00	AAPL	Stock	11.8143	11.8271	11.8143	11.8271	8400.0
2011-04-05 05:55:00	AAPL	Stock	11.8143	11.825	11.8143	11.825	5600.0
2011-04-05 06:00:00	AAPL	Stock	11.8268	11.8304	11.8189	11.8214	33600.0
2011-04-05 06:05:00	AAPL	Stock	11.8161	11.8254	11.8161	11.8254	41720.0
2011-04-05 06:10:00	AAPL	Stock	11.8211	11.8211	11.8071	11.8107	112364.0
2011-04-05 06:15:00	AAPL	Stock	11.8107	11.8107	11.7964	11.7964	133392.0
2011-04-05 06:20:00	AAPL	Stock	11.8046	11.8046	11.7857	11.7857	14308.0
2011-04-05 06:25:00	AAPL	Stock	11.7907	11.7907	11.7857	11.7857	98000.0
2011-04-05 06:30:00	AAPL	Stock	11.7857	11.8214	11.7857	11.8214	19152.0
2011-04-05 06:35:00	AAPL	Stock	11.7929	11.8036	11.7893	11.8036	30800.0
2011-04-05 06:40:00	AAPL	Stock	11.8	11.8107	11.8	11.8107	21000.0
2011-04-05 06:45:00	AAPL	Stock	11.8	11.815	11.8	11.8036	66920.0
2011-04-05 06:50:00	AAPL	Stock	11.8036	11.8125	11.8036	11.8125	41020.0
2011-04-05 06:55:00	AAPL	Stock	11.8143	11.8571	11.8071	11.8571	84168.0
2011-04-05 07:00:00	AAPL	Stock	11.8868	11.9425	11.885	11.9411	330316.0
2011-04-05 07:05:00	AAPL	Stock	11.9418	11.9732	11.9354	11.9696	409892.0
2011-04-05 07:10:00	AAPL	Stock	11.9757	12.0132	11.9714	12.0089	589092.0
2011-04-05 07:15:00	AAPL	Stock	12.0089	12.0179	11.9768	11.9796	603064.0
2011-04-05 07:20:00	AAPL	Stock	11.9682	11.9746	11.9554	11.9732	269948.0
2011-04-05 07:25:00	AAPL	Stock	11.9811	11.9986	11.9732	11.9732	145236.0
2011-04-05 07:30:00	AAPL	Stock	11.975	11.9821	11.9732	11.9818	140532.0
2011-04-05 07:35:00	AAPL	Stock	11.9818	12.0261	11.9814	11.9979	213808.0
2011-04-05 07:40:00	AAPL	Stock	12.0004	12.0107	12.0	12.0014	294868.0
2011-04-05 07:45:00	AAPL	Stock	12.0018	12.0089	11.9821	12.0089	351204.0
2011-04-05 07:50:00	AAPL	Stock	12.0021	12.0714	12.0018	12.0679	638260.0
2011-04-05 07:55:00	AAPL	Stock	12.0536	12.0568	12.0286	12.0357	893676.0
2011-04-05 08:00:00	AAPL	Stock	12.0357	12.0489	11.9339	11.9393	1462328.0
2011-04-05 08:05:00	AAPL	Stock	12.0214	12.0429	12.0214	12.0414	1074892.0
2011-04-05 08:10:00	AAPL	Stock	12.0429	12.0536	12.0036	12.0429	710724.0
2011-04-05 08:15:00	AAPL	Stock	12.0457	12.05	12.0393	12.0411	364448.0
2011-04-05 08:20:00	AAPL	Stock	12.0411	12.0411	12.0268	12.0321	806260.0

> showing 50 of 329,218 rows — these rows as CSV

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