PREVIEW / stock_30min / 2008-08-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-25.parquet
  size:    1.2 MB
  rows:    67,077
  symbols: 3,301

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-08-25 06:30:00	AAPL	Stock	6.3086	6.3086	6.3086	6.3086	2800.0
2008-08-25 07:30:00	AAPL	Stock	6.3036	6.3046	6.3032	6.3036	65800.0
2008-08-25 08:00:00	AAPL	Stock	6.3107	6.3125	6.2875	6.2893	607964.0
2008-08-25 08:30:00	AAPL	Stock	6.2893	6.2893	6.2818	6.2857	473620.0
2008-08-25 09:00:00	AAPL	Stock	6.2857	6.3	6.2814	6.2836	892808.0
2008-08-25 09:30:00	AAPL	Stock	6.285	6.2939	6.2429	6.2586	59924760.0
2008-08-25 10:00:00	AAPL	Stock	6.26	6.2786	6.25	6.26	36375024.0
2008-08-25 10:30:00	AAPL	Stock	6.2611	6.2636	6.205	6.2071	45139164.0
2008-08-25 11:00:00	AAPL	Stock	6.2061	6.2279	6.1986	6.2225	27974240.0
2008-08-25 11:30:00	AAPL	Stock	6.2218	6.2264	6.1914	6.1929	22647408.0
2008-08-25 12:00:00	AAPL	Stock	6.1918	6.1961	6.1786	6.1854	31305036.0
2008-08-25 12:30:00	AAPL	Stock	6.1868	6.1943	6.1664	6.1757	26134500.0
2008-08-25 13:00:00	AAPL	Stock	6.175	6.2107	6.1732	6.1975	23359224.0
2008-08-25 13:30:00	AAPL	Stock	6.1982	6.2043	6.1786	6.1814	25138400.0
2008-08-25 14:00:00	AAPL	Stock	6.1814	6.1939	6.1707	6.1775	21373548.0
2008-08-25 14:30:00	AAPL	Stock	6.1786	6.1839	6.1561	6.1607	34285496.0
2008-08-25 15:00:00	AAPL	Stock	6.1611	6.1671	6.1429	6.1464	43499036.0
2008-08-25 15:30:00	AAPL	Stock	6.1468	6.1746	6.1307	6.1696	59101112.0
2008-08-25 16:00:00	AAPL	Stock	6.1671	6.2013	6.1364	6.1629	13599124.0
2008-08-25 16:30:00	AAPL	Stock	6.1643	6.1679	6.1625	6.1643	5926284.0
2008-08-25 17:00:00	AAPL	Stock	6.1671	6.1679	6.1643	6.1661	219100.0
2008-08-25 17:30:00	AAPL	Stock	6.1661	6.1679	6.1657	6.1671	116452.0
2008-08-25 18:00:00	AAPL	Stock	6.1646	6.1675	6.1625	6.1632	95900.0
2008-08-25 18:30:00	AAPL	Stock	6.1668	6.1696	6.1632	6.1643	21308.0
2008-08-25 19:00:00	AAPL	Stock	6.1643	6.1661	6.1643	6.1661	9800.0
2008-08-25 19:30:00	AAPL	Stock	6.1661	6.1675	6.1643	6.1661	56140.0
2008-08-25 07:30:00	MSFT	Stock	27.75	27.75	27.75	27.75	100.0
2008-08-25 08:00:00	MSFT	Stock	27.88	27.88	27.79	27.79	787.0
2008-08-25 08:30:00	MSFT	Stock	27.68	27.68	27.68	27.68	1000.0
2008-08-25 09:00:00	MSFT	Stock	27.68	27.71	27.55	27.62	50112.0
2008-08-25 09:30:00	MSFT	Stock	27.62	27.75	27.55	27.7	5197517.0
2008-08-25 10:00:00	MSFT	Stock	27.7	27.84	27.66	27.75	4153565.0
2008-08-25 10:30:00	MSFT	Stock	27.75	27.81	27.7	27.72	2764751.0
2008-08-25 11:00:00	MSFT	Stock	27.71	27.72	27.68	27.69	2499526.0
2008-08-25 11:30:00	MSFT	Stock	27.69	27.7	27.62	27.65	2533602.0
2008-08-25 12:00:00	MSFT	Stock	27.65	27.66	27.59	27.6	5139960.0
2008-08-25 12:30:00	MSFT	Stock	27.61	27.65	27.55	27.55	2164577.0
2008-08-25 13:00:00	MSFT	Stock	27.55	27.63	27.55	27.55	2661255.0
2008-08-25 13:30:00	MSFT	Stock	27.55	27.6	27.51	27.55	2436228.0
2008-08-25 14:00:00	MSFT	Stock	27.55	27.61	27.49	27.49	3265454.0
2008-08-25 14:30:00	MSFT	Stock	27.49	27.54	27.46	27.51	2610595.0
2008-08-25 15:00:00	MSFT	Stock	27.5	27.58	27.48	27.54	3979045.0
2008-08-25 15:30:00	MSFT	Stock	27.545	27.69	27.47	27.67	7911917.0
2008-08-25 16:00:00	MSFT	Stock	27.67	27.72	27.474	27.564	2739698.0
2008-08-25 16:30:00	MSFT	Stock	27.66	27.68	27.62	27.66	766655.0
2008-08-25 17:00:00	MSFT	Stock	27.62	27.62	27.62	27.62	400.0
2008-08-25 17:30:00	MSFT	Stock	27.71	27.75	27.71	27.75	8288.0
2008-08-25 19:30:00	MSFT	Stock	27.73	27.73	27.73	27.73	500.0
2008-08-25 08:00:00	NVDA	Stock	0.3395	0.3395	0.3395	0.3395	8800.0
2008-08-25 08:30:00	NVDA	Stock	0.3395	0.34	0.3362	0.34	67800.0

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

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