PREVIEW / stock_30min / 2012-01-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-03.parquet
  size:    1.4 MB
  rows:    77,136
  symbols: 3,574

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-01-03 04:00:00	AAPL	Stock	14.4571	14.7143	14.4571	14.7143	110852.0
2012-01-03 04:30:00	AAPL	Stock	14.7196	14.7429	14.7196	14.7429	6160.0
2012-01-03 05:00:00	AAPL	Stock	14.7375	14.7375	14.7357	14.7357	5600.0
2012-01-03 05:30:00	AAPL	Stock	14.6786	14.7143	14.6786	14.6904	49420.0
2012-01-03 06:00:00	AAPL	Stock	14.6904	14.7143	14.6904	14.6964	42000.0
2012-01-03 06:30:00	AAPL	Stock	14.6964	14.6964	14.6596	14.6607	101864.0
2012-01-03 07:00:00	AAPL	Stock	14.6782	14.6782	14.6268	14.6393	315280.0
2012-01-03 07:30:00	AAPL	Stock	14.6339	14.6475	14.6268	14.6293	383572.0
2012-01-03 08:00:00	AAPL	Stock	14.6607	14.6607	14.4643	14.5996	2069900.0
2012-01-03 08:30:00	AAPL	Stock	14.5936	14.6032	14.575	14.5893	1200612.0
2012-01-03 09:00:00	AAPL	Stock	14.5918	14.6389	14.4643	14.6179	3215100.0
2012-01-03 09:30:00	AAPL	Stock	14.6179	14.7029	14.6071	14.6893	57306816.0
2012-01-03 10:00:00	AAPL	Stock	14.6893	14.7321	14.6825	14.7221	28749112.0
2012-01-03 10:30:00	AAPL	Stock	14.7221	14.7279	14.6507	14.6746	25133136.0
2012-01-03 11:00:00	AAPL	Stock	14.6761	14.6948	14.6693	14.6768	13702528.0
2012-01-03 11:30:00	AAPL	Stock	14.6752	14.6907	14.6693	14.6718	10679480.0
2012-01-03 12:00:00	AAPL	Stock	14.6696	14.6814	14.6579	14.6782	10386684.0
2012-01-03 12:30:00	AAPL	Stock	14.6761	14.6775	14.6271	14.6355	15556380.0
2012-01-03 13:00:00	AAPL	Stock	14.6354	14.6532	14.6171	14.6371	12095412.0
2012-01-03 13:30:00	AAPL	Stock	14.6371	14.675	14.615	14.6718	13401780.0
2012-01-03 14:00:00	AAPL	Stock	14.6732	14.685	14.6607	14.6755	11192776.0
2012-01-03 14:30:00	AAPL	Stock	14.6768	14.7061	14.6746	14.7047	15861328.0
2012-01-03 15:00:00	AAPL	Stock	14.705	14.7132	14.6932	14.6971	15930992.0
2012-01-03 15:30:00	AAPL	Stock	14.6979	14.7157	14.6657	14.6821	35222992.0
2012-01-03 16:00:00	AAPL	Stock	14.6793	14.73	14.6635	14.6868	19450424.0
2012-01-03 16:30:00	AAPL	Stock	14.6939	14.7102	14.6868	14.6918	565236.0
2012-01-03 17:00:00	AAPL	Stock	14.6979	14.6982	14.6846	14.6846	84028.0
2012-01-03 17:30:00	AAPL	Stock	14.6864	14.6957	14.6857	14.6911	107912.0
2012-01-03 18:00:00	AAPL	Stock	14.6886	14.6911	14.6868	14.6911	114352.0
2012-01-03 18:30:00	AAPL	Stock	14.6918	14.6918	14.6907	14.6907	30940.0
2012-01-03 19:00:00	AAPL	Stock	14.6911	14.6957	14.6911	14.6914	39956.0
2012-01-03 19:30:00	AAPL	Stock	14.6929	14.6929	14.6911	14.6911	44548.0
2012-01-03 04:00:00	MSFT	Stock	26.06	26.32	26.06	26.32	2277.0
2012-01-03 05:00:00	MSFT	Stock	26.49	26.74	26.48	26.74	1100.0
2012-01-03 05:30:00	MSFT	Stock	26.5	26.5	26.5	26.5	100.0
2012-01-03 06:30:00	MSFT	Stock	26.44	26.44	26.44	26.44	300.0
2012-01-03 07:00:00	MSFT	Stock	26.39	26.41	26.38	26.4	27050.0
2012-01-03 07:30:00	MSFT	Stock	26.38	26.4	26.32	26.32	13400.0
2012-01-03 08:00:00	MSFT	Stock	26.32	26.36	25.96	26.33	58238.0
2012-01-03 08:30:00	MSFT	Stock	26.33	26.35	26.25	26.35	31033.0
2012-01-03 09:00:00	MSFT	Stock	26.35	26.55	25.96	26.55	168172.0
2012-01-03 09:30:00	MSFT	Stock	26.55	26.57	26.39	26.51	6015167.0
2012-01-03 10:00:00	MSFT	Stock	26.51	26.65	26.51	26.645	4458796.0
2012-01-03 10:30:00	MSFT	Stock	26.65	26.75	26.645	26.732	3357198.0
2012-01-03 11:00:00	MSFT	Stock	26.74	26.87	26.72	26.869	5806340.0
2012-01-03 11:30:00	MSFT	Stock	26.865	26.91	26.85	26.86	5220499.0
2012-01-03 12:00:00	MSFT	Stock	26.85	26.91	26.85	26.885	3940434.0
2012-01-03 12:30:00	MSFT	Stock	26.885	26.89	26.8	26.85	2544761.0
2012-01-03 13:00:00	MSFT	Stock	26.85	26.905	26.845	26.88	3002656.0
2012-01-03 13:30:00	MSFT	Stock	26.88	26.9	26.81	26.895	2820332.0

> showing 50 of 77,136 rows — these rows as CSV

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