PREVIEW / stock_1hour / 2005-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-30.parquet
  size:    544 KB
  rows:    25,957
  symbols: 2,059

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-30 08:00:00	AAPL	Stock	1.6411	1.6518	1.6393	1.6439	2968308.0
2005-08-30 09:00:00	AAPL	Stock	1.6439	1.6654	1.6382	1.6636	84091812.0
2005-08-30 10:00:00	AAPL	Stock	1.6636	1.6711	1.655	1.6585	104062924.0
2005-08-30 11:00:00	AAPL	Stock	1.6582	1.6593	1.6446	1.6496	61439560.0
2005-08-30 12:00:00	AAPL	Stock	1.6496	1.6636	1.6486	1.6582	49230020.0
2005-08-30 13:00:00	AAPL	Stock	1.6582	1.6654	1.6561	1.6604	43688904.0
2005-08-30 14:00:00	AAPL	Stock	1.66	1.6604	1.6461	1.6482	66152884.0
2005-08-30 15:00:00	AAPL	Stock	1.6482	1.6646	1.6479	1.6643	88551540.0
2005-08-30 16:00:00	AAPL	Stock	1.6643	1.6682	1.6625	1.6679	6048196.0
2005-08-30 17:00:00	AAPL	Stock	1.6679	1.6696	1.6643	1.6643	355824.0
2005-08-30 18:00:00	AAPL	Stock	1.6643	1.6693	1.6643	1.6693	192080.0
2005-08-30 08:00:00	MSFT	Stock	27.1	27.1	27.01	27.07	5414.0
2005-08-30 09:00:00	MSFT	Stock	27.08	27.3	27.0	27.12	5403610.0
2005-08-30 10:00:00	MSFT	Stock	27.11	27.15	27.0	27.07	7528406.0
2005-08-30 11:00:00	MSFT	Stock	27.07	27.11	26.96	27.05	5445427.0
2005-08-30 12:00:00	MSFT	Stock	27.05	27.11	27.03	27.1	5814632.0
2005-08-30 13:00:00	MSFT	Stock	27.09	27.13	27.06	27.06	3553979.0
2005-08-30 14:00:00	MSFT	Stock	27.07	27.08	26.99	27.02	8433111.0
2005-08-30 15:00:00	MSFT	Stock	27.02	27.23	27.01	27.19	11842082.0
2005-08-30 16:00:00	MSFT	Stock	27.19	27.24	27.087	27.2	309243.0
2005-08-30 17:00:00	MSFT	Stock	27.2	27.2	27.179	27.18	17872.0
2005-08-30 18:00:00	MSFT	Stock	27.18	27.18	27.17	27.17	5125.0
2005-08-30 07:00:00	NVDA	Stock	0.2396	0.2417	0.2396	0.2406	648000.0
2005-08-30 08:00:00	NVDA	Stock	0.2404	0.2423	0.2398	0.24	1191360.0
2005-08-30 09:00:00	NVDA	Stock	0.24	0.2457	0.24	0.2457	110550000.0
2005-08-30 10:00:00	NVDA	Stock	0.2457	0.2487	0.2445	0.2462	243460800.0
2005-08-30 11:00:00	NVDA	Stock	0.2462	0.248	0.246	0.2475	120772440.0
2005-08-30 12:00:00	NVDA	Stock	0.2476	0.25	0.2475	0.2494	92498400.0
2005-08-30 13:00:00	NVDA	Stock	0.2494	0.2507	0.2485	0.25	110944320.0
2005-08-30 14:00:00	NVDA	Stock	0.25	0.2502	0.2487	0.2495	77526120.0
2005-08-30 15:00:00	NVDA	Stock	0.2495	0.2503	0.2491	0.25	176331960.0
2005-08-30 16:00:00	NVDA	Stock	0.2501	0.2508	0.2496	0.2508	3276360.0
2005-08-30 17:00:00	NVDA	Stock	0.2508	0.2508	0.2503	0.2503	227400.0
2005-08-30 18:00:00	NVDA	Stock	0.2507	0.2507	0.2507	0.2507	132000.0
2005-08-30 08:00:00	AMZN	Stock	2.135	2.135	2.135	2.135	2000.0
2005-08-30 09:00:00	AMZN	Stock	2.1375	2.1375	2.118	2.1245	7417660.0
2005-08-30 10:00:00	AMZN	Stock	2.1245	2.1285	2.1	2.1065	18095900.0
2005-08-30 11:00:00	AMZN	Stock	2.1065	2.11	2.098	2.1035	12109400.0
2005-08-30 12:00:00	AMZN	Stock	2.104	2.115	2.1025	2.115	7118460.0
2005-08-30 13:00:00	AMZN	Stock	2.115	2.1215	2.113	2.1165	5707840.0
2005-08-30 14:00:00	AMZN	Stock	2.1165	2.117	2.112	2.1125	6056260.0
2005-08-30 15:00:00	AMZN	Stock	2.1125	2.127	2.1125	2.1245	13683580.0
2005-08-30 16:00:00	AMZN	Stock	2.1245	2.127	2.1235	2.124	743160.0
2005-08-30 17:00:00	AMZN	Stock	2.1245	2.1245	2.1235	2.1235	26040.0
2005-08-30 18:00:00	AMZN	Stock	2.1125	2.1125	2.1125	2.1125	4000.0
2005-08-30 09:00:00	CL	Stock	26.35	26.37	26.23	26.3	265600.0
2005-08-30 10:00:00	CL	Stock	26.305	26.325	26.125	26.17	840600.0
2005-08-30 11:00:00	CL	Stock	26.165	26.175	26.065	26.11	386200.0
2005-08-30 12:00:00	CL	Stock	26.1	26.22	26.085	26.115	376800.0
2005-08-30 13:00:00	CL	Stock	26.11	26.195	26.1	26.145	283600.0

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

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