PREVIEW / stock_30min / 2010-02-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-24.parquet
  size:    1.3 MB
  rows:    71,754
  symbols: 3,455

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-24 04:00:00	AAPL	Stock	7.0432	7.0432	7.0289	7.0289	15008.0
2010-02-24 04:30:00	AAPL	Stock	7.0261	7.0261	7.0154	7.0154	14000.0
2010-02-24 05:00:00	AAPL	Stock	7.0261	7.0314	7.0261	7.0314	8400.0
2010-02-24 06:00:00	AAPL	Stock	7.0357	7.0368	7.0357	7.0368	8400.0
2010-02-24 06:30:00	AAPL	Stock	7.0357	7.0529	7.0318	7.0529	16800.0
2010-02-24 07:00:00	AAPL	Stock	7.0571	7.0793	7.0571	7.0793	146272.0
2010-02-24 07:30:00	AAPL	Stock	7.0714	7.0804	7.0657	7.0679	544040.0
2010-02-24 08:00:00	AAPL	Stock	7.0636	7.0761	7.0607	7.0718	1194956.0
2010-02-24 08:30:00	AAPL	Stock	7.0721	7.075	7.0661	7.075	607936.0
2010-02-24 09:00:00	AAPL	Stock	7.0721	7.0804	7.0643	7.08	894488.0
2010-02-24 09:30:00	AAPL	Stock	7.0796	7.1375	7.0657	7.1289	74872476.0
2010-02-24 10:00:00	AAPL	Stock	7.1282	7.1429	7.1021	7.1214	60226012.0
2010-02-24 10:30:00	AAPL	Stock	7.1204	7.175	7.1143	7.1668	49560840.0
2010-02-24 11:00:00	AAPL	Stock	7.1664	7.1714	7.14	7.1468	29190980.0
2010-02-24 11:30:00	AAPL	Stock	7.1475	7.1614	7.1425	7.1507	19453616.0
2010-02-24 12:00:00	AAPL	Stock	7.1507	7.1685	7.145	7.16	16241036.0
2010-02-24 12:30:00	AAPL	Stock	7.16	7.1682	7.1543	7.1607	12204808.0
2010-02-24 13:00:00	AAPL	Stock	7.1611	7.1943	7.1571	7.1843	35872340.0
2010-02-24 13:30:00	AAPL	Stock	7.185	7.1911	7.1739	7.1896	20727308.0
2010-02-24 14:00:00	AAPL	Stock	7.1889	7.1914	7.1721	7.1747	18411064.0
2010-02-24 14:30:00	AAPL	Stock	7.1736	7.175	7.1336	7.1339	35331688.0
2010-02-24 15:00:00	AAPL	Stock	7.1346	7.1479	7.1193	7.1368	26483828.0
2010-02-24 15:30:00	AAPL	Stock	7.1371	7.1711	7.1232	7.1625	45648092.0
2010-02-24 16:00:00	AAPL	Stock	7.1625	7.1768	7.1481	7.1714	7379036.0
2010-02-24 16:30:00	AAPL	Stock	7.1371	7.1729	7.1371	7.1689	246792.0
2010-02-24 17:00:00	AAPL	Stock	7.1544	7.1696	7.1544	7.1661	58800.0
2010-02-24 17:30:00	AAPL	Stock	7.1679	7.1693	7.1679	7.1693	8400.0
2010-02-24 18:00:00	AAPL	Stock	7.1664	7.1696	7.1664	7.1696	65772.0
2010-02-24 18:30:00	AAPL	Stock	7.1686	7.1686	7.1682	7.1682	19600.0
2010-02-24 19:00:00	AAPL	Stock	7.1661	7.1679	7.1661	7.1679	19880.0
2010-02-24 19:30:00	AAPL	Stock	7.1664	7.1704	7.1625	7.1661	274148.0
2010-02-24 08:00:00	MSFT	Stock	28.4	28.4	28.38	28.38	10018.0
2010-02-24 08:30:00	MSFT	Stock	28.39	28.39	28.39	28.39	6000.0
2010-02-24 09:00:00	MSFT	Stock	28.4	28.55	28.38	28.53	45106.0
2010-02-24 09:30:00	MSFT	Stock	28.52	28.77	28.48	28.738	5847145.0
2010-02-24 10:00:00	MSFT	Stock	28.72	28.74	28.42	28.43	6062074.0
2010-02-24 10:30:00	MSFT	Stock	28.42	28.75	28.38	28.71	5928579.0
2010-02-24 11:00:00	MSFT	Stock	28.705	28.75	28.6	28.64	2373936.0
2010-02-24 11:30:00	MSFT	Stock	28.631	28.74	28.63	28.715	1451739.0
2010-02-24 12:00:00	MSFT	Stock	28.71	28.75	28.68	28.715	1367734.0
2010-02-24 12:30:00	MSFT	Stock	28.73	28.79	28.7	28.73	1693931.0
2010-02-24 13:00:00	MSFT	Stock	28.72	28.74	28.65	28.7	2058729.0
2010-02-24 13:30:00	MSFT	Stock	28.7	28.73	28.59	28.64	1901691.0
2010-02-24 14:00:00	MSFT	Stock	28.65	28.655	28.57	28.608	1901917.0
2010-02-24 14:30:00	MSFT	Stock	28.605	28.65	28.51	28.56	3144810.0
2010-02-24 15:00:00	MSFT	Stock	28.565	28.62	28.55	28.57	2107901.0
2010-02-24 15:30:00	MSFT	Stock	28.565	28.66	28.52	28.64	4486906.0
2010-02-24 16:00:00	MSFT	Stock	28.64	28.65	28.62	28.63	1811666.0
2010-02-24 16:30:00	MSFT	Stock	28.56	28.65	28.56	28.65	14734.0
2010-02-24 17:00:00	MSFT	Stock	28.71	28.71	28.61	28.61	190200.0

> showing 50 of 71,754 rows — these rows as CSV

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