PREVIEW / stock_30min / 2010-04-21

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-21.parquet
  size:    1.4 MB
  rows:    73,906
  symbols: 3,468

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-04-21 04:00:00	AAPL	Stock	9.125	9.1825	9.0732	9.1789	35000.0
2010-04-21 04:30:00	AAPL	Stock	9.1964	9.205	9.1429	9.1429	63392.0
2010-04-21 05:00:00	AAPL	Stock	9.1964	9.1964	9.1696	9.1696	42644.0
2010-04-21 05:30:00	AAPL	Stock	9.1704	9.1964	9.1704	9.1964	35924.0
2010-04-21 06:00:00	AAPL	Stock	9.1786	9.2196	9.1786	9.2196	71260.0
2010-04-21 06:30:00	AAPL	Stock	9.1946	9.2232	9.1904	9.1964	167076.0
2010-04-21 07:00:00	AAPL	Stock	9.2139	9.2846	9.1929	9.2321	1614452.0
2010-04-21 07:30:00	AAPL	Stock	9.2321	9.2679	9.1971	9.2679	974932.0
2010-04-21 08:00:00	AAPL	Stock	9.265	9.265	9.1679	9.21	6389068.0
2010-04-21 08:30:00	AAPL	Stock	9.2121	9.2732	9.2093	9.2732	5853876.0
2010-04-21 09:00:00	AAPL	Stock	9.2743	9.3214	9.2425	9.2425	13731396.0
2010-04-21 09:30:00	AAPL	Stock	9.2429	9.2946	9.1332	9.2776	304086272.0
2010-04-21 10:00:00	AAPL	Stock	9.2775	9.2846	9.2071	9.2143	118272588.0
2010-04-21 10:30:00	AAPL	Stock	9.2132	9.2518	9.2075	9.2343	69031872.0
2010-04-21 11:00:00	AAPL	Stock	9.235	9.2657	9.1894	9.2111	76846812.0
2010-04-21 11:30:00	AAPL	Stock	9.2125	9.2407	9.2036	9.2304	42146692.0
2010-04-21 12:00:00	AAPL	Stock	9.2295	9.2311	9.2107	9.2232	20824440.0
2010-04-21 12:30:00	AAPL	Stock	9.2232	9.2411	9.2204	9.2204	23083592.0
2010-04-21 13:00:00	AAPL	Stock	9.2206	9.2254	9.2089	9.2214	23822624.0
2010-04-21 13:30:00	AAPL	Stock	9.2214	9.2482	9.2189	9.2468	25575396.0
2010-04-21 14:00:00	AAPL	Stock	9.2464	9.2675	9.2261	9.2339	49997304.0
2010-04-21 14:30:00	AAPL	Stock	9.2332	9.2457	9.2095	9.2412	40312076.0
2010-04-21 15:00:00	AAPL	Stock	9.2425	9.2504	9.2396	9.2429	34277992.0
2010-04-21 15:30:00	AAPL	Stock	9.2429	9.2832	9.2411	9.2586	85593592.0
2010-04-21 16:00:00	AAPL	Stock	9.2586	9.275	9.2275	9.2496	13311480.0
2010-04-21 16:30:00	AAPL	Stock	9.2409	9.246	9.2089	9.2214	2546824.0
2010-04-21 17:00:00	AAPL	Stock	9.2168	9.225	9.215	9.2239	219380.0
2010-04-21 17:30:00	AAPL	Stock	9.2243	9.23	9.2186	9.2296	353164.0
2010-04-21 18:00:00	AAPL	Stock	9.2304	9.2579	9.2271	9.2286	563220.0
2010-04-21 18:30:00	AAPL	Stock	9.2314	9.2321	9.2293	9.2296	84532.0
2010-04-21 19:00:00	AAPL	Stock	9.2314	9.2346	9.2293	9.2321	326340.0
2010-04-21 19:30:00	AAPL	Stock	9.2304	9.2357	9.2289	9.2357	154728.0
2010-04-21 06:30:00	MSFT	Stock	31.42	31.42	31.42	31.42	900.0
2010-04-21 07:30:00	MSFT	Stock	31.38	31.38	31.38	31.38	1600.0
2010-04-21 08:00:00	MSFT	Stock	31.32	31.46	31.32	31.4	6276.0
2010-04-21 08:30:00	MSFT	Stock	31.43	31.43	31.4	31.43	3034.0
2010-04-21 09:00:00	MSFT	Stock	31.43	31.5	31.33	31.33	67916.0
2010-04-21 09:30:00	MSFT	Stock	31.33	31.44	31.28	31.41	4938857.0
2010-04-21 10:00:00	MSFT	Stock	31.4	31.44	31.3	31.371	3859972.0
2010-04-21 10:30:00	MSFT	Stock	31.37	31.415	31.29	31.29	3360479.0
2010-04-21 11:00:00	MSFT	Stock	31.295	31.38	31.23	31.305	3654590.0
2010-04-21 11:30:00	MSFT	Stock	31.3	31.38	31.29	31.315	4652915.0
2010-04-21 12:00:00	MSFT	Stock	31.31	31.42	31.31	31.42	2501335.0
2010-04-21 12:30:00	MSFT	Stock	31.42	31.5	31.4	31.48	3591977.0
2010-04-21 13:00:00	MSFT	Stock	31.48	31.49	31.43	31.434	2174817.0
2010-04-21 13:30:00	MSFT	Stock	31.432	31.46	31.37	31.415	2794394.0
2010-04-21 14:00:00	MSFT	Stock	31.41	31.44	31.27	31.32	3889193.0
2010-04-21 14:30:00	MSFT	Stock	31.32	31.32	31.25	31.295	2944154.0
2010-04-21 15:00:00	MSFT	Stock	31.3	31.33	31.25	31.275	3382842.0
2010-04-21 15:30:00	MSFT	Stock	31.275	31.45	31.27	31.32	5869389.0

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

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