PREVIEW / stock_30min / 2012-12-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-18.parquet
  size:    1.5 MB
  rows:    78,403
  symbols: 3,510

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-12-18 04:00:00	AAPL	Stock	18.7429	18.7918	18.7143	18.7164	103124.0
2012-12-18 04:30:00	AAPL	Stock	18.7143	18.7143	18.7071	18.7143	63560.0
2012-12-18 05:00:00	AAPL	Stock	18.7143	18.7161	18.7018	18.7079	37800.0
2012-12-18 05:30:00	AAPL	Stock	18.7018	18.7018	18.5911	18.6275	57400.0
2012-12-18 06:00:00	AAPL	Stock	18.6271	18.6429	18.6254	18.6429	52360.0
2012-12-18 06:30:00	AAPL	Stock	18.6429	18.6429	18.6071	18.6071	91532.0
2012-12-18 07:00:00	AAPL	Stock	18.5982	18.7425	18.5946	18.7321	1814932.0
2012-12-18 07:30:00	AAPL	Stock	18.7321	18.8214	18.7143	18.8125	2425892.0
2012-12-18 08:00:00	AAPL	Stock	18.8096	18.8518	18.7143	18.7775	6406064.0
2012-12-18 08:30:00	AAPL	Stock	18.7775	18.8136	18.7211	18.7264	3142440.0
2012-12-18 09:00:00	AAPL	Stock	18.7279	18.7768	18.6789	18.7457	3889732.0
2012-12-18 09:30:00	AAPL	Stock	18.7446	18.8	18.6168	18.6393	100175768.0
2012-12-18 10:00:00	AAPL	Stock	18.6289	18.7054	18.5804	18.6907	49554344.0
2012-12-18 10:30:00	AAPL	Stock	18.6939	18.7218	18.6018	18.6446	36912512.0
2012-12-18 11:00:00	AAPL	Stock	18.6493	18.7186	18.625	18.6793	29186976.0
2012-12-18 11:30:00	AAPL	Stock	18.685	18.855	18.6786	18.8204	46096568.0
2012-12-18 12:00:00	AAPL	Stock	18.8243	18.9239	18.7779	18.9043	42568988.0
2012-12-18 12:30:00	AAPL	Stock	18.9068	19.0279	18.8996	18.9982	54600504.0
2012-12-18 13:00:00	AAPL	Stock	19.0046	19.0046	18.9018	18.9541	31759280.0
2012-12-18 13:30:00	AAPL	Stock	18.9536	19.0179	18.9286	18.9393	26425868.0
2012-12-18 14:00:00	AAPL	Stock	18.9386	18.9871	18.8868	18.8964	24844260.0
2012-12-18 14:30:00	AAPL	Stock	18.8964	18.9596	18.8493	18.9568	32936400.0
2012-12-18 15:00:00	AAPL	Stock	18.9532	19.0514	18.9407	18.9588	40569004.0
2012-12-18 15:30:00	AAPL	Stock	18.9571	19.1036	18.9357	19.0661	67244800.0
2012-12-18 16:00:00	AAPL	Stock	19.0653	19.0857	18.63	19.0714	13296780.0
2012-12-18 16:30:00	AAPL	Stock	19.0157	19.035	18.7072	19.025	469560.0
2012-12-18 17:00:00	AAPL	Stock	19.0179	19.0621	18.6823	19.0536	534660.0
2012-12-18 17:30:00	AAPL	Stock	19.0525	19.0568	19.0275	19.0275	151368.0
2012-12-18 18:00:00	AAPL	Stock	19.0268	19.0493	19.0179	19.0464	162708.0
2012-12-18 18:30:00	AAPL	Stock	19.0446	19.0454	19.0357	19.0386	76048.0
2012-12-18 19:00:00	AAPL	Stock	19.0464	19.0464	19.0325	19.0357	267708.0
2012-12-18 19:30:00	AAPL	Stock	19.0396	19.0571	19.0336	19.0571	407792.0
2012-12-18 05:30:00	MSFT	Stock	27.19	27.19	27.19	27.19	100.0
2012-12-18 07:00:00	MSFT	Stock	27.2	27.22	27.2	27.22	600.0
2012-12-18 07:30:00	MSFT	Stock	27.21	27.25	27.21	27.24	2200.0
2012-12-18 08:00:00	MSFT	Stock	27.25	27.3	27.25	27.29	30710.0
2012-12-18 08:30:00	MSFT	Stock	27.27	27.31	27.09	27.29	65673.0
2012-12-18 09:00:00	MSFT	Stock	27.28	27.33	27.09	27.26	45925.0
2012-12-18 09:30:00	MSFT	Stock	27.25	27.29	27.15	27.18	4262906.0
2012-12-18 10:00:00	MSFT	Stock	27.17	27.26	27.14	27.25	4958756.0
2012-12-18 10:30:00	MSFT	Stock	27.245	27.43	27.24	27.355	3996126.0
2012-12-18 11:00:00	MSFT	Stock	27.35	27.47	27.3	27.39	4037180.0
2012-12-18 11:30:00	MSFT	Stock	27.4	27.49	27.36	27.44	2407583.0
2012-12-18 12:00:00	MSFT	Stock	27.44	27.45	27.38	27.395	1704350.0
2012-12-18 12:30:00	MSFT	Stock	27.395	27.5	27.39	27.495	2857450.0
2012-12-18 13:00:00	MSFT	Stock	27.495	27.5	27.37	27.42	2424334.0
2012-12-18 13:30:00	MSFT	Stock	27.42	27.5	27.4	27.5	2629397.0
2012-12-18 14:00:00	MSFT	Stock	27.5	27.54	27.45	27.47	2563706.0
2012-12-18 14:30:00	MSFT	Stock	27.47	27.49	27.44	27.456	2363284.0
2012-12-18 15:00:00	MSFT	Stock	27.46	27.51	27.45	27.455	3131717.0

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

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