PREVIEW / stock_30min / 2010-07-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-23.parquet
  size:    1.4 MB
  rows:    74,048
  symbols: 3,457

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-07-23 04:00:00	AAPL	Stock	9.2482	9.2854	9.2482	9.2854	23716.0
2010-07-23 04:30:00	AAPL	Stock	9.2921	9.2921	9.2921	9.2921	2800.0
2010-07-23 05:00:00	AAPL	Stock	9.2957	9.3193	9.2957	9.3175	8400.0
2010-07-23 06:00:00	AAPL	Stock	9.3143	9.3143	9.3143	9.3143	2800.0
2010-07-23 06:30:00	AAPL	Stock	9.3157	9.3161	9.2964	9.2964	12348.0
2010-07-23 07:00:00	AAPL	Stock	9.2961	9.3179	9.2929	9.3104	260372.0
2010-07-23 07:30:00	AAPL	Stock	9.2996	9.3161	9.2946	9.3	230104.0
2010-07-23 08:00:00	AAPL	Stock	9.2986	9.2986	9.2386	9.2661	869092.0
2010-07-23 08:30:00	AAPL	Stock	9.2607	9.2679	9.1582	9.2107	3022516.0
2010-07-23 09:00:00	AAPL	Stock	9.2104	9.2232	9.1789	9.1804	2386972.0
2010-07-23 09:30:00	AAPL	Stock	9.1814	9.2643	9.1607	9.1618	68595044.0
2010-07-23 10:00:00	AAPL	Stock	9.1636	9.2221	9.1529	9.22	46376680.0
2010-07-23 10:30:00	AAPL	Stock	9.2207	9.2589	9.2196	9.2264	43995924.0
2010-07-23 11:00:00	AAPL	Stock	9.2257	9.2464	9.1939	9.2164	28564928.0
2010-07-23 11:30:00	AAPL	Stock	9.2157	9.2404	9.2004	9.2286	19713456.0
2010-07-23 12:00:00	AAPL	Stock	9.2289	9.2571	9.1807	9.2314	37246048.0
2010-07-23 12:30:00	AAPL	Stock	9.2318	9.2332	9.1904	9.2296	20944112.0
2010-07-23 13:00:00	AAPL	Stock	9.2304	9.2675	9.215	9.2604	30470916.0
2010-07-23 13:30:00	AAPL	Stock	9.2604	9.2814	9.2525	9.2743	30591736.0
2010-07-23 14:00:00	AAPL	Stock	9.2743	9.2993	9.2543	9.2723	45440360.0
2010-07-23 14:30:00	AAPL	Stock	9.2729	9.2971	9.26	9.2814	31212412.0
2010-07-23 15:00:00	AAPL	Stock	9.2811	9.2961	9.2689	9.2821	37553264.0
2010-07-23 15:30:00	AAPL	Stock	9.2811	9.2946	9.2593	9.2875	65271220.0
2010-07-23 16:00:00	AAPL	Stock	9.2876	9.2891	9.1786	9.2864	14674520.0
2010-07-23 16:30:00	AAPL	Stock	9.2857	9.2868	9.19	9.2854	972916.0
2010-07-23 17:00:00	AAPL	Stock	9.285	9.2875	9.2843	9.2854	172788.0
2010-07-23 17:30:00	AAPL	Stock	9.2857	9.2857	9.2764	9.2818	111552.0
2010-07-23 18:00:00	AAPL	Stock	9.2771	9.2854	9.2771	9.285	158760.0
2010-07-23 18:30:00	AAPL	Stock	9.2854	9.2875	9.2854	9.2854	78652.0
2010-07-23 19:00:00	AAPL	Stock	9.2854	9.2893	9.2854	9.2893	55608.0
2010-07-23 19:30:00	AAPL	Stock	9.2857	9.2893	9.2829	9.2832	34076.0
2010-07-23 04:00:00	MSFT	Stock	25.89	25.94	25.89	25.94	300.0
2010-07-23 06:00:00	MSFT	Stock	25.94	25.94	25.94	25.94	100.0
2010-07-23 07:00:00	MSFT	Stock	25.94	25.95	25.88	25.92	36710.0
2010-07-23 07:30:00	MSFT	Stock	25.92	26.16	25.92	26.09	172219.0
2010-07-23 08:00:00	MSFT	Stock	26.08	26.11	25.89	25.97	308070.0
2010-07-23 08:30:00	MSFT	Stock	25.96	26.13	25.84	26.08	1584440.0
2010-07-23 09:00:00	MSFT	Stock	26.09	26.09	25.83	25.83	940678.0
2010-07-23 09:30:00	MSFT	Stock	25.83	26.02	25.39	25.39	20555503.0
2010-07-23 10:00:00	MSFT	Stock	25.39	25.71	25.37	25.68	8365691.0
2010-07-23 10:30:00	MSFT	Stock	25.68	25.74	25.62	25.622	6038903.0
2010-07-23 11:00:00	MSFT	Stock	25.621	25.65	25.38	25.405	7855008.0
2010-07-23 11:30:00	MSFT	Stock	25.405	25.58	25.39	25.5	5137500.0
2010-07-23 12:00:00	MSFT	Stock	25.5	25.58	25.3	25.308	7984840.0
2010-07-23 12:30:00	MSFT	Stock	25.3	25.42	25.25	25.401	4692453.0
2010-07-23 13:00:00	MSFT	Stock	25.41	25.55	25.36	25.54	4293776.0
2010-07-23 13:30:00	MSFT	Stock	25.54	25.62	25.48	25.5	5084969.0
2010-07-23 14:00:00	MSFT	Stock	25.505	25.6	25.49	25.565	4172143.0
2010-07-23 14:30:00	MSFT	Stock	25.565	25.64	25.5	25.57	4425656.0
2010-07-23 15:00:00	MSFT	Stock	25.57	25.651	25.5	25.63	5808517.0

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

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