PREVIEW / stock_1hour / 2004-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-06.parquet
  size:    508 KB
  rows:    24,390
  symbols: 1,804

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
2004-08-06 08:00:00	AAPL	Stock	0.5879	0.6152	0.5488	0.5488	294560.0
2004-08-06 09:00:00	AAPL	Stock	0.5527	0.5554	0.5473	0.5493	48754384.0
2004-08-06 10:00:00	AAPL	Stock	0.5493	0.55	0.5393	0.54	94574424.0
2004-08-06 11:00:00	AAPL	Stock	0.5399	0.5464	0.5391	0.5454	45525816.0
2004-08-06 12:00:00	AAPL	Stock	0.5454	0.5511	0.5446	0.5498	46428200.0
2004-08-06 13:00:00	AAPL	Stock	0.5496	0.5496	0.5386	0.54	43637552.0
2004-08-06 14:00:00	AAPL	Stock	0.54	0.5425	0.5384	0.5393	45188808.0
2004-08-06 15:00:00	AAPL	Stock	0.5393	0.5404	0.5304	0.5305	132493312.0
2004-08-06 16:00:00	AAPL	Stock	0.5316	0.5427	0.5304	0.532	17809568.0
2004-08-06 17:00:00	AAPL	Stock	0.5336	0.5341	0.5336	0.5339	38640.0
2004-08-06 18:00:00	AAPL	Stock	0.5321	0.5321	0.5321	0.5321	89600.0
2004-08-06 08:00:00	MSFT	Stock	27.56	27.71	27.26	27.28	307336.0
2004-08-06 09:00:00	MSFT	Stock	27.3	27.52	27.2	27.38	9206900.0
2004-08-06 10:00:00	MSFT	Stock	27.38	27.86	27.38	27.62	16171856.0
2004-08-06 11:00:00	MSFT	Stock	27.62	27.68	27.5	27.569	8323956.0
2004-08-06 12:00:00	MSFT	Stock	27.56	27.62	27.47	27.52	4235157.0
2004-08-06 13:00:00	MSFT	Stock	27.52	27.61	27.34	27.43	5973612.0
2004-08-06 14:00:00	MSFT	Stock	27.43	27.44	27.29	27.36	7599781.0
2004-08-06 15:00:00	MSFT	Stock	27.37	27.41	27.06	27.14	20556890.0
2004-08-06 16:00:00	MSFT	Stock	27.13	27.22	27.1	27.18	1397257.0
2004-08-06 17:00:00	MSFT	Stock	27.2	27.4451	27.2	27.4451	61000.0
2004-08-06 18:00:00	MSFT	Stock	27.2	27.2	27.18	27.18	2500.0
2004-08-06 08:00:00	NVDA	Stock	0.0917	0.0933	0.0893	0.0897	64232160.0
2004-08-06 09:00:00	NVDA	Stock	0.0897	0.0908	0.0799	0.0812	1307299560.0
2004-08-06 10:00:00	NVDA	Stock	0.0812	0.0837	0.0812	0.0821	820948800.0
2004-08-06 11:00:00	NVDA	Stock	0.0821	0.0827	0.0808	0.0821	551331840.0
2004-08-06 12:00:00	NVDA	Stock	0.0821	0.0839	0.0819	0.0829	554303400.0
2004-08-06 13:00:00	NVDA	Stock	0.0829	0.084	0.0817	0.0821	386241120.0
2004-08-06 14:00:00	NVDA	Stock	0.0821	0.0827	0.0811	0.0813	289376640.0
2004-08-06 15:00:00	NVDA	Stock	0.0812	0.0813	0.0781	0.0784	925320960.0
2004-08-06 16:00:00	NVDA	Stock	0.0783	0.0812	0.0772	0.0791	119549880.0
2004-08-06 17:00:00	NVDA	Stock	0.079	0.0792	0.0783	0.079	2303160.0
2004-08-06 18:00:00	NVDA	Stock	0.079	0.0791	0.0787	0.0787	2094000.0
2004-08-06 08:00:00	AMZN	Stock	1.7605	1.765	1.7445	1.7625	1264700.0
2004-08-06 09:00:00	AMZN	Stock	1.76	1.7855	1.7425	1.775	42670020.0
2004-08-06 10:00:00	AMZN	Stock	1.775	1.812	1.7515	1.79	61917820.0
2004-08-06 11:00:00	AMZN	Stock	1.7915	1.8285	1.7875	1.8125	27472520.0
2004-08-06 12:00:00	AMZN	Stock	1.8115	1.8335	1.8075	1.817	24735280.0
2004-08-06 13:00:00	AMZN	Stock	1.817	1.8175	1.787	1.792	16968860.0
2004-08-06 14:00:00	AMZN	Stock	1.792	1.798	1.778	1.779	13736820.0
2004-08-06 15:00:00	AMZN	Stock	1.78	1.78	1.7665	1.778	35336580.0
2004-08-06 16:00:00	AMZN	Stock	1.778	1.778	1.7675	1.7752	1792900.0
2004-08-06 17:00:00	AMZN	Stock	1.7745	1.7929	1.7745	1.7929	75440.0
2004-08-06 18:00:00	AMZN	Stock	1.775	1.775	1.7675	1.7675	39400.0
2004-08-06 09:00:00	CL	Stock	26.05	26.075	25.925	26.005	387400.0
2004-08-06 10:00:00	CL	Stock	26.015	26.19	25.905	26.09	529200.0
2004-08-06 11:00:00	CL	Stock	26.09	26.09	25.89	25.89	410400.0
2004-08-06 12:00:00	CL	Stock	25.89	25.99	25.85	25.94	198600.0
2004-08-06 13:00:00	CL	Stock	25.94	26.025	25.915	25.975	96800.0
2004-08-06 14:00:00	CL	Stock	25.975	25.98	25.83	25.85	352000.0

> showing 50 of 24,390 rows — these rows as CSV

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