PREVIEW / stock_30min / 2013-09-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-23.parquet
  size:    1.5 MB
  rows:    80,420
  symbols: 3,521

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
2013-09-23 04:00:00	AAPL	Stock	16.7546	16.7546	16.7546	16.7546	2800.0
2013-09-23 04:30:00	AAPL	Stock	16.7893	16.7893	16.7893	16.7893	2800.0
2013-09-23 05:00:00	AAPL	Stock	16.8357	16.8357	16.7857	16.7857	40348.0
2013-09-23 05:30:00	AAPL	Stock	16.765	16.765	16.7443	16.7639	14000.0
2013-09-23 06:00:00	AAPL	Stock	16.7743	16.7875	16.7714	16.7732	80920.0
2013-09-23 06:30:00	AAPL	Stock	16.7511	16.7571	16.7404	16.7429	39200.0
2013-09-23 07:00:00	AAPL	Stock	16.7443	16.75	16.5718	16.6064	191604.0
2013-09-23 07:30:00	AAPL	Stock	16.5786	16.625	16.5357	16.5893	503636.0
2013-09-23 08:00:00	AAPL	Stock	16.5893	16.7143	16.5361	16.5811	1170092.0
2013-09-23 08:30:00	AAPL	Stock	16.5811	17.7857	16.5811	17.7411	60252248.0
2013-09-23 09:00:00	AAPL	Stock	17.7411	17.8214	17.6786	17.7146	25824428.0
2013-09-23 09:30:00	AAPL	Stock	17.7182	17.7468	17.4111	17.4329	188875932.0
2013-09-23 10:00:00	AAPL	Stock	17.4336	17.4575	17.2357	17.3891	109464684.0
2013-09-23 10:30:00	AAPL	Stock	17.3894	17.4789	17.3393	17.3929	38092460.0
2013-09-23 11:00:00	AAPL	Stock	17.3929	17.4464	17.2807	17.365	45015432.0
2013-09-23 11:30:00	AAPL	Stock	17.3636	17.3936	17.3064	17.3064	26891172.0
2013-09-23 12:00:00	AAPL	Stock	17.3064	17.3379	17.245	17.2854	29391740.0
2013-09-23 12:30:00	AAPL	Stock	17.285	17.3875	17.2361	17.3675	28632156.0
2013-09-23 13:00:00	AAPL	Stock	17.3675	17.4036	17.335	17.3554	18546696.0
2013-09-23 13:30:00	AAPL	Stock	17.3571	17.4732	17.3554	17.47	22491560.0
2013-09-23 14:00:00	AAPL	Stock	17.4693	17.5168	17.4254	17.4543	31062192.0
2013-09-23 14:30:00	AAPL	Stock	17.4529	17.5686	17.445	17.5636	25759328.0
2013-09-23 15:00:00	AAPL	Stock	17.5636	17.5804	17.4734	17.4802	33262432.0
2013-09-23 15:30:00	AAPL	Stock	17.478	17.5957	17.4754	17.5304	54642000.0
2013-09-23 16:00:00	AAPL	Stock	17.5325	17.5623	17.418	17.5343	14907116.0
2013-09-23 16:30:00	AAPL	Stock	17.5386	17.5396	17.3817	17.3817	549024.0
2013-09-23 17:00:00	AAPL	Stock	17.5361	17.5443	17.5261	17.5393	336616.0
2013-09-23 17:30:00	AAPL	Stock	17.5421	17.5539	17.5261	17.5468	237132.0
2013-09-23 18:00:00	AAPL	Stock	17.55	17.5811	17.55	17.5646	474292.0
2013-09-23 18:30:00	AAPL	Stock	17.5661	17.5821	17.5639	17.5804	357840.0
2013-09-23 19:00:00	AAPL	Stock	17.5804	17.5921	17.5804	17.5864	309344.0
2013-09-23 19:30:00	AAPL	Stock	17.5875	17.6032	17.5839	17.5982	877800.0
2013-09-23 05:30:00	MSFT	Stock	32.96	32.96	32.96	32.96	150.0
2013-09-23 07:00:00	MSFT	Stock	32.83	32.83	32.8	32.8	5000.0
2013-09-23 07:30:00	MSFT	Stock	32.82	32.82	32.72	32.72	1500.0
2013-09-23 08:00:00	MSFT	Stock	32.69	32.84	32.66	32.73	8872.0
2013-09-23 08:30:00	MSFT	Stock	32.73	32.74	32.7	32.7	7290.0
2013-09-23 09:00:00	MSFT	Stock	32.72	32.72	32.51	32.54	72993.0
2013-09-23 09:30:00	MSFT	Stock	32.54	32.969	32.5	32.73	6760403.0
2013-09-23 10:00:00	MSFT	Stock	32.735	32.89	32.73	32.844	3240701.0
2013-09-23 10:30:00	MSFT	Stock	32.84	32.921	32.76	32.79	3169849.0
2013-09-23 11:00:00	MSFT	Stock	32.78	32.84	32.72	32.8	2328991.0
2013-09-23 11:30:00	MSFT	Stock	32.8	32.85	32.76	32.825	1851584.0
2013-09-23 12:00:00	MSFT	Stock	32.82	32.89	32.78	32.835	1924621.0
2013-09-23 12:30:00	MSFT	Stock	32.84	32.85	32.78	32.79	1146395.0
2013-09-23 13:00:00	MSFT	Stock	32.79	32.8	32.7	32.748	1592004.0
2013-09-23 13:30:00	MSFT	Stock	32.74	32.835	32.71	32.82	1585997.0
2013-09-23 14:00:00	MSFT	Stock	32.83	32.85	32.73	32.79	1647593.0
2013-09-23 14:30:00	MSFT	Stock	32.78	32.81	32.72	32.795	1397924.0
2013-09-23 15:00:00	MSFT	Stock	32.797	32.8	32.67	32.67	2162052.0

> showing 50 of 80,420 rows — these rows as CSV

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