PREVIEW / stock_30min / 2009-10-05

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-05.parquet
  size:    1.3 MB
  rows:    72,285
  symbols: 3,385

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
2009-10-05 04:30:00	AAPL	Stock	6.6393	6.6393	6.6393	6.6393	2800.0
2009-10-05 05:00:00	AAPL	Stock	6.6518	6.6518	6.6518	6.6518	2800.0
2009-10-05 07:00:00	AAPL	Stock	6.6511	6.6511	6.6393	6.6393	18480.0
2009-10-05 07:30:00	AAPL	Stock	6.6429	6.6571	6.6386	6.6571	207592.0
2009-10-05 08:00:00	AAPL	Stock	6.6571	6.6761	6.6539	6.6711	1329916.0
2009-10-05 08:30:00	AAPL	Stock	6.6654	6.675	6.6561	6.6568	896924.0
2009-10-05 09:00:00	AAPL	Stock	6.6554	6.6668	6.6454	6.6529	699496.0
2009-10-05 09:30:00	AAPL	Stock	6.6504	6.6679	6.6097	6.6185	76579356.0
2009-10-05 10:00:00	AAPL	Stock	6.6193	6.6329	6.5811	6.6186	70054208.0
2009-10-05 10:30:00	AAPL	Stock	6.6186	6.6536	6.6161	6.6521	36435840.0
2009-10-05 11:00:00	AAPL	Stock	6.6518	6.6564	6.6307	6.6368	25769940.0
2009-10-05 11:30:00	AAPL	Stock	6.6361	6.6518	6.6236	6.6446	17257100.0
2009-10-05 12:00:00	AAPL	Stock	6.6439	6.6496	6.6336	6.6418	10205188.0
2009-10-05 12:30:00	AAPL	Stock	6.6425	6.6636	6.6421	6.6621	20704880.0
2009-10-05 13:00:00	AAPL	Stock	6.6625	6.6643	6.6525	6.6531	15199520.0
2009-10-05 13:30:00	AAPL	Stock	6.653	6.6586	6.6457	6.6534	13577424.0
2009-10-05 14:00:00	AAPL	Stock	6.6532	6.6571	6.6368	6.6486	17351488.0
2009-10-05 14:30:00	AAPL	Stock	6.6489	6.6736	6.6486	6.6621	33533360.0
2009-10-05 15:00:00	AAPL	Stock	6.6614	6.6711	6.6525	6.6568	23294936.0
2009-10-05 15:30:00	AAPL	Stock	6.6568	6.6582	6.6357	6.6429	43890700.0
2009-10-05 16:00:00	AAPL	Stock	6.6429	6.6496	6.6399	6.6404	6359724.0
2009-10-05 16:30:00	AAPL	Stock	6.6429	6.6482	6.6399	6.6482	855932.0
2009-10-05 17:00:00	AAPL	Stock	6.6464	6.6507	6.6029	6.6504	2350068.0
2009-10-05 17:30:00	AAPL	Stock	6.6504	6.6582	6.6493	6.6582	182560.0
2009-10-05 18:00:00	AAPL	Stock	6.6436	6.6604	6.6436	6.6589	191576.0
2009-10-05 18:30:00	AAPL	Stock	6.6543	6.6543	6.65	6.6536	124712.0
2009-10-05 19:00:00	AAPL	Stock	6.6536	6.6557	6.6504	6.6504	99596.0
2009-10-05 19:30:00	AAPL	Stock	6.6536	6.6571	6.6493	6.6493	54964.0
2009-10-05 08:00:00	MSFT	Stock	24.96	25.19	24.96	25.15	55710.0
2009-10-05 08:30:00	MSFT	Stock	25.16	25.16	25.13	25.13	1185.0
2009-10-05 09:00:00	MSFT	Stock	25.13	25.15	24.96	24.98	38901.0
2009-10-05 09:30:00	MSFT	Stock	24.97	25.06	24.79	24.81	5626645.0
2009-10-05 10:00:00	MSFT	Stock	24.81	24.86	24.54	24.635	7830961.0
2009-10-05 10:30:00	MSFT	Stock	24.64	24.78	24.63	24.76	3639844.0
2009-10-05 11:00:00	MSFT	Stock	24.75	24.805	24.68	24.72	3337814.0
2009-10-05 11:30:00	MSFT	Stock	24.73	24.75	24.63	24.672	2859671.0
2009-10-05 12:00:00	MSFT	Stock	24.68	24.68	24.55	24.55	3537086.0
2009-10-05 12:30:00	MSFT	Stock	24.55	24.61	24.53	24.55	3363634.0
2009-10-05 13:00:00	MSFT	Stock	24.56	24.62	24.54	24.58	2212336.0
2009-10-05 13:30:00	MSFT	Stock	24.575	24.58	24.54	24.576	2435647.0
2009-10-05 14:00:00	MSFT	Stock	24.57	24.61	24.52	24.54	2978360.0
2009-10-05 14:30:00	MSFT	Stock	24.55	24.65	24.54	24.57	3732993.0
2009-10-05 15:00:00	MSFT	Stock	24.57	24.63	24.55	24.6	3354015.0
2009-10-05 15:30:00	MSFT	Stock	24.6	24.7	24.6	24.65	8122212.0
2009-10-05 16:00:00	MSFT	Stock	24.65	24.66	24.6	24.61	1853381.0
2009-10-05 16:30:00	MSFT	Stock	24.61	24.64	24.61	24.62	179879.0
2009-10-05 17:00:00	MSFT	Stock	24.96	24.96	24.56	24.61	470850.0
2009-10-05 17:30:00	MSFT	Stock	24.61	24.61	24.61	24.61	280.0
2009-10-05 18:00:00	MSFT	Stock	24.65	24.65	24.63	24.65	18147.0
2009-10-05 18:30:00	MSFT	Stock	24.64	24.64	24.64	24.64	1940.0

> showing 50 of 72,285 rows — these rows as CSV

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