PREVIEW / stock_5min / 2012-05-04

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-04.parquet
  size:    4.9 MB
  rows:    334,426
  symbols: 3,531

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-05-04 04:30:00	AAPL	Stock	20.75	20.75	20.75	20.75	5600.0
2012-05-04 05:15:00	AAPL	Stock	20.7146	20.7146	20.7146	20.7146	2800.0
2012-05-04 06:10:00	AAPL	Stock	20.7182	20.7182	20.7182	20.7182	2800.0
2012-05-04 06:35:00	AAPL	Stock	20.7236	20.7236	20.7236	20.7236	2800.0
2012-05-04 06:50:00	AAPL	Stock	20.75	20.75	20.75	20.75	2800.0
2012-05-04 07:00:00	AAPL	Stock	20.7571	20.7857	20.7571	20.7857	48440.0
2012-05-04 07:05:00	AAPL	Stock	20.7854	20.7857	20.75	20.75	34160.0
2012-05-04 07:10:00	AAPL	Stock	20.7489	20.7661	20.7489	20.7661	14000.0
2012-05-04 07:15:00	AAPL	Stock	20.75	20.75	20.7414	20.7414	21280.0
2012-05-04 07:20:00	AAPL	Stock	20.7411	20.7432	20.7232	20.7432	31080.0
2012-05-04 07:25:00	AAPL	Stock	20.7396	20.7411	20.7396	20.7411	5600.0
2012-05-04 07:30:00	AAPL	Stock	20.7321	20.7321	20.7286	20.7321	16800.0
2012-05-04 07:35:00	AAPL	Stock	20.7386	20.7386	20.7143	20.7143	53760.0
2012-05-04 07:40:00	AAPL	Stock	20.6964	20.7379	20.6964	20.7257	45640.0
2012-05-04 07:45:00	AAPL	Stock	20.7357	20.7379	20.7321	20.7379	37184.0
2012-05-04 07:55:00	AAPL	Stock	20.7211	20.7304	20.7179	20.7304	11200.0
2012-05-04 08:00:00	AAPL	Stock	20.7307	20.7639	20.7307	20.7457	68600.0
2012-05-04 08:05:00	AAPL	Stock	20.7457	20.7457	20.7321	20.7321	20468.0
2012-05-04 08:10:00	AAPL	Stock	20.7286	20.7407	20.7254	20.7407	22540.0
2012-05-04 08:15:00	AAPL	Stock	20.7411	20.7446	20.7286	20.735	198576.0
2012-05-04 08:20:00	AAPL	Stock	20.7289	20.7346	20.7214	20.7214	138712.0
2012-05-04 08:25:00	AAPL	Stock	20.715	20.7279	20.7104	20.7143	104664.0
2012-05-04 08:30:00	AAPL	Stock	20.71	20.8164	20.6464	20.7957	1245916.0
2012-05-04 08:35:00	AAPL	Stock	20.7929	20.7964	20.7418	20.7418	528304.0
2012-05-04 08:40:00	AAPL	Stock	20.7361	20.7468	20.725	20.7343	223860.0
2012-05-04 08:45:00	AAPL	Stock	20.7271	20.7318	20.6875	20.6989	500360.0
2012-05-04 08:50:00	AAPL	Stock	20.6904	20.695	20.6625	20.6786	911372.0
2012-05-04 08:55:00	AAPL	Stock	20.6743	20.6775	20.6229	20.6246	1191680.0
2012-05-04 09:00:00	AAPL	Stock	20.6311	20.6536	20.6214	20.6432	434308.0
2012-05-04 09:05:00	AAPL	Stock	20.6439	20.6511	20.6161	20.6171	732424.0
2012-05-04 09:10:00	AAPL	Stock	20.6161	20.6314	20.6114	20.6254	381892.0
2012-05-04 09:15:00	AAPL	Stock	20.625	20.6404	20.6239	20.6318	300636.0
2012-05-04 09:20:00	AAPL	Stock	20.6339	20.6411	20.6282	20.6386	104804.0
2012-05-04 09:25:00	AAPL	Stock	20.6393	20.6518	20.6039	20.6154	885304.0
2012-05-04 09:30:00	AAPL	Stock	20.61	20.6557	20.5493	20.6097	17653244.0
2012-05-04 09:35:00	AAPL	Stock	20.6116	20.6192	20.5014	20.5193	19354524.0
2012-05-04 09:40:00	AAPL	Stock	20.5261	20.5268	20.46	20.5007	15346744.0
2012-05-04 09:45:00	AAPL	Stock	20.5025	20.5043	20.4325	20.4667	14998116.0
2012-05-04 09:50:00	AAPL	Stock	20.4696	20.5196	20.4614	20.5089	13454700.0
2012-05-04 09:55:00	AAPL	Stock	20.508	20.5114	20.4396	20.4718	11061204.0
2012-05-04 10:00:00	AAPL	Stock	20.4707	20.4932	20.4018	20.4425	15935500.0
2012-05-04 10:05:00	AAPL	Stock	20.4361	20.4636	20.4157	20.4197	7771176.0
2012-05-04 10:10:00	AAPL	Stock	20.4168	20.4436	20.3807	20.3929	9647708.0
2012-05-04 10:15:00	AAPL	Stock	20.3921	20.3939	20.3118	20.3243	20241508.0
2012-05-04 10:20:00	AAPL	Stock	20.324	20.375	20.3196	20.37	13457276.0
2012-05-04 10:25:00	AAPL	Stock	20.3711	20.4096	20.3425	20.3611	12648216.0
2012-05-04 10:30:00	AAPL	Stock	20.3625	20.37	20.3243	20.3468	6462120.0
2012-05-04 10:35:00	AAPL	Stock	20.3439	20.3525	20.2954	20.3336	8811768.0
2012-05-04 10:40:00	AAPL	Stock	20.3375	20.3661	20.3086	20.3606	7744856.0
2012-05-04 10:45:00	AAPL	Stock	20.3568	20.3929	20.3464	20.3764	7325332.0

> showing 50 of 334,426 rows — these rows as CSV

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