PREVIEW / stock_30min / 2011-12-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-01.parquet
  size:    1.4 MB
  rows:    75,904
  symbols: 3,533

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-12-01 04:00:00	AAPL	Stock	13.5957	13.5957	13.5954	13.5954	14000.0
2011-12-01 04:30:00	AAPL	Stock	13.6	13.6	13.6	13.6	11200.0
2011-12-01 05:00:00	AAPL	Stock	13.625	13.6321	13.625	13.6321	11200.0
2011-12-01 05:30:00	AAPL	Stock	13.6429	13.6429	13.6429	13.6429	10640.0
2011-12-01 06:30:00	AAPL	Stock	13.6379	13.6429	13.6379	13.6429	33740.0
2011-12-01 07:00:00	AAPL	Stock	13.65	13.6996	13.65	13.6846	184800.0
2011-12-01 07:30:00	AAPL	Stock	13.6957	13.7107	13.6957	13.7054	374892.0
2011-12-01 08:00:00	AAPL	Stock	13.71	13.71	13.65	13.6786	698236.0
2011-12-01 08:30:00	AAPL	Stock	13.6714	13.6804	13.6286	13.6389	943376.0
2011-12-01 09:00:00	AAPL	Stock	13.6361	13.6682	13.6343	13.6664	709800.0
2011-12-01 09:30:00	AAPL	Stock	13.6579	13.7479	13.5982	13.7454	51093448.0
2011-12-01 10:00:00	AAPL	Stock	13.7425	13.7961	13.7364	13.7814	45957072.0
2011-12-01 10:30:00	AAPL	Stock	13.7802	13.7814	13.7179	13.7268	28815612.0
2011-12-01 11:00:00	AAPL	Stock	13.7261	13.7671	13.7218	13.7361	21627648.0
2011-12-01 11:30:00	AAPL	Stock	13.7354	13.7696	13.7179	13.7607	18896864.0
2011-12-01 12:00:00	AAPL	Stock	13.7611	13.8071	13.7543	13.7964	17022320.0
2011-12-01 12:30:00	AAPL	Stock	13.7982	13.8189	13.7861	13.79	19696628.0
2011-12-01 13:00:00	AAPL	Stock	13.79	13.8018	13.7611	13.8	14475076.0
2011-12-01 13:30:00	AAPL	Stock	13.7996	13.8686	13.7857	13.8663	26498892.0
2011-12-01 14:00:00	AAPL	Stock	13.8652	13.8693	13.8393	13.8643	19277524.0
2011-12-01 14:30:00	AAPL	Stock	13.8654	13.8893	13.8507	13.8786	21171752.0
2011-12-01 15:00:00	AAPL	Stock	13.8786	13.8929	13.8525	13.8854	25065684.0
2011-12-01 15:30:00	AAPL	Stock	13.8868	13.8871	13.804	13.8507	54601848.0
2011-12-01 16:00:00	AAPL	Stock	13.8454	13.8554	13.65	13.8507	10444728.0
2011-12-01 16:30:00	AAPL	Stock	13.8539	13.878	13.7524	13.8464	659148.0
2011-12-01 17:00:00	AAPL	Stock	13.8496	13.8564	13.8482	13.8561	137592.0
2011-12-01 17:30:00	AAPL	Stock	13.8568	13.8571	13.8536	13.8554	77812.0
2011-12-01 18:00:00	AAPL	Stock	13.8507	13.8557	13.8321	13.8393	335860.0
2011-12-01 18:30:00	AAPL	Stock	13.8357	13.8429	13.8232	13.8429	182924.0
2011-12-01 19:00:00	AAPL	Stock	13.8429	13.855	13.8429	13.8536	225624.0
2011-12-01 19:30:00	AAPL	Stock	13.8557	13.8643	13.8554	13.8643	255416.0
2011-12-01 05:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	200.0
2011-12-01 08:00:00	MSFT	Stock	25.44	25.58	25.44	25.58	2570.0
2011-12-01 08:30:00	MSFT	Stock	25.52	25.58	25.49	25.49	36785.0
2011-12-01 09:00:00	MSFT	Stock	25.42	25.65	25.42	25.58	77134.0
2011-12-01 09:30:00	MSFT	Stock	25.58	25.63	25.32	25.39	4809140.0
2011-12-01 10:00:00	MSFT	Stock	25.39	25.49	25.33	25.395	4417604.0
2011-12-01 10:30:00	MSFT	Stock	25.4	25.4	25.27	25.3	3349463.0
2011-12-01 11:00:00	MSFT	Stock	25.3	25.34	25.2	25.27	3583212.0
2011-12-01 11:30:00	MSFT	Stock	25.27	25.38	25.255	25.35	2726517.0
2011-12-01 12:00:00	MSFT	Stock	25.35	25.36	25.29	25.32	2082080.0
2011-12-01 12:30:00	MSFT	Stock	25.324	25.34	25.275	25.31	2259823.0
2011-12-01 13:00:00	MSFT	Stock	25.306	25.355	25.28	25.345	1788982.0
2011-12-01 13:30:00	MSFT	Stock	25.345	25.39	25.33	25.375	1995631.0
2011-12-01 14:00:00	MSFT	Stock	25.375	25.38	25.31	25.345	1931280.0
2011-12-01 14:30:00	MSFT	Stock	25.35	25.35	25.285	25.3	2563678.0
2011-12-01 15:00:00	MSFT	Stock	25.3	25.37	25.265	25.365	3975826.0
2011-12-01 15:30:00	MSFT	Stock	25.36	25.37	25.26	25.27	8395149.0
2011-12-01 16:00:00	MSFT	Stock	25.273	25.345	25.22	25.27	3431654.0
2011-12-01 16:30:00	MSFT	Stock	25.28	25.316	25.26	25.27	152426.0

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

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