PREVIEW / stock_30min / 2007-02-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-23.parquet
  size:    1007 KB
  rows:    54,670
  symbols: 2,540

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
2007-02-23 06:30:00	AAPL	Stock	3.1911	3.1911	3.1911	3.1911	8400.0
2007-02-23 07:00:00	AAPL	Stock	3.1911	3.1911	3.1911	3.1911	16800.0
2007-02-23 07:30:00	AAPL	Stock	3.1786	3.1911	3.1786	3.1911	16800.0
2007-02-23 08:00:00	AAPL	Stock	3.1911	3.1911	3.1836	3.1854	105140.0
2007-02-23 08:30:00	AAPL	Stock	3.1854	3.1929	3.1821	3.1929	355264.0
2007-02-23 09:00:00	AAPL	Stock	3.1929	3.1943	3.1836	3.1882	450604.0
2007-02-23 09:30:00	AAPL	Stock	3.1843	3.2171	3.1732	3.2071	100781520.0
2007-02-23 10:00:00	AAPL	Stock	3.2071	3.2264	3.1879	3.1896	100030756.0
2007-02-23 10:30:00	AAPL	Stock	3.1896	3.1954	3.1786	3.1875	65155496.0
2007-02-23 11:00:00	AAPL	Stock	3.1875	3.2	3.1818	3.1957	42014000.0
2007-02-23 11:30:00	AAPL	Stock	3.1957	3.2071	3.1954	3.1989	36114400.0
2007-02-23 12:00:00	AAPL	Stock	3.1986	3.2	3.1914	3.1946	20761160.0
2007-02-23 12:30:00	AAPL	Stock	3.1943	3.1964	3.1832	3.1889	28562184.0
2007-02-23 13:00:00	AAPL	Stock	3.1886	3.1943	3.185	3.1921	15866648.0
2007-02-23 13:30:00	AAPL	Stock	3.1925	3.1939	3.1875	3.1904	9124304.0
2007-02-23 14:00:00	AAPL	Stock	3.1904	3.1964	3.1879	3.1889	12896576.0
2007-02-23 14:30:00	AAPL	Stock	3.1893	3.195	3.1886	3.1932	14636104.0
2007-02-23 15:00:00	AAPL	Stock	3.1929	3.1946	3.1896	3.1921	12651688.0
2007-02-23 15:30:00	AAPL	Stock	3.1924	3.1925	3.1786	3.1804	48569388.0
2007-02-23 16:00:00	AAPL	Stock	3.1804	3.1811	3.1768	3.1768	1710492.0
2007-02-23 16:30:00	AAPL	Stock	3.1771	3.1782	3.1718	3.1718	282380.0
2007-02-23 17:00:00	AAPL	Stock	3.1718	3.1779	3.1718	3.1754	284900.0
2007-02-23 17:30:00	AAPL	Stock	3.175	3.1757	3.175	3.175	52920.0
2007-02-23 18:00:00	AAPL	Stock	3.1768	3.1768	3.1732	3.175	119476.0
2007-02-23 18:30:00	AAPL	Stock	3.1757	3.1782	3.175	3.175	66276.0
2007-02-23 19:00:00	AAPL	Stock	3.175	3.175	3.175	3.175	30800.0
2007-02-23 19:30:00	AAPL	Stock	3.175	3.1768	3.175	3.175	25200.0
2007-02-23 04:30:00	MSFT	Stock	29.12	29.12	29.12	29.12	100.0
2007-02-23 06:30:00	MSFT	Stock	29.09	29.17	29.09	29.17	3500.0
2007-02-23 07:00:00	MSFT	Stock	29.21	29.21	29.21	29.21	4900.0
2007-02-23 07:30:00	MSFT	Stock	29.28	29.33	29.26	29.33	10106.0
2007-02-23 08:00:00	MSFT	Stock	29.26	29.28	29.24	29.24	32064.0
2007-02-23 08:30:00	MSFT	Stock	29.25	29.27	29.24	29.27	3700.0
2007-02-23 09:00:00	MSFT	Stock	29.25	29.3	29.22	29.25	45360.0
2007-02-23 09:30:00	MSFT	Stock	29.22	29.28	29.05	29.05	10177241.0
2007-02-23 10:00:00	MSFT	Stock	29.05	29.14	29.02	29.06	6941151.0
2007-02-23 10:30:00	MSFT	Stock	29.06	29.07	28.97	29.01	6729030.0
2007-02-23 11:00:00	MSFT	Stock	29.01	29.11	28.951	29.07	4663676.0
2007-02-23 11:30:00	MSFT	Stock	29.07	29.12	29.0	29.0	6121732.0
2007-02-23 12:00:00	MSFT	Stock	29.0	29.01	28.93	28.98	3461333.0
2007-02-23 12:30:00	MSFT	Stock	28.98	29.15	28.91	28.94	3981798.0
2007-02-23 13:00:00	MSFT	Stock	28.942	28.95	28.9	28.92	2550778.0
2007-02-23 13:30:00	MSFT	Stock	28.92	29.25	28.91	28.91	2506037.0
2007-02-23 14:00:00	MSFT	Stock	28.915	28.93	28.89	28.91	2965094.0
2007-02-23 14:30:00	MSFT	Stock	28.92	28.98	28.91	28.96	2469785.0
2007-02-23 15:00:00	MSFT	Stock	28.95	28.99	28.93	28.97	2092469.0
2007-02-23 15:30:00	MSFT	Stock	28.97	29.0	28.9	28.9	6219601.0
2007-02-23 16:00:00	MSFT	Stock	28.9	29.035	28.88	28.89	47416.0
2007-02-23 16:30:00	MSFT	Stock	28.9	28.91	28.88	28.88	8100.0
2007-02-23 17:00:00	MSFT	Stock	28.88	28.92	28.86	28.88	11629.0

> showing 50 of 54,670 rows — these rows as CSV

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