PREVIEW / stock_30min / 2012-07-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-26.parquet
  size:    1.4 MB
  rows:    74,615
  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
2012-07-26 04:00:00	AAPL	Stock	20.6071	20.6071	20.5536	20.5536	84980.0
2012-07-26 04:30:00	AAPL	Stock	20.5714	20.5714	20.5714	20.5714	2800.0
2012-07-26 05:00:00	AAPL	Stock	20.5536	20.5536	20.5536	20.5536	2800.0
2012-07-26 05:30:00	AAPL	Stock	20.5646	20.5646	20.5432	20.5432	44800.0
2012-07-26 06:00:00	AAPL	Stock	20.5411	20.6071	20.5411	20.6071	145796.0
2012-07-26 06:30:00	AAPL	Stock	20.6057	20.6571	20.6057	20.625	76272.0
2012-07-26 07:00:00	AAPL	Stock	20.625	20.7221	20.625	20.6786	1027544.0
2012-07-26 07:30:00	AAPL	Stock	20.6761	20.7411	20.675	20.7071	778540.0
2012-07-26 08:00:00	AAPL	Stock	20.7079	20.7321	20.6393	20.6504	1356460.0
2012-07-26 08:30:00	AAPL	Stock	20.6571	20.6704	20.5346	20.5789	4208232.0
2012-07-26 09:00:00	AAPL	Stock	20.5771	20.7307	20.5543	20.7079	3819060.0
2012-07-26 09:30:00	AAPL	Stock	20.7054	20.7286	20.5182	20.5396	71689828.0
2012-07-26 10:00:00	AAPL	Stock	20.5382	20.6375	20.5036	20.5664	46715956.0
2012-07-26 10:30:00	AAPL	Stock	20.5664	20.5993	20.4843	20.5246	40924436.0
2012-07-26 11:00:00	AAPL	Stock	20.5246	20.5475	20.4582	20.4759	23230704.0
2012-07-26 11:30:00	AAPL	Stock	20.475	20.4911	20.3929	20.4107	28163548.0
2012-07-26 12:00:00	AAPL	Stock	20.4086	20.485	20.37	20.4635	27601084.0
2012-07-26 12:30:00	AAPL	Stock	20.4671	20.5071	20.4486	20.5007	13682256.0
2012-07-26 13:00:00	AAPL	Stock	20.4996	20.5446	20.4907	20.5364	16202956.0
2012-07-26 13:30:00	AAPL	Stock	20.539	20.5682	20.4864	20.4904	15976856.0
2012-07-26 14:00:00	AAPL	Stock	20.4929	20.5396	20.4857	20.5045	16524620.0
2012-07-26 14:30:00	AAPL	Stock	20.5029	20.5654	20.4671	20.5418	19444964.0
2012-07-26 15:00:00	AAPL	Stock	20.5422	20.5625	20.5054	20.5353	17234140.0
2012-07-26 15:30:00	AAPL	Stock	20.5336	20.5682	20.5064	20.5236	33741036.0
2012-07-26 16:00:00	AAPL	Stock	20.517	20.5821	20.4821	20.5125	8087968.0
2012-07-26 16:30:00	AAPL	Stock	20.505	20.5318	20.4964	20.4964	186508.0
2012-07-26 17:00:00	AAPL	Stock	20.4861	20.5314	20.4746	20.4989	394688.0
2012-07-26 17:30:00	AAPL	Stock	20.4964	20.4964	20.4904	20.4911	65548.0
2012-07-26 18:00:00	AAPL	Stock	20.4914	20.4925	20.4886	20.4925	65604.0
2012-07-26 18:30:00	AAPL	Stock	20.4911	20.5132	20.4911	20.5107	22232.0
2012-07-26 19:00:00	AAPL	Stock	20.5061	20.5143	20.5036	20.5107	44380.0
2012-07-26 19:30:00	AAPL	Stock	20.5164	20.5179	20.5	20.5175	119980.0
2012-07-26 06:30:00	MSFT	Stock	28.88	28.88	28.88	28.88	200.0
2012-07-26 07:00:00	MSFT	Stock	28.96	29.39	28.96	29.13	5700.0
2012-07-26 07:30:00	MSFT	Stock	29.16	29.21	29.05	29.05	4340.0
2012-07-26 08:00:00	MSFT	Stock	29.1	29.17	29.1	29.16	39340.0
2012-07-26 08:30:00	MSFT	Stock	29.16	29.23	28.83	29.14	55848.0
2012-07-26 09:00:00	MSFT	Stock	29.12	29.25	29.1	29.23	99508.0
2012-07-26 09:30:00	MSFT	Stock	29.23	29.5	29.17	29.17	5579569.0
2012-07-26 10:00:00	MSFT	Stock	29.17	29.375	29.1	29.321	4132552.0
2012-07-26 10:30:00	MSFT	Stock	29.33	29.37	29.15	29.19	3499102.0
2012-07-26 11:00:00	MSFT	Stock	29.2	29.23	29.105	29.14	2882961.0
2012-07-26 11:30:00	MSFT	Stock	29.14	29.18	29.09	29.16	2263541.0
2012-07-26 12:00:00	MSFT	Stock	29.16	29.21	29.12	29.18	1620797.0
2012-07-26 12:30:00	MSFT	Stock	29.18	29.23	29.115	29.22	1612443.0
2012-07-26 13:00:00	MSFT	Stock	29.21	29.28	29.2	29.226	1667766.0
2012-07-26 13:30:00	MSFT	Stock	29.225	29.28	29.11	29.13	2785458.0
2012-07-26 14:00:00	MSFT	Stock	29.136	29.21	29.12	29.135	1913701.0
2012-07-26 14:30:00	MSFT	Stock	29.13	29.22	29.12	29.185	1968944.0
2012-07-26 15:00:00	MSFT	Stock	29.185	29.21	29.13	29.193	2650834.0

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

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