PREVIEW / stock_30min / 2009-01-12

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-12.parquet
  size:    1.2 MB
  rows:    67,970
  symbols: 3,291

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
2009-01-12 04:30:00	AAPL	Stock	3.235	3.235	3.235	3.235	5600.0
2009-01-12 08:00:00	AAPL	Stock	3.2321	3.2496	3.2196	3.2268	160552.0
2009-01-12 08:30:00	AAPL	Stock	3.225	3.2371	3.2232	3.2243	651448.0
2009-01-12 09:00:00	AAPL	Stock	3.2268	3.2393	3.2239	3.2286	427280.0
2009-01-12 09:30:00	AAPL	Stock	3.2307	3.2496	3.1964	3.2304	80609732.0
2009-01-12 10:00:00	AAPL	Stock	3.2311	3.2321	3.1875	3.2011	55236328.0
2009-01-12 10:30:00	AAPL	Stock	3.2011	3.2061	3.1864	3.1904	36624420.0
2009-01-12 11:00:00	AAPL	Stock	3.1911	3.1986	3.175	3.1779	42510048.0
2009-01-12 11:30:00	AAPL	Stock	3.1775	3.1782	3.1475	3.15	55263068.0
2009-01-12 12:00:00	AAPL	Stock	3.15	3.1621	3.1425	3.155	42655452.0
2009-01-12 12:30:00	AAPL	Stock	3.1561	3.1689	3.1493	3.1532	24672256.0
2009-01-12 13:00:00	AAPL	Stock	3.1529	3.1614	3.1486	3.1557	18888268.0
2009-01-12 13:30:00	AAPL	Stock	3.1554	3.16	3.1457	3.155	26729108.0
2009-01-12 14:00:00	AAPL	Stock	3.1555	3.1555	3.1371	3.1421	38452540.0
2009-01-12 14:30:00	AAPL	Stock	3.1418	3.1514	3.1268	3.1475	42480704.0
2009-01-12 15:00:00	AAPL	Stock	3.1479	3.1536	3.1307	3.1468	46621820.0
2009-01-12 15:30:00	AAPL	Stock	3.1468	3.1743	3.1368	3.1664	73552976.0
2009-01-12 16:00:00	AAPL	Stock	3.1645	3.1964	3.1636	3.1786	22570408.0
2009-01-12 16:30:00	AAPL	Stock	3.1782	3.1786	3.1679	3.1714	197484.0
2009-01-12 17:00:00	AAPL	Stock	3.1736	3.175	3.1689	3.175	114240.0
2009-01-12 17:30:00	AAPL	Stock	3.1771	3.1771	3.1714	3.1718	57400.0
2009-01-12 18:00:00	AAPL	Stock	3.1714	3.1746	3.1664	3.1746	2466100.0
2009-01-12 18:30:00	AAPL	Stock	3.1711	3.1743	3.1711	3.1739	18760.0
2009-01-12 19:00:00	AAPL	Stock	3.1739	3.1761	3.1739	3.1757	48580.0
2009-01-12 19:30:00	AAPL	Stock	3.1775	3.1786	3.175	3.1786	267148.0
2009-01-12 20:00:00	AAPL	Stock	3.1618	3.1618	3.1618	3.1618	36400.0
2009-01-12 07:30:00	MSFT	Stock	19.53	19.53	19.53	19.53	225.0
2009-01-12 08:00:00	MSFT	Stock	19.64	19.64	19.6	19.63	4800.0
2009-01-12 08:30:00	MSFT	Stock	19.68	19.7	19.57	19.7	9386.0
2009-01-12 09:00:00	MSFT	Stock	19.65	19.75	19.57	19.72	39733.0
2009-01-12 09:30:00	MSFT	Stock	19.71	19.79	19.6	19.71	4416364.0
2009-01-12 10:00:00	MSFT	Stock	19.72	19.74	19.46	19.58	2964719.0
2009-01-12 10:30:00	MSFT	Stock	19.57	19.68	19.53	19.53	2708164.0
2009-01-12 11:00:00	MSFT	Stock	19.542	19.57	19.47	19.49	2639568.0
2009-01-12 11:30:00	MSFT	Stock	19.5	19.532	19.42	19.5	3203905.0
2009-01-12 12:00:00	MSFT	Stock	19.5	19.64	19.48	19.59	2667232.0
2009-01-12 12:30:00	MSFT	Stock	19.58	19.63	19.54	19.59	2296957.0
2009-01-12 13:00:00	MSFT	Stock	19.598	19.68	19.55	19.612	2031962.0
2009-01-12 13:30:00	MSFT	Stock	19.62	19.642	19.53	19.53	2121853.0
2009-01-12 14:00:00	MSFT	Stock	19.53	19.54	19.42	19.46	2777737.0
2009-01-12 14:30:00	MSFT	Stock	19.46	19.47	19.3	19.41	4142071.0
2009-01-12 15:00:00	MSFT	Stock	19.4	19.49	19.39	19.45	4622024.0
2009-01-12 15:30:00	MSFT	Stock	19.45	19.56	19.38	19.47	6581751.0
2009-01-12 16:00:00	MSFT	Stock	19.46	19.526	19.46	19.48	4677191.0
2009-01-12 16:30:00	MSFT	Stock	19.48	19.57	19.47	19.51	4006570.0
2009-01-12 17:00:00	MSFT	Stock	19.526	19.526	19.5	19.5	22951.0
2009-01-12 17:30:00	MSFT	Stock	19.48	19.51	19.48	19.51	3100.0
2009-01-12 18:00:00	MSFT	Stock	19.48	19.51	19.48	19.51	200.0
2009-01-12 19:00:00	MSFT	Stock	19.51	19.55	19.51	19.55	1280.0
2009-01-12 19:30:00	MSFT	Stock	19.5	19.56	19.5	19.56	500.0

> showing 50 of 67,970 rows — these rows as CSV

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