PREVIEW / stock_1hour / 2005-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-04.parquet
  size:    571 KB
  rows:    27,197
  symbols: 2,089

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-10-04 08:00:00	AAPL	Stock	1.9482	1.9625	1.9482	1.9621	1415512.0
2005-10-04 09:00:00	AAPL	Stock	1.9621	1.9643	1.9496	1.9554	59638992.0
2005-10-04 10:00:00	AAPL	Stock	1.9554	1.9768	1.9554	1.9707	107119768.0
2005-10-04 11:00:00	AAPL	Stock	1.9707	1.9729	1.9579	1.9718	68906740.0
2005-10-04 12:00:00	AAPL	Stock	1.9718	1.9732	1.9639	1.9646	37519860.0
2005-10-04 13:00:00	AAPL	Stock	1.9654	1.9675	1.9418	1.9457	70111216.0
2005-10-04 14:00:00	AAPL	Stock	1.9454	1.9624	1.9271	1.9271	85056916.0
2005-10-04 15:00:00	AAPL	Stock	1.9271	1.9321	1.9157	1.9175	96620888.0
2005-10-04 16:00:00	AAPL	Stock	1.9171	1.9258	1.9146	1.9189	1690808.0
2005-10-04 17:00:00	AAPL	Stock	1.9193	1.9196	1.9164	1.9164	7070616.0
2005-10-04 18:00:00	AAPL	Stock	1.9193	1.9204	1.9164	1.9196	2020256.0
2005-10-04 07:00:00	MSFT	Stock	25.48	25.49	25.48	25.49	13600.0
2005-10-04 08:00:00	MSFT	Stock	25.45	25.48	25.4	25.44	161400.0
2005-10-04 09:00:00	MSFT	Stock	25.42	25.43	24.75	24.96	30579698.0
2005-10-04 10:00:00	MSFT	Stock	24.951	25.03	24.81	24.97	27492427.0
2005-10-04 11:00:00	MSFT	Stock	24.98	25.06	24.9	25.02	17338543.0
2005-10-04 12:00:00	MSFT	Stock	25.01	25.19	24.94	25.17	18935903.0
2005-10-04 13:00:00	MSFT	Stock	25.17	25.24	25.0	25.07	20322490.0
2005-10-04 14:00:00	MSFT	Stock	25.07	25.08	24.86	24.87	13896119.0
2005-10-04 15:00:00	MSFT	Stock	24.88	25.01	24.87	24.97	19848551.0
2005-10-04 16:00:00	MSFT	Stock	24.97	25.0	24.94	24.94	493954.0
2005-10-04 17:00:00	MSFT	Stock	24.96	24.99	24.95	24.98	1112956.0
2005-10-04 18:00:00	MSFT	Stock	24.95	24.97	24.95	24.97	1500.0
2005-10-04 08:00:00	NVDA	Stock	0.2954	0.2954	0.2949	0.2949	192000.0
2005-10-04 09:00:00	NVDA	Stock	0.2949	0.2977	0.2924	0.2956	120134040.0
2005-10-04 10:00:00	NVDA	Stock	0.2954	0.2996	0.2952	0.2971	106366080.0
2005-10-04 11:00:00	NVDA	Stock	0.2971	0.2976	0.2955	0.2972	58916880.0
2005-10-04 12:00:00	NVDA	Stock	0.2969	0.297	0.2954	0.2963	28159080.0
2005-10-04 13:00:00	NVDA	Stock	0.2963	0.2966	0.2931	0.2932	23567640.0
2005-10-04 14:00:00	NVDA	Stock	0.2932	0.2954	0.2931	0.2939	61270200.0
2005-10-04 15:00:00	NVDA	Stock	0.2939	0.2944	0.289	0.2897	105361920.0
2005-10-04 16:00:00	NVDA	Stock	0.2894	0.2947	0.2888	0.2897	7037040.0
2005-10-04 18:00:00	NVDA	Stock	0.2897	0.2897	0.2889	0.2889	1806720.0
2005-10-04 08:00:00	AMZN	Stock	2.29	2.31	2.29	2.31	21980.0
2005-10-04 09:00:00	AMZN	Stock	2.302	2.306	2.2745	2.275	15775900.0
2005-10-04 10:00:00	AMZN	Stock	2.275	2.277	2.2505	2.26	25720900.0
2005-10-04 11:00:00	AMZN	Stock	2.2605	2.264	2.2535	2.2625	14770720.0
2005-10-04 12:00:00	AMZN	Stock	2.263	2.263	2.2565	2.2615	9545480.0
2005-10-04 13:00:00	AMZN	Stock	2.261	2.2675	2.2565	2.2575	9062340.0
2005-10-04 14:00:00	AMZN	Stock	2.2575	2.2655	2.25	2.25	17126640.0
2005-10-04 15:00:00	AMZN	Stock	2.25	2.258	2.225	2.245	35724060.0
2005-10-04 16:00:00	AMZN	Stock	2.243	2.2465	2.2405	2.246	170360.0
2005-10-04 17:00:00	AMZN	Stock	2.2465	2.2465	2.245	2.245	683660.0
2005-10-04 08:00:00	CL	Stock	26.5	26.5	26.5	26.5	101400.0
2005-10-04 09:00:00	CL	Stock	26.4	26.4	26.1	26.375	767000.0
2005-10-04 10:00:00	CL	Stock	26.38	26.695	26.35	26.535	703200.0
2005-10-04 11:00:00	CL	Stock	26.51	26.54	26.35	26.495	629000.0
2005-10-04 12:00:00	CL	Stock	26.49	26.525	26.35	26.415	581000.0
2005-10-04 13:00:00	CL	Stock	26.42	26.58	26.415	26.5455	865800.0
2005-10-04 14:00:00	CL	Stock	26.55	26.55	26.43	26.435	583200.0

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

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