PREVIEW / stock_30min / 2011-12-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-09.parquet
  size:    1.4 MB
  rows:    75,585
  symbols: 3,537

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-12-09 04:00:00	AAPL	Stock	14.0	14.0179	14.0	14.0179	8400.0
2011-12-09 05:00:00	AAPL	Stock	14.0339	14.0339	14.0339	14.0339	9072.0
2011-12-09 05:30:00	AAPL	Stock	14.0321	14.0357	14.0321	14.0357	35000.0
2011-12-09 06:00:00	AAPL	Stock	14.0621	14.0621	14.0475	14.0536	22120.0
2011-12-09 06:30:00	AAPL	Stock	14.06	14.0636	14.06	14.0636	22400.0
2011-12-09 07:00:00	AAPL	Stock	14.0579	14.0925	14.0536	14.0786	366044.0
2011-12-09 07:30:00	AAPL	Stock	14.0696	14.0718	14.0464	14.0536	305620.0
2011-12-09 08:00:00	AAPL	Stock	14.0539	14.0625	14.0107	14.0271	648312.0
2011-12-09 08:30:00	AAPL	Stock	14.0286	14.0336	14.01	14.02	1197000.0
2011-12-09 09:00:00	AAPL	Stock	14.0218	14.0357	14.0125	14.0264	975996.0
2011-12-09 09:30:00	AAPL	Stock	14.0271	14.0657	13.9743	14.0086	49501760.0
2011-12-09 10:00:00	AAPL	Stock	14.0125	14.0457	13.9654	14.0025	33934012.0
2011-12-09 10:30:00	AAPL	Stock	14.0025	14.0343	13.9718	14.0342	25453456.0
2011-12-09 11:00:00	AAPL	Stock	14.0314	14.04	14.0129	14.0221	18372340.0
2011-12-09 11:30:00	AAPL	Stock	14.0225	14.0454	14.0114	14.0332	16125396.0
2011-12-09 12:00:00	AAPL	Stock	14.0343	14.0525	14.0179	14.0371	13533744.0
2011-12-09 12:30:00	AAPL	Stock	14.0357	14.0532	14.0321	14.0407	10149916.0
2011-12-09 13:00:00	AAPL	Stock	14.0414	14.0518	14.0229	14.0496	11619160.0
2011-12-09 13:30:00	AAPL	Stock	14.0496	14.0571	14.0286	14.0321	10473568.0
2011-12-09 14:00:00	AAPL	Stock	14.0329	14.0479	14.0286	14.0379	12194252.0
2011-12-09 14:30:00	AAPL	Stock	14.0357	14.0482	14.0286	14.0386	14495740.0
2011-12-09 15:00:00	AAPL	Stock	14.0393	14.0696	14.0304	14.0696	23285780.0
2011-12-09 15:30:00	AAPL	Stock	14.0694	14.0729	14.045	14.0589	43821540.0
2011-12-09 16:00:00	AAPL	Stock	14.058	14.0693	14.0081	14.0081	7443912.0
2011-12-09 16:30:00	AAPL	Stock	14.0643	14.0711	14.0579	14.0711	852824.0
2011-12-09 17:00:00	AAPL	Stock	14.0664	14.0711	14.0629	14.0654	94976.0
2011-12-09 17:30:00	AAPL	Stock	14.0664	14.0696	14.0654	14.0679	91280.0
2011-12-09 18:00:00	AAPL	Stock	14.0693	14.0821	14.0579	14.0804	185836.0
2011-12-09 18:30:00	AAPL	Stock	14.0786	14.0786	14.0786	14.0786	47404.0
2011-12-09 19:00:00	AAPL	Stock	14.0804	14.0804	14.0804	14.0804	2800.0
2011-12-09 19:30:00	AAPL	Stock	14.0754	14.0871	14.0754	14.0757	101108.0
2011-12-09 06:00:00	MSFT	Stock	25.63	25.67	25.63	25.67	1600.0
2011-12-09 06:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2011-12-09 07:00:00	MSFT	Stock	25.69	25.7	25.61	25.61	5600.0
2011-12-09 07:30:00	MSFT	Stock	25.64	25.64	25.58	25.6	6100.0
2011-12-09 08:00:00	MSFT	Stock	25.61	25.63	25.54	25.54	35559.0
2011-12-09 08:30:00	MSFT	Stock	25.54	25.55	25.46	25.48	504750.0
2011-12-09 09:00:00	MSFT	Stock	25.5	25.54	25.47	25.52	22433.0
2011-12-09 09:30:00	MSFT	Stock	25.52	25.765	25.49	25.68	6991323.0
2011-12-09 10:00:00	MSFT	Stock	25.685	25.845	25.67	25.75	4501978.0
2011-12-09 10:30:00	MSFT	Stock	25.745	25.83	25.7	25.82	4083836.0
2011-12-09 11:00:00	MSFT	Stock	25.821	25.85	25.77	25.84	3726738.0
2011-12-09 11:30:00	MSFT	Stock	25.835	25.85	25.76	25.78	2114852.0
2011-12-09 12:00:00	MSFT	Stock	25.78	25.8	25.74	25.8	1791857.0
2011-12-09 12:30:00	MSFT	Stock	25.8	25.84	25.77	25.8	2775467.0
2011-12-09 13:00:00	MSFT	Stock	25.805	25.82	25.76	25.82	1241005.0
2011-12-09 13:30:00	MSFT	Stock	25.815	25.85	25.8	25.832	2301645.0
2011-12-09 14:00:00	MSFT	Stock	25.83	25.85	25.75	25.845	2237055.0
2011-12-09 14:30:00	MSFT	Stock	25.845	25.87	25.801	25.822	4070416.0
2011-12-09 15:00:00	MSFT	Stock	25.827	25.83	25.74	25.79	4057557.0

> showing 50 of 75,585 rows — these rows as CSV

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