PREVIEW / stock_30min / 2012-08-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-01.parquet
  size:    1.4 MB
  rows:    74,774
  symbols: 3,459

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-08-01 04:00:00	AAPL	Stock	21.8571	21.9286	21.8571	21.9286	44800.0
2012-08-01 04:30:00	AAPL	Stock	21.8929	21.8929	21.8839	21.8839	14000.0
2012-08-01 05:00:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	25200.0
2012-08-01 05:30:00	AAPL	Stock	21.875	21.875	21.875	21.875	5600.0
2012-08-01 06:00:00	AAPL	Stock	21.875	21.8929	21.875	21.8929	17416.0
2012-08-01 06:30:00	AAPL	Stock	21.8929	21.9036	21.8929	21.8929	19516.0
2012-08-01 07:00:00	AAPL	Stock	21.8786	21.9604	21.8786	21.9286	960456.0
2012-08-01 07:30:00	AAPL	Stock	21.9289	21.9571	21.9032	21.9571	310688.0
2012-08-01 08:00:00	AAPL	Stock	21.9464	22.0129	21.8129	22.0111	3172316.0
2012-08-01 08:30:00	AAPL	Stock	22.0111	22.0475	22.0014	22.04	2164344.0
2012-08-01 09:00:00	AAPL	Stock	22.0396	22.0643	21.9832	21.9946	2967720.0
2012-08-01 09:30:00	AAPL	Stock	21.9966	22.0143	21.81	21.8239	62461644.0
2012-08-01 10:00:00	AAPL	Stock	21.8214	21.8868	21.76	21.8425	39479272.0
2012-08-01 10:30:00	AAPL	Stock	21.8461	21.8689	21.7414	21.7686	28025172.0
2012-08-01 11:00:00	AAPL	Stock	21.7689	21.7975	21.6724	21.7052	25659256.0
2012-08-01 11:30:00	AAPL	Stock	21.7045	21.7193	21.6268	21.6807	21971740.0
2012-08-01 12:00:00	AAPL	Stock	21.68	21.75	21.6536	21.7189	15720628.0
2012-08-01 12:30:00	AAPL	Stock	21.7231	21.7493	21.6893	21.7089	9951004.0
2012-08-01 13:00:00	AAPL	Stock	21.7054	21.7461	21.7	21.712	11805920.0
2012-08-01 13:30:00	AAPL	Stock	21.7089	21.7121	21.6557	21.6625	8038632.0
2012-08-01 14:00:00	AAPL	Stock	21.6625	21.7929	21.5357	21.7929	42610120.0
2012-08-01 14:30:00	AAPL	Stock	21.7904	21.7929	21.7171	21.7782	26022080.0
2012-08-01 15:00:00	AAPL	Stock	21.7812	21.8461	21.7429	21.8289	26797372.0
2012-08-01 15:30:00	AAPL	Stock	21.8354	21.8404	21.6532	21.6729	40517148.0
2012-08-01 16:00:00	AAPL	Stock	21.6718	21.7601	21.6429	21.6607	5996368.0
2012-08-01 16:30:00	AAPL	Stock	21.6607	21.8446	21.6607	21.6696	400372.0
2012-08-01 17:00:00	AAPL	Stock	21.6824	21.6824	21.6679	21.6721	77000.0
2012-08-01 17:30:00	AAPL	Stock	21.6729	21.675	21.6682	21.6682	53340.0
2012-08-01 18:00:00	AAPL	Stock	21.6686	21.6714	21.6607	21.6661	129976.0
2012-08-01 18:30:00	AAPL	Stock	21.6643	21.6679	21.6611	21.6611	106820.0
2012-08-01 19:00:00	AAPL	Stock	21.6618	21.6679	21.6607	21.6675	47684.0
2012-08-01 19:30:00	AAPL	Stock	21.6732	21.6786	21.6725	21.6754	135128.0
2012-08-01 06:30:00	MSFT	Stock	29.54	29.54	29.54	29.54	132.0
2012-08-01 08:00:00	MSFT	Stock	29.55	29.65	29.45	29.62	6870.0
2012-08-01 08:30:00	MSFT	Stock	29.64	29.72	29.47	29.66	68631.0
2012-08-01 09:00:00	MSFT	Stock	29.7	29.73	29.6	29.6	22490.0
2012-08-01 09:30:00	MSFT	Stock	29.61	29.65	29.34	29.39	2550381.0
2012-08-01 10:00:00	MSFT	Stock	29.39	29.55	29.355	29.38	2360417.0
2012-08-01 10:30:00	MSFT	Stock	29.39	29.51	29.37	29.48	2058358.0
2012-08-01 11:00:00	MSFT	Stock	29.49	29.54	29.42	29.469	2354485.0
2012-08-01 11:30:00	MSFT	Stock	29.47	29.51	29.46	29.49	1247710.0
2012-08-01 12:00:00	MSFT	Stock	29.485	29.56	29.48	29.54	1588436.0
2012-08-01 12:30:00	MSFT	Stock	29.53	29.59	29.47	29.5	1975306.0
2012-08-01 13:00:00	MSFT	Stock	29.51	29.55	29.49	29.53	1589977.0
2012-08-01 13:30:00	MSFT	Stock	29.53	29.53	29.41	29.42	1570460.0
2012-08-01 14:00:00	MSFT	Stock	29.43	29.44	29.21	29.395	3277800.0
2012-08-01 14:30:00	MSFT	Stock	29.4	29.41	29.29	29.35	1615388.0
2012-08-01 15:00:00	MSFT	Stock	29.35	29.5	29.32	29.48	2375400.0
2012-08-01 15:30:00	MSFT	Stock	29.49	29.53	29.36	29.41	4336611.0
2012-08-01 16:00:00	MSFT	Stock	29.41	29.443	29.4	29.41	1530948.0

> showing 50 of 74,774 rows — these rows as CSV

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