PREVIEW / stock_1hour / 2005-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-28.parquet
  size:    574 KB
  rows:    27,313
  symbols: 2,009

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-06-28 08:00:00	AAPL	Stock	1.3364	1.3407	1.3339	1.3364	566860.0
2005-06-28 09:00:00	AAPL	Stock	1.3364	1.3425	1.325	1.3329	83927900.0
2005-06-28 10:00:00	AAPL	Stock	1.3332	1.3389	1.3275	1.3336	76772108.0
2005-06-28 11:00:00	AAPL	Stock	1.3336	1.3425	1.3325	1.3386	41667724.0
2005-06-28 12:00:00	AAPL	Stock	1.3382	1.3421	1.3321	1.3325	27168204.0
2005-06-28 13:00:00	AAPL	Stock	1.3325	1.3382	1.3321	1.3336	30277576.0
2005-06-28 14:00:00	AAPL	Stock	1.3336	1.3393	1.3329	1.3357	29917720.0
2005-06-28 15:00:00	AAPL	Stock	1.3354	1.3393	1.3314	1.3318	48340768.0
2005-06-28 16:00:00	AAPL	Stock	1.3325	1.3357	1.3161	1.3214	5599944.0
2005-06-28 17:00:00	AAPL	Stock	1.3214	1.3344	1.3175	1.3211	569548.0
2005-06-28 18:00:00	AAPL	Stock	1.3211	1.3214	1.3211	1.3214	173600.0
2005-06-28 08:00:00	MSFT	Stock	25.13	25.2	25.1	25.17	77680.0
2005-06-28 09:00:00	MSFT	Stock	25.15	25.16	25.04	25.09	7830742.0
2005-06-28 10:00:00	MSFT	Stock	25.09	25.12	25.029	25.05	8139756.0
2005-06-28 11:00:00	MSFT	Stock	25.04	25.12	25.04	25.08	6979899.0
2005-06-28 12:00:00	MSFT	Stock	25.08	25.11	25.041	25.08	4013535.0
2005-06-28 13:00:00	MSFT	Stock	25.08	25.13	25.07	25.07	4160761.0
2005-06-28 14:00:00	MSFT	Stock	25.07	25.12	25.04	25.09	6171564.0
2005-06-28 15:00:00	MSFT	Stock	25.1	25.2	25.07	25.07	14056392.0
2005-06-28 16:00:00	MSFT	Stock	25.09	25.14	25.035	25.1	458238.0
2005-06-28 17:00:00	MSFT	Stock	25.09	25.13	25.07	25.1	32130.0
2005-06-28 18:00:00	MSFT	Stock	25.1	25.12	25.08	25.08	21900.0
2005-06-28 08:00:00	NVDA	Stock	0.2262	0.2263	0.2262	0.2263	72000.0
2005-06-28 09:00:00	NVDA	Stock	0.2254	0.2268	0.2246	0.2262	33433200.0
2005-06-28 10:00:00	NVDA	Stock	0.2262	0.2267	0.2251	0.2252	36904560.0
2005-06-28 11:00:00	NVDA	Stock	0.2252	0.2258	0.2246	0.2247	25842360.0
2005-06-28 12:00:00	NVDA	Stock	0.2247	0.2247	0.2223	0.2225	42392760.0
2005-06-28 13:00:00	NVDA	Stock	0.2225	0.225	0.2224	0.2236	41567160.0
2005-06-28 14:00:00	NVDA	Stock	0.2235	0.225	0.2232	0.2248	31055880.0
2005-06-28 15:00:00	NVDA	Stock	0.2248	0.2256	0.2248	0.2253	43450080.0
2005-06-28 16:00:00	NVDA	Stock	0.2248	0.2254	0.2248	0.2254	212400.0
2005-06-28 17:00:00	NVDA	Stock	0.2267	0.2267	0.225	0.2252	3571560.0
2005-06-28 08:00:00	AMZN	Stock	1.73	1.73	1.73	1.73	6000.0
2005-06-28 09:00:00	AMZN	Stock	1.7295	1.7315	1.702	1.702	11291780.0
2005-06-28 10:00:00	AMZN	Stock	1.702	1.7125	1.686	1.6875	26436000.0
2005-06-28 11:00:00	AMZN	Stock	1.6874	1.693	1.6795	1.688	23678160.0
2005-06-28 12:00:00	AMZN	Stock	1.688	1.7015	1.688	1.697	13366020.0
2005-06-28 13:00:00	AMZN	Stock	1.696	1.7065	1.6945	1.7	15187760.0
2005-06-28 14:00:00	AMZN	Stock	1.7	1.7	1.6895	1.6925	13587140.0
2005-06-28 15:00:00	AMZN	Stock	1.6925	1.694	1.6845	1.6855	33420500.0
2005-06-28 16:00:00	AMZN	Stock	1.6855	1.6886	1.683	1.6855	1306200.0
2005-06-28 17:00:00	AMZN	Stock	1.6865	1.6865	1.6865	1.6865	12120.0
2005-06-28 18:00:00	AMZN	Stock	1.685	1.685	1.685	1.685	7000.0
2005-06-28 09:00:00	CL	Stock	25.16	25.36	25.075	25.36	817200.0
2005-06-28 10:00:00	CL	Stock	25.365	25.49	25.34	25.445	818000.0
2005-06-28 11:00:00	CL	Stock	25.445	25.45	25.337	25.37	1054200.0
2005-06-28 12:00:00	CL	Stock	25.375	25.415	25.33	25.33	474000.0
2005-06-28 13:00:00	CL	Stock	25.33	25.405	25.33	25.38	428800.0
2005-06-28 14:00:00	CL	Stock	25.375	25.385	25.325	25.34	483600.0
2005-06-28 15:00:00	CL	Stock	25.34	25.35	25.28	25.33	671600.0

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

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