PREVIEW / stock_1hour / 2005-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-16.parquet
  size:    571 KB
  rows:    27,449
  symbols: 2,057

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-16 08:00:00	AAPL	Stock	1.7043	1.7043	1.6893	1.6932	860300.0
2005-08-16 09:00:00	AAPL	Stock	1.6932	1.6964	1.6836	1.69	84634200.0
2005-08-16 10:00:00	AAPL	Stock	1.6896	1.6911	1.6632	1.6725	133513184.0
2005-08-16 11:00:00	AAPL	Stock	1.6725	1.6786	1.6679	1.6721	64341592.0
2005-08-16 12:00:00	AAPL	Stock	1.6721	1.6736	1.6679	1.6711	41012104.0
2005-08-16 13:00:00	AAPL	Stock	1.6711	1.6771	1.6657	1.6657	35421176.0
2005-08-16 14:00:00	AAPL	Stock	1.6657	1.6686	1.6561	1.6596	59553620.0
2005-08-16 15:00:00	AAPL	Stock	1.6596	1.6657	1.6504	1.6518	102788672.0
2005-08-16 16:00:00	AAPL	Stock	1.6529	1.6625	1.6517	1.6554	2565724.0
2005-08-16 17:00:00	AAPL	Stock	1.6554	1.6869	1.6554	1.66	895580.0
2005-08-16 18:00:00	AAPL	Stock	1.6518	1.6589	1.6518	1.6571	31052.0
2005-08-16 08:00:00	MSFT	Stock	27.13	27.15	27.06	27.06	30679.0
2005-08-16 09:00:00	MSFT	Stock	27.05	27.14	27.0	27.09	4500950.0
2005-08-16 10:00:00	MSFT	Stock	27.08	27.09	26.97	27.01	7643952.0
2005-08-16 11:00:00	MSFT	Stock	27.0	27.05	26.91	26.95	5769626.0
2005-08-16 12:00:00	MSFT	Stock	26.95	27.008	26.9	26.961	3426969.0
2005-08-16 13:00:00	MSFT	Stock	26.97	27.05	26.899	26.91	3824350.0
2005-08-16 14:00:00	MSFT	Stock	26.902	26.93	26.87	26.909	4839857.0
2005-08-16 15:00:00	MSFT	Stock	26.9	26.92	26.7	26.73	14855999.0
2005-08-16 16:00:00	MSFT	Stock	26.73	26.81	26.72	26.8	734292.0
2005-08-16 17:00:00	MSFT	Stock	26.78	27.04	26.76	26.83	183714.0
2005-08-16 18:00:00	MSFT	Stock	26.84	26.84	26.74	26.8	7204.0
2005-08-16 09:00:00	NVDA	Stock	0.2547	0.256	0.2532	0.2542	178192560.0
2005-08-16 10:00:00	NVDA	Stock	0.2542	0.2544	0.25	0.2518	142957680.0
2005-08-16 11:00:00	NVDA	Stock	0.2517	0.2523	0.2503	0.251	79227960.0
2005-08-16 12:00:00	NVDA	Stock	0.2509	0.2517	0.2497	0.2507	46950000.0
2005-08-16 13:00:00	NVDA	Stock	0.2507	0.2521	0.25	0.2512	50145240.0
2005-08-16 14:00:00	NVDA	Stock	0.2512	0.2521	0.2511	0.2517	32545800.0
2005-08-16 15:00:00	NVDA	Stock	0.2517	0.2524	0.2511	0.2516	99767640.0
2005-08-16 16:00:00	NVDA	Stock	0.2516	0.2526	0.2516	0.2519	228000.0
2005-08-16 17:00:00	NVDA	Stock	0.2522	0.2541	0.2522	0.2541	3912000.0
2005-08-16 18:00:00	NVDA	Stock	0.2524	0.2524	0.2524	0.2524	12000.0
2005-08-16 08:00:00	AMZN	Stock	2.2545	2.2545	2.2475	2.2475	24000.0
2005-08-16 09:00:00	AMZN	Stock	2.2475	2.2475	2.232	2.2335	8749100.0
2005-08-16 10:00:00	AMZN	Stock	2.2335	2.235	2.215	2.2155	15891460.0
2005-08-16 11:00:00	AMZN	Stock	2.2155	2.229	2.213	2.2225	8523560.0
2005-08-16 12:00:00	AMZN	Stock	2.2225	2.225	2.216	2.219	3471940.0
2005-08-16 13:00:00	AMZN	Stock	2.219	2.222	2.2155	2.2155	4107600.0
2005-08-16 14:00:00	AMZN	Stock	2.2155	2.226	2.2115	2.222	10434260.0
2005-08-16 15:00:00	AMZN	Stock	2.2225	2.2265	2.21	2.2135	19005500.0
2005-08-16 16:00:00	AMZN	Stock	2.214	2.223	2.2134	2.218	715180.0
2005-08-16 09:00:00	CL	Stock	26.425	26.485	26.3	26.315	209000.0
2005-08-16 10:00:00	CL	Stock	26.3	26.385	26.24	26.24	261800.0
2005-08-16 11:00:00	CL	Stock	26.24	26.28	26.205	26.26	165200.0
2005-08-16 12:00:00	CL	Stock	26.255	26.32	26.205	26.32	170400.0
2005-08-16 13:00:00	CL	Stock	26.32	26.33	26.26	26.275	161400.0
2005-08-16 14:00:00	CL	Stock	26.275	26.32	26.23	26.31	267800.0
2005-08-16 15:00:00	CL	Stock	26.305	26.325	26.145	26.18	447600.0

> showing 48 of 27,449 rows — these rows as CSV

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