PREVIEW / stock_30min / 2010-01-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-11.parquet
  size:    1.4 MB
  rows:    74,042
  symbols: 3,441

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
2010-01-11 04:00:00	AAPL	Stock	7.6446	7.6554	7.6446	7.6554	19600.0
2010-01-11 04:30:00	AAPL	Stock	7.6554	7.6554	7.6554	7.6554	14000.0
2010-01-11 05:30:00	AAPL	Stock	7.6554	7.6554	7.6518	7.6518	14000.0
2010-01-11 06:00:00	AAPL	Stock	7.6511	7.6511	7.6425	7.6425	31360.0
2010-01-11 06:30:00	AAPL	Stock	7.6407	7.6407	7.6214	7.6214	39648.0
2010-01-11 07:00:00	AAPL	Stock	7.6179	7.625	7.6129	7.6154	131992.0
2010-01-11 07:30:00	AAPL	Stock	7.6182	7.6232	7.6075	7.6125	262724.0
2010-01-11 08:00:00	AAPL	Stock	7.6125	7.6243	7.5914	7.6179	1434076.0
2010-01-11 08:30:00	AAPL	Stock	7.6171	7.6175	7.6	7.6064	950460.0
2010-01-11 09:00:00	AAPL	Stock	7.6068	7.6068	7.6	7.6	573412.0
2010-01-11 09:30:00	AAPL	Stock	7.6036	7.6071	7.5268	7.5293	82941600.0
2010-01-11 10:00:00	AAPL	Stock	7.5307	7.55	7.4861	7.5064	58340912.0
2010-01-11 10:30:00	AAPL	Stock	7.5068	7.5157	7.4871	7.51	28335860.0
2010-01-11 11:00:00	AAPL	Stock	7.5089	7.5229	7.4946	7.4986	26223876.0
2010-01-11 11:30:00	AAPL	Stock	7.4994	7.5125	7.4786	7.5075	28097832.0
2010-01-11 12:00:00	AAPL	Stock	7.5079	7.5175	7.4843	7.4958	18068064.0
2010-01-11 12:30:00	AAPL	Stock	7.4946	7.5057	7.4825	7.4857	15914360.0
2010-01-11 13:00:00	AAPL	Stock	7.4857	7.4993	7.4739	7.4839	18995424.0
2010-01-11 13:30:00	AAPL	Stock	7.4839	7.4907	7.4714	7.4721	18356912.0
2010-01-11 14:00:00	AAPL	Stock	7.4721	7.4768	7.4536	7.4617	37679992.0
2010-01-11 14:30:00	AAPL	Stock	7.4618	7.4714	7.4446	7.4636	29977948.0
2010-01-11 15:00:00	AAPL	Stock	7.4625	7.4946	7.4618	7.4918	31703476.0
2010-01-11 15:30:00	AAPL	Stock	7.4917	7.5196	7.485	7.5025	50777692.0
2010-01-11 16:00:00	AAPL	Stock	7.5189	7.5189	7.4882	7.4925	10789996.0
2010-01-11 16:30:00	AAPL	Stock	7.4893	7.5039	7.4832	7.4857	420896.0
2010-01-11 17:00:00	AAPL	Stock	7.4825	7.4857	7.4821	7.4839	67816.0
2010-01-11 17:30:00	AAPL	Stock	7.4846	7.4857	7.4839	7.4854	49504.0
2010-01-11 18:00:00	AAPL	Stock	7.4839	7.5039	7.4768	7.4768	488096.0
2010-01-11 18:30:00	AAPL	Stock	7.4775	7.4846	7.4775	7.4821	41300.0
2010-01-11 19:00:00	AAPL	Stock	7.4854	7.4879	7.4818	7.4879	28868.0
2010-01-11 19:30:00	AAPL	Stock	7.4777	7.4839	7.4764	7.4764	119756.0
2010-01-11 04:00:00	MSFT	Stock	31.18	31.18	30.89	30.93	600.0
2010-01-11 07:00:00	MSFT	Stock	30.95	30.95	30.89	30.89	7300.0
2010-01-11 07:30:00	MSFT	Stock	30.89	30.89	30.89	30.89	1378.0
2010-01-11 08:00:00	MSFT	Stock	30.84	30.89	30.8	30.83	5523.0
2010-01-11 08:30:00	MSFT	Stock	30.83	30.85	30.72	30.72	12499.0
2010-01-11 09:00:00	MSFT	Stock	30.73	30.76	30.7	30.72	23764.0
2010-01-11 09:30:00	MSFT	Stock	30.72	30.8	30.5	30.54	8970158.0
2010-01-11 10:00:00	MSFT	Stock	30.54	30.59	30.33	30.348	5558722.0
2010-01-11 10:30:00	MSFT	Stock	30.342	30.46	30.3	30.4	4841873.0
2010-01-11 11:00:00	MSFT	Stock	30.41	30.41	30.12	30.29	4856617.0
2010-01-11 11:30:00	MSFT	Stock	30.285	30.39	30.26	30.39	2789803.0
2010-01-11 12:00:00	MSFT	Stock	30.39	30.45	30.31	30.35	3500448.0
2010-01-11 12:30:00	MSFT	Stock	30.35	30.35	30.23	30.24	2828731.0
2010-01-11 13:00:00	MSFT	Stock	30.24	30.24	30.14	30.165	3337786.0
2010-01-11 13:30:00	MSFT	Stock	30.16	30.22	30.15	30.21	2712023.0
2010-01-11 14:00:00	MSFT	Stock	30.2	30.23	30.16	30.19	2897904.0
2010-01-11 14:30:00	MSFT	Stock	30.2	30.21	30.16	30.195	1985700.0
2010-01-11 15:00:00	MSFT	Stock	30.19	30.29	30.18	30.28	4381349.0
2010-01-11 15:30:00	MSFT	Stock	30.27	30.34	30.19	30.28	13499738.0

> showing 50 of 74,042 rows — these rows as CSV

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