PREVIEW / stock_30min / 2012-02-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-24.parquet
  size:    1.4 MB
  rows:    75,028
  symbols: 3,544

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-02-24 04:00:00	AAPL	Stock	18.48	18.5357	18.48	18.5357	102200.0
2012-02-24 04:30:00	AAPL	Stock	18.5461	18.5514	18.5357	18.5514	14000.0
2012-02-24 05:00:00	AAPL	Stock	18.5511	18.5714	18.5511	18.5643	31920.0
2012-02-24 05:30:00	AAPL	Stock	18.5475	18.5571	18.5393	18.5571	81340.0
2012-02-24 06:00:00	AAPL	Stock	18.5393	18.5393	18.5357	18.5357	16800.0
2012-02-24 06:30:00	AAPL	Stock	18.5357	18.5714	18.5357	18.54	35140.0
2012-02-24 07:00:00	AAPL	Stock	18.5411	18.5786	18.5232	18.5643	949480.0
2012-02-24 07:30:00	AAPL	Stock	18.5632	18.5632	18.5	18.5	380268.0
2012-02-24 08:00:00	AAPL	Stock	18.51	18.5639	18.4839	18.485	1259300.0
2012-02-24 08:30:00	AAPL	Stock	18.485	18.5264	18.4686	18.5125	1598548.0
2012-02-24 09:00:00	AAPL	Stock	18.5086	18.5643	18.5	18.5596	3036628.0
2012-02-24 09:30:00	AAPL	Stock	18.5636	18.6107	18.5229	18.5925	78319808.0
2012-02-24 10:00:00	AAPL	Stock	18.5861	18.5968	18.54	18.5596	37746492.0
2012-02-24 10:30:00	AAPL	Stock	18.5589	18.5793	18.5471	18.5718	25185524.0
2012-02-24 11:00:00	AAPL	Stock	18.5718	18.5893	18.5618	18.5657	21266308.0
2012-02-24 11:30:00	AAPL	Stock	18.5679	18.5804	18.5571	18.5721	14782488.0
2012-02-24 12:00:00	AAPL	Stock	18.5725	18.5918	18.5671	18.5854	13985832.0
2012-02-24 12:30:00	AAPL	Stock	18.585	18.6611	18.5782	18.6318	37936500.0
2012-02-24 13:00:00	AAPL	Stock	18.6314	18.675	18.6286	18.6525	24431036.0
2012-02-24 13:30:00	AAPL	Stock	18.6543	18.6586	18.6086	18.6193	17576048.0
2012-02-24 14:00:00	AAPL	Stock	18.6168	18.6404	18.6004	18.6046	14799540.0
2012-02-24 14:30:00	AAPL	Stock	18.6046	18.6086	18.5621	18.6043	27816600.0
2012-02-24 15:00:00	AAPL	Stock	18.605	18.6289	18.5907	18.6111	25429992.0
2012-02-24 15:30:00	AAPL	Stock	18.6118	18.6646	18.6029	18.6557	45838464.0
2012-02-24 16:00:00	AAPL	Stock	18.6575	18.6614	18.6493	18.6496	7918260.0
2012-02-24 16:30:00	AAPL	Stock	18.645	18.6575	18.6249	18.6357	608524.0
2012-02-24 17:00:00	AAPL	Stock	18.6418	18.6464	18.6332	18.6464	54712.0
2012-02-24 17:30:00	AAPL	Stock	18.6393	18.6446	18.6357	18.6446	80164.0
2012-02-24 18:00:00	AAPL	Stock	18.6446	18.6446	18.6411	18.6429	73556.0
2012-02-24 18:30:00	AAPL	Stock	18.6425	18.6446	18.6393	18.6429	88536.0
2012-02-24 19:00:00	AAPL	Stock	18.6393	18.6518	18.6357	18.6518	79436.0
2012-02-24 19:30:00	AAPL	Stock	18.6536	18.6536	18.6429	18.6432	90188.0
2012-02-24 07:00:00	MSFT	Stock	31.52	31.52	31.52	31.52	200.0
2012-02-24 07:30:00	MSFT	Stock	31.52	31.52	31.48	31.48	800.0
2012-02-24 08:00:00	MSFT	Stock	31.45	31.47	31.45	31.47	950.0
2012-02-24 08:30:00	MSFT	Stock	31.47	31.47	31.47	31.47	100.0
2012-02-24 09:00:00	MSFT	Stock	31.48	31.48	31.45	31.46	4560.0
2012-02-24 09:30:00	MSFT	Stock	31.47	31.49	31.24	31.4	4599069.0
2012-02-24 10:00:00	MSFT	Stock	31.395	31.49	31.28	31.29	3467767.0
2012-02-24 10:30:00	MSFT	Stock	31.295	31.35	31.28	31.29	1981178.0
2012-02-24 11:00:00	MSFT	Stock	31.295	31.4	31.29	31.392	2017807.0
2012-02-24 11:30:00	MSFT	Stock	31.39	31.425	31.37	31.42	1523677.0
2012-02-24 12:00:00	MSFT	Stock	31.42	31.43	31.38	31.428	1631213.0
2012-02-24 12:30:00	MSFT	Stock	31.425	31.46	31.41	31.435	1711733.0
2012-02-24 13:00:00	MSFT	Stock	31.43	31.45	31.39	31.395	1511120.0
2012-02-24 13:30:00	MSFT	Stock	31.395	31.44	31.37	31.434	1070873.0
2012-02-24 14:00:00	MSFT	Stock	31.436	31.495	31.43	31.44	1545748.0
2012-02-24 14:30:00	MSFT	Stock	31.445	31.46	31.37	31.4	2135357.0
2012-02-24 15:00:00	MSFT	Stock	31.395	31.48	31.39	31.44	2036107.0
2012-02-24 15:30:00	MSFT	Stock	31.435	31.5	31.4	31.49	4324348.0

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

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