PREVIEW / stock_30min / 2011-09-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-01.parquet
  size:    1.4 MB
  rows:    74,435
  symbols: 3,490

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-09-01 04:30:00	AAPL	Stock	13.7511	13.7511	13.7511	13.7511	2800.0
2011-09-01 07:00:00	AAPL	Stock	13.7454	13.7604	13.7343	13.7604	84000.0
2011-09-01 07:30:00	AAPL	Stock	13.7582	13.7664	13.7432	13.7471	98028.0
2011-09-01 08:00:00	AAPL	Stock	13.7532	13.7711	13.7229	13.7618	948752.0
2011-09-01 08:30:00	AAPL	Stock	13.76	13.8443	13.75	13.8304	1701000.0
2011-09-01 09:00:00	AAPL	Stock	13.83	13.8321	13.7439	13.785	1532468.0
2011-09-01 09:30:00	AAPL	Stock	13.7854	13.8164	13.7089	13.7507	46973360.0
2011-09-01 10:00:00	AAPL	Stock	13.7511	13.8336	13.7364	13.7739	44575132.0
2011-09-01 10:30:00	AAPL	Stock	13.7743	13.7764	13.7375	13.7421	29137528.0
2011-09-01 11:00:00	AAPL	Stock	13.7439	13.7618	13.7182	13.7404	24690456.0
2011-09-01 11:30:00	AAPL	Stock	13.74	13.7618	13.7289	13.7577	13824580.0
2011-09-01 12:00:00	AAPL	Stock	13.7575	13.7582	13.7143	13.7411	13250440.0
2011-09-01 12:30:00	AAPL	Stock	13.7418	13.7482	13.7029	13.7071	13635216.0
2011-09-01 13:00:00	AAPL	Stock	13.7036	13.7064	13.6571	13.6732	21129556.0
2011-09-01 13:30:00	AAPL	Stock	13.6732	13.6775	13.6304	13.6429	19776120.0
2011-09-01 14:00:00	AAPL	Stock	13.6404	13.65	13.5971	13.6243	22463700.0
2011-09-01 14:30:00	AAPL	Stock	13.6246	13.66	13.6243	13.6443	15710604.0
2011-09-01 15:00:00	AAPL	Stock	13.6436	13.6507	13.61	13.6311	22417416.0
2011-09-01 15:30:00	AAPL	Stock	13.6314	13.6429	13.6068	13.6125	34611836.0
2011-09-01 16:00:00	AAPL	Stock	13.6082	13.7439	13.6068	13.6089	10695580.0
2011-09-01 16:30:00	AAPL	Stock	13.6089	13.6311	13.5975	13.6054	142380.0
2011-09-01 17:00:00	AAPL	Stock	13.7455	13.7455	13.6036	13.6107	2720312.0
2011-09-01 17:30:00	AAPL	Stock	13.6143	13.6229	13.6089	13.6107	106400.0
2011-09-01 18:00:00	AAPL	Stock	13.6143	13.6143	13.6082	13.6121	157780.0
2011-09-01 18:30:00	AAPL	Stock	13.6107	13.6107	13.5918	13.6018	228368.0
2011-09-01 19:00:00	AAPL	Stock	13.6046	13.6046	13.5886	13.5975	53200.0
2011-09-01 19:30:00	AAPL	Stock	13.5982	13.6018	13.5946	13.5964	93520.0
2011-09-01 07:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	100.0
2011-09-01 07:30:00	MSFT	Stock	26.45	26.45	26.45	26.45	200.0
2011-09-01 08:00:00	MSFT	Stock	26.5	26.6	26.46	26.5	24395.0
2011-09-01 08:30:00	MSFT	Stock	26.51	26.55	26.51	26.54	1521.0
2011-09-01 09:00:00	MSFT	Stock	26.55	26.58	26.42	26.47	22541.0
2011-09-01 09:30:00	MSFT	Stock	26.46	26.8	26.4	26.61	5958730.0
2011-09-01 10:00:00	MSFT	Stock	26.6	26.86	26.53	26.55	7121525.0
2011-09-01 10:30:00	MSFT	Stock	26.55	26.595	26.45	26.45	4379291.0
2011-09-01 11:00:00	MSFT	Stock	26.45	26.48	26.39	26.43	3655042.0
2011-09-01 11:30:00	MSFT	Stock	26.431	26.54	26.42	26.505	2892368.0
2011-09-01 12:00:00	MSFT	Stock	26.5	26.505	26.39	26.423	2413492.0
2011-09-01 12:30:00	MSFT	Stock	26.421	26.46	26.36	26.36	2574625.0
2011-09-01 13:00:00	MSFT	Stock	26.36	26.41	26.33	26.37	3070335.0
2011-09-01 13:30:00	MSFT	Stock	26.37	26.38	26.24	26.313	3295207.0
2011-09-01 14:00:00	MSFT	Stock	26.31	26.339	26.24	26.325	3274729.0
2011-09-01 14:30:00	MSFT	Stock	26.32	26.39	26.22	26.265	5438261.0
2011-09-01 15:00:00	MSFT	Stock	26.27	26.35	26.225	26.295	3704548.0
2011-09-01 15:30:00	MSFT	Stock	26.295	26.32	26.21	26.23	6449804.0
2011-09-01 16:00:00	MSFT	Stock	26.24	26.6	26.21	26.25	5101089.0
2011-09-01 16:30:00	MSFT	Stock	26.22	26.345	26.14	26.14	4889.0
2011-09-01 17:00:00	MSFT	Stock	26.645	26.645	26.11	26.2	797036.0
2011-09-01 18:00:00	MSFT	Stock	26.15	26.21	26.15	26.21	10803.0
2011-09-01 19:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	500.0

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

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