PREVIEW / stock_5min / 2010-06-28

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-06-28.parquet
  size:    4.8 MB
  rows:    333,884
  symbols: 3,458

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
2010-06-28 04:15:00	AAPL	Stock	9.5289	9.5289	9.5289	9.5289	2800.0
2010-06-28 04:30:00	AAPL	Stock	9.5646	9.5646	9.5646	9.5646	2800.0
2010-06-28 04:35:00	AAPL	Stock	9.5536	9.5536	9.5536	9.5536	2800.0
2010-06-28 05:05:00	AAPL	Stock	9.5571	9.5571	9.5571	9.5571	32760.0
2010-06-28 06:10:00	AAPL	Stock	9.5893	9.5893	9.5893	9.5893	10248.0
2010-06-28 06:15:00	AAPL	Stock	9.5893	9.5893	9.5893	9.5893	2800.0
2010-06-28 06:45:00	AAPL	Stock	9.5786	9.5786	9.5786	9.5786	2800.0
2010-06-28 06:50:00	AAPL	Stock	9.5786	9.5786	9.5786	9.5786	5544.0
2010-06-28 07:00:00	AAPL	Stock	9.5625	9.5646	9.5196	9.5646	45360.0
2010-06-28 07:05:00	AAPL	Stock	9.5679	9.5679	9.5679	9.5679	7056.0
2010-06-28 07:10:00	AAPL	Stock	9.5486	9.5625	9.5486	9.5625	5600.0
2010-06-28 07:15:00	AAPL	Stock	9.5625	9.5625	9.5625	9.5625	6300.0
2010-06-28 07:25:00	AAPL	Stock	9.5629	9.5629	9.5629	9.5629	2800.0
2010-06-28 07:30:00	AAPL	Stock	9.5625	9.5625	9.5536	9.5536	14700.0
2010-06-28 07:35:00	AAPL	Stock	9.5461	9.5475	9.5446	9.5475	40320.0
2010-06-28 07:40:00	AAPL	Stock	9.5532	9.5618	9.5532	9.5618	19600.0
2010-06-28 07:45:00	AAPL	Stock	9.5614	9.5621	9.5614	9.5614	14000.0
2010-06-28 07:50:00	AAPL	Stock	9.5604	9.5604	9.5571	9.5571	5600.0
2010-06-28 07:55:00	AAPL	Stock	9.5518	9.5525	9.5518	9.5525	25200.0
2010-06-28 08:00:00	AAPL	Stock	9.5521	9.5618	9.5289	9.5493	207088.0
2010-06-28 08:05:00	AAPL	Stock	9.5468	9.5468	9.5321	9.5321	254380.0
2010-06-28 08:10:00	AAPL	Stock	9.5289	9.5293	9.5086	9.5214	207032.0
2010-06-28 08:15:00	AAPL	Stock	9.5214	9.525	9.5107	9.5175	137340.0
2010-06-28 08:20:00	AAPL	Stock	9.5171	9.5179	9.5018	9.5036	147896.0
2010-06-28 08:25:00	AAPL	Stock	9.5068	9.5179	9.5057	9.5179	35980.0
2010-06-28 08:30:00	AAPL	Stock	9.5161	9.5571	9.5161	9.5532	884436.0
2010-06-28 08:35:00	AAPL	Stock	9.5518	9.5529	9.5146	9.5311	1032304.0
2010-06-28 08:40:00	AAPL	Stock	9.5304	9.5464	9.5207	9.5464	699916.0
2010-06-28 08:45:00	AAPL	Stock	9.5443	9.5493	9.5157	9.5189	650804.0
2010-06-28 08:50:00	AAPL	Stock	9.5214	9.5232	9.5146	9.5204	362600.0
2010-06-28 08:55:00	AAPL	Stock	9.5225	9.5304	9.5143	9.5143	337148.0
2010-06-28 09:00:00	AAPL	Stock	9.5168	9.5471	9.5168	9.545	506940.0
2010-06-28 09:05:00	AAPL	Stock	9.5436	9.545	9.5339	9.5339	420336.0
2010-06-28 09:10:00	AAPL	Stock	9.5329	9.5393	9.5329	9.5386	156100.0
2010-06-28 09:15:00	AAPL	Stock	9.5382	9.5393	9.5305	9.5357	603316.0
2010-06-28 09:20:00	AAPL	Stock	9.5354	9.5357	9.53	9.5304	288400.0
2010-06-28 09:25:00	AAPL	Stock	9.5318	9.5343	9.5143	9.5336	398748.0
2010-06-28 09:30:00	AAPL	Stock	9.5332	9.5354	9.4857	9.5118	20144796.0
2010-06-28 09:35:00	AAPL	Stock	9.5114	9.5893	9.5111	9.5886	19165524.0
2010-06-28 09:40:00	AAPL	Stock	9.5861	9.5893	9.5554	9.5821	16944424.0
2010-06-28 09:45:00	AAPL	Stock	9.5768	9.6054	9.5489	9.5961	14606872.0
2010-06-28 09:50:00	AAPL	Stock	9.5957	9.5964	9.5596	9.5607	16308432.0
2010-06-28 09:55:00	AAPL	Stock	9.56	9.5625	9.52	9.5611	18209184.0
2010-06-28 10:00:00	AAPL	Stock	9.5621	9.5625	9.5304	9.5307	13037976.0
2010-06-28 10:05:00	AAPL	Stock	9.5304	9.5418	9.4657	9.4761	23896348.0
2010-06-28 10:10:00	AAPL	Stock	9.4739	9.4954	9.4471	9.49	19433204.0
2010-06-28 10:15:00	AAPL	Stock	9.4914	9.5	9.4786	9.4807	7233380.0
2010-06-28 10:20:00	AAPL	Stock	9.4793	9.5196	9.4786	9.5029	8787492.0
2010-06-28 10:25:00	AAPL	Stock	9.5025	9.5136	9.4886	9.5	6755532.0
2010-06-28 10:30:00	AAPL	Stock	9.5	9.5118	9.4771	9.4852	6341356.0

> showing 50 of 333,884 rows — these rows as CSV

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