PREVIEW / stock_30min / 2013-11-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-05.parquet
  size:    1.5 MB
  rows:    80,005
  symbols: 3,546

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-05 04:00:00	AAPL	Stock	18.7786	18.7786	18.7786	18.7786	2800.0
2013-11-05 04:30:00	AAPL	Stock	18.7143	18.7321	18.7143	18.7321	33600.0
2013-11-05 05:00:00	AAPL	Stock	18.7254	18.7329	18.7254	18.7321	24584.0
2013-11-05 05:30:00	AAPL	Stock	18.7339	18.7339	18.7339	18.7339	4200.0
2013-11-05 06:00:00	AAPL	Stock	18.7321	18.7411	18.7321	18.7411	13328.0
2013-11-05 06:30:00	AAPL	Stock	18.7357	18.7518	18.7357	18.7518	8400.0
2013-11-05 07:00:00	AAPL	Stock	18.7464	18.7843	18.7464	18.7714	163240.0
2013-11-05 07:30:00	AAPL	Stock	18.7804	18.7804	18.7589	18.7589	54880.0
2013-11-05 08:00:00	AAPL	Stock	18.7643	18.8036	18.75	18.7857	475888.0
2013-11-05 08:30:00	AAPL	Stock	18.7821	18.7857	18.725	18.7393	1132908.0
2013-11-05 09:00:00	AAPL	Stock	18.7393	18.7629	18.7239	18.7286	859908.0
2013-11-05 09:30:00	AAPL	Stock	18.735	18.8887	18.7286	18.7743	46028332.0
2013-11-05 10:00:00	AAPL	Stock	18.7811	18.7946	18.6786	18.7229	26095160.0
2013-11-05 10:30:00	AAPL	Stock	18.7204	18.7975	18.7196	18.7843	19654292.0
2013-11-05 11:00:00	AAPL	Stock	18.7854	18.7996	18.7414	18.7429	14938028.0
2013-11-05 11:30:00	AAPL	Stock	18.7446	18.7954	18.7425	18.7554	8473528.0
2013-11-05 12:00:00	AAPL	Stock	18.7532	18.7654	18.7118	18.752	14914872.0
2013-11-05 12:30:00	AAPL	Stock	18.7529	18.7946	18.75	18.775	9519888.0
2013-11-05 13:00:00	AAPL	Stock	18.7711	18.81	18.7657	18.7961	7765072.0
2013-11-05 13:30:00	AAPL	Stock	18.7964	18.8054	18.7629	18.7725	6914488.0
2013-11-05 14:00:00	AAPL	Stock	18.7693	18.8557	18.7643	18.8107	12395292.0
2013-11-05 14:30:00	AAPL	Stock	18.8111	18.8314	18.795	18.8146	9327976.0
2013-11-05 15:00:00	AAPL	Stock	18.8154	18.83	18.765	18.7757	12125064.0
2013-11-05 15:30:00	AAPL	Stock	18.7757	18.8164	18.7468	18.7707	27213172.0
2013-11-05 16:00:00	AAPL	Stock	18.7711	18.8125	18.755	18.7721	10524696.0
2013-11-05 16:30:00	AAPL	Stock	18.7764	18.7921	18.7605	18.7696	378560.0
2013-11-05 17:00:00	AAPL	Stock	18.7696	18.7732	18.7696	18.7714	471884.0
2013-11-05 17:30:00	AAPL	Stock	18.7732	18.7843	18.7732	18.7786	201684.0
2013-11-05 18:00:00	AAPL	Stock	18.7768	18.7768	18.7721	18.7732	62020.0
2013-11-05 18:30:00	AAPL	Stock	18.7743	18.7746	18.7696	18.7746	17360.0
2013-11-05 19:00:00	AAPL	Stock	18.7696	18.7746	18.765	18.7746	34300.0
2013-11-05 19:30:00	AAPL	Stock	18.7704	18.7764	18.7704	18.7764	88396.0
2013-11-05 07:00:00	MSFT	Stock	35.87	35.87	35.84	35.84	981.0
2013-11-05 08:30:00	MSFT	Stock	35.9	35.98	35.9	35.91	3590.0
2013-11-05 09:00:00	MSFT	Stock	35.85	35.94	35.78	35.94	8834.0
2013-11-05 09:30:00	MSFT	Stock	35.78	36.49	35.77	36.248	8246491.0
2013-11-05 10:00:00	MSFT	Stock	36.25	36.49	36.165	36.47	3796894.0
2013-11-05 10:30:00	MSFT	Stock	36.475	36.49	36.38	36.4	2837563.0
2013-11-05 11:00:00	MSFT	Stock	36.4	36.47	36.32	36.44	2801372.0
2013-11-05 11:30:00	MSFT	Stock	36.44	36.47	36.41	36.44	2002405.0
2013-11-05 12:00:00	MSFT	Stock	36.435	36.63	36.43	36.625	4316723.0
2013-11-05 12:30:00	MSFT	Stock	36.625	36.63	36.5	36.59	2484886.0
2013-11-05 13:00:00	MSFT	Stock	36.59	36.65	36.56	36.56	1249416.0
2013-11-05 13:30:00	MSFT	Stock	36.56	36.58	36.43	36.435	2751189.0
2013-11-05 14:00:00	MSFT	Stock	36.437	36.49	36.32	36.4	3306751.0
2013-11-05 14:30:00	MSFT	Stock	36.405	36.51	36.39	36.5	2611233.0
2013-11-05 15:00:00	MSFT	Stock	36.5	36.55	36.49	36.54	4135138.0
2013-11-05 15:30:00	MSFT	Stock	36.535	36.71	36.53	36.63	7934929.0
2013-11-05 16:00:00	MSFT	Stock	36.635	36.69	35.94	36.64	2109689.0
2013-11-05 16:30:00	MSFT	Stock	36.628	36.64	36.52	36.55	16418.0

> showing 50 of 80,005 rows — these rows as CSV

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