PREVIEW / stock_1hour / 2005-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-28.parquet
  size:    564 KB
  rows:    26,875
  symbols: 2,076

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-09-28 08:00:00	AAPL	Stock	1.9111	1.9125	1.8911	1.8982	2414020.0
2005-09-28 09:00:00	AAPL	Stock	1.8982	1.9036	1.8679	1.8746	124802720.0
2005-09-28 10:00:00	AAPL	Stock	1.8743	1.8779	1.8393	1.8554	227437280.0
2005-09-28 11:00:00	AAPL	Stock	1.8555	1.8679	1.8482	1.8586	99761788.0
2005-09-28 12:00:00	AAPL	Stock	1.8586	1.8589	1.8482	1.8564	44754276.0
2005-09-28 13:00:00	AAPL	Stock	1.8564	1.8639	1.8196	1.8243	131070996.0
2005-09-28 14:00:00	AAPL	Stock	1.825	1.8393	1.8107	1.8232	273780864.0
2005-09-28 15:00:00	AAPL	Stock	1.8232	1.8261	1.8068	1.8246	204137556.0
2005-09-28 16:00:00	AAPL	Stock	1.8239	1.8422	1.8236	1.8286	3100496.0
2005-09-28 17:00:00	AAPL	Stock	1.8491	1.8491	1.8204	1.8239	929488.0
2005-09-28 18:00:00	AAPL	Stock	1.8257	1.8371	1.8246	1.8339	1093568.0
2005-09-28 05:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	100.0
2005-09-28 08:00:00	MSFT	Stock	25.4	25.4	25.38	25.38	32316.0
2005-09-28 09:00:00	MSFT	Stock	25.38	25.64	25.37	25.58	9223650.0
2005-09-28 10:00:00	MSFT	Stock	25.57	25.78	25.54	25.7	11003186.0
2005-09-28 11:00:00	MSFT	Stock	25.7	25.73	25.609	25.63	8795036.0
2005-09-28 12:00:00	MSFT	Stock	25.64	25.68	25.54	25.57	8559128.0
2005-09-28 13:00:00	MSFT	Stock	25.56	25.65	25.519	25.62	7511216.0
2005-09-28 14:00:00	MSFT	Stock	25.62	25.87	25.62	25.79	10558082.0
2005-09-28 15:00:00	MSFT	Stock	25.8	25.84	25.619	25.69	11905279.0
2005-09-28 16:00:00	MSFT	Stock	25.67	25.7	25.39	25.68	2007373.0
2005-09-28 17:00:00	MSFT	Stock	25.62	25.67	25.6	25.62	179594.0
2005-09-28 18:00:00	MSFT	Stock	25.761	25.761	25.61	25.63	5783.0
2005-09-28 09:00:00	NVDA	Stock	0.2759	0.2782	0.2757	0.2771	35913120.0
2005-09-28 10:00:00	NVDA	Stock	0.2772	0.2781	0.2767	0.2775	59916480.0
2005-09-28 11:00:00	NVDA	Stock	0.2775	0.278	0.2757	0.2765	60407040.0
2005-09-28 12:00:00	NVDA	Stock	0.2764	0.2765	0.2738	0.2754	46022640.0
2005-09-28 13:00:00	NVDA	Stock	0.2754	0.2759	0.2734	0.2742	26742720.0
2005-09-28 14:00:00	NVDA	Stock	0.2742	0.2771	0.2742	0.2766	32827560.0
2005-09-28 15:00:00	NVDA	Stock	0.2766	0.2777	0.2763	0.2774	75645000.0
2005-09-28 16:00:00	NVDA	Stock	0.2774	0.2776	0.2773	0.2774	1449000.0
2005-09-28 17:00:00	NVDA	Stock	0.2762	0.2762	0.2762	0.2762	317280.0
2005-09-28 18:00:00	NVDA	Stock	0.2781	0.2781	0.2781	0.2781	60000.0
2005-09-28 09:00:00	AMZN	Stock	2.1565	2.182	2.1565	2.18	6623080.0
2005-09-28 10:00:00	AMZN	Stock	2.1795	2.187	2.163	2.1725	12261620.0
2005-09-28 11:00:00	AMZN	Stock	2.1725	2.1735	2.159	2.1605	7863520.0
2005-09-28 12:00:00	AMZN	Stock	2.1605	2.1655	2.1495	2.1585	6849940.0
2005-09-28 13:00:00	AMZN	Stock	2.1585	2.159	2.1495	2.1545	6861160.0
2005-09-28 14:00:00	AMZN	Stock	2.155	2.1755	2.155	2.1705	9412960.0
2005-09-28 15:00:00	AMZN	Stock	2.1705	2.1735	2.158	2.1685	13875100.0
2005-09-28 16:00:00	AMZN	Stock	2.1675	2.1675	2.163	2.163	28000.0
2005-09-28 17:00:00	AMZN	Stock	2.1675	2.1685	2.1675	2.1685	39940.0
2005-09-28 09:00:00	CL	Stock	25.99	26.045	25.96	25.98	283200.0
2005-09-28 10:00:00	CL	Stock	26.005	26.285	25.99	26.245	512800.0
2005-09-28 11:00:00	CL	Stock	26.26	26.295	26.135	26.2	532800.0
2005-09-28 12:00:00	CL	Stock	26.21	26.24	26.16	26.175	381000.0
2005-09-28 13:00:00	CL	Stock	26.165	26.175	26.02	26.055	351200.0
2005-09-28 14:00:00	CL	Stock	26.05	26.245	26.05	26.23	303200.0
2005-09-28 15:00:00	CL	Stock	26.23	26.26	26.15	26.17	531600.0
2005-09-28 16:00:00	CL	Stock	26.185	26.185	26.185	26.185	112400.0

> showing 50 of 26,875 rows — these rows as CSV

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