PREVIEW / stock_5min / 2011-10-10

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-10.parquet
  size:    4.6 MB
  rows:    319,433
  symbols: 3,474

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-10-10 04:00:00	AAPL	Stock	13.3557	13.3557	13.3557	13.3557	11200.0
2011-10-10 04:05:00	AAPL	Stock	13.3286	13.3286	13.3286	13.3286	7000.0
2011-10-10 04:10:00	AAPL	Stock	13.3557	13.3557	13.3557	13.3557	8400.0
2011-10-10 04:15:00	AAPL	Stock	13.3482	13.3482	13.3479	13.3479	5600.0
2011-10-10 04:20:00	AAPL	Stock	13.3479	13.3482	13.3357	13.3357	14840.0
2011-10-10 04:45:00	AAPL	Stock	13.3557	13.3557	13.3557	13.3557	8400.0
2011-10-10 05:35:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	2800.0
2011-10-10 05:55:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	5600.0
2011-10-10 06:00:00	AAPL	Stock	13.375	13.375	13.375	13.375	2800.0
2011-10-10 06:25:00	AAPL	Stock	13.3925	13.3925	13.3925	13.3925	5600.0
2011-10-10 06:30:00	AAPL	Stock	13.3857	13.3857	13.3857	13.3857	14000.0
2011-10-10 06:35:00	AAPL	Stock	13.3832	13.3925	13.3832	13.3925	10248.0
2011-10-10 06:40:00	AAPL	Stock	13.3857	13.3857	13.3857	13.3857	14000.0
2011-10-10 06:45:00	AAPL	Stock	13.3921	13.3921	13.375	13.375	8400.0
2011-10-10 06:50:00	AAPL	Stock	13.3786	13.3889	13.375	13.3889	85400.0
2011-10-10 06:55:00	AAPL	Stock	13.375	13.375	13.375	13.375	2800.0
2011-10-10 07:00:00	AAPL	Stock	13.3921	13.3921	13.375	13.3754	64400.0
2011-10-10 07:05:00	AAPL	Stock	13.3839	13.3921	13.3839	13.3921	35616.0
2011-10-10 07:10:00	AAPL	Stock	13.3911	13.4025	13.3911	13.3946	93184.0
2011-10-10 07:15:00	AAPL	Stock	13.4011	13.4179	13.3946	13.4179	60844.0
2011-10-10 07:20:00	AAPL	Stock	13.4196	13.4286	13.4179	13.4196	44800.0
2011-10-10 07:25:00	AAPL	Stock	13.4286	13.4286	13.4286	13.4286	2800.0
2011-10-10 07:30:00	AAPL	Stock	13.4239	13.4239	13.4239	13.4239	5600.0
2011-10-10 07:35:00	AAPL	Stock	13.4032	13.4032	13.4011	13.4011	16800.0
2011-10-10 07:40:00	AAPL	Stock	13.4075	13.4154	13.4071	13.4143	39200.0
2011-10-10 07:45:00	AAPL	Stock	13.4057	13.4057	13.3964	13.3964	28000.0
2011-10-10 07:50:00	AAPL	Stock	13.4	13.4	13.3946	13.3946	25200.0
2011-10-10 07:55:00	AAPL	Stock	13.4029	13.4107	13.395	13.4086	122360.0
2011-10-10 08:00:00	AAPL	Stock	13.4014	13.4054	13.3593	13.3893	423500.0
2011-10-10 08:05:00	AAPL	Stock	13.3896	13.3946	13.3811	13.3836	174580.0
2011-10-10 08:10:00	AAPL	Stock	13.3804	13.3839	13.3661	13.3704	145488.0
2011-10-10 08:15:00	AAPL	Stock	13.3625	13.375	13.3571	13.375	256144.0
2011-10-10 08:20:00	AAPL	Stock	13.375	13.3825	13.3714	13.3811	366996.0
2011-10-10 08:25:00	AAPL	Stock	13.3807	13.3893	13.3807	13.3871	215992.0
2011-10-10 08:30:00	AAPL	Stock	13.3875	13.4786	13.3875	13.4643	1668324.0
2011-10-10 08:35:00	AAPL	Stock	13.4646	13.475	13.4482	13.45	627368.0
2011-10-10 08:40:00	AAPL	Stock	13.45	13.4761	13.4464	13.4754	334264.0
2011-10-10 08:45:00	AAPL	Stock	13.4679	13.5396	13.4679	13.5286	1196804.0
2011-10-10 08:50:00	AAPL	Stock	13.5275	13.5475	13.5268	13.5304	751296.0
2011-10-10 08:55:00	AAPL	Stock	13.5268	13.5357	13.5114	13.5357	575400.0
2011-10-10 09:00:00	AAPL	Stock	13.5357	13.5489	13.5189	13.5318	392896.0
2011-10-10 09:05:00	AAPL	Stock	13.5321	13.5443	13.5282	13.5286	295148.0
2011-10-10 09:10:00	AAPL	Stock	13.5357	13.5404	13.525	13.5393	314048.0
2011-10-10 09:15:00	AAPL	Stock	13.5461	13.5536	13.5393	13.5429	393708.0
2011-10-10 09:20:00	AAPL	Stock	13.5461	13.5521	13.5368	13.54	705852.0
2011-10-10 09:25:00	AAPL	Stock	13.5429	13.55	13.5382	13.5393	840112.0
2011-10-10 09:30:00	AAPL	Stock	13.5389	13.5957	13.5075	13.5554	25739868.0
2011-10-10 09:35:00	AAPL	Stock	13.5543	13.5793	13.5354	13.5536	11611068.0
2011-10-10 09:40:00	AAPL	Stock	13.5496	13.5646	13.5089	13.5414	9693180.0
2011-10-10 09:45:00	AAPL	Stock	13.5357	13.5785	13.5343	13.5568	6492528.0

> showing 50 of 319,433 rows — these rows as CSV

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