PREVIEW / stock_30min / 2013-06-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-27.parquet
  size:    1.5 MB
  rows:    81,525
  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
2013-06-27 05:00:00	AAPL	Stock	14.2054	14.2054	14.2054	14.2054	2800.0
2013-06-27 05:30:00	AAPL	Stock	14.2018	14.2018	14.2	14.2	14000.0
2013-06-27 06:30:00	AAPL	Stock	14.2143	14.2143	14.2143	14.2143	2800.0
2013-06-27 07:00:00	AAPL	Stock	14.2232	14.2232	14.1868	14.1868	60312.0
2013-06-27 07:30:00	AAPL	Stock	14.1868	14.2429	14.1732	14.2429	232204.0
2013-06-27 08:00:00	AAPL	Stock	14.2321	14.2714	14.1929	14.2643	686560.0
2013-06-27 08:30:00	AAPL	Stock	14.2675	14.2696	14.2332	14.2493	574812.0
2013-06-27 09:00:00	AAPL	Stock	14.2493	14.2682	14.2361	14.2411	518420.0
2013-06-27 09:30:00	AAPL	Stock	14.2589	14.2621	14.1272	14.2514	53151784.0
2013-06-27 10:00:00	AAPL	Stock	14.2514	14.3296	14.2036	14.3043	42090804.0
2013-06-27 10:30:00	AAPL	Stock	14.3075	14.3354	14.225	14.2425	28682780.0
2013-06-27 11:00:00	AAPL	Stock	14.2464	14.2621	14.1643	14.1686	19122824.0
2013-06-27 11:30:00	AAPL	Stock	14.17	14.1857	14.1432	14.1779	16694440.0
2013-06-27 12:00:00	AAPL	Stock	14.1781	14.1925	14.1593	14.1639	11576264.0
2013-06-27 12:30:00	AAPL	Stock	14.1644	14.1757	14.1468	14.1679	8033312.0
2013-06-27 13:00:00	AAPL	Stock	14.1688	14.1821	14.1318	14.1339	13189512.0
2013-06-27 13:30:00	AAPL	Stock	14.1339	14.1382	14.0893	14.0993	22569372.0
2013-06-27 14:00:00	AAPL	Stock	14.1004	14.1244	14.0714	14.1079	20670944.0
2013-06-27 14:30:00	AAPL	Stock	14.1087	14.1429	14.0857	14.1062	13804588.0
2013-06-27 15:00:00	AAPL	Stock	14.1071	14.1121	14.0854	14.1072	14123172.0
2013-06-27 15:30:00	AAPL	Stock	14.1082	14.1125	14.055	14.0641	36890700.0
2013-06-27 16:00:00	AAPL	Stock	14.0636	14.2281	14.0518	14.0582	27168540.0
2013-06-27 16:30:00	AAPL	Stock	14.0536	14.1054	14.0414	14.0464	451388.0
2013-06-27 17:00:00	AAPL	Stock	14.0496	14.0539	14.0357	14.0361	374500.0
2013-06-27 17:30:00	AAPL	Stock	14.0361	14.0468	14.0286	14.0357	209776.0
2013-06-27 18:00:00	AAPL	Stock	14.055	14.055	14.055	14.055	53676.0
2013-06-27 18:30:00	AAPL	Stock	14.0536	14.06	14.0536	14.06	33600.0
2013-06-27 19:00:00	AAPL	Stock	14.05	14.0536	14.05	14.0536	14420.0
2013-06-27 19:30:00	AAPL	Stock	14.0504	14.0536	14.0482	14.0536	106680.0
2013-06-27 04:00:00	MSFT	Stock	34.39	34.39	34.36	34.36	500.0
2013-06-27 07:30:00	MSFT	Stock	34.39	34.39	34.39	34.39	200.0
2013-06-27 08:00:00	MSFT	Stock	34.35	34.45	34.35	34.43	4060.0
2013-06-27 08:30:00	MSFT	Stock	34.49	34.55	34.46	34.46	5018.0
2013-06-27 09:00:00	MSFT	Stock	34.49	34.55	34.48	34.49	9900.0
2013-06-27 09:30:00	MSFT	Stock	34.5	34.78	34.5	34.72	3177234.0
2013-06-27 10:00:00	MSFT	Stock	34.72	34.75	34.62	34.62	2774960.0
2013-06-27 10:30:00	MSFT	Stock	34.625	34.68	34.6	34.63	2152617.0
2013-06-27 11:00:00	MSFT	Stock	34.63	34.675	34.57	34.57	1891546.0
2013-06-27 11:30:00	MSFT	Stock	34.56	34.7	34.52	34.69	2407397.0
2013-06-27 12:00:00	MSFT	Stock	34.691	34.7	34.56	34.575	1495949.0
2013-06-27 12:30:00	MSFT	Stock	34.58	34.66	34.56	34.609	1100846.0
2013-06-27 13:00:00	MSFT	Stock	34.6	34.65	34.57	34.6	1628242.0
2013-06-27 13:30:00	MSFT	Stock	34.6	34.71	34.592	34.63	959935.0
2013-06-27 14:00:00	MSFT	Stock	34.62	34.63	34.51	34.58	1127301.0
2013-06-27 14:30:00	MSFT	Stock	34.58	34.65	34.55	34.59	916359.0
2013-06-27 15:00:00	MSFT	Stock	34.59	34.63	34.53	34.615	1335321.0
2013-06-27 15:30:00	MSFT	Stock	34.61	34.63	34.54	34.61	4270192.0
2013-06-27 16:00:00	MSFT	Stock	34.62	34.653	34.3	34.6	3066956.0
2013-06-27 16:30:00	MSFT	Stock	34.62	34.627	34.61	34.61	16866.0
2013-06-27 17:00:00	MSFT	Stock	34.61	34.61	34.52	34.52	2100.0

> showing 50 of 81,525 rows — these rows as CSV

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