PREVIEW / stock_30min / 2011-08-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-19.parquet
  size:    1.4 MB
  rows:    77,076
  symbols: 3,534

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-08-19 04:00:00	AAPL	Stock	13.1018	13.1018	12.8396	12.8396	20132.0
2011-08-19 04:30:00	AAPL	Stock	12.8929	12.9286	12.8929	12.9286	39200.0
2011-08-19 05:00:00	AAPL	Stock	12.9357	12.9643	12.9357	12.9643	11200.0
2011-08-19 05:30:00	AAPL	Stock	12.9357	12.9414	12.9189	12.9414	51240.0
2011-08-19 06:00:00	AAPL	Stock	12.9546	12.9546	12.9286	12.9286	11200.0
2011-08-19 06:30:00	AAPL	Stock	12.9146	12.9286	12.8929	12.9032	44912.0
2011-08-19 07:00:00	AAPL	Stock	12.9286	12.9607	12.9286	12.95	467908.0
2011-08-19 07:30:00	AAPL	Stock	12.9564	13.0329	12.9564	13.0268	468860.0
2011-08-19 08:00:00	AAPL	Stock	13.0039	13.0604	12.9643	13.0143	2587480.0
2011-08-19 08:30:00	AAPL	Stock	13.0182	13.0218	12.9343	12.9489	2291240.0
2011-08-19 09:00:00	AAPL	Stock	12.9504	12.9639	12.9054	12.9204	3448004.0
2011-08-19 09:30:00	AAPL	Stock	12.9346	13.0939	12.9111	13.0507	145328400.0
2011-08-19 10:00:00	AAPL	Stock	13.0504	13.1071	13.0061	13.0741	73711260.0
2011-08-19 10:30:00	AAPL	Stock	13.0768	13.1068	13.0086	13.0268	47250644.0
2011-08-19 11:00:00	AAPL	Stock	13.0254	13.0429	12.9507	12.9743	37865604.0
2011-08-19 11:30:00	AAPL	Stock	12.9768	13.0279	12.9568	13.0268	38582012.0
2011-08-19 12:00:00	AAPL	Stock	13.02	13.0289	12.9643	12.9893	23477608.0
2011-08-19 12:30:00	AAPL	Stock	12.99	13.0089	12.9754	12.9796	21670880.0
2011-08-19 13:00:00	AAPL	Stock	12.9831	12.9896	12.9236	12.9446	26380760.0
2011-08-19 13:30:00	AAPL	Stock	12.9454	12.95	12.8775	12.8821	34476008.0
2011-08-19 14:00:00	AAPL	Stock	12.8832	12.8939	12.7571	12.7979	71950060.0
2011-08-19 14:30:00	AAPL	Stock	12.7996	12.8568	12.7607	12.7943	53650324.0
2011-08-19 15:00:00	AAPL	Stock	12.7954	12.8282	12.7379	12.8039	62683572.0
2011-08-19 15:30:00	AAPL	Stock	12.8039	12.8071	12.7143	12.7171	97288772.0
2011-08-19 16:00:00	AAPL	Stock	12.7167	13.0732	12.6839	12.6961	11202184.0
2011-08-19 16:30:00	AAPL	Stock	12.6961	12.9865	12.6961	12.7089	2493456.0
2011-08-19 17:00:00	AAPL	Stock	12.7121	12.75	12.7071	12.7443	688324.0
2011-08-19 17:30:00	AAPL	Stock	12.7446	12.775	12.7393	12.7429	341852.0
2011-08-19 18:00:00	AAPL	Stock	12.7361	12.7496	12.7154	12.7489	162652.0
2011-08-19 18:30:00	AAPL	Stock	12.7482	12.7643	12.7471	12.75	196056.0
2011-08-19 19:00:00	AAPL	Stock	12.7571	12.7643	12.7571	12.7643	50512.0
2011-08-19 19:30:00	AAPL	Stock	12.7643	12.7643	12.75	12.75	80668.0
2011-08-19 04:00:00	MSFT	Stock	24.55	24.55	24.5	24.5	3400.0
2011-08-19 05:30:00	MSFT	Stock	24.5	24.5	24.5	24.5	100.0
2011-08-19 06:30:00	MSFT	Stock	24.45	24.45	24.36	24.36	2000.0
2011-08-19 07:00:00	MSFT	Stock	24.45	24.45	24.4	24.4	1223.0
2011-08-19 07:30:00	MSFT	Stock	24.44	24.57	24.44	24.57	14610.0
2011-08-19 08:00:00	MSFT	Stock	24.54	24.67	24.54	24.6	14400.0
2011-08-19 08:30:00	MSFT	Stock	24.6	24.6	24.46	24.56	69882.0
2011-08-19 09:00:00	MSFT	Stock	24.56	24.65	24.4	24.41	84673.0
2011-08-19 09:30:00	MSFT	Stock	24.42	24.62	24.26	24.38	17061095.0
2011-08-19 10:00:00	MSFT	Stock	24.38	24.6	24.32	24.56	6862917.0
2011-08-19 10:30:00	MSFT	Stock	24.558	24.57	24.24	24.36	4754593.0
2011-08-19 11:00:00	MSFT	Stock	24.35	24.41	24.24	24.27	3867157.0
2011-08-19 11:30:00	MSFT	Stock	24.27	24.39	24.2	24.38	3583904.0
2011-08-19 12:00:00	MSFT	Stock	24.38	24.39	24.25	24.295	2357901.0
2011-08-19 12:30:00	MSFT	Stock	24.295	24.338	24.25	24.26	3120803.0
2011-08-19 13:00:00	MSFT	Stock	24.26	24.318	24.2	24.22	2682155.0
2011-08-19 13:30:00	MSFT	Stock	24.21	24.23	24.07	24.143	3044810.0
2011-08-19 14:00:00	MSFT	Stock	24.15	24.18	23.91	24.03	5757654.0

> showing 50 of 77,076 rows — these rows as CSV

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