PREVIEW / stock_30min / 2011-12-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-15.parquet
  size:    1.4 MB
  rows:    76,035
  symbols: 3,548

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-15 04:00:00	AAPL	Stock	13.5393	13.6071	13.5393	13.6071	28000.0
2011-12-15 04:30:00	AAPL	Stock	13.6111	13.63	13.6111	13.63	22400.0
2011-12-15 06:30:00	AAPL	Stock	13.6439	13.6439	13.6439	13.6439	15792.0
2011-12-15 07:00:00	AAPL	Stock	13.6436	13.7089	13.6393	13.7014	418964.0
2011-12-15 07:30:00	AAPL	Stock	13.6879	13.7143	13.6879	13.705	292908.0
2011-12-15 08:00:00	AAPL	Stock	13.6943	13.7196	13.6743	13.7032	1206688.0
2011-12-15 08:30:00	AAPL	Stock	13.7036	13.7321	13.7036	13.7214	1214024.0
2011-12-15 09:00:00	AAPL	Stock	13.7196	13.7211	13.6786	13.6943	1182104.0
2011-12-15 09:30:00	AAPL	Stock	13.6921	13.705	13.5893	13.6121	39470060.0
2011-12-15 10:00:00	AAPL	Stock	13.6136	13.6379	13.5657	13.6152	26667172.0
2011-12-15 10:30:00	AAPL	Stock	13.6161	13.6221	13.554	13.5793	23732380.0
2011-12-15 11:00:00	AAPL	Stock	13.5789	13.5861	13.5264	13.5829	15089788.0
2011-12-15 11:30:00	AAPL	Stock	13.5829	13.5996	13.5364	13.5446	15952944.0
2011-12-15 12:00:00	AAPL	Stock	13.5461	13.5931	13.5407	13.5811	11430132.0
2011-12-15 12:30:00	AAPL	Stock	13.5818	13.5893	13.5479	13.5572	11604488.0
2011-12-15 13:00:00	AAPL	Stock	13.5586	13.5804	13.5554	13.5679	8054200.0
2011-12-15 13:30:00	AAPL	Stock	13.5656	13.5782	13.5429	13.5646	10793608.0
2011-12-15 14:00:00	AAPL	Stock	13.5629	13.5768	13.551	13.5546	10451616.0
2011-12-15 14:30:00	AAPL	Stock	13.555	13.5639	13.5389	13.5418	14656796.0
2011-12-15 15:00:00	AAPL	Stock	13.5421	13.5593	13.5329	13.5432	18587492.0
2011-12-15 15:30:00	AAPL	Stock	13.5446	13.5564	13.5111	13.5314	31928876.0
2011-12-15 16:00:00	AAPL	Stock	13.5325	13.5793	13.5261	13.5364	11277812.0
2011-12-15 16:30:00	AAPL	Stock	13.5336	13.55	13.5332	13.5436	554596.0
2011-12-15 17:00:00	AAPL	Stock	13.5443	13.55	13.5429	13.55	58156.0
2011-12-15 17:30:00	AAPL	Stock	13.55	13.5529	13.55	13.5521	28168.0
2011-12-15 18:00:00	AAPL	Stock	13.5336	13.5536	13.5336	13.5536	38444.0
2011-12-15 18:30:00	AAPL	Stock	13.5532	13.5536	13.5532	13.5536	24668.0
2011-12-15 19:00:00	AAPL	Stock	13.5536	13.5571	13.5536	13.5546	40488.0
2011-12-15 19:30:00	AAPL	Stock	13.5596	13.5714	13.5596	13.5714	141736.0
2011-12-15 08:00:00	MSFT	Stock	25.72	25.72	25.67	25.7	4300.0
2011-12-15 08:30:00	MSFT	Stock	25.75	25.82	25.75	25.78	9524.0
2011-12-15 09:00:00	MSFT	Stock	25.8	25.8	25.59	25.69	126265.0
2011-12-15 09:30:00	MSFT	Stock	25.72	25.88	25.64	25.785	5909717.0
2011-12-15 10:00:00	MSFT	Stock	25.78	25.82	25.67	25.69	3450291.0
2011-12-15 10:30:00	MSFT	Stock	25.69	25.73	25.62	25.66	2635893.0
2011-12-15 11:00:00	MSFT	Stock	25.665	25.71	25.56	25.67	3124639.0
2011-12-15 11:30:00	MSFT	Stock	25.68	25.69	25.62	25.64	2153211.0
2011-12-15 12:00:00	MSFT	Stock	25.64	25.72	25.63	25.682	2480387.0
2011-12-15 12:30:00	MSFT	Stock	25.685	25.72	25.67	25.72	2347799.0
2011-12-15 13:00:00	MSFT	Stock	25.71	25.73	25.68	25.698	2191032.0
2011-12-15 13:30:00	MSFT	Stock	25.695	25.74	25.655	25.7	2441866.0
2011-12-15 14:00:00	MSFT	Stock	25.7	25.72	25.672	25.68	1554585.0
2011-12-15 14:30:00	MSFT	Stock	25.685	25.735	25.645	25.65	2704428.0
2011-12-15 15:00:00	MSFT	Stock	25.65	25.78	25.64	25.7	2809465.0
2011-12-15 15:30:00	MSFT	Stock	25.69	25.725	25.54	25.57	7089547.0
2011-12-15 16:00:00	MSFT	Stock	25.55	25.705	25.534	25.56	4301972.0
2011-12-15 16:30:00	MSFT	Stock	25.56	25.69	25.55	25.55	94767.0
2011-12-15 17:00:00	MSFT	Stock	25.705	25.705	25.59	25.59	82081.0
2011-12-15 17:30:00	MSFT	Stock	25.6	25.6	25.56	25.6	18545.0
2011-12-15 18:00:00	MSFT	Stock	25.6	25.6	25.56	25.56	5371.0

> showing 50 of 76,035 rows — these rows as CSV

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