PREVIEW / stock_5min / 2012-11-05

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-05.parquet
  size:    4.6 MB
  rows:    313,674
  symbols: 3,467

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
2012-11-05 04:00:00	AAPL	Stock	20.6	20.6	20.5357	20.5357	16800.0
2012-11-05 04:25:00	AAPL	Stock	20.52	20.52	20.52	20.52	2800.0
2012-11-05 04:35:00	AAPL	Stock	20.5	20.5	20.4943	20.4943	10836.0
2012-11-05 05:30:00	AAPL	Stock	20.4679	20.4679	20.4679	20.4679	2800.0
2012-11-05 05:35:00	AAPL	Stock	20.48	20.515	20.48	20.515	18060.0
2012-11-05 05:45:00	AAPL	Stock	20.4964	20.4964	20.4964	20.4964	2800.0
2012-11-05 05:50:00	AAPL	Stock	20.5179	20.5179	20.5179	20.5179	2800.0
2012-11-05 05:55:00	AAPL	Stock	20.5179	20.5179	20.5179	20.5179	11200.0
2012-11-05 06:00:00	AAPL	Stock	20.5179	20.5179	20.5179	20.5179	2800.0
2012-11-05 06:05:00	AAPL	Stock	20.5125	20.5125	20.5125	20.5125	7000.0
2012-11-05 06:25:00	AAPL	Stock	20.5357	20.5393	20.5357	20.5393	8400.0
2012-11-05 06:30:00	AAPL	Stock	20.5575	20.5604	20.5575	20.5575	14000.0
2012-11-05 06:35:00	AAPL	Stock	20.5389	20.5389	20.5357	20.5357	11060.0
2012-11-05 06:45:00	AAPL	Stock	20.5357	20.5357	20.5357	20.5357	9800.0
2012-11-05 06:55:00	AAPL	Stock	20.5304	20.5304	20.5304	20.5304	13244.0
2012-11-05 07:00:00	AAPL	Stock	20.5179	20.5357	20.5179	20.5221	19600.0
2012-11-05 07:05:00	AAPL	Stock	20.5214	20.5214	20.5093	20.5179	80920.0
2012-11-05 07:10:00	AAPL	Stock	20.5093	20.5093	20.5	20.5039	19180.0
2012-11-05 07:15:00	AAPL	Stock	20.5	20.5121	20.5	20.5121	46788.0
2012-11-05 07:20:00	AAPL	Stock	20.4993	20.5004	20.4643	20.4643	162120.0
2012-11-05 07:25:00	AAPL	Stock	20.4643	20.4821	20.4643	20.4679	18060.0
2012-11-05 07:30:00	AAPL	Stock	20.4643	20.4732	20.4446	20.4446	86128.0
2012-11-05 07:35:00	AAPL	Stock	20.4321	20.4393	20.3821	20.3929	463316.0
2012-11-05 07:40:00	AAPL	Stock	20.3921	20.405	20.3818	20.405	151536.0
2012-11-05 07:45:00	AAPL	Stock	20.4211	20.4429	20.4129	20.4429	110600.0
2012-11-05 07:50:00	AAPL	Stock	20.4468	20.4557	20.435	20.4411	53200.0
2012-11-05 07:55:00	AAPL	Stock	20.4379	20.4546	20.4214	20.4343	117152.0
2012-11-05 08:00:00	AAPL	Stock	20.4446	20.5304	20.4286	20.5039	351792.0
2012-11-05 08:05:00	AAPL	Stock	20.5039	20.5639	20.4996	20.5554	483392.0
2012-11-05 08:10:00	AAPL	Stock	20.5536	20.5536	20.5179	20.5179	127260.0
2012-11-05 08:15:00	AAPL	Stock	20.5179	20.5196	20.4732	20.4732	87724.0
2012-11-05 08:20:00	AAPL	Stock	20.4821	20.5	20.4675	20.4689	256704.0
2012-11-05 08:25:00	AAPL	Stock	20.4821	20.5196	20.4821	20.5196	141792.0
2012-11-05 08:30:00	AAPL	Stock	20.5179	20.8564	20.5179	20.7518	4810400.0
2012-11-05 08:35:00	AAPL	Stock	20.7721	20.8854	20.75	20.8457	3129280.0
2012-11-05 08:40:00	AAPL	Stock	20.855	20.8571	20.8057	20.8411	887908.0
2012-11-05 08:45:00	AAPL	Stock	20.8468	20.8643	20.8036	20.8036	764904.0
2012-11-05 08:50:00	AAPL	Stock	20.8036	20.8571	20.7836	20.8464	890428.0
2012-11-05 08:55:00	AAPL	Stock	20.84	20.8929	20.84	20.8771	1663620.0
2012-11-05 09:00:00	AAPL	Stock	20.8846	20.9071	20.8686	20.8939	1221892.0
2012-11-05 09:05:00	AAPL	Stock	20.8929	20.895	20.8571	20.8689	646996.0
2012-11-05 09:10:00	AAPL	Stock	20.8832	20.8929	20.8539	20.8539	953232.0
2012-11-05 09:15:00	AAPL	Stock	20.8507	20.8743	20.8468	20.8689	630196.0
2012-11-05 09:20:00	AAPL	Stock	20.8718	20.8929	20.8711	20.8875	568792.0
2012-11-05 09:25:00	AAPL	Stock	20.885	20.9211	20.8311	20.8393	1706936.0
2012-11-05 09:30:00	AAPL	Stock	20.8475	20.9286	20.7839	20.9093	31416532.0
2012-11-05 09:35:00	AAPL	Stock	20.9061	20.9918	20.9008	20.9732	18460484.0
2012-11-05 09:40:00	AAPL	Stock	20.9732	20.9857	20.875	20.8861	14407988.0
2012-11-05 09:45:00	AAPL	Stock	20.8861	20.8911	20.8286	20.8462	11526676.0
2012-11-05 09:50:00	AAPL	Stock	20.843	20.8921	20.7393	20.7693	11956252.0

> showing 50 of 313,674 rows — these rows as CSV

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