PREVIEW / stock_1hour / 2005-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-01.parquet
  size:    585 KB
  rows:    27,862
  symbols: 2,077

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-01 08:00:00	AAPL	Stock	1.675	1.6843	1.6746	1.6804	568848.0
2005-09-01 09:00:00	AAPL	Stock	1.6746	1.6846	1.6668	1.6775	70868672.0
2005-09-01 10:00:00	AAPL	Stock	1.6775	1.6786	1.6614	1.6682	59267040.0
2005-09-01 11:00:00	AAPL	Stock	1.6682	1.675	1.6632	1.6679	60767756.0
2005-09-01 12:00:00	AAPL	Stock	1.6679	1.6689	1.6561	1.6579	29289904.0
2005-09-01 13:00:00	AAPL	Stock	1.6582	1.664	1.6518	1.6525	32596788.0
2005-09-01 14:00:00	AAPL	Stock	1.6525	1.6582	1.6461	1.6525	42727832.0
2005-09-01 15:00:00	AAPL	Stock	1.6525	1.6593	1.6504	1.6521	48716080.0
2005-09-01 16:00:00	AAPL	Stock	1.6525	1.653	1.65	1.6521	3029208.0
2005-09-01 17:00:00	AAPL	Stock	1.6521	1.6532	1.6521	1.6521	127960.0
2005-09-01 18:00:00	AAPL	Stock	1.6532	1.6532	1.6532	1.6532	64400.0
2005-09-01 08:00:00	MSFT	Stock	27.4	27.43	27.38	27.38	262617.0
2005-09-01 09:00:00	MSFT	Stock	27.38	27.4	27.23	27.28	6108032.0
2005-09-01 10:00:00	MSFT	Stock	27.29	27.29	27.15	27.212	9890965.0
2005-09-01 11:00:00	MSFT	Stock	27.21	27.35	27.17	27.21	11063952.0
2005-09-01 12:00:00	MSFT	Stock	27.21	27.28	27.18	27.21	13437683.0
2005-09-01 13:00:00	MSFT	Stock	27.21	27.34	27.16	27.221	13389868.0
2005-09-01 14:00:00	MSFT	Stock	27.22	27.33	27.17	27.24	9262071.0
2005-09-01 15:00:00	MSFT	Stock	27.24	27.29	27.2	27.2	9967739.0
2005-09-01 16:00:00	MSFT	Stock	27.21	27.4	27.16	27.4	484908.0
2005-09-01 17:00:00	MSFT	Stock	27.23	27.23	27.18	27.18	87088.0
2005-09-01 18:00:00	MSFT	Stock	27.21	27.21	27.18	27.2	2498.0
2005-09-01 09:00:00	NVDA	Stock	0.2557	0.2572	0.2542	0.2557	63288840.0
2005-09-01 10:00:00	NVDA	Stock	0.2557	0.2559	0.2536	0.2553	117213480.0
2005-09-01 11:00:00	NVDA	Stock	0.2552	0.2581	0.2546	0.2567	81643920.0
2005-09-01 12:00:00	NVDA	Stock	0.2567	0.258	0.2559	0.2569	66265200.0
2005-09-01 13:00:00	NVDA	Stock	0.2569	0.2575	0.2558	0.2562	58877760.0
2005-09-01 14:00:00	NVDA	Stock	0.2562	0.2565	0.2547	0.2553	74282880.0
2005-09-01 15:00:00	NVDA	Stock	0.2554	0.2563	0.2549	0.2556	86797920.0
2005-09-01 16:00:00	NVDA	Stock	0.2557	0.2577	0.2557	0.256	2714880.0
2005-09-01 17:00:00	NVDA	Stock	0.256	0.256	0.2557	0.2557	201600.0
2005-09-01 08:00:00	AMZN	Stock	2.135	2.135	2.135	2.135	88400.0
2005-09-01 09:00:00	AMZN	Stock	2.135	2.1485	2.122	2.1265	6050540.0
2005-09-01 10:00:00	AMZN	Stock	2.125	2.127	2.1035	2.1145	8567720.0
2005-09-01 11:00:00	AMZN	Stock	2.1145	2.129	2.111	2.1205	16181820.0
2005-09-01 12:00:00	AMZN	Stock	2.1195	2.1215	2.1125	2.1175	6784100.0
2005-09-01 13:00:00	AMZN	Stock	2.1175	2.1225	2.1035	2.1061	6073680.0
2005-09-01 14:00:00	AMZN	Stock	2.1065	2.107	2.092	2.094	12642520.0
2005-09-01 15:00:00	AMZN	Stock	2.0945	2.1085	2.0875	2.0925	23196840.0
2005-09-01 16:00:00	AMZN	Stock	2.0925	2.135	2.09	2.135	463680.0
2005-09-01 17:00:00	AMZN	Stock	2.0945	2.0945	2.092	2.092	1711400.0
2005-09-01 18:00:00	AMZN	Stock	2.092	2.0945	2.0905	2.0905	32000.0
2005-09-01 08:00:00	CL	Stock	26.25	26.25	26.25	26.25	23200.0
2005-09-01 09:00:00	CL	Stock	26.25	26.34	26.16	26.175	299200.0
2005-09-01 10:00:00	CL	Stock	26.175	26.275	26.08	26.245	481000.0
2005-09-01 11:00:00	CL	Stock	26.245	26.43	26.22	26.325	432000.0
2005-09-01 12:00:00	CL	Stock	26.325	26.355	26.265	26.27	329600.0
2005-09-01 13:00:00	CL	Stock	26.27	26.32	26.245	26.28	198200.0
2005-09-01 14:00:00	CL	Stock	26.285	26.36	26.23	26.265	272400.0
2005-09-01 15:00:00	CL	Stock	26.265	26.36	26.265	26.32	590000.0

> showing 50 of 27,862 rows — these rows as CSV

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