PREVIEW / stock_30min / 2013-10-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-11.parquet
  size:    1.5 MB
  rows:    79,800
  symbols: 3,538

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-10-11 04:00:00	AAPL	Stock	17.4286	17.4286	17.4286	17.4286	2800.0
2013-10-11 04:30:00	AAPL	Stock	17.4589	17.4643	17.4589	17.4643	22400.0
2013-10-11 05:30:00	AAPL	Stock	17.4625	17.4625	17.4214	17.4443	8400.0
2013-10-11 06:30:00	AAPL	Stock	17.4196	17.4289	17.3714	17.4096	23884.0
2013-10-11 07:00:00	AAPL	Stock	17.4286	17.4286	17.3929	17.4121	121940.0
2013-10-11 07:30:00	AAPL	Stock	17.4129	17.4279	17.3996	17.3996	148764.0
2013-10-11 08:00:00	AAPL	Stock	17.4068	17.4371	17.35	17.375	1797656.0
2013-10-11 08:30:00	AAPL	Stock	17.3732	17.4871	17.37	17.3936	681576.0
2013-10-11 09:00:00	AAPL	Stock	17.3996	17.425	17.3736	17.3939	405496.0
2013-10-11 09:30:00	AAPL	Stock	17.3929	17.4464	17.3271	17.4414	44265620.0
2013-10-11 10:00:00	AAPL	Stock	17.4414	17.4532	17.3625	17.3957	20953688.0
2013-10-11 10:30:00	AAPL	Stock	17.3932	17.4004	17.3621	17.3864	12982592.0
2013-10-11 11:00:00	AAPL	Stock	17.3837	17.4246	17.38	17.4116	10163636.0
2013-10-11 11:30:00	AAPL	Stock	17.4086	17.5179	17.4039	17.512	21258216.0
2013-10-11 12:00:00	AAPL	Stock	17.5118	17.5496	17.503	17.5286	20467216.0
2013-10-11 12:30:00	AAPL	Stock	17.5282	17.5436	17.5211	17.5416	12701192.0
2013-10-11 13:00:00	AAPL	Stock	17.5382	17.5643	17.5254	17.5439	15088220.0
2013-10-11 13:30:00	AAPL	Stock	17.5443	17.6111	17.5368	17.6043	20335560.0
2013-10-11 14:00:00	AAPL	Stock	17.6046	17.6371	17.5896	17.6009	14493024.0
2013-10-11 14:30:00	AAPL	Stock	17.6046	17.6093	17.5793	17.5935	9436616.0
2013-10-11 15:00:00	AAPL	Stock	17.5932	17.6043	17.5607	17.5946	15668800.0
2013-10-11 15:30:00	AAPL	Stock	17.5946	17.6082	17.5839	17.605	31098340.0
2013-10-11 16:00:00	AAPL	Stock	17.605	17.6225	17.4003	17.6011	12150180.0
2013-10-11 16:30:00	AAPL	Stock	17.6004	17.6071	17.5875	17.6032	625800.0
2013-10-11 17:00:00	AAPL	Stock	17.6036	17.6036	17.5936	17.5964	111412.0
2013-10-11 17:30:00	AAPL	Stock	17.5964	17.6021	17.5943	17.5982	113372.0
2013-10-11 18:00:00	AAPL	Stock	17.5982	17.6068	17.5982	17.6064	79660.0
2013-10-11 18:30:00	AAPL	Stock	17.6036	17.6068	17.6036	17.6036	36232.0
2013-10-11 19:00:00	AAPL	Stock	17.6036	17.6125	17.6007	17.6125	78932.0
2013-10-11 19:30:00	AAPL	Stock	17.6143	17.6179	17.6	17.6179	178276.0
2013-10-11 07:00:00	MSFT	Stock	33.67	33.67	33.67	33.67	427.0
2013-10-11 08:00:00	MSFT	Stock	33.5	33.81	33.5	33.81	2835.0
2013-10-11 08:30:00	MSFT	Stock	33.76	33.76	33.64	33.64	59053.0
2013-10-11 09:00:00	MSFT	Stock	33.7	33.76	33.7	33.71	24968.0
2013-10-11 09:30:00	MSFT	Stock	33.68	33.99	33.68	33.96	3638267.0
2013-10-11 10:00:00	MSFT	Stock	33.96	33.99	33.74	33.86	2245184.0
2013-10-11 10:30:00	MSFT	Stock	33.85	33.93	33.82	33.93	2075524.0
2013-10-11 11:00:00	MSFT	Stock	33.92	33.98	33.88	33.91	1723688.0
2013-10-11 11:30:00	MSFT	Stock	33.9	34.06	33.89	34.06	2067042.0
2013-10-11 12:00:00	MSFT	Stock	34.05	34.13	34.02	34.02	2513317.0
2013-10-11 12:30:00	MSFT	Stock	34.025	34.06	34.0	34.02	1144096.0
2013-10-11 13:00:00	MSFT	Stock	34.02	34.06	33.96	33.975	1277461.0
2013-10-11 13:30:00	MSFT	Stock	33.97	34.04	33.97	34.03	921811.0
2013-10-11 14:00:00	MSFT	Stock	34.02	34.09	34.01	34.077	879890.0
2013-10-11 14:30:00	MSFT	Stock	34.077	34.09	34.0	34.02	1213306.0
2013-10-11 15:00:00	MSFT	Stock	34.02	34.08	34.0	34.055	2053530.0
2013-10-11 15:30:00	MSFT	Stock	34.055	34.14	34.02	34.13	4661172.0
2013-10-11 16:00:00	MSFT	Stock	34.13	34.16	33.723	34.13	2742656.0
2013-10-11 16:30:00	MSFT	Stock	34.1	34.16	34.03	34.13	194521.0
2013-10-11 17:00:00	MSFT	Stock	34.13	34.13	34.13	34.13	3730.0

> showing 50 of 79,800 rows — these rows as CSV

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