PREVIEW / stock_1hour / 2005-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-31.parquet
  size:    583 KB
  rows:    27,453
  symbols: 2,073

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-08-31 08:00:00	AAPL	Stock	1.6632	1.6743	1.6632	1.665	549192.0
2005-08-31 09:00:00	AAPL	Stock	1.6679	1.6771	1.6586	1.6632	68261508.0
2005-08-31 10:00:00	AAPL	Stock	1.6632	1.6725	1.6525	1.6639	85169700.0
2005-08-31 11:00:00	AAPL	Stock	1.6639	1.6704	1.6614	1.6654	44290456.0
2005-08-31 12:00:00	AAPL	Stock	1.665	1.667	1.6571	1.6575	36167180.0
2005-08-31 13:00:00	AAPL	Stock	1.6575	1.6671	1.6564	1.665	35027636.0
2005-08-31 14:00:00	AAPL	Stock	1.6654	1.6675	1.6593	1.6668	32519900.0
2005-08-31 15:00:00	AAPL	Stock	1.6668	1.6796	1.6643	1.6757	67274648.0
2005-08-31 16:00:00	AAPL	Stock	1.675	1.6761	1.6661	1.6696	10699528.0
2005-08-31 17:00:00	AAPL	Stock	1.6761	1.6761	1.6721	1.6721	30548.0
2005-08-31 18:00:00	AAPL	Stock	1.6732	1.6746	1.6732	1.6746	38640.0
2005-08-31 07:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	2000.0
2005-08-31 08:00:00	MSFT	Stock	27.17	27.25	27.17	27.18	38484.0
2005-08-31 09:00:00	MSFT	Stock	27.18	27.24	27.11	27.12	3989233.0
2005-08-31 10:00:00	MSFT	Stock	27.12	27.2	27.04	27.06	11441082.0
2005-08-31 11:00:00	MSFT	Stock	27.06	27.17	27.05	27.11	5649789.0
2005-08-31 12:00:00	MSFT	Stock	27.12	27.22	27.11	27.15	5402179.0
2005-08-31 13:00:00	MSFT	Stock	27.15	27.33	27.1	27.26	10412955.0
2005-08-31 14:00:00	MSFT	Stock	27.26	27.33	27.179	27.28	8551071.0
2005-08-31 15:00:00	MSFT	Stock	27.28	27.44	27.26	27.38	15332901.0
2005-08-31 16:00:00	MSFT	Stock	27.39	27.41	27.29	27.37	1640437.0
2005-08-31 17:00:00	MSFT	Stock	27.37	27.4	27.36	27.39	16973.0
2005-08-31 18:00:00	MSFT	Stock	27.37	27.37	27.37	27.37	750.0
2005-08-31 08:00:00	NVDA	Stock	0.2508	0.2518	0.2508	0.2518	2868000.0
2005-08-31 09:00:00	NVDA	Stock	0.2514	0.2539	0.2487	0.2523	84872640.0
2005-08-31 10:00:00	NVDA	Stock	0.2523	0.2568	0.2517	0.2562	248014080.0
2005-08-31 11:00:00	NVDA	Stock	0.2562	0.2588	0.2562	0.2572	169897080.0
2005-08-31 12:00:00	NVDA	Stock	0.2572	0.2575	0.2548	0.2549	87439560.0
2005-08-31 13:00:00	NVDA	Stock	0.2548	0.2555	0.2537	0.2548	54606360.0
2005-08-31 14:00:00	NVDA	Stock	0.2548	0.2557	0.2545	0.2557	57593760.0
2005-08-31 15:00:00	NVDA	Stock	0.2556	0.2575	0.255	0.2555	161195400.0
2005-08-31 16:00:00	NVDA	Stock	0.2558	0.2558	0.2552	0.2552	5001000.0
2005-08-31 17:00:00	NVDA	Stock	0.255	0.255	0.255	0.255	12000.0
2005-08-31 08:00:00	AMZN	Stock	2.1285	2.1285	2.1285	2.1285	4000.0
2005-08-31 09:00:00	AMZN	Stock	2.1245	2.1245	2.112	2.1125	6860860.0
2005-08-31 10:00:00	AMZN	Stock	2.112	2.122	2.1035	2.1085	16025400.0
2005-08-31 11:00:00	AMZN	Stock	2.1085	2.115	2.106	2.114	7287820.0
2005-08-31 12:00:00	AMZN	Stock	2.1145	2.1145	2.102	2.1055	4872800.0
2005-08-31 13:00:00	AMZN	Stock	2.1055	2.1165	2.1035	2.1155	7618460.0
2005-08-31 14:00:00	AMZN	Stock	2.1155	2.1215	2.1101	2.1215	5978180.0
2005-08-31 15:00:00	AMZN	Stock	2.1215	2.1405	2.121	2.135	16156220.0
2005-08-31 16:00:00	AMZN	Stock	2.133	2.135	2.13	2.134	303260.0
2005-08-31 17:00:00	AMZN	Stock	2.1345	2.1345	2.13	2.13	30000.0
2005-08-31 18:00:00	AMZN	Stock	2.1245	2.1245	2.1245	2.1245	1299600.0
2005-08-31 09:00:00	CL	Stock	26.205	26.24	26.035	26.045	368000.0
2005-08-31 10:00:00	CL	Stock	26.055	26.22	26.0	26.17	534800.0
2005-08-31 11:00:00	CL	Stock	26.17	26.22	26.145	26.155	260000.0
2005-08-31 12:00:00	CL	Stock	26.155	26.165	26.085	26.125	387800.0
2005-08-31 13:00:00	CL	Stock	26.125	26.245	26.11	26.2	399200.0
2005-08-31 14:00:00	CL	Stock	26.1955	26.24	26.12	26.23	423200.0

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

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