PREVIEW / stock_30min / 2011-10-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-12.parquet
  size:    1.4 MB
  rows:    76,671
  symbols: 3,515

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-10-12 04:00:00	AAPL	Stock	14.375	14.4196	14.3571	14.4107	50792.0
2011-10-12 04:30:00	AAPL	Stock	14.4107	14.4157	14.4082	14.4082	42084.0
2011-10-12 05:00:00	AAPL	Stock	14.4139	14.4464	14.4036	14.4464	87780.0
2011-10-12 05:30:00	AAPL	Stock	14.4196	14.4518	14.4196	14.4518	43680.0
2011-10-12 06:00:00	AAPL	Stock	14.4518	14.4518	14.4286	14.4286	34972.0
2011-10-12 06:30:00	AAPL	Stock	14.4286	14.4286	14.4286	14.4286	8400.0
2011-10-12 07:00:00	AAPL	Stock	14.4143	14.4464	14.3929	14.4354	566832.0
2011-10-12 07:30:00	AAPL	Stock	14.4354	14.4475	14.3996	14.4036	489720.0
2011-10-12 08:00:00	AAPL	Stock	14.4036	14.4643	14.3929	14.4475	2607360.0
2011-10-12 08:30:00	AAPL	Stock	14.4532	14.5432	14.4432	14.5364	3755528.0
2011-10-12 09:00:00	AAPL	Stock	14.5407	14.5804	14.5293	14.5475	7528920.0
2011-10-12 09:30:00	AAPL	Stock	14.5482	14.6161	14.525	14.5957	109890900.0
2011-10-12 10:00:00	AAPL	Stock	14.5936	14.5979	14.4825	14.5	60691764.0
2011-10-12 10:30:00	AAPL	Stock	14.5	14.5632	14.4986	14.51	32085732.0
2011-10-12 11:00:00	AAPL	Stock	14.5104	14.5868	14.5093	14.57	28344400.0
2011-10-12 11:30:00	AAPL	Stock	14.57	14.5861	14.5307	14.5329	23236304.0
2011-10-12 12:00:00	AAPL	Stock	14.5329	14.5461	14.4896	14.5168	26584152.0
2011-10-12 12:30:00	AAPL	Stock	14.5186	14.5332	14.4725	14.5153	24357788.0
2011-10-12 13:00:00	AAPL	Stock	14.5145	14.56	14.5121	14.5391	20353004.0
2011-10-12 13:30:00	AAPL	Stock	14.5407	14.5536	14.4971	14.5093	17768828.0
2011-10-12 14:00:00	AAPL	Stock	14.5093	14.5357	14.4389	14.4564	35787500.0
2011-10-12 14:30:00	AAPL	Stock	14.4586	14.4821	14.3114	14.3333	75102664.0
2011-10-12 15:00:00	AAPL	Stock	14.3379	14.42	14.2907	14.4136	64475544.0
2011-10-12 15:30:00	AAPL	Stock	14.4134	14.4354	14.3521	14.3611	64058148.0
2011-10-12 16:00:00	AAPL	Stock	14.3607	14.5389	14.3525	14.3614	9274188.0
2011-10-12 16:30:00	AAPL	Stock	14.3604	14.4202	14.3432	14.3579	778904.0
2011-10-12 17:00:00	AAPL	Stock	14.3571	14.3593	14.3507	14.3518	456316.0
2011-10-12 17:30:00	AAPL	Stock	14.3518	14.3607	14.3507	14.3557	153468.0
2011-10-12 18:00:00	AAPL	Stock	14.3571	14.3643	14.3571	14.3614	148568.0
2011-10-12 18:30:00	AAPL	Stock	14.3614	14.3614	14.3536	14.3586	369348.0
2011-10-12 19:00:00	AAPL	Stock	14.3589	14.3643	14.3564	14.3571	110936.0
2011-10-12 19:30:00	AAPL	Stock	14.3607	14.3607	14.3518	14.3518	111132.0
2011-10-12 05:00:00	MSFT	Stock	27.11	27.11	27.11	27.11	100.0
2011-10-12 05:30:00	MSFT	Stock	27.25	27.25	27.25	27.25	200.0
2011-10-12 07:30:00	MSFT	Stock	27.18	27.21	27.15	27.15	1385.0
2011-10-12 08:00:00	MSFT	Stock	27.08	27.15	27.0	27.15	20335.0
2011-10-12 08:30:00	MSFT	Stock	27.0	27.19	27.0	27.16	102588.0
2011-10-12 09:00:00	MSFT	Stock	27.16	27.2	27.16	27.18	74125.0
2011-10-12 09:30:00	MSFT	Stock	27.18	27.19	26.95	26.98	5070683.0
2011-10-12 10:00:00	MSFT	Stock	26.99	27.14	26.93	27.115	3606452.0
2011-10-12 10:30:00	MSFT	Stock	27.12	27.305	27.09	27.11	4388690.0
2011-10-12 11:00:00	MSFT	Stock	27.11	27.2	27.08	27.168	2186202.0
2011-10-12 11:30:00	MSFT	Stock	27.17	27.22	27.111	27.13	1715537.0
2011-10-12 12:00:00	MSFT	Stock	27.13	27.16	27.1	27.14	1710447.0
2011-10-12 12:30:00	MSFT	Stock	27.14	27.26	27.105	27.23	2860870.0
2011-10-12 13:00:00	MSFT	Stock	27.225	27.3	27.22	27.225	2089830.0
2011-10-12 13:30:00	MSFT	Stock	27.23	27.29	27.12	27.155	2346965.0
2011-10-12 14:00:00	MSFT	Stock	27.15	27.285	27.13	27.25	2440478.0
2011-10-12 14:30:00	MSFT	Stock	27.24	27.31	27.15	27.19	2718745.0
2011-10-12 15:00:00	MSFT	Stock	27.195	27.26	27.14	27.21	3320280.0

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

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