PREVIEW / stock_30min / 2010-12-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-14.parquet
  size:    1.4 MB
  rows:    75,419
  symbols: 3,529

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-12-14 04:00:00	AAPL	Stock	11.5	11.5	11.4768	11.4768	27440.0
2010-12-14 04:30:00	AAPL	Stock	11.4893	11.4893	11.4718	11.4718	14000.0
2010-12-14 05:00:00	AAPL	Stock	11.4718	11.5164	11.4718	11.5154	42000.0
2010-12-14 05:30:00	AAPL	Stock	11.5143	11.5357	11.5143	11.5357	44800.0
2010-12-14 06:00:00	AAPL	Stock	11.5089	11.5179	11.5089	11.5179	36400.0
2010-12-14 06:30:00	AAPL	Stock	11.525	11.5357	11.5157	11.5157	31920.0
2010-12-14 07:00:00	AAPL	Stock	11.5196	11.5214	11.4821	11.49	381248.0
2010-12-14 07:30:00	AAPL	Stock	11.4893	11.5161	11.4679	11.4821	631820.0
2010-12-14 08:00:00	AAPL	Stock	11.4857	11.4875	11.4386	11.4589	2140096.0
2010-12-14 08:30:00	AAPL	Stock	11.4586	11.4796	11.4539	11.4754	986664.0
2010-12-14 09:00:00	AAPL	Stock	11.4754	11.4868	11.4571	11.4807	2004968.0
2010-12-14 09:30:00	AAPL	Stock	11.4821	11.5036	11.4039	11.4425	62065864.0
2010-12-14 10:00:00	AAPL	Stock	11.4443	11.5193	11.4429	11.495	48326768.0
2010-12-14 10:30:00	AAPL	Stock	11.4957	11.5089	11.4732	11.4732	16373224.0
2010-12-14 11:00:00	AAPL	Stock	11.4732	11.4936	11.4607	11.4878	14009436.0
2010-12-14 11:30:00	AAPL	Stock	11.4876	11.4907	11.4718	11.4786	8914892.0
2010-12-14 12:00:00	AAPL	Stock	11.4786	11.4857	11.4714	11.4768	7727468.0
2010-12-14 12:30:00	AAPL	Stock	11.4789	11.4811	11.4718	11.4754	7281232.0
2010-12-14 13:00:00	AAPL	Stock	11.4757	11.4989	11.4739	11.4932	8501444.0
2010-12-14 13:30:00	AAPL	Stock	11.4954	11.5121	11.4868	11.4939	13316016.0
2010-12-14 14:00:00	AAPL	Stock	11.4943	11.5057	11.4586	11.4739	18668552.0
2010-12-14 14:30:00	AAPL	Stock	11.4721	11.4911	11.4393	11.4646	25831736.0
2010-12-14 15:00:00	AAPL	Stock	11.4646	11.4818	11.4125	11.4257	32102812.0
2010-12-14 15:30:00	AAPL	Stock	11.425	11.4425	11.3929	11.4379	54864964.0
2010-12-14 16:00:00	AAPL	Stock	11.4382	11.4592	11.4282	11.4393	10457328.0
2010-12-14 16:30:00	AAPL	Stock	11.4393	11.4393	11.4049	11.4293	585760.0
2010-12-14 17:00:00	AAPL	Stock	11.4293	11.4304	11.4232	11.4304	438284.0
2010-12-14 17:30:00	AAPL	Stock	11.4286	11.4389	11.4286	11.43	95228.0
2010-12-14 18:00:00	AAPL	Stock	11.4286	11.4389	11.425	11.4379	239624.0
2010-12-14 18:30:00	AAPL	Stock	11.4371	11.4389	11.43	11.4386	215740.0
2010-12-14 19:00:00	AAPL	Stock	11.4354	11.4354	11.4325	11.4325	24024.0
2010-12-14 19:30:00	AAPL	Stock	11.4386	11.4411	11.4304	11.4411	111076.0
2010-12-14 04:30:00	MSFT	Stock	27.2	27.2	27.2	27.2	100.0
2010-12-14 05:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	552.0
2010-12-14 05:30:00	MSFT	Stock	27.28	27.28	27.28	27.28	100.0
2010-12-14 07:00:00	MSFT	Stock	27.28	27.28	27.28	27.28	375.0
2010-12-14 07:30:00	MSFT	Stock	27.28	27.28	27.21	27.28	600.0
2010-12-14 08:00:00	MSFT	Stock	27.24	27.24	27.21	27.24	4848.0
2010-12-14 08:30:00	MSFT	Stock	27.21	27.21	27.21	27.21	952.0
2010-12-14 09:00:00	MSFT	Stock	27.24	27.31	27.0	27.31	69296.0
2010-12-14 09:30:00	MSFT	Stock	27.31	27.42	27.26	27.41	6238376.0
2010-12-14 10:00:00	MSFT	Stock	27.405	27.5	27.39	27.49	5805950.0
2010-12-14 10:30:00	MSFT	Stock	27.48	27.49	27.445	27.48	3567061.0
2010-12-14 11:00:00	MSFT	Stock	27.48	27.5	27.46	27.49	2788124.0
2010-12-14 11:30:00	MSFT	Stock	27.49	27.612	27.48	27.612	4676026.0
2010-12-14 12:00:00	MSFT	Stock	27.62	27.68	27.59	27.63	3468590.0
2010-12-14 12:30:00	MSFT	Stock	27.64	27.66	27.6	27.66	2275135.0
2010-12-14 13:00:00	MSFT	Stock	27.66	27.68	27.63	27.662	2328471.0
2010-12-14 13:30:00	MSFT	Stock	27.67	27.68	27.64	27.678	1935743.0
2010-12-14 14:00:00	MSFT	Stock	27.675	27.68	27.61	27.62	4035052.0

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

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