PREVIEW / stock_30min / 2007-03-15

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-15.parquet
  size:    1019 KB
  rows:    55,114
  symbols: 2,538

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-03-15 07:30:00	AAPL	Stock	3.2314	3.2346	3.2279	3.2321	303100.0
2007-03-15 08:00:00	AAPL	Stock	3.2332	3.2339	3.2232	3.2293	1054788.0
2007-03-15 08:30:00	AAPL	Stock	3.2275	3.2275	3.2114	3.215	3470712.0
2007-03-15 09:00:00	AAPL	Stock	3.2168	3.2179	3.2054	3.2129	1821848.0
2007-03-15 09:30:00	AAPL	Stock	3.2121	3.2268	3.1996	3.2261	80415328.0
2007-03-15 10:00:00	AAPL	Stock	3.2261	3.2271	3.2096	3.2232	47030424.0
2007-03-15 10:30:00	AAPL	Stock	3.2236	3.2246	3.2043	3.2096	47464564.0
2007-03-15 11:00:00	AAPL	Stock	3.2096	3.2268	3.1996	3.2125	56692552.0
2007-03-15 11:30:00	AAPL	Stock	3.2121	3.2196	3.1968	3.1996	40673360.0
2007-03-15 12:00:00	AAPL	Stock	3.2	3.2057	3.1936	3.2039	35298928.0
2007-03-15 12:30:00	AAPL	Stock	3.2039	3.2143	3.2036	3.2043	27269284.0
2007-03-15 13:00:00	AAPL	Stock	3.2039	3.2089	3.1957	3.1983	21603624.0
2007-03-15 13:30:00	AAPL	Stock	3.1982	3.2029	3.1896	3.1975	34911996.0
2007-03-15 14:00:00	AAPL	Stock	3.1975	3.2036	3.195	3.1989	23499476.0
2007-03-15 14:30:00	AAPL	Stock	3.1989	3.2068	3.1979	3.2046	19098716.0
2007-03-15 15:00:00	AAPL	Stock	3.205	3.2118	3.2011	3.2071	33317340.0
2007-03-15 15:30:00	AAPL	Stock	3.2075	3.2121	3.1968	3.1989	45262980.0
2007-03-15 16:00:00	AAPL	Stock	3.1971	3.1993	3.1957	3.1961	3545332.0
2007-03-15 16:30:00	AAPL	Stock	3.1964	3.1964	3.195	3.195	260036.0
2007-03-15 17:00:00	AAPL	Stock	3.1957	3.1989	3.1957	3.1961	27779304.0
2007-03-15 17:30:00	AAPL	Stock	3.1961	3.1964	3.1961	3.1964	47600.0
2007-03-15 18:00:00	AAPL	Stock	3.1964	3.1964	3.1957	3.1964	69244.0
2007-03-15 18:30:00	AAPL	Stock	3.1954	3.1964	3.1954	3.1964	53200.0
2007-03-15 19:00:00	AAPL	Stock	3.1964	3.1986	3.1964	3.1986	321412.0
2007-03-15 19:30:00	AAPL	Stock	3.1986	3.2011	3.1986	3.1986	48944.0
2007-03-15 07:30:00	MSFT	Stock	27.37	27.46	27.37	27.46	400.0
2007-03-15 08:00:00	MSFT	Stock	27.46	27.46	27.41	27.43	5400.0
2007-03-15 08:30:00	MSFT	Stock	27.43	27.44	27.37	27.38	63900.0
2007-03-15 09:00:00	MSFT	Stock	27.37	27.38	27.32	27.35	119092.0
2007-03-15 09:30:00	MSFT	Stock	27.35	27.47	27.2	27.39	5497476.0
2007-03-15 10:00:00	MSFT	Stock	27.39	27.45	27.3	27.39	3664116.0
2007-03-15 10:30:00	MSFT	Stock	27.38	27.47	27.31	27.35	3850019.0
2007-03-15 11:00:00	MSFT	Stock	27.34	27.46	27.21	27.31	5389648.0
2007-03-15 11:30:00	MSFT	Stock	27.31	27.32	27.24	27.25	2662937.0
2007-03-15 12:00:00	MSFT	Stock	27.25	27.28	27.21	27.26	2634411.0
2007-03-15 12:30:00	MSFT	Stock	27.25	27.32	27.25	27.28	2186273.0
2007-03-15 13:00:00	MSFT	Stock	27.272	27.36	27.27	27.33	3767204.0
2007-03-15 13:30:00	MSFT	Stock	27.33	27.34	27.2	27.27	3347910.0
2007-03-15 14:00:00	MSFT	Stock	27.26	27.3	27.23	27.26	2765255.0
2007-03-15 14:30:00	MSFT	Stock	27.26	27.35	27.24	27.27	2608130.0
2007-03-15 15:00:00	MSFT	Stock	27.26	27.3	27.24	27.24	3821423.0
2007-03-15 15:30:00	MSFT	Stock	27.24	27.31	27.23	27.28	4957363.0
2007-03-15 16:00:00	MSFT	Stock	27.27	27.3	27.26	27.28	401974.0
2007-03-15 16:30:00	MSFT	Stock	27.265	27.265	27.25	27.25	77200.0
2007-03-15 17:00:00	MSFT	Stock	27.28	27.28	27.28	27.28	1856611.0
2007-03-15 17:30:00	MSFT	Stock	27.26	27.26	27.26	27.26	1700.0
2007-03-15 18:00:00	MSFT	Stock	27.26	27.26	27.26	27.26	400.0
2007-03-15 18:30:00	MSFT	Stock	27.24	27.26	27.16	27.26	9039.0
2007-03-15 19:00:00	MSFT	Stock	27.19	27.19	27.17	27.17	460.0
2007-03-15 19:30:00	MSFT	Stock	27.22	27.24	27.22	27.24	750.0

> showing 50 of 55,114 rows — these rows as CSV

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