PREVIEW / stock_30min / 2010-02-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-17.parquet
  size:    1.3 MB
  rows:    72,423
  symbols: 3,447

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-02-17 06:00:00	AAPL	Stock	7.2696	7.2696	7.2696	7.2696	3752.0
2010-02-17 07:00:00	AAPL	Stock	7.2732	7.2732	7.2732	7.2732	2800.0
2010-02-17 07:30:00	AAPL	Stock	7.2807	7.2946	7.2793	7.2921	119224.0
2010-02-17 08:00:00	AAPL	Stock	7.2857	7.2964	7.2804	7.2946	1276016.0
2010-02-17 08:30:00	AAPL	Stock	7.2929	7.3036	7.2896	7.2961	541408.0
2010-02-17 09:00:00	AAPL	Stock	7.295	7.3	7.2843	7.2929	1463532.0
2010-02-17 09:30:00	AAPL	Stock	7.2925	7.2968	7.2457	7.2618	70927920.0
2010-02-17 10:00:00	AAPL	Stock	7.2625	7.2846	7.2589	7.2607	43598912.0
2010-02-17 10:30:00	AAPL	Stock	7.2601	7.275	7.2486	7.2593	34450864.0
2010-02-17 11:00:00	AAPL	Stock	7.2589	7.2599	7.1943	7.2004	44946776.0
2010-02-17 11:30:00	AAPL	Stock	7.2006	7.2186	7.1896	7.2073	28016632.0
2010-02-17 12:00:00	AAPL	Stock	7.2079	7.2139	7.1736	7.2096	36840608.0
2010-02-17 12:30:00	AAPL	Stock	7.2093	7.2239	7.2039	7.2225	18147640.0
2010-02-17 13:00:00	AAPL	Stock	7.2228	7.2439	7.2221	7.2396	27562388.0
2010-02-17 13:30:00	AAPL	Stock	7.239	7.2396	7.2189	7.2343	21471828.0
2010-02-17 14:00:00	AAPL	Stock	7.2339	7.235	7.1964	7.2221	20827324.0
2010-02-17 14:30:00	AAPL	Stock	7.2221	7.2329	7.215	7.2314	14338520.0
2010-02-17 15:00:00	AAPL	Stock	7.2304	7.2393	7.2229	7.2246	18271736.0
2010-02-17 15:30:00	AAPL	Stock	7.2257	7.2339	7.2086	7.2336	40245016.0
2010-02-17 16:00:00	AAPL	Stock	7.2321	7.2669	7.2296	7.2386	4785844.0
2010-02-17 16:30:00	AAPL	Stock	7.2239	7.24	7.2239	7.2361	210224.0
2010-02-17 17:00:00	AAPL	Stock	7.2364	7.2393	7.2361	7.2364	37800.0
2010-02-17 17:30:00	AAPL	Stock	7.2371	7.2382	7.2361	7.2382	9632.0
2010-02-17 18:00:00	AAPL	Stock	7.2341	7.2357	7.2325	7.2336	1075788.0
2010-02-17 18:30:00	AAPL	Stock	7.2339	7.2357	7.2336	7.2339	83524.0
2010-02-17 19:00:00	AAPL	Stock	7.2339	7.2339	7.2304	7.2304	220948.0
2010-02-17 19:30:00	AAPL	Stock	7.2311	7.2321	7.2254	7.2254	229040.0
2010-02-17 07:00:00	MSFT	Stock	28.47	28.47	28.45	28.45	800.0
2010-02-17 07:30:00	MSFT	Stock	28.48	28.5	28.45	28.45	3250.0
2010-02-17 08:00:00	MSFT	Stock	28.55	28.62	28.5	28.6	9500.0
2010-02-17 08:30:00	MSFT	Stock	28.62	28.62	28.57	28.57	25870.0
2010-02-17 09:00:00	MSFT	Stock	28.58	28.58	28.45	28.55	66993.0
2010-02-17 09:30:00	MSFT	Stock	28.56	28.62	28.42	28.515	8201850.0
2010-02-17 10:00:00	MSFT	Stock	28.52	28.65	28.47	28.541	3438475.0
2010-02-17 10:30:00	MSFT	Stock	28.55	28.6	28.49	28.56	3128597.0
2010-02-17 11:00:00	MSFT	Stock	28.56	28.57	28.43	28.47	3723442.0
2010-02-17 11:30:00	MSFT	Stock	28.47	28.58	28.45	28.58	2135213.0
2010-02-17 12:00:00	MSFT	Stock	28.58	28.62	28.53	28.54	2143052.0
2010-02-17 12:30:00	MSFT	Stock	28.545	28.55	28.44	28.5	1483275.0
2010-02-17 13:00:00	MSFT	Stock	28.5	28.54	28.48	28.48	1522556.0
2010-02-17 13:30:00	MSFT	Stock	28.485	28.49	28.4	28.45	1323161.0
2010-02-17 14:00:00	MSFT	Stock	28.45	28.48	28.36	28.39	2240005.0
2010-02-17 14:30:00	MSFT	Stock	28.39	28.49	28.371	28.48	1609409.0
2010-02-17 15:00:00	MSFT	Stock	28.475	28.55	28.46	28.523	3094834.0
2010-02-17 15:30:00	MSFT	Stock	28.52	28.61	28.515	28.6	8122610.0
2010-02-17 16:00:00	MSFT	Stock	28.6	28.68	28.485	28.65	2275400.0
2010-02-17 16:30:00	MSFT	Stock	28.516	28.67	28.516	28.67	8850.0
2010-02-17 17:00:00	MSFT	Stock	28.519	28.65	28.482	28.64	187882.0
2010-02-17 17:30:00	MSFT	Stock	28.59	28.59	28.59	28.59	20029.0
2010-02-17 18:00:00	MSFT	Stock	28.59	28.67	28.59	28.67	8486.0

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

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