PREVIEW / stock_30min / 2011-10-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-18.parquet
  size:    1.4 MB
  rows:    78,820
  symbols: 3,527

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
2011-10-18 04:00:00	AAPL	Stock	14.945	14.945	14.945	14.945	2800.0
2011-10-18 05:30:00	AAPL	Stock	14.9821	14.9907	14.9414	14.9414	18200.0
2011-10-18 06:30:00	AAPL	Stock	14.9464	14.9464	14.9464	14.9464	2800.0
2011-10-18 07:00:00	AAPL	Stock	14.9886	15.0089	14.9286	14.9732	162624.0
2011-10-18 07:30:00	AAPL	Stock	14.975	14.9821	14.9375	14.9375	438956.0
2011-10-18 08:00:00	AAPL	Stock	14.9561	15.06	14.9286	15.0536	1841840.0
2011-10-18 08:30:00	AAPL	Stock	15.0536	15.0714	15.0121	15.0618	2079084.0
2011-10-18 09:00:00	AAPL	Stock	15.0625	15.1029	15.05	15.0561	2760044.0
2011-10-18 09:30:00	AAPL	Stock	15.0629	15.0821	14.905	14.9732	80297672.0
2011-10-18 10:00:00	AAPL	Stock	14.9736	14.9779	14.8568	14.9325	63489636.0
2011-10-18 10:30:00	AAPL	Stock	14.9357	14.9964	14.9318	14.9881	42714140.0
2011-10-18 11:00:00	AAPL	Stock	14.989	14.9979	14.9407	14.9503	30675680.0
2011-10-18 11:30:00	AAPL	Stock	14.9493	15.0661	14.9493	15.0586	43560832.0
2011-10-18 12:00:00	AAPL	Stock	15.0598	15.0714	14.9943	15.0011	29860572.0
2011-10-18 12:30:00	AAPL	Stock	15.0018	15.0264	14.9617	14.9818	25352236.0
2011-10-18 13:00:00	AAPL	Stock	14.9843	14.9993	14.9143	14.9679	25308500.0
2011-10-18 13:30:00	AAPL	Stock	14.9682	15.0429	14.9657	15.0339	33736276.0
2011-10-18 14:00:00	AAPL	Stock	15.0364	15.05	15.0146	15.0416	31329172.0
2011-10-18 14:30:00	AAPL	Stock	15.0413	15.0571	15.0143	15.0254	30267468.0
2011-10-18 15:00:00	AAPL	Stock	15.0261	15.1717	15.0239	15.125	96408144.0
2011-10-18 15:30:00	AAPL	Stock	15.125	15.135	15.0232	15.0671	119284956.0
2011-10-18 16:00:00	AAPL	Stock	15.0557	15.2071	14.9652	15.1786	15551060.0
2011-10-18 16:30:00	AAPL	Stock	15.1857	15.1857	13.8896	14.1057	133878472.0
2011-10-18 17:00:00	AAPL	Stock	14.1061	15.08	14.0179	14.0221	36441888.0
2011-10-18 17:30:00	AAPL	Stock	14.0196	15.08	14.0039	14.0707	11967284.0
2011-10-18 18:00:00	AAPL	Stock	14.0714	15.08	14.0704	14.1425	5143544.0
2011-10-18 18:30:00	AAPL	Stock	14.1429	14.1607	14.0925	14.0982	2319632.0
2011-10-18 19:00:00	AAPL	Stock	14.1	14.1046	14.0643	14.0896	2889488.0
2011-10-18 19:30:00	AAPL	Stock	14.0857	14.1018	14.0679	14.0732	2896768.0
2011-10-18 06:30:00	MSFT	Stock	26.97	26.97	26.97	26.97	3000.0
2011-10-18 07:00:00	MSFT	Stock	26.86	26.93	26.8	26.87	5800.0
2011-10-18 07:30:00	MSFT	Stock	26.87	26.87	26.76	26.76	3400.0
2011-10-18 08:00:00	MSFT	Stock	26.78	26.88	26.75	26.88	31899.0
2011-10-18 08:30:00	MSFT	Stock	26.88	26.9	26.86	26.86	4400.0
2011-10-18 09:00:00	MSFT	Stock	26.86	26.95	26.85	26.91	56243.0
2011-10-18 09:30:00	MSFT	Stock	26.95	27.08	26.8	26.9	3240028.0
2011-10-18 10:00:00	MSFT	Stock	26.9	27.09	26.83	27.07	3611373.0
2011-10-18 10:30:00	MSFT	Stock	27.07	27.16	27.0	27.03	3091104.0
2011-10-18 11:00:00	MSFT	Stock	27.025	27.025	26.94	27.0	2393169.0
2011-10-18 11:30:00	MSFT	Stock	27.0	27.19	26.98	27.11	3044757.0
2011-10-18 12:00:00	MSFT	Stock	27.11	27.16	27.05	27.06	1944820.0
2011-10-18 12:30:00	MSFT	Stock	27.06	27.2	27.04	27.14	1906454.0
2011-10-18 13:00:00	MSFT	Stock	27.14	27.16	27.04	27.085	1361063.0
2011-10-18 13:30:00	MSFT	Stock	27.085	27.19	27.08	27.14	1909929.0
2011-10-18 14:00:00	MSFT	Stock	27.14	27.18	27.1	27.14	1655946.0
2011-10-18 14:30:00	MSFT	Stock	27.136	27.16	27.01	27.05	3895250.0
2011-10-18 15:00:00	MSFT	Stock	27.045	27.38	27.04	27.305	9428760.0
2011-10-18 15:30:00	MSFT	Stock	27.3	27.4	27.21	27.285	10859643.0
2011-10-18 16:00:00	MSFT	Stock	27.29	27.42	26.893	27.34	3158315.0
2011-10-18 16:30:00	MSFT	Stock	27.34	27.4	27.22	27.24	305490.0

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

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