PREVIEW / stock_30min / 2010-06-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-03.parquet
  size:    1.3 MB
  rows:    72,930
  symbols: 3,460

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-06-03 04:00:00	AAPL	Stock	9.5575	9.5575	9.4532	9.5	25200.0
2010-06-03 05:00:00	AAPL	Stock	9.5004	9.5179	9.5004	9.5179	11200.0
2010-06-03 05:30:00	AAPL	Stock	9.5143	9.5143	9.5143	9.5143	2800.0
2010-06-03 06:00:00	AAPL	Stock	9.5143	9.5143	9.4911	9.4911	8400.0
2010-06-03 06:30:00	AAPL	Stock	9.4911	9.4911	9.4911	9.4911	17332.0
2010-06-03 07:00:00	AAPL	Stock	9.4911	9.4979	9.4786	9.4875	336532.0
2010-06-03 07:30:00	AAPL	Stock	9.4893	9.5121	9.4893	9.4986	525672.0
2010-06-03 08:00:00	AAPL	Stock	9.4954	9.5032	9.4511	9.4643	2041676.0
2010-06-03 08:30:00	AAPL	Stock	9.4643	9.4821	9.4493	9.4761	1756916.0
2010-06-03 09:00:00	AAPL	Stock	9.4775	9.4786	9.4539	9.4696	1894564.0
2010-06-03 09:30:00	AAPL	Stock	9.4696	9.4839	9.4075	9.4345	100037028.0
2010-06-03 10:00:00	AAPL	Stock	9.4343	9.4343	9.3636	9.3729	72075948.0
2010-06-03 10:30:00	AAPL	Stock	9.3714	9.415	9.3571	9.4136	45599204.0
2010-06-03 11:00:00	AAPL	Stock	9.4139	9.4439	9.3875	9.3961	45770396.0
2010-06-03 11:30:00	AAPL	Stock	9.395	9.4129	9.3871	9.3943	29037036.0
2010-06-03 12:00:00	AAPL	Stock	9.3968	9.4032	9.3004	9.3291	54787460.0
2010-06-03 12:30:00	AAPL	Stock	9.3296	9.3457	9.305	9.3221	36308776.0
2010-06-03 13:00:00	AAPL	Stock	9.3229	9.3454	9.3075	9.3211	22166340.0
2010-06-03 13:30:00	AAPL	Stock	9.32	9.3786	9.3193	9.3496	34996584.0
2010-06-03 14:00:00	AAPL	Stock	9.35	9.375	9.3232	9.3475	35937888.0
2010-06-03 14:30:00	AAPL	Stock	9.3475	9.3971	9.3452	9.3736	33057808.0
2010-06-03 15:00:00	AAPL	Stock	9.3739	9.4214	9.3393	9.4189	44843792.0
2010-06-03 15:30:00	AAPL	Stock	9.4179	9.4264	9.3821	9.4036	68822740.0
2010-06-03 16:00:00	AAPL	Stock	9.4068	9.4096	9.3667	9.3929	10513580.0
2010-06-03 16:30:00	AAPL	Stock	9.3929	9.4211	9.3882	9.3918	668724.0
2010-06-03 17:00:00	AAPL	Stock	9.4268	9.4268	9.3861	9.3875	88200.0
2010-06-03 17:30:00	AAPL	Stock	9.3857	9.3907	9.3793	9.3907	216664.0
2010-06-03 18:00:00	AAPL	Stock	9.3857	9.3971	9.3841	9.3893	131544.0
2010-06-03 18:30:00	AAPL	Stock	9.3861	9.3893	9.385	9.3882	71960.0
2010-06-03 19:00:00	AAPL	Stock	9.3864	9.3904	9.3829	9.3864	142072.0
2010-06-03 19:30:00	AAPL	Stock	9.3861	9.4018	9.3861	9.4018	225176.0
2010-06-03 07:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	100.0
2010-06-03 08:00:00	MSFT	Stock	26.49	26.59	26.49	26.59	10794.0
2010-06-03 08:30:00	MSFT	Stock	26.49	26.56	26.49	26.53	2700.0
2010-06-03 09:00:00	MSFT	Stock	26.52	26.55	26.5	26.54	20683.0
2010-06-03 09:30:00	MSFT	Stock	26.55	26.6	26.41	26.6	7601462.0
2010-06-03 10:00:00	MSFT	Stock	26.59	26.62	26.47	26.49	5157818.0
2010-06-03 10:30:00	MSFT	Stock	26.48	26.67	26.46	26.61	4883014.0
2010-06-03 11:00:00	MSFT	Stock	26.61	26.63	26.5	26.56	2274155.0
2010-06-03 11:30:00	MSFT	Stock	26.56	26.63	26.53	26.55	3591942.0
2010-06-03 12:00:00	MSFT	Stock	26.54	26.6	26.465	26.54	5350069.0
2010-06-03 12:30:00	MSFT	Stock	26.54	26.69	26.53	26.65	3021587.0
2010-06-03 13:00:00	MSFT	Stock	26.65	26.77	26.62	26.674	4198318.0
2010-06-03 13:30:00	MSFT	Stock	26.68	26.81	26.67	26.73	3710284.0
2010-06-03 14:00:00	MSFT	Stock	26.73	26.78	26.66	26.74	2845647.0
2010-06-03 14:30:00	MSFT	Stock	26.74	26.9	26.72	26.83	3853112.0
2010-06-03 15:00:00	MSFT	Stock	26.83	26.91	26.75	26.905	3928965.0
2010-06-03 15:30:00	MSFT	Stock	26.91	26.93	26.78	26.85	11024916.0
2010-06-03 16:00:00	MSFT	Stock	26.85	26.9	26.415	26.83	5373777.0
2010-06-03 16:30:00	MSFT	Stock	26.926	26.926	26.81	26.81	53968.0

> showing 50 of 72,930 rows — these rows as CSV

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