PREVIEW / stock_1hour / 2004-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-25.parquet
  size:    495 KB
  rows:    23,353
  symbols: 1,818

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-25 08:00:00	AAPL	Stock	0.5696	0.5696	0.5696	0.5696	11200.0
2004-08-25 09:00:00	AAPL	Stock	0.5688	0.5714	0.567	0.5682	36708896.0
2004-08-25 10:00:00	AAPL	Stock	0.5684	0.5739	0.5666	0.5716	74654664.0
2004-08-25 11:00:00	AAPL	Stock	0.5714	0.5743	0.5704	0.5729	42506912.0
2004-08-25 12:00:00	AAPL	Stock	0.5729	0.5848	0.5725	0.5827	77400456.0
2004-08-25 13:00:00	AAPL	Stock	0.5827	0.5854	0.5807	0.5836	49444528.0
2004-08-25 14:00:00	AAPL	Stock	0.5838	0.5902	0.5834	0.5898	87137960.0
2004-08-25 15:00:00	AAPL	Stock	0.5898	0.592	0.5882	0.5906	114865072.0
2004-08-25 16:00:00	AAPL	Stock	0.5902	0.5921	0.5902	0.5902	17852744.0
2004-08-25 17:00:00	AAPL	Stock	0.5911	0.592	0.5911	0.5916	235200.0
2004-08-25 08:00:00	MSFT	Stock	27.22	27.26	27.19	27.2	958798.0
2004-08-25 09:00:00	MSFT	Stock	27.19	27.35	27.17	27.23	4804324.0
2004-08-25 10:00:00	MSFT	Stock	27.23	27.32	27.18	27.31	4121465.0
2004-08-25 11:00:00	MSFT	Stock	27.31	27.33	27.22	27.28	3985054.0
2004-08-25 12:00:00	MSFT	Stock	27.28	27.42	27.27	27.4	5684384.0
2004-08-25 13:00:00	MSFT	Stock	27.39	27.5	27.37	27.49	7766170.0
2004-08-25 14:00:00	MSFT	Stock	27.49	27.67	27.45	27.58	13282325.0
2004-08-25 15:00:00	MSFT	Stock	27.59	27.62	27.4484	27.54	10258476.0
2004-08-25 16:00:00	MSFT	Stock	27.53	27.57	27.5	27.55	1558767.0
2004-08-25 17:00:00	MSFT	Stock	27.52	27.54	27.45	27.47	34362.0
2004-08-25 18:00:00	MSFT	Stock	27.47	27.53	27.334	27.53	2742.0
2004-08-25 08:00:00	NVDA	Stock	0.1028	0.1037	0.1025	0.1033	2824440.0
2004-08-25 09:00:00	NVDA	Stock	0.1037	0.1038	0.1016	0.102	97426560.0
2004-08-25 10:00:00	NVDA	Stock	0.102	0.1038	0.1017	0.1029	117408240.0
2004-08-25 11:00:00	NVDA	Stock	0.1028	0.1032	0.1019	0.1022	76348440.0
2004-08-25 12:00:00	NVDA	Stock	0.1022	0.104	0.1022	0.1037	61645440.0
2004-08-25 13:00:00	NVDA	Stock	0.1037	0.1042	0.1035	0.1039	54898800.0
2004-08-25 14:00:00	NVDA	Stock	0.1039	0.1051	0.1037	0.1051	63666240.0
2004-08-25 15:00:00	NVDA	Stock	0.105	0.1063	0.1049	0.1055	208540560.0
2004-08-25 16:00:00	NVDA	Stock	0.1056	0.1058	0.1051	0.1056	9609960.0
2004-08-25 17:00:00	NVDA	Stock	0.1057	0.1057	0.1057	0.1057	132000.0
2004-08-25 18:00:00	NVDA	Stock	0.1046	0.1057	0.1046	0.1057	322200.0
2004-08-25 08:00:00	AMZN	Stock	1.9525	1.9525	1.9525	1.9525	4000.0
2004-08-25 09:00:00	AMZN	Stock	1.949	1.957	1.932	1.9325	14091140.0
2004-08-25 10:00:00	AMZN	Stock	1.9325	1.941	1.908	1.9365	23230100.0
2004-08-25 11:00:00	AMZN	Stock	1.9365	1.938	1.9305	1.935	6445920.0
2004-08-25 12:00:00	AMZN	Stock	1.9355	1.9695	1.934	1.9645	18566520.0
2004-08-25 13:00:00	AMZN	Stock	1.9655	1.985	1.9625	1.9745	13802640.0
2004-08-25 14:00:00	AMZN	Stock	1.9745	2.0225	1.9745	2.015	32724480.0
2004-08-25 15:00:00	AMZN	Stock	2.014	2.0245	2.0075	2.015	29531880.0
2004-08-25 16:00:00	AMZN	Stock	2.017	2.0195	2.013	2.015	1843660.0
2004-08-25 17:00:00	AMZN	Stock	2.018	2.018	2.015	2.0175	136000.0
2004-08-25 18:00:00	AMZN	Stock	2.0195	2.0195	2.0195	2.0195	14000.0
2004-08-25 09:00:00	CL	Stock	26.65	26.75	26.635	26.65	189000.0
2004-08-25 10:00:00	CL	Stock	26.655	26.655	26.56	26.64	207200.0
2004-08-25 11:00:00	CL	Stock	26.64	26.675	26.575	26.67	262000.0
2004-08-25 12:00:00	CL	Stock	26.66	26.8	26.66	26.785	248600.0
2004-08-25 13:00:00	CL	Stock	26.78	26.86	26.775	26.84	278000.0
2004-08-25 14:00:00	CL	Stock	26.85	26.935	26.83	26.9	268400.0
2004-08-25 15:00:00	CL	Stock	26.905	26.955	26.85	26.9	493200.0

> showing 50 of 23,353 rows — these rows as CSV

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