PREVIEW / stock_30min / 2010-04-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-09.parquet
  size:    1.4 MB
  rows:    73,732
  symbols: 3,475

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-04-09 04:00:00	AAPL	Stock	8.5893	8.6071	8.5893	8.6071	28000.0
2010-04-09 04:30:00	AAPL	Stock	8.6304	8.6304	8.6304	8.6304	5600.0
2010-04-09 05:00:00	AAPL	Stock	8.6418	8.6646	8.6418	8.6643	22400.0
2010-04-09 06:00:00	AAPL	Stock	8.6357	8.6511	8.6357	8.6511	23184.0
2010-04-09 07:00:00	AAPL	Stock	8.6429	8.6511	8.625	8.625	254968.0
2010-04-09 07:30:00	AAPL	Stock	8.6321	8.635	8.625	8.625	192052.0
2010-04-09 08:00:00	AAPL	Stock	8.6232	8.625	8.6064	8.6093	1082564.0
2010-04-09 08:30:00	AAPL	Stock	8.6107	8.6143	8.5986	8.6107	1366876.0
2010-04-09 09:00:00	AAPL	Stock	8.6121	8.6243	8.5825	8.6225	1258236.0
2010-04-09 09:30:00	AAPL	Stock	8.6204	8.6239	8.5879	8.6168	70309904.0
2010-04-09 10:00:00	AAPL	Stock	8.6179	8.6304	8.5993	8.6043	46725224.0
2010-04-09 10:30:00	AAPL	Stock	8.6043	8.6211	8.5982	8.6039	27760068.0
2010-04-09 11:00:00	AAPL	Stock	8.6025	8.6211	8.5982	8.6179	17707760.0
2010-04-09 11:30:00	AAPL	Stock	8.6168	8.6232	8.6079	8.6082	15994832.0
2010-04-09 12:00:00	AAPL	Stock	8.6082	8.6179	8.6079	8.6125	8462048.0
2010-04-09 12:30:00	AAPL	Stock	8.6125	8.6146	8.6	8.605	10660104.0
2010-04-09 13:00:00	AAPL	Stock	8.605	8.6068	8.5918	8.5989	13639220.0
2010-04-09 13:30:00	AAPL	Stock	8.5992	8.6118	8.5929	8.5946	11863964.0
2010-04-09 14:00:00	AAPL	Stock	8.5943	8.6118	8.5893	8.6103	12395796.0
2010-04-09 14:30:00	AAPL	Stock	8.6103	8.6179	8.6039	8.6131	12759460.0
2010-04-09 15:00:00	AAPL	Stock	8.6125	8.6339	8.6054	8.6339	22564640.0
2010-04-09 15:30:00	AAPL	Stock	8.6329	8.6386	8.6207	8.6386	50752884.0
2010-04-09 16:00:00	AAPL	Stock	8.6375	8.6468	8.614	8.6389	6673940.0
2010-04-09 16:30:00	AAPL	Stock	8.6087	8.6429	8.6087	8.6429	360136.0
2010-04-09 17:00:00	AAPL	Stock	8.6446	8.6475	8.6446	8.6475	96992.0
2010-04-09 17:30:00	AAPL	Stock	8.6454	8.6482	8.6418	8.6421	88200.0
2010-04-09 18:00:00	AAPL	Stock	8.6429	8.6432	8.6354	8.6429	48524.0
2010-04-09 18:30:00	AAPL	Stock	8.6448	8.645	8.6448	8.645	12348.0
2010-04-09 19:00:00	AAPL	Stock	8.645	8.6454	8.6429	8.6454	136192.0
2010-04-09 19:30:00	AAPL	Stock	8.6429	8.6464	8.6429	8.6464	122276.0
2010-04-09 06:30:00	MSFT	Stock	30.06	30.06	30.06	30.06	100.0
2010-04-09 07:00:00	MSFT	Stock	30.0	30.0	29.98	29.98	800.0
2010-04-09 08:00:00	MSFT	Stock	29.99	30.02	29.98	30.0	34805.0
2010-04-09 08:30:00	MSFT	Stock	30.0	30.01	29.99	30.01	42180.0
2010-04-09 09:00:00	MSFT	Stock	30.01	30.05	29.92	29.95	124994.0
2010-04-09 09:30:00	MSFT	Stock	29.95	29.99	29.895	29.98	5106464.0
2010-04-09 10:00:00	MSFT	Stock	29.97	30.0	29.92	29.94	5141921.0
2010-04-09 10:30:00	MSFT	Stock	29.94	29.98	29.91	29.95	3684964.0
2010-04-09 11:00:00	MSFT	Stock	29.95	30.0	29.94	29.975	2461363.0
2010-04-09 11:30:00	MSFT	Stock	29.975	30.1	29.97	30.064	3710764.0
2010-04-09 12:00:00	MSFT	Stock	30.06	30.17	30.02	30.15	3073923.0
2010-04-09 12:30:00	MSFT	Stock	30.158	30.17	30.085	30.095	3476395.0
2010-04-09 13:00:00	MSFT	Stock	30.1	30.21	30.09	30.18	2653498.0
2010-04-09 13:30:00	MSFT	Stock	30.185	30.28	30.15	30.26	3116967.0
2010-04-09 14:00:00	MSFT	Stock	30.255	30.3	30.23	30.275	2885531.0
2010-04-09 14:30:00	MSFT	Stock	30.275	30.29	30.162	30.275	2232667.0
2010-04-09 15:00:00	MSFT	Stock	30.27	30.3	30.23	30.295	4378490.0
2010-04-09 15:30:00	MSFT	Stock	30.3	30.41	30.28	30.33	8577666.0
2010-04-09 16:00:00	MSFT	Stock	30.33	30.42	29.888	30.33	2556011.0
2010-04-09 16:30:00	MSFT	Stock	30.33	30.36	30.262	30.36	79473.0

> showing 50 of 73,732 rows — these rows as CSV

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