PREVIEW / stock_30min / 2010-05-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-03.parquet
  size:    1.5 MB
  rows:    78,672
  symbols: 3,505

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-05-03 04:00:00	AAPL	Stock	9.3704	9.3704	9.3704	9.3704	2800.0
2010-05-03 06:00:00	AAPL	Stock	9.3429	9.3429	9.3318	9.3396	22400.0
2010-05-03 06:30:00	AAPL	Stock	9.3396	9.3679	9.3396	9.3679	64400.0
2010-05-03 07:00:00	AAPL	Stock	9.3814	9.4071	9.3814	9.3968	58800.0
2010-05-03 07:30:00	AAPL	Stock	9.3932	9.4179	9.3839	9.4161	479080.0
2010-05-03 08:00:00	AAPL	Stock	9.4161	9.4446	9.3246	9.4414	1843324.0
2010-05-03 08:30:00	AAPL	Stock	9.4382	9.4536	9.3246	9.4496	2058756.0
2010-05-03 09:00:00	AAPL	Stock	9.4486	9.4486	9.4079	9.4186	2721320.0
2010-05-03 09:30:00	AAPL	Stock	9.4229	9.4571	9.3886	9.4339	79046632.0
2010-05-03 10:00:00	AAPL	Stock	9.4339	9.5318	9.425	9.5105	56198884.0
2010-05-03 10:30:00	AAPL	Stock	9.5093	9.5196	9.4771	9.5041	34690096.0
2010-05-03 11:00:00	AAPL	Stock	9.5021	9.5118	9.4739	9.5054	21331212.0
2010-05-03 11:30:00	AAPL	Stock	9.5065	9.5271	9.4932	9.5154	22852004.0
2010-05-03 12:00:00	AAPL	Stock	9.5161	9.5536	9.5025	9.5514	31734500.0
2010-05-03 12:30:00	AAPL	Stock	9.5525	9.5571	9.5311	9.5568	21568204.0
2010-05-03 13:00:00	AAPL	Stock	9.5571	9.5579	9.5411	9.5489	14606200.0
2010-05-03 13:30:00	AAPL	Stock	9.5492	9.5671	9.5475	9.5593	14549052.0
2010-05-03 14:00:00	AAPL	Stock	9.5593	9.5611	9.4893	9.5511	37080932.0
2010-05-03 14:30:00	AAPL	Stock	9.5504	9.5521	9.5286	9.5479	18278652.0
2010-05-03 15:00:00	AAPL	Stock	9.5482	9.55	9.4964	9.5052	27489364.0
2010-05-03 15:30:00	AAPL	Stock	9.505	9.5307	9.5	9.5129	47712056.0
2010-05-03 16:00:00	AAPL	Stock	9.5143	9.5309	9.5005	9.5057	8117620.0
2010-05-03 16:30:00	AAPL	Stock	9.5088	9.5147	9.3257	9.4911	3939852.0
2010-05-03 17:00:00	AAPL	Stock	9.4982	9.5	9.4893	9.4964	352604.0
2010-05-03 17:30:00	AAPL	Stock	9.4946	9.4964	9.4861	9.4964	155596.0
2010-05-03 18:00:00	AAPL	Stock	9.4964	9.5125	9.4929	9.4989	208768.0
2010-05-03 18:30:00	AAPL	Stock	9.4936	9.4996	9.4843	9.4861	252448.0
2010-05-03 19:00:00	AAPL	Stock	9.4929	9.4982	9.4875	9.4879	190288.0
2010-05-03 19:30:00	AAPL	Stock	9.4875	9.5	9.4829	9.4911	158452.0
2010-05-03 07:30:00	MSFT	Stock	30.7	30.91	30.68	30.9	21634.0
2010-05-03 08:00:00	MSFT	Stock	30.76	30.76	30.69	30.7	15981.0
2010-05-03 08:30:00	MSFT	Stock	30.7	30.72	30.535	30.67	7512.0
2010-05-03 09:00:00	MSFT	Stock	30.69	30.7	30.54	30.67	101310.0
2010-05-03 09:30:00	MSFT	Stock	30.67	30.75	30.58	30.69	5013670.0
2010-05-03 10:00:00	MSFT	Stock	30.7	30.75	30.62	30.72	2531816.0
2010-05-03 10:30:00	MSFT	Stock	30.715	30.72	30.65	30.69	1788076.0
2010-05-03 11:00:00	MSFT	Stock	30.69	30.725	30.68	30.705	2682998.0
2010-05-03 11:30:00	MSFT	Stock	30.71	30.83	30.7	30.8	2612696.0
2010-05-03 12:00:00	MSFT	Stock	30.8	30.98	30.785	30.96	2981261.0
2010-05-03 12:30:00	MSFT	Stock	30.96	30.99	30.8	30.98	2482433.0
2010-05-03 13:00:00	MSFT	Stock	30.98	30.99	30.719	30.942	1887539.0
2010-05-03 13:30:00	MSFT	Stock	30.948	30.99	30.94	30.97	1911168.0
2010-05-03 14:00:00	MSFT	Stock	30.97	31.061	30.97	30.982	2550149.0
2010-05-03 14:30:00	MSFT	Stock	30.99	30.99	30.92	30.94	1876769.0
2010-05-03 15:00:00	MSFT	Stock	30.94	30.98	30.9	30.95	3093210.0
2010-05-03 15:30:00	MSFT	Stock	30.942	30.98	30.85	30.86	7085128.0
2010-05-03 16:00:00	MSFT	Stock	30.86	30.88	30.841	30.857	2877625.0
2010-05-03 16:30:00	MSFT	Stock	30.938	30.938	30.54	30.84	1810973.0
2010-05-03 17:00:00	MSFT	Stock	30.86	30.86	30.84	30.85	1317.0
2010-05-03 17:30:00	MSFT	Stock	30.85	30.85	30.82	30.82	5300.0

> showing 50 of 78,672 rows — these rows as CSV

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