PREVIEW / stock_30min / 2013-04-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-25.parquet
  size:    1.5 MB
  rows:    77,373
  symbols: 3,496

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-04-25 04:00:00	AAPL	Stock	14.5218	14.5354	14.5218	14.5243	42784.0
2013-04-25 04:30:00	AAPL	Stock	14.5232	14.5232	14.5136	14.5136	16800.0
2013-04-25 05:00:00	AAPL	Stock	14.5232	14.5261	14.5229	14.5229	25200.0
2013-04-25 05:30:00	AAPL	Stock	14.5261	14.5261	14.5261	14.5261	5600.0
2013-04-25 06:00:00	AAPL	Stock	14.525	14.5411	14.525	14.5411	82404.0
2013-04-25 06:30:00	AAPL	Stock	14.5625	14.5625	14.5625	14.5625	2800.0
2013-04-25 07:00:00	AAPL	Stock	14.5418	14.6207	14.535	14.5854	662088.0
2013-04-25 07:30:00	AAPL	Stock	14.5768	14.5768	14.5368	14.5625	114520.0
2013-04-25 08:00:00	AAPL	Stock	14.5518	14.6107	14.5271	14.6071	848988.0
2013-04-25 08:30:00	AAPL	Stock	14.6068	14.6393	14.6068	14.6161	1442616.0
2013-04-25 09:00:00	AAPL	Stock	14.6179	14.6982	14.5875	14.6982	2968952.0
2013-04-25 09:30:00	AAPL	Stock	14.6982	14.7836	14.5911	14.6129	85685852.0
2013-04-25 10:00:00	AAPL	Stock	14.6161	14.6429	14.5511	14.6096	35229404.0
2013-04-25 10:30:00	AAPL	Stock	14.6105	14.6286	14.5357	14.5732	30573928.0
2013-04-25 11:00:00	AAPL	Stock	14.5761	14.6686	14.5732	14.6457	26212088.0
2013-04-25 11:30:00	AAPL	Stock	14.6457	14.6804	14.5957	14.6179	21459676.0
2013-04-25 12:00:00	AAPL	Stock	14.6171	14.6679	14.6089	14.6609	11874352.0
2013-04-25 12:30:00	AAPL	Stock	14.6611	14.7211	14.6514	14.6782	26148836.0
2013-04-25 13:00:00	AAPL	Stock	14.6771	14.7004	14.6486	14.6869	13357876.0
2013-04-25 13:30:00	AAPL	Stock	14.6821	14.6978	14.6357	14.6654	12420156.0
2013-04-25 14:00:00	AAPL	Stock	14.6638	14.6686	14.6036	14.6079	16930116.0
2013-04-25 14:30:00	AAPL	Stock	14.6107	14.6489	14.5821	14.6043	14794304.0
2013-04-25 15:00:00	AAPL	Stock	14.6018	14.6071	14.5564	14.6071	20306468.0
2013-04-25 15:30:00	AAPL	Stock	14.6071	14.6304	14.5689	14.5964	27727504.0
2013-04-25 16:00:00	AAPL	Stock	14.5964	14.6411	14.5714	14.585	20527108.0
2013-04-25 16:30:00	AAPL	Stock	14.5857	14.6249	14.585	14.5857	234192.0
2013-04-25 17:00:00	AAPL	Stock	14.5857	14.5893	14.5761	14.5768	408632.0
2013-04-25 17:30:00	AAPL	Stock	14.5786	14.5832	14.5754	14.5768	104076.0
2013-04-25 18:00:00	AAPL	Stock	14.5786	14.5893	14.5786	14.5893	43596.0
2013-04-25 18:30:00	AAPL	Stock	14.5821	14.5882	14.5771	14.5882	48160.0
2013-04-25 19:00:00	AAPL	Stock	14.5807	14.5875	14.5804	14.5811	38500.0
2013-04-25 19:30:00	AAPL	Stock	14.585	14.5961	14.5846	14.5925	83580.0
2013-04-25 07:00:00	MSFT	Stock	31.82	31.82	31.82	31.82	2925.0
2013-04-25 07:30:00	MSFT	Stock	31.8	31.85	31.8	31.8	2178.0
2013-04-25 08:00:00	MSFT	Stock	31.78	31.85	31.76	31.77	7368.0
2013-04-25 08:30:00	MSFT	Stock	31.85	31.85	31.8	31.81	7202.0
2013-04-25 09:00:00	MSFT	Stock	31.82	31.83	31.69	31.73	35920.0
2013-04-25 09:30:00	MSFT	Stock	31.75	32.6	31.54	32.512	17681868.0
2013-04-25 10:00:00	MSFT	Stock	32.53	32.84	32.49	32.5	16257160.0
2013-04-25 10:30:00	MSFT	Stock	32.49	32.79	32.33	32.57	12954258.0
2013-04-25 11:00:00	MSFT	Stock	32.57	32.705	32.56	32.58	6092946.0
2013-04-25 11:30:00	MSFT	Stock	32.575	32.65	32.29	32.33	5801706.0
2013-04-25 12:00:00	MSFT	Stock	32.33	32.41	32.13	32.148	4925521.0
2013-04-25 12:30:00	MSFT	Stock	32.145	32.22	32.05	32.17	5488378.0
2013-04-25 13:00:00	MSFT	Stock	32.17	32.31	32.13	32.17	4075218.0
2013-04-25 13:30:00	MSFT	Stock	32.17	32.2	31.95	31.96	4770693.0
2013-04-25 14:00:00	MSFT	Stock	31.963	32.14	31.93	31.956	4677039.0
2013-04-25 14:30:00	MSFT	Stock	31.95	32.07	31.88	31.91	4591235.0
2013-04-25 15:00:00	MSFT	Stock	31.91	31.92	31.77	31.86	6126317.0
2013-04-25 15:30:00	MSFT	Stock	31.85	32.08	31.81	31.93	8375168.0

> showing 50 of 77,373 rows — these rows as CSV

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