PREVIEW / stock_30min / 2013-12-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-19.parquet
  size:    1.6 MB
  rows:    82,246
  symbols: 3,532

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
2013-12-19 04:00:00	AAPL	Stock	19.6786	19.7014	19.6429	19.6429	62692.0
2013-12-19 04:30:00	AAPL	Stock	19.6571	19.6571	19.6571	19.6571	2800.0
2013-12-19 05:00:00	AAPL	Stock	19.6518	19.6518	19.6446	19.6446	14000.0
2013-12-19 05:30:00	AAPL	Stock	19.6439	19.6518	19.6439	19.6518	24416.0
2013-12-19 06:00:00	AAPL	Stock	19.6429	19.6429	19.6429	19.6429	2800.0
2013-12-19 06:30:00	AAPL	Stock	19.6404	19.6404	19.6232	19.6232	11200.0
2013-12-19 07:00:00	AAPL	Stock	19.6132	19.6179	19.5643	19.5643	119224.0
2013-12-19 07:30:00	AAPL	Stock	19.5696	19.6375	19.5625	19.6314	176316.0
2013-12-19 08:00:00	AAPL	Stock	19.5982	19.6575	19.5661	19.6575	515816.0
2013-12-19 08:30:00	AAPL	Stock	19.6479	19.6571	19.5939	19.6393	566720.0
2013-12-19 09:00:00	AAPL	Stock	19.6314	19.65	19.6121	19.6154	716492.0
2013-12-19 09:30:00	AAPL	Stock	19.6154	19.6429	19.4839	19.5182	43343888.0
2013-12-19 10:00:00	AAPL	Stock	19.5182	19.6046	19.4929	19.5821	32893448.0
2013-12-19 10:30:00	AAPL	Stock	19.583	19.6225	19.5089	19.5239	24789128.0
2013-12-19 11:00:00	AAPL	Stock	19.5257	19.5746	19.5032	19.5214	17874640.0
2013-12-19 11:30:00	AAPL	Stock	19.5191	19.5618	19.5089	19.5096	12321484.0
2013-12-19 12:00:00	AAPL	Stock	19.5104	19.5196	19.4679	19.4925	14415772.0
2013-12-19 12:30:00	AAPL	Stock	19.4914	19.5018	19.4407	19.4729	21710612.0
2013-12-19 13:00:00	AAPL	Stock	19.4732	19.4854	19.4189	19.4689	18390512.0
2013-12-19 13:30:00	AAPL	Stock	19.4657	19.4925	19.4475	19.4614	9319604.0
2013-12-19 14:00:00	AAPL	Stock	19.4639	19.4804	19.4329	19.4432	8118684.0
2013-12-19 14:30:00	AAPL	Stock	19.4446	19.5261	19.4339	19.4989	15166340.0
2013-12-19 15:00:00	AAPL	Stock	19.4964	19.5025	19.4468	19.4505	10594248.0
2013-12-19 15:30:00	AAPL	Stock	19.4497	19.4632	19.4286	19.4446	23814140.0
2013-12-19 16:00:00	AAPL	Stock	19.4461	19.5405	19.4239	19.4321	16613324.0
2013-12-19 16:30:00	AAPL	Stock	19.4293	19.5445	19.4218	19.4282	291396.0
2013-12-19 17:00:00	AAPL	Stock	19.445	19.4489	19.4179	19.4179	869092.0
2013-12-19 17:30:00	AAPL	Stock	19.4179	19.445	19.4036	19.4111	283556.0
2013-12-19 18:00:00	AAPL	Stock	19.4268	19.4411	19.42	19.4411	239120.0
2013-12-19 18:30:00	AAPL	Stock	19.4304	19.4414	19.4304	19.4393	55804.0
2013-12-19 19:00:00	AAPL	Stock	19.4364	19.4364	19.4304	19.4361	23772.0
2013-12-19 19:30:00	AAPL	Stock	19.4432	19.4432	19.4321	19.4321	22120.0
2013-12-19 06:00:00	MSFT	Stock	36.55	36.55	36.55	36.55	200.0
2013-12-19 07:30:00	MSFT	Stock	36.53	36.54	36.53	36.54	669.0
2013-12-19 08:00:00	MSFT	Stock	36.57	36.58	36.57	36.58	793.0
2013-12-19 08:30:00	MSFT	Stock	36.57	36.58	36.45	36.46	5500.0
2013-12-19 09:00:00	MSFT	Stock	36.5	36.64	36.47	36.55	16414.0
2013-12-19 09:30:00	MSFT	Stock	36.51	36.55	36.195	36.285	4233881.0
2013-12-19 10:00:00	MSFT	Stock	36.28	36.43	36.25	36.34	2880201.0
2013-12-19 10:30:00	MSFT	Stock	36.34	36.355	36.195	36.27	2435552.0
2013-12-19 11:00:00	MSFT	Stock	36.27	36.37	36.25	36.36	1633039.0
2013-12-19 11:30:00	MSFT	Stock	36.36	36.41	36.33	36.38	2389610.0
2013-12-19 12:00:00	MSFT	Stock	36.375	36.39	36.25	36.255	1551458.0
2013-12-19 12:30:00	MSFT	Stock	36.254	36.27	36.2	36.2	1219120.0
2013-12-19 13:00:00	MSFT	Stock	36.205	36.24	36.16	36.224	1580947.0
2013-12-19 13:30:00	MSFT	Stock	36.22	36.26	36.16	36.22	1391164.0
2013-12-19 14:00:00	MSFT	Stock	36.219	36.29	36.132	36.132	1777345.0
2013-12-19 14:30:00	MSFT	Stock	36.14	36.21	36.135	36.18	2080008.0
2013-12-19 15:00:00	MSFT	Stock	36.18	36.21	36.08	36.1	2421213.0
2013-12-19 15:30:00	MSFT	Stock	36.1	36.3	36.08	36.26	4479852.0

> showing 50 of 82,246 rows — these rows as CSV

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