PREVIEW / stock_30min / 2011-09-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-29.parquet
  size:    1.4 MB
  rows:    74,504
  symbols: 3,482

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-09-29 04:00:00	AAPL	Stock	14.2857	14.3214	14.2857	14.3125	36400.0
2011-09-29 05:00:00	AAPL	Stock	14.3036	14.3214	14.25	14.3214	42000.0
2011-09-29 06:00:00	AAPL	Stock	14.3211	14.3214	14.2857	14.2857	25200.0
2011-09-29 06:30:00	AAPL	Stock	14.2857	14.295	14.2521	14.2521	21000.0
2011-09-29 07:00:00	AAPL	Stock	14.2679	14.2918	14.22	14.2421	282660.0
2011-09-29 07:30:00	AAPL	Stock	14.2439	14.2668	14.2275	14.2275	228788.0
2011-09-29 08:00:00	AAPL	Stock	14.2457	14.2768	14.2421	14.2625	897204.0
2011-09-29 08:30:00	AAPL	Stock	14.2671	14.3929	14.2671	14.3582	3786776.0
2011-09-29 09:00:00	AAPL	Stock	14.3568	14.3804	14.3404	14.3575	1908396.0
2011-09-29 09:30:00	AAPL	Stock	14.3543	14.3646	14.195	14.2464	65296644.0
2011-09-29 10:00:00	AAPL	Stock	14.2461	14.2679	14.0282	14.0321	56777980.0
2011-09-29 10:30:00	AAPL	Stock	14.0339	14.1032	13.9643	14.0796	70667632.0
2011-09-29 11:00:00	AAPL	Stock	14.0818	14.1389	14.0114	14.1071	40444936.0
2011-09-29 11:30:00	AAPL	Stock	14.1075	14.1657	14.075	14.1118	29247260.0
2011-09-29 12:00:00	AAPL	Stock	14.1161	14.1296	14.0782	14.1046	16167396.0
2011-09-29 12:30:00	AAPL	Stock	14.1018	14.1043	14.0	14.026	25943316.0
2011-09-29 13:00:00	AAPL	Stock	14.0229	14.0714	14.0093	14.0099	20183296.0
2011-09-29 13:30:00	AAPL	Stock	14.0129	14.02	13.9139	13.9482	59465728.0
2011-09-29 14:00:00	AAPL	Stock	13.9461	13.9911	13.7932	13.9421	72159584.0
2011-09-29 14:30:00	AAPL	Stock	13.9421	13.9643	13.8325	13.8929	42417676.0
2011-09-29 15:00:00	AAPL	Stock	13.8925	13.9157	13.8125	13.8614	54351920.0
2011-09-29 15:30:00	AAPL	Stock	13.8639	13.9643	13.8393	13.9354	78768060.0
2011-09-29 16:00:00	AAPL	Stock	13.9354	14.2796	13.8732	13.9661	8735804.0
2011-09-29 16:30:00	AAPL	Stock	13.9711	13.9711	13.9593	13.97	162400.0
2011-09-29 17:00:00	AAPL	Stock	13.9704	13.9821	13.9489	13.9671	223552.0
2011-09-29 17:30:00	AAPL	Stock	13.975	13.975	13.9661	13.9661	133812.0
2011-09-29 18:00:00	AAPL	Stock	13.9686	13.9836	13.9489	13.9793	99904.0
2011-09-29 18:30:00	AAPL	Stock	13.9786	13.9929	13.9775	13.9836	53900.0
2011-09-29 19:00:00	AAPL	Stock	13.9821	13.9971	13.9821	13.9821	91336.0
2011-09-29 19:30:00	AAPL	Stock	13.9782	14.0032	13.9782	13.9932	87556.0
2011-09-29 04:00:00	MSFT	Stock	25.8	25.84	25.8	25.84	900.0
2011-09-29 06:00:00	MSFT	Stock	25.85	25.85	25.85	25.85	400.0
2011-09-29 07:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	400.0
2011-09-29 07:30:00	MSFT	Stock	25.82	25.82	25.82	25.82	100.0
2011-09-29 08:00:00	MSFT	Stock	25.75	25.9	25.75	25.9	7678.0
2011-09-29 08:30:00	MSFT	Stock	25.91	26.14	25.91	26.05	34168.0
2011-09-29 09:00:00	MSFT	Stock	26.03	26.12	25.93	25.93	98620.0
2011-09-29 09:30:00	MSFT	Stock	25.98	26.17	25.89	26.07	4462609.0
2011-09-29 10:00:00	MSFT	Stock	26.07	26.16	25.93	25.95	3351894.0
2011-09-29 10:30:00	MSFT	Stock	25.95	25.96	25.73	25.8	3921676.0
2011-09-29 11:00:00	MSFT	Stock	25.8	25.835	25.73	25.79	2244942.0
2011-09-29 11:30:00	MSFT	Stock	25.8	25.81	25.68	25.73	3687290.0
2011-09-29 12:00:00	MSFT	Stock	25.74	25.8	25.7	25.725	2739194.0
2011-09-29 12:30:00	MSFT	Stock	25.72	25.745	25.63	25.645	3551070.0
2011-09-29 13:00:00	MSFT	Stock	25.645	25.65	25.5	25.5	3560477.0
2011-09-29 13:30:00	MSFT	Stock	25.51	25.53	25.32	25.39	5280448.0
2011-09-29 14:00:00	MSFT	Stock	25.39	25.43	25.11	25.276	5392383.0
2011-09-29 14:30:00	MSFT	Stock	25.28	25.415	25.11	25.27	4064331.0
2011-09-29 15:00:00	MSFT	Stock	25.27	25.3	25.09	25.27	4813608.0
2011-09-29 15:30:00	MSFT	Stock	25.275	25.47	25.25	25.44	12505244.0

> showing 50 of 74,504 rows — these rows as CSV

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