PREVIEW / stock_30min / 2012-07-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-27.parquet
  size:    1.4 MB
  rows:    75,594
  symbols: 3,483

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-27 04:00:00	AAPL	Stock	20.5611	20.6425	20.5611	20.6025	36960.0
2012-07-27 04:30:00	AAPL	Stock	20.5936	20.5936	20.5575	20.5575	25200.0
2012-07-27 05:00:00	AAPL	Stock	20.5414	20.5414	20.5414	20.5414	2800.0
2012-07-27 05:30:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	25200.0
2012-07-27 06:30:00	AAPL	Stock	20.6068	20.6071	20.6036	20.6071	30520.0
2012-07-27 07:00:00	AAPL	Stock	20.6054	20.6071	20.5893	20.6032	201152.0
2012-07-27 07:30:00	AAPL	Stock	20.5954	20.5954	20.5571	20.5571	66920.0
2012-07-27 08:00:00	AAPL	Stock	20.5536	20.5571	20.5182	20.5339	564144.0
2012-07-27 08:30:00	AAPL	Stock	20.535	20.5536	20.4911	20.4946	1049104.0
2012-07-27 09:00:00	AAPL	Stock	20.4964	20.55	20.4861	20.5446	1230544.0
2012-07-27 09:30:00	AAPL	Stock	20.5361	20.5464	20.4139	20.4721	49419720.0
2012-07-27 10:00:00	AAPL	Stock	20.4718	20.5082	20.4379	20.4411	22993152.0
2012-07-27 10:30:00	AAPL	Stock	20.4429	20.5693	20.4361	20.5579	27192368.0
2012-07-27 11:00:00	AAPL	Stock	20.5586	20.6704	20.55	20.6507	35329252.0
2012-07-27 11:30:00	AAPL	Stock	20.6536	20.6957	20.6318	20.6739	25056528.0
2012-07-27 12:00:00	AAPL	Stock	20.675	20.6868	20.6325	20.6414	15827252.0
2012-07-27 12:30:00	AAPL	Stock	20.6439	20.685	20.6411	20.6643	11417056.0
2012-07-27 13:00:00	AAPL	Stock	20.6666	20.7857	20.6664	20.7796	30608788.0
2012-07-27 13:30:00	AAPL	Stock	20.7762	20.8446	20.6357	20.7793	39335100.0
2012-07-27 14:00:00	AAPL	Stock	20.7764	20.8132	20.76	20.7886	15838872.0
2012-07-27 14:30:00	AAPL	Stock	20.7864	20.8393	20.7832	20.8171	18025308.0
2012-07-27 15:00:00	AAPL	Stock	20.8164	20.9004	20.8143	20.8804	31788652.0
2012-07-27 15:30:00	AAPL	Stock	20.8771	20.9225	20.8721	20.9029	48425412.0
2012-07-27 16:00:00	AAPL	Stock	20.9089	20.9089	20.6925	20.8929	15491000.0
2012-07-27 16:30:00	AAPL	Stock	20.8939	20.8986	20.8911	20.8946	476644.0
2012-07-27 17:00:00	AAPL	Stock	20.8946	20.8996	20.8921	20.8982	281120.0
2012-07-27 17:30:00	AAPL	Stock	20.8957	20.8996	20.8954	20.8968	46620.0
2012-07-27 18:00:00	AAPL	Stock	20.8996	20.9018	20.8975	20.8986	42140.0
2012-07-27 18:30:00	AAPL	Stock	20.9	20.9	20.8964	20.8964	16240.0
2012-07-27 19:00:00	AAPL	Stock	20.8946	20.8946	20.8911	20.8929	45976.0
2012-07-27 19:30:00	AAPL	Stock	20.8929	20.9	20.8911	20.9	72800.0
2012-07-27 07:00:00	MSFT	Stock	29.21	29.21	29.21	29.21	500.0
2012-07-27 07:30:00	MSFT	Stock	29.32	29.34	29.3	29.34	500.0
2012-07-27 08:00:00	MSFT	Stock	29.23	29.32	29.23	29.27	1911.0
2012-07-27 08:30:00	MSFT	Stock	29.25	29.26	29.23	29.23	2640.0
2012-07-27 09:00:00	MSFT	Stock	29.28	29.48	29.28	29.44	59894.0
2012-07-27 09:30:00	MSFT	Stock	29.47	29.5	29.18	29.3	3493110.0
2012-07-27 10:00:00	MSFT	Stock	29.29	29.46	29.24	29.425	3209410.0
2012-07-27 10:30:00	MSFT	Stock	29.42	29.5	29.39	29.49	2538755.0
2012-07-27 11:00:00	MSFT	Stock	29.49	29.57	29.42	29.456	2284879.0
2012-07-27 11:30:00	MSFT	Stock	29.46	29.5	29.44	29.495	1733080.0
2012-07-27 12:00:00	MSFT	Stock	29.5	29.52	29.47	29.51	1670778.0
2012-07-27 12:30:00	MSFT	Stock	29.512	29.58	29.49	29.505	1533893.0
2012-07-27 13:00:00	MSFT	Stock	29.51	29.75	29.49	29.73	2635256.0
2012-07-27 13:30:00	MSFT	Stock	29.735	29.81	29.69	29.76	4365972.0
2012-07-27 14:00:00	MSFT	Stock	29.75	29.77	29.67	29.725	2971860.0
2012-07-27 14:30:00	MSFT	Stock	29.72	29.73	29.64	29.66	2502006.0
2012-07-27 15:00:00	MSFT	Stock	29.66	29.77	29.65	29.76	3089767.0
2012-07-27 15:30:00	MSFT	Stock	29.76	29.85	29.7	29.77	7222470.0
2012-07-27 16:00:00	MSFT	Stock	29.76	29.8	29.48	29.78	4580327.0

> showing 50 of 75,594 rows — these rows as CSV

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