PREVIEW / stock_30min / 2013-11-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-25.parquet
  size:    1.6 MB
  rows:    81,271
  symbols: 3,554

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-11-25 04:00:00	AAPL	Stock	18.6068	18.6068	18.6054	18.6068	14000.0
2013-11-25 04:30:00	AAPL	Stock	18.6061	18.6061	18.6061	18.6061	2800.0
2013-11-25 05:00:00	AAPL	Stock	18.6218	18.6218	18.6218	18.6218	2940.0
2013-11-25 05:30:00	AAPL	Stock	18.6218	18.6218	18.6218	18.6218	2800.0
2013-11-25 06:00:00	AAPL	Stock	18.6071	18.6071	18.5721	18.5721	28000.0
2013-11-25 06:30:00	AAPL	Stock	18.6071	18.6071	18.6071	18.6071	16800.0
2013-11-25 07:00:00	AAPL	Stock	18.625	18.6529	18.6071	18.6375	114800.0
2013-11-25 07:30:00	AAPL	Stock	18.6475	18.6782	18.6475	18.6621	334796.0
2013-11-25 08:00:00	AAPL	Stock	18.6568	18.66	18.6071	18.6146	528836.0
2013-11-25 08:30:00	AAPL	Stock	18.6139	18.6554	18.6079	18.6429	954604.0
2013-11-25 09:00:00	AAPL	Stock	18.6393	18.6421	18.6071	18.6093	466396.0
2013-11-25 09:30:00	AAPL	Stock	18.6079	18.7536	18.6071	18.6899	50891484.0
2013-11-25 10:00:00	AAPL	Stock	18.6907	18.7673	18.6829	18.7054	30654624.0
2013-11-25 10:30:00	AAPL	Stock	18.7011	18.7386	18.6979	18.71	23893352.0
2013-11-25 11:00:00	AAPL	Stock	18.7104	18.7489	18.7102	18.7446	13613684.0
2013-11-25 11:30:00	AAPL	Stock	18.7429	18.7568	18.7189	18.75	13758052.0
2013-11-25 12:00:00	AAPL	Stock	18.7507	18.7743	18.7457	18.7657	10776696.0
2013-11-25 12:30:00	AAPL	Stock	18.7632	18.7732	18.7321	18.7346	7779520.0
2013-11-25 13:00:00	AAPL	Stock	18.7375	18.76	18.7339	18.7457	5276880.0
2013-11-25 13:30:00	AAPL	Stock	18.7439	18.7643	18.7411	18.7639	6449716.0
2013-11-25 14:00:00	AAPL	Stock	18.7632	18.7686	18.7505	18.7611	8029336.0
2013-11-25 14:30:00	AAPL	Stock	18.7589	18.7811	18.75	18.7668	9605204.0
2013-11-25 15:00:00	AAPL	Stock	18.7665	18.7711	18.6946	18.7043	15040816.0
2013-11-25 15:30:00	AAPL	Stock	18.7043	18.7196	18.6889	18.7054	19585524.0
2013-11-25 16:00:00	AAPL	Stock	18.705	18.7303	18.6932	18.7004	7807604.0
2013-11-25 16:30:00	AAPL	Stock	18.6939	18.7335	18.6893	18.6957	251860.0
2013-11-25 17:00:00	AAPL	Stock	18.6911	18.7014	18.6911	18.6946	78680.0
2013-11-25 17:30:00	AAPL	Stock	18.7025	18.705	18.7	18.7018	193480.0
2013-11-25 18:00:00	AAPL	Stock	18.7025	18.7043	18.7	18.7043	30800.0
2013-11-25 18:30:00	AAPL	Stock	18.7043	18.7132	18.7043	18.7054	14000.0
2013-11-25 19:00:00	AAPL	Stock	18.7054	18.7143	18.7054	18.7071	20104.0
2013-11-25 19:30:00	AAPL	Stock	18.7175	18.7175	18.7107	18.7143	43652.0
2013-11-25 06:00:00	MSFT	Stock	37.79	37.83	37.79	37.83	700.0
2013-11-25 07:00:00	MSFT	Stock	37.82	37.82	37.82	37.82	500.0
2013-11-25 07:30:00	MSFT	Stock	37.8	37.82	37.78	37.81	2500.0
2013-11-25 08:00:00	MSFT	Stock	37.77	37.83	37.7	37.76	7978.0
2013-11-25 08:30:00	MSFT	Stock	37.75	37.76	37.74	37.76	2855.0
2013-11-25 09:00:00	MSFT	Stock	37.75	38.01	37.71	37.93	70696.0
2013-11-25 09:30:00	MSFT	Stock	37.93	37.95	37.705	37.78	4128727.0
2013-11-25 10:00:00	MSFT	Stock	37.78	37.85	37.75	37.8	2488186.0
2013-11-25 10:30:00	MSFT	Stock	37.8	37.83	37.715	37.75	2085182.0
2013-11-25 11:00:00	MSFT	Stock	37.75	37.77	37.625	37.71	2095786.0
2013-11-25 11:30:00	MSFT	Stock	37.708	37.74	37.65	37.68	1356507.0
2013-11-25 12:00:00	MSFT	Stock	37.68	37.69	37.57	37.68	1773378.0
2013-11-25 12:30:00	MSFT	Stock	37.68	37.685	37.645	37.66	1541465.0
2013-11-25 13:00:00	MSFT	Stock	37.669	37.68	37.62	37.66	1771794.0
2013-11-25 13:30:00	MSFT	Stock	37.656	37.72	37.65	37.685	1088336.0
2013-11-25 14:00:00	MSFT	Stock	37.685	37.745	37.68	37.725	1758398.0
2013-11-25 14:30:00	MSFT	Stock	37.73	37.74	37.69	37.71	798569.0
2013-11-25 15:00:00	MSFT	Stock	37.71	37.72	37.67	37.69	1669038.0

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

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