PREVIEW / stock_1hour / 2002-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-29.parquet
  size:    406 KB
  rows:    19,175
  symbols: 1,459

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
2002-07-29 08:00:00	AAPL	Stock	0.2589	0.2602	0.256	0.2602	845600.0
2002-07-29 09:00:00	AAPL	Stock	0.2591	0.2625	0.258	0.2607	20816936.0
2002-07-29 10:00:00	AAPL	Stock	0.2602	0.263	0.2582	0.2595	32820648.0
2002-07-29 11:00:00	AAPL	Stock	0.2595	0.2609	0.2566	0.2602	22963080.0
2002-07-29 12:00:00	AAPL	Stock	0.2605	0.2664	0.2598	0.2659	23636704.0
2002-07-29 13:00:00	AAPL	Stock	0.2659	0.267	0.2625	0.2655	27572160.0
2002-07-29 14:00:00	AAPL	Stock	0.2655	0.2668	0.2618	0.2641	41899088.0
2002-07-29 15:00:00	AAPL	Stock	0.2639	0.2677	0.2638	0.2677	80962728.0
2002-07-29 16:00:00	AAPL	Stock	0.2677	0.2841	0.2644	0.2682	10740800.0
2002-07-29 17:00:00	AAPL	Stock	0.2661	0.2682	0.2661	0.2682	16800.0
2002-07-29 08:00:00	MSFT	Stock	22.95	23.5	22.7	23.375	257500.0
2002-07-29 09:00:00	MSFT	Stock	23.375	23.555	22.855	23.37	20175666.0
2002-07-29 10:00:00	MSFT	Stock	23.375	23.64	23.325	23.525	18402018.0
2002-07-29 11:00:00	MSFT	Stock	23.533	23.625	23.44	23.61	13338224.0
2002-07-29 12:00:00	MSFT	Stock	23.58	23.9	23.55	23.86	11510778.0
2002-07-29 13:00:00	MSFT	Stock	23.8555	23.9	23.625	23.79	11289098.0
2002-07-29 14:00:00	MSFT	Stock	23.79	23.89	23.625	23.835	10694106.0
2002-07-29 15:00:00	MSFT	Stock	23.835	24.15	23.45	24.12	21041340.0
2002-07-29 16:00:00	MSFT	Stock	24.11	24.14	23.9525	24.07	3038322.0
2002-07-29 17:00:00	MSFT	Stock	24.069	24.125	23.95	24.005	23426.0
2002-07-29 18:00:00	MSFT	Stock	24.005	24.09	24.005	24.005	18880.0
2002-07-29 08:00:00	NVDA	Stock	0.1242	0.1291	0.1228	0.1279	2464800.0
2002-07-29 09:00:00	NVDA	Stock	0.1283	0.1283	0.1229	0.1238	161841600.0
2002-07-29 10:00:00	NVDA	Stock	0.1237	0.1247	0.1219	0.1239	229110240.0
2002-07-29 11:00:00	NVDA	Stock	0.1239	0.1247	0.122	0.1241	126547320.0
2002-07-29 12:00:00	NVDA	Stock	0.1241	0.128	0.1238	0.1255	211419960.0
2002-07-29 13:00:00	NVDA	Stock	0.1256	0.1281	0.1252	0.1267	175390200.0
2002-07-29 14:00:00	NVDA	Stock	0.1268	0.1282	0.1258	0.1262	119928960.0
2002-07-29 15:00:00	NVDA	Stock	0.1263	0.1276	0.1256	0.126	177476280.0
2002-07-29 16:00:00	NVDA	Stock	0.1262	0.1269	0.1258	0.1262	9602040.0
2002-07-29 17:00:00	NVDA	Stock	0.1262	0.1264	0.1261	0.1261	490920.0
2002-07-29 18:00:00	NVDA	Stock	0.1262	0.1262	0.1258	0.1258	648000.0
2002-07-29 08:00:00	AMZN	Stock	0.65	0.67	0.65	0.67	108000.0
2002-07-29 09:00:00	AMZN	Stock	0.6701	0.6835	0.6589	0.668	18435080.0
2002-07-29 10:00:00	AMZN	Stock	0.6675	0.6785	0.666	0.6745	23662940.0
2002-07-29 11:00:00	AMZN	Stock	0.6735	0.698	0.673	0.694	20308280.0
2002-07-29 12:00:00	AMZN	Stock	0.6945	0.709	0.6905	0.7071	19614000.0
2002-07-29 13:00:00	AMZN	Stock	0.7075	0.72	0.705	0.716	20326580.0
2002-07-29 14:00:00	AMZN	Stock	0.7155	0.72	0.7035	0.716	13747100.0
2002-07-29 15:00:00	AMZN	Stock	0.7165	0.723	0.7125	0.715	16241880.0
2002-07-29 16:00:00	AMZN	Stock	0.713	0.7175	0.7085	0.712	4978000.0
2002-07-29 17:00:00	AMZN	Stock	0.7125	0.7165	0.7125	0.7125	18000.0
2002-07-29 18:00:00	AMZN	Stock	0.7145	0.7145	0.7145	0.7145	2000.0
2002-07-29 09:00:00	CL	Stock	25.5	25.57	25.345	25.415	478600.0
2002-07-29 10:00:00	CL	Stock	25.4	26.015	25.365	25.89	998400.0
2002-07-29 11:00:00	CL	Stock	25.895	26.005	25.805	25.89	627800.0
2002-07-29 12:00:00	CL	Stock	25.89	25.895	25.72	25.84	698200.0
2002-07-29 13:00:00	CL	Stock	25.84	25.9	25.785	25.88	428000.0
2002-07-29 14:00:00	CL	Stock	25.885	26.12	25.875	26.05	529800.0
2002-07-29 15:00:00	CL	Stock	26.04	26.25	25.965	26.235	969000.0

> showing 50 of 19,175 rows — these rows as CSV

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