PREVIEW / stock_30min / 2010-01-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-25.parquet
  size:    1.4 MB
  rows:    73,767
  symbols: 3,451

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-01-25 04:00:00	AAPL	Stock	7.175	7.1946	7.175	7.1829	11200.0
2010-01-25 04:30:00	AAPL	Stock	7.1821	7.225	7.1821	7.225	11200.0
2010-01-25 05:00:00	AAPL	Stock	7.2354	7.2568	7.2321	7.2568	24612.0
2010-01-25 05:30:00	AAPL	Stock	7.2532	7.2532	7.2321	7.2446	116480.0
2010-01-25 06:00:00	AAPL	Stock	7.25	7.25	7.2304	7.2339	77504.0
2010-01-25 06:30:00	AAPL	Stock	7.2454	7.2454	7.2168	7.2196	120512.0
2010-01-25 07:00:00	AAPL	Stock	7.2164	7.2282	7.1964	7.2039	783104.0
2010-01-25 07:30:00	AAPL	Stock	7.2036	7.2143	7.1825	7.1946	649796.0
2010-01-25 08:00:00	AAPL	Stock	7.1904	7.2339	7.1896	7.2304	5435836.0
2010-01-25 08:30:00	AAPL	Stock	7.2314	7.2314	7.2089	7.2214	2888004.0
2010-01-25 09:00:00	AAPL	Stock	7.2196	7.2375	7.2054	7.2311	6432636.0
2010-01-25 09:30:00	AAPL	Stock	7.2325	7.2686	7.2054	7.2646	150215072.0
2010-01-25 10:00:00	AAPL	Stock	7.2671	7.2807	7.2054	7.2557	88738524.0
2010-01-25 10:30:00	AAPL	Stock	7.255	7.2804	7.2436	7.2707	50043560.0
2010-01-25 11:00:00	AAPL	Stock	7.2711	7.2739	7.2082	7.2107	62397496.0
2010-01-25 11:30:00	AAPL	Stock	7.2096	7.2111	7.1496	7.1761	70182784.0
2010-01-25 12:00:00	AAPL	Stock	7.1764	7.2132	7.1761	7.1871	37030532.0
2010-01-25 12:30:00	AAPL	Stock	7.1871	7.2411	7.1846	7.2357	39115244.0
2010-01-25 13:00:00	AAPL	Stock	7.2361	7.2421	7.2225	7.2375	28112588.0
2010-01-25 13:30:00	AAPL	Stock	7.2375	7.2707	7.2232	7.2611	43365952.0
2010-01-25 14:00:00	AAPL	Stock	7.2621	7.2921	7.2511	7.2866	56600068.0
2010-01-25 14:30:00	AAPL	Stock	7.2864	7.3029	7.2793	7.3025	46161164.0
2010-01-25 15:00:00	AAPL	Stock	7.3025	7.3107	7.2832	7.2965	73357144.0
2010-01-25 15:30:00	AAPL	Stock	7.2975	7.3093	7.2321	7.2321	120169840.0
2010-01-25 16:00:00	AAPL	Stock	7.2529	7.3089	7.0582	7.2864	10645040.0
2010-01-25 16:30:00	AAPL	Stock	7.2984	7.4404	6.9714	7.4	49872732.0
2010-01-25 17:00:00	AAPL	Stock	7.2185	7.4011	7.1064	7.2357	66618664.0
2010-01-25 17:30:00	AAPL	Stock	7.2361	7.3471	7.2186	7.3393	24357732.0
2010-01-25 18:00:00	AAPL	Stock	7.34	7.3529	7.2525	7.3057	6790168.0
2010-01-25 18:30:00	AAPL	Stock	7.3064	7.3286	7.3043	7.3257	2741816.0
2010-01-25 19:00:00	AAPL	Stock	7.3232	7.3246	7.3104	7.3104	1537368.0
2010-01-25 19:30:00	AAPL	Stock	7.3104	7.3214	7.3018	7.3214	2424548.0
2010-01-25 05:00:00	MSFT	Stock	29.06	29.06	29.06	29.06	2000.0
2010-01-25 05:30:00	MSFT	Stock	29.15	29.2	29.13	29.2	3200.0
2010-01-25 06:00:00	MSFT	Stock	29.2	29.25	29.2	29.25	1152.0
2010-01-25 07:00:00	MSFT	Stock	29.21	29.25	29.2	29.22	7750.0
2010-01-25 07:30:00	MSFT	Stock	29.23	29.23	29.2	29.23	3550.0
2010-01-25 08:00:00	MSFT	Stock	29.22	29.29	28.96	29.29	46090.0
2010-01-25 08:30:00	MSFT	Stock	29.26	29.27	29.21	29.27	9300.0
2010-01-25 09:00:00	MSFT	Stock	29.3	29.3	29.2	29.24	29490.0
2010-01-25 09:30:00	MSFT	Stock	29.23	29.42	29.1	29.35	8245464.0
2010-01-25 10:00:00	MSFT	Stock	29.35	29.65	29.27	29.61	8892284.0
2010-01-25 10:30:00	MSFT	Stock	29.6	29.66	29.45	29.51	4325619.0
2010-01-25 11:00:00	MSFT	Stock	29.502	29.51	29.24	29.29	5183751.0
2010-01-25 11:30:00	MSFT	Stock	29.29	29.37	29.17	29.32	3496382.0
2010-01-25 12:00:00	MSFT	Stock	29.32	29.515	29.31	29.4	2709710.0
2010-01-25 12:30:00	MSFT	Stock	29.401	29.46	29.39	29.43	1964309.0
2010-01-25 13:00:00	MSFT	Stock	29.43	29.48	29.38	29.46	2115523.0
2010-01-25 13:30:00	MSFT	Stock	29.46	29.482	29.35	29.39	2372276.0
2010-01-25 14:00:00	MSFT	Stock	29.4	29.5	29.36	29.472	2575440.0

> showing 50 of 73,767 rows — these rows as CSV

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