PREVIEW / stock_30min / 2007-08-22

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-22.parquet
  size:    1.1 MB
  rows:    65,337
  symbols: 3,111

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-08-22 09:30:00	AAPL	Stock	4.6864	4.7368	4.6739	4.6968	195913788.0
2007-08-22 10:00:00	AAPL	Stock	4.6968	4.6982	4.6707	4.6846	101863440.0
2007-08-22 10:30:00	AAPL	Stock	4.6846	4.7054	4.6786	4.6796	68184844.0
2007-08-22 11:00:00	AAPL	Stock	4.68	4.6907	4.6661	4.6818	70389676.0
2007-08-22 11:30:00	AAPL	Stock	4.6825	4.6982	4.6768	4.6889	41448372.0
2007-08-22 12:00:00	AAPL	Stock	4.6886	4.7	4.6811	4.6857	40708752.0
2007-08-22 12:30:00	AAPL	Stock	4.6857	4.6896	4.6664	4.6689	49248444.0
2007-08-22 13:00:00	AAPL	Stock	4.6689	4.6857	4.6546	4.6829	59608220.0
2007-08-22 13:30:00	AAPL	Stock	4.6829	4.6964	4.6825	4.6929	48483288.0
2007-08-22 14:00:00	AAPL	Stock	4.6929	4.6936	4.6786	4.685	38652824.0
2007-08-22 14:30:00	AAPL	Stock	4.6846	4.7196	4.6843	4.7171	73524640.0
2007-08-22 15:00:00	AAPL	Stock	4.7171	4.7339	4.7079	4.7241	77435344.0
2007-08-22 15:30:00	AAPL	Stock	4.7243	4.7411	4.7186	4.7325	103628924.0
2007-08-22 16:00:00	AAPL	Stock	4.7329	4.7329	4.7321	4.7325	9538928.0
2007-08-22 09:30:00	MSFT	Stock	28.27	28.32	28.06	28.09	3713734.0
2007-08-22 10:00:00	MSFT	Stock	28.09	28.18	28.07	28.15	2351656.0
2007-08-22 10:30:00	MSFT	Stock	28.14	28.2	28.1	28.13	1968401.0
2007-08-22 11:00:00	MSFT	Stock	28.132	28.25	28.091	28.23	3775115.0
2007-08-22 11:30:00	MSFT	Stock	28.231	28.25	28.17	28.2	1513868.0
2007-08-22 12:00:00	MSFT	Stock	28.191	28.21	28.14	28.17	2018628.0
2007-08-22 12:30:00	MSFT	Stock	28.17	28.18	28.07	28.11	2106069.0
2007-08-22 13:00:00	MSFT	Stock	28.103	28.15	28.06	28.121	1728906.0
2007-08-22 13:30:00	MSFT	Stock	28.12	28.15	28.1	28.13	1466347.0
2007-08-22 14:00:00	MSFT	Stock	28.13	28.14	28.05	28.07	2047539.0
2007-08-22 14:30:00	MSFT	Stock	28.075	28.14	28.01	28.063	2234041.0
2007-08-22 15:00:00	MSFT	Stock	28.07	28.19	28.05	28.13	4154695.0
2007-08-22 15:30:00	MSFT	Stock	28.14	28.25	28.13	28.21	7038502.0
2007-08-22 16:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	1354429.0
2007-08-22 08:00:00	NVDA	Stock	0.7892	0.795	0.7892	0.795	274560.0
2007-08-22 08:30:00	NVDA	Stock	0.795	0.8025	0.795	0.8025	792360.0
2007-08-22 09:00:00	NVDA	Stock	0.8017	0.8078	0.8013	0.805	6886920.0
2007-08-22 09:30:00	NVDA	Stock	0.8065	0.809	0.797	0.8017	87127500.0
2007-08-22 10:00:00	NVDA	Stock	0.8017	0.8033	0.7962	0.7982	66238620.0
2007-08-22 10:30:00	NVDA	Stock	0.7985	0.8071	0.797	0.802	43332420.0
2007-08-22 11:00:00	NVDA	Stock	0.8023	0.8032	0.7948	0.7983	35481660.0
2007-08-22 11:30:00	NVDA	Stock	0.7987	0.801	0.7977	0.799	26070120.0
2007-08-22 12:00:00	NVDA	Stock	0.799	0.8015	0.7937	0.7953	28480020.0
2007-08-22 12:30:00	NVDA	Stock	0.7953	0.7983	0.7925	0.7972	23496240.0
2007-08-22 13:00:00	NVDA	Stock	0.797	0.7983	0.793	0.7967	30213420.0
2007-08-22 13:30:00	NVDA	Stock	0.7967	0.805	0.7948	0.8015	31778400.0
2007-08-22 14:00:00	NVDA	Stock	0.8013	0.8027	0.7972	0.7976	18447060.0
2007-08-22 14:30:00	NVDA	Stock	0.7975	0.806	0.7958	0.8056	38939400.0
2007-08-22 15:00:00	NVDA	Stock	0.8055	0.8115	0.8052	0.8072	48092880.0
2007-08-22 15:30:00	NVDA	Stock	0.8072	0.8115	0.8052	0.8068	56661660.0
2007-08-22 16:00:00	NVDA	Stock	0.8067	0.8078	0.8058	0.8078	452640.0
2007-08-22 16:30:00	NVDA	Stock	0.8068	0.809	0.8062	0.8062	1465380.0
2007-08-22 17:00:00	NVDA	Stock	0.8065	0.8065	0.8062	0.8062	119400.0
2007-08-22 17:30:00	NVDA	Stock	0.8062	0.8062	0.8062	0.8062	30000.0
2007-08-22 18:00:00	NVDA	Stock	0.8068	0.813	0.8068	0.813	5113080.0
2007-08-22 18:30:00	NVDA	Stock	0.8133	0.8133	0.8065	0.813	159000.0

> showing 50 of 65,337 rows — these rows as CSV

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