PREVIEW / stock_1hour / 2005-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-15.parquet
  size:    544 KB
  rows:    25,501
  symbols: 1,935

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
2005-02-15 08:00:00	AAPL	Stock	1.5355	1.545	1.5313	1.5441	22981504.0
2005-02-15 09:00:00	AAPL	Stock	1.5441	1.5604	1.515	1.5505	423670912.0
2005-02-15 10:00:00	AAPL	Stock	1.5509	1.5754	1.5482	1.5738	324329600.0
2005-02-15 11:00:00	AAPL	Stock	1.5734	1.5907	1.5698	1.5793	334092528.0
2005-02-15 12:00:00	AAPL	Stock	1.5795	1.5825	1.5573	1.5627	308548688.0
2005-02-15 13:00:00	AAPL	Stock	1.5627	1.5655	1.5455	1.5455	236482904.0
2005-02-15 14:00:00	AAPL	Stock	1.5455	1.5654	1.5357	1.5634	309813448.0
2005-02-15 15:00:00	AAPL	Stock	1.5634	1.5798	1.5618	1.578	323953784.0
2005-02-15 16:00:00	AAPL	Stock	1.5788	1.5804	1.5695	1.5798	13870696.0
2005-02-15 17:00:00	AAPL	Stock	1.5795	1.5804	1.5527	1.58	1636432.0
2005-02-15 18:00:00	AAPL	Stock	1.5804	1.582	1.5798	1.5818	452256.0
2005-02-15 08:00:00	MSFT	Stock	26.03	26.05	26.0	26.03	37081.0
2005-02-15 09:00:00	MSFT	Stock	26.03	26.25	25.9	25.98	9476828.0
2005-02-15 10:00:00	MSFT	Stock	25.98	26.08	25.92	26.07	13034983.0
2005-02-15 11:00:00	MSFT	Stock	26.06	26.08	25.97	25.98	9326669.0
2005-02-15 12:00:00	MSFT	Stock	25.98	26.06	25.94	25.98	5841821.0
2005-02-15 13:00:00	MSFT	Stock	25.97	25.98	25.86	25.91	9447838.0
2005-02-15 14:00:00	MSFT	Stock	25.91	26.05	25.88	25.96	12078273.0
2005-02-15 15:00:00	MSFT	Stock	25.96	26.0	25.9	25.94	14819590.0
2005-02-15 16:00:00	MSFT	Stock	25.94	25.97	25.92	25.95	823801.0
2005-02-15 17:00:00	MSFT	Stock	25.94	25.96	25.92	25.94	694809.0
2005-02-15 18:00:00	MSFT	Stock	25.94	25.94	25.93	25.93	1281.0
2005-02-15 09:00:00	NVDA	Stock	0.2142	0.2202	0.2137	0.2194	119263800.0
2005-02-15 10:00:00	NVDA	Stock	0.2195	0.2221	0.2192	0.2208	147840840.0
2005-02-15 11:00:00	NVDA	Stock	0.221	0.2221	0.2203	0.2219	85991160.0
2005-02-15 12:00:00	NVDA	Stock	0.2218	0.2219	0.219	0.2191	62654880.0
2005-02-15 13:00:00	NVDA	Stock	0.2192	0.2192	0.2144	0.2161	120051240.0
2005-02-15 14:00:00	NVDA	Stock	0.2162	0.2172	0.2144	0.2154	107056920.0
2005-02-15 15:00:00	NVDA	Stock	0.2153	0.2161	0.2147	0.2153	94447920.0
2005-02-15 16:00:00	NVDA	Stock	0.2153	0.2161	0.215	0.2161	7448040.0
2005-02-15 17:00:00	NVDA	Stock	0.2165	0.2165	0.2157	0.216	192000.0
2005-02-15 08:00:00	AMZN	Stock	1.805	1.8125	1.804	1.8115	67740.0
2005-02-15 09:00:00	AMZN	Stock	1.8095	1.821	1.7875	1.7955	20375400.0
2005-02-15 10:00:00	AMZN	Stock	1.7955	1.8155	1.7875	1.815	24262340.0
2005-02-15 11:00:00	AMZN	Stock	1.815	1.8225	1.809	1.81	12641560.0
2005-02-15 12:00:00	AMZN	Stock	1.81	1.8145	1.801	1.803	6662720.0
2005-02-15 13:00:00	AMZN	Stock	1.8035	1.8035	1.7875	1.797	15663260.0
2005-02-15 14:00:00	AMZN	Stock	1.797	1.802	1.791	1.797	7665560.0
2005-02-15 15:00:00	AMZN	Stock	1.7975	1.807	1.795	1.8045	13780600.0
2005-02-15 16:00:00	AMZN	Stock	1.8065	1.817	1.801	1.8065	513120.0
2005-02-15 17:00:00	AMZN	Stock	1.8015	1.807	1.8015	1.807	91860.0
2005-02-15 18:00:00	AMZN	Stock	1.801	1.8065	1.801	1.8065	12000.0
2005-02-15 09:00:00	CL	Stock	27.25	27.25	27.05	27.085	398400.0
2005-02-15 10:00:00	CL	Stock	27.08	27.09	26.815	26.865	1409800.0
2005-02-15 11:00:00	CL	Stock	26.865	26.965	26.85	26.935	987400.0
2005-02-15 12:00:00	CL	Stock	26.93	26.945	26.88	26.89	982000.0
2005-02-15 13:00:00	CL	Stock	26.895	26.935	26.85	26.9	410200.0
2005-02-15 14:00:00	CL	Stock	26.905	26.95	26.885	26.945	628000.0
2005-02-15 15:00:00	CL	Stock	26.945	27.06	26.92	26.98	1109200.0
2005-02-15 16:00:00	CL	Stock	26.96	26.96	26.96	26.96	13600.0

> showing 50 of 25,501 rows — these rows as CSV

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