PREVIEW / stock_1hour / 2005-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-21.parquet
  size:    546 KB
  rows:    25,733
  symbols: 1,953

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-03-21 08:00:00	AAPL	Stock	1.5375	1.5432	1.5321	1.5389	1913744.0
2005-03-21 09:00:00	AAPL	Stock	1.5389	1.5564	1.5336	1.5532	82806808.0
2005-03-21 10:00:00	AAPL	Stock	1.5532	1.5536	1.5307	1.5389	97600440.0
2005-03-21 11:00:00	AAPL	Stock	1.5389	1.5536	1.5389	1.5489	72858576.0
2005-03-21 12:00:00	AAPL	Stock	1.5493	1.5675	1.5489	1.5643	94917564.0
2005-03-21 13:00:00	AAPL	Stock	1.5643	1.5654	1.5571	1.5601	48501012.0
2005-03-21 14:00:00	AAPL	Stock	1.56	1.5643	1.555	1.5629	38948168.0
2005-03-21 15:00:00	AAPL	Stock	1.5629	1.5704	1.5571	1.5608	86335900.0
2005-03-21 16:00:00	AAPL	Stock	1.5611	1.5629	1.5582	1.5607	1885688.0
2005-03-21 17:00:00	AAPL	Stock	1.5607	1.5625	1.5589	1.5593	429940.0
2005-03-21 18:00:00	AAPL	Stock	1.5604	1.5625	1.5589	1.5625	135800.0
2005-03-21 08:00:00	MSFT	Stock	24.37	24.4	24.35	24.35	132321.0
2005-03-21 09:00:00	MSFT	Stock	24.35	24.36	24.26	24.28	8146893.0
2005-03-21 10:00:00	MSFT	Stock	24.27	24.3	24.15	24.25	14813211.0
2005-03-21 11:00:00	MSFT	Stock	24.24	24.28	24.19	24.27	7738528.0
2005-03-21 12:00:00	MSFT	Stock	24.27	24.36	24.23	24.24	9970667.0
2005-03-21 13:00:00	MSFT	Stock	24.23	24.26	24.2	24.22	7593648.0
2005-03-21 14:00:00	MSFT	Stock	24.22	24.25	24.17	24.24	8164398.0
2005-03-21 15:00:00	MSFT	Stock	24.24	24.29	24.18	24.19	11928719.0
2005-03-21 16:00:00	MSFT	Stock	24.18	24.2	24.16	24.2	1647102.0
2005-03-21 17:00:00	MSFT	Stock	24.17	24.2	24.16	24.18	143356.0
2005-03-21 18:00:00	MSFT	Stock	24.18	24.2	24.17	24.17	2020.0
2005-03-21 09:00:00	NVDA	Stock	0.2002	0.2035	0.2001	0.2033	63566160.0
2005-03-21 10:00:00	NVDA	Stock	0.2033	0.2034	0.2012	0.2034	89731920.0
2005-03-21 11:00:00	NVDA	Stock	0.2034	0.2056	0.2007	0.205	87695880.0
2005-03-21 12:00:00	NVDA	Stock	0.205	0.207	0.205	0.2064	89256000.0
2005-03-21 13:00:00	NVDA	Stock	0.2063	0.2088	0.2052	0.2077	102326640.0
2005-03-21 14:00:00	NVDA	Stock	0.2077	0.2085	0.2072	0.2083	95513520.0
2005-03-21 15:00:00	NVDA	Stock	0.2083	0.2088	0.2074	0.2082	112085640.0
2005-03-21 16:00:00	NVDA	Stock	0.2083	0.2084	0.2062	0.2062	6325560.0
2005-03-21 17:00:00	NVDA	Stock	0.2071	0.2082	0.2065	0.2082	408960.0
2005-03-21 18:00:00	NVDA	Stock	0.2074	0.2074	0.2066	0.2066	414000.0
2005-03-21 08:00:00	AMZN	Stock	1.7	1.705	1.7	1.705	6000.0
2005-03-21 09:00:00	AMZN	Stock	1.7015	1.7315	1.6875	1.7065	13320120.0
2005-03-21 10:00:00	AMZN	Stock	1.7065	1.7065	1.682	1.692	17988540.0
2005-03-21 11:00:00	AMZN	Stock	1.6915	1.716	1.6855	1.7075	16938340.0
2005-03-21 12:00:00	AMZN	Stock	1.7076	1.7215	1.6955	1.6955	9539120.0
2005-03-21 13:00:00	AMZN	Stock	1.6955	1.6985	1.6845	1.685	9155140.0
2005-03-21 14:00:00	AMZN	Stock	1.6855	1.69	1.677	1.683	18498500.0
2005-03-21 15:00:00	AMZN	Stock	1.6835	1.6885	1.677	1.684	32762060.0
2005-03-21 16:00:00	AMZN	Stock	1.683	1.688	1.682	1.6835	1317120.0
2005-03-21 17:00:00	AMZN	Stock	1.6835	1.6835	1.6835	1.6835	18200.0
2005-03-21 18:00:00	AMZN	Stock	1.684	1.684	1.684	1.684	9000.0
2005-03-21 09:00:00	CL	Stock	26.07	26.1	25.905	25.985	156400.0
2005-03-21 10:00:00	CL	Stock	25.985	26.02	25.925	25.955	379200.0
2005-03-21 11:00:00	CL	Stock	25.96	25.98	25.855	25.88	393800.0
2005-03-21 12:00:00	CL	Stock	25.88	25.94	25.815	25.815	466200.0
2005-03-21 13:00:00	CL	Stock	25.815	25.86	25.77	25.78	339600.0
2005-03-21 14:00:00	CL	Stock	25.78	25.86	25.742	25.825	454400.0
2005-03-21 15:00:00	CL	Stock	25.825	25.875	25.805	25.83	607800.0

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

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