PREVIEW / stock_30min / 2012-08-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-10.parquet
  size:    1.4 MB
  rows:    72,905
  symbols: 3,493

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
2012-08-10 06:00:00	AAPL	Stock	22.1321	22.1321	22.1321	22.1321	9380.0
2012-08-10 07:00:00	AAPL	Stock	22.1218	22.125	22.06	22.0711	130032.0
2012-08-10 07:30:00	AAPL	Stock	22.0714	22.1071	22.0714	22.0893	91056.0
2012-08-10 08:00:00	AAPL	Stock	22.0907	22.1689	22.0582	22.0993	666680.0
2012-08-10 08:30:00	AAPL	Stock	22.1007	22.1689	22.0786	22.1357	717752.0
2012-08-10 09:00:00	AAPL	Stock	22.1364	22.1364	22.0921	22.11	884996.0
2012-08-10 09:30:00	AAPL	Stock	22.1057	22.1639	22.0964	22.1418	29921668.0
2012-08-10 10:00:00	AAPL	Stock	22.1429	22.2057	22.1393	22.1679	20989668.0
2012-08-10 10:30:00	AAPL	Stock	22.1682	22.1907	22.1479	22.1625	11523092.0
2012-08-10 11:00:00	AAPL	Stock	22.1657	22.1711	22.1286	22.1589	10765636.0
2012-08-10 11:30:00	AAPL	Stock	22.1589	22.1632	22.1343	22.1504	6092016.0
2012-08-10 12:00:00	AAPL	Stock	22.1504	22.1525	22.1271	22.1339	6970656.0
2012-08-10 12:30:00	AAPL	Stock	22.1339	22.1546	22.1329	22.1471	7900732.0
2012-08-10 13:00:00	AAPL	Stock	22.1511	22.1547	22.1286	22.1419	7192332.0
2012-08-10 13:30:00	AAPL	Stock	22.1415	22.1518	22.1368	22.1418	6083280.0
2012-08-10 14:00:00	AAPL	Stock	22.1425	22.1489	22.1386	22.1475	5699008.0
2012-08-10 14:30:00	AAPL	Stock	22.1479	22.2046	22.1461	22.1802	15570156.0
2012-08-10 15:00:00	AAPL	Stock	22.1802	22.2021	22.1711	22.1946	11686220.0
2012-08-10 15:30:00	AAPL	Stock	22.1946	22.2046	22.1743	22.2014	27749232.0
2012-08-10 16:00:00	AAPL	Stock	22.2014	22.2314	22.1458	22.2286	16343432.0
2012-08-10 16:30:00	AAPL	Stock	22.2275	22.2275	22.1895	22.2182	225512.0
2012-08-10 17:00:00	AAPL	Stock	22.2196	22.2261	22.2179	22.2261	59080.0
2012-08-10 17:30:00	AAPL	Stock	22.2229	22.2232	22.2229	22.2232	8400.0
2012-08-10 18:00:00	AAPL	Stock	22.2221	22.2221	22.2164	22.2164	14000.0
2012-08-10 18:30:00	AAPL	Stock	22.2207	22.2207	22.2207	22.2207	7392.0
2012-08-10 19:00:00	AAPL	Stock	22.2207	22.2214	22.2189	22.2189	48076.0
2012-08-10 19:30:00	AAPL	Stock	22.2214	22.2232	22.2214	22.2232	67200.0
2012-08-10 07:30:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-08-10 08:00:00	MSFT	Stock	30.43	30.43	30.42	30.42	1400.0
2012-08-10 08:30:00	MSFT	Stock	30.41	30.44	30.41	30.44	800.0
2012-08-10 09:00:00	MSFT	Stock	30.44	30.52	30.43	30.52	16667.0
2012-08-10 09:30:00	MSFT	Stock	30.5	30.62	30.25	30.33	3610400.0
2012-08-10 10:00:00	MSFT	Stock	30.325	30.43	30.3	30.345	2530519.0
2012-08-10 10:30:00	MSFT	Stock	30.341	30.41	30.34	30.381	1797543.0
2012-08-10 11:00:00	MSFT	Stock	30.39	30.4	30.27	30.375	2828190.0
2012-08-10 11:30:00	MSFT	Stock	30.38	30.39	30.33	30.355	1340914.0
2012-08-10 12:00:00	MSFT	Stock	30.35	30.36	30.31	30.335	951360.0
2012-08-10 12:30:00	MSFT	Stock	30.34	30.35	30.3	30.3	780221.0
2012-08-10 13:00:00	MSFT	Stock	30.305	30.32	30.28	30.29	854652.0
2012-08-10 13:30:00	MSFT	Stock	30.3	30.36	30.28	30.355	1166951.0
2012-08-10 14:00:00	MSFT	Stock	30.36	30.36	30.3	30.31	1274761.0
2012-08-10 14:30:00	MSFT	Stock	30.313	30.329	30.28	30.295	843583.0
2012-08-10 15:00:00	MSFT	Stock	30.29	30.33	30.28	30.33	2235852.0
2012-08-10 15:30:00	MSFT	Stock	30.33	30.411	30.265	30.41	5578692.0
2012-08-10 16:00:00	MSFT	Stock	30.4	30.45	30.345	30.42	1712524.0
2012-08-10 16:30:00	MSFT	Stock	30.41	30.42	30.334	30.334	4826.0
2012-08-10 17:00:00	MSFT	Stock	30.42	30.42	30.42	30.42	100.0
2012-08-10 18:30:00	MSFT	Stock	30.41	30.41	30.41	30.41	300.0
2012-08-10 19:30:00	MSFT	Stock	30.42	30.42	30.42	30.42	2874.0
2012-08-10 07:00:00	NVDA	Stock	0.382	0.3853	0.382	0.384	85000.0

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

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