PREVIEW / stock_30min / 2008-07-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-17.parquet
  size:    1.3 MB
  rows:    71,178
  symbols: 3,337

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
2008-07-17 05:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-07-17 06:30:00	AAPL	Stock	6.1929	6.1929	6.1929	6.1929	2800.0
2008-07-17 07:00:00	AAPL	Stock	6.1964	6.2568	6.1964	6.2232	391160.0
2008-07-17 07:30:00	AAPL	Stock	6.2282	6.2282	6.2036	6.2136	188216.0
2008-07-17 08:00:00	AAPL	Stock	6.2125	6.2204	6.1864	6.1864	1244348.0
2008-07-17 08:30:00	AAPL	Stock	6.1921	6.2125	6.1875	6.2064	560476.0
2008-07-17 09:00:00	AAPL	Stock	6.2071	6.2221	6.1943	6.2175	2293340.0
2008-07-17 09:30:00	AAPL	Stock	6.2143	6.2493	6.1896	6.1954	98273980.0
2008-07-17 10:00:00	AAPL	Stock	6.195	6.205	6.1532	6.1711	67368280.0
2008-07-17 10:30:00	AAPL	Stock	6.17	6.19	6.1511	6.1764	43542968.0
2008-07-17 11:00:00	AAPL	Stock	6.1775	6.2246	6.1489	6.2204	63899024.0
2008-07-17 11:30:00	AAPL	Stock	6.2196	6.2336	6.1954	6.1986	40657148.0
2008-07-17 12:00:00	AAPL	Stock	6.1996	6.1996	6.1643	6.1693	25220328.0
2008-07-17 12:30:00	AAPL	Stock	6.1689	6.2	6.1607	6.1942	26365808.0
2008-07-17 13:00:00	AAPL	Stock	6.1943	6.2396	6.1875	6.2254	42688296.0
2008-07-17 13:30:00	AAPL	Stock	6.2254	6.2464	6.1929	6.1943	45185000.0
2008-07-17 14:00:00	AAPL	Stock	6.1939	6.2093	6.1782	6.2057	47944568.0
2008-07-17 14:30:00	AAPL	Stock	6.205	6.2061	6.1389	6.1625	57027992.0
2008-07-17 15:00:00	AAPL	Stock	6.1632	6.1786	6.1504	6.1693	34735988.0
2008-07-17 15:30:00	AAPL	Stock	6.1696	6.1771	6.1211	6.1343	76298348.0
2008-07-17 16:00:00	AAPL	Stock	6.1304	6.1886	5.9321	5.9964	60785200.0
2008-07-17 16:30:00	AAPL	Stock	5.9932	6.1361	5.9588	5.9893	4854808.0
2008-07-17 17:00:00	AAPL	Stock	5.9893	6.141	5.9568	5.9746	4715900.0
2008-07-17 17:30:00	AAPL	Stock	5.9746	6.2158	5.9682	5.9907	1388016.0
2008-07-17 18:00:00	AAPL	Stock	5.9907	6.0039	5.9886	6.0	373408.0
2008-07-17 18:30:00	AAPL	Stock	6.0	6.0014	5.9932	5.9982	205688.0
2008-07-17 19:00:00	AAPL	Stock	5.9982	5.9996	5.9893	5.9971	127596.0
2008-07-17 19:30:00	AAPL	Stock	5.9932	6.0007	5.9857	6.0	374416.0
2008-07-17 07:00:00	MSFT	Stock	27.49	27.49	27.29	27.44	2228.0
2008-07-17 07:30:00	MSFT	Stock	27.44	27.45	27.41	27.41	3900.0
2008-07-17 08:00:00	MSFT	Stock	27.41	27.5	27.33	27.5	21445.0
2008-07-17 08:30:00	MSFT	Stock	27.5	27.56	27.45	27.54	31131.0
2008-07-17 09:00:00	MSFT	Stock	27.54	27.58	27.46	27.57	33784.0
2008-07-17 09:30:00	MSFT	Stock	27.58	27.73	27.37	27.4	7627585.0
2008-07-17 10:00:00	MSFT	Stock	27.39	27.41	27.11	27.36	7369738.0
2008-07-17 10:30:00	MSFT	Stock	27.37	27.52	27.3	27.5	5407858.0
2008-07-17 11:00:00	MSFT	Stock	27.5	27.65	27.29	27.605	5583048.0
2008-07-17 11:30:00	MSFT	Stock	27.61	27.68	27.46	27.66	3226089.0
2008-07-17 12:00:00	MSFT	Stock	27.65	27.655	27.53	27.55	2698564.0
2008-07-17 12:30:00	MSFT	Stock	27.55	27.55	27.33	27.415	4429520.0
2008-07-17 13:00:00	MSFT	Stock	27.42	27.69	27.4	27.67	3883015.0
2008-07-17 13:30:00	MSFT	Stock	27.66	27.835	27.65	27.69	5255744.0
2008-07-17 14:00:00	MSFT	Stock	27.7	27.8	27.67	27.79	5330710.0
2008-07-17 14:30:00	MSFT	Stock	27.8	27.91	27.74	27.81	7224240.0
2008-07-17 15:00:00	MSFT	Stock	27.82	27.9	27.6	27.61	7699342.0
2008-07-17 15:30:00	MSFT	Stock	27.62	27.76	27.48	27.57	13631141.0
2008-07-17 16:00:00	MSFT	Stock	27.57	27.652	25.77	26.05	8217509.0
2008-07-17 16:30:00	MSFT	Stock	26.05	27.667	25.82	25.82	1588158.0
2008-07-17 17:00:00	MSFT	Stock	25.82	27.542	25.68	25.95	1489198.0
2008-07-17 17:30:00	MSFT	Stock	25.91	25.95	25.8	25.81	83701.0

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

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