PREVIEW / stock_1hour / 2002-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-03.parquet
  size:    400 KB
  rows:    19,082
  symbols: 1,451

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-03 08:00:00	AAPL	Stock	0.3016	0.3016	0.3016	0.3016	5600.0
2002-07-03 09:00:00	AAPL	Stock	0.3018	0.3086	0.2991	0.3082	36915200.0
2002-07-03 10:00:00	AAPL	Stock	0.308	0.3082	0.2995	0.3009	28386400.0
2002-07-03 11:00:00	AAPL	Stock	0.3014	0.3107	0.3	0.3106	21509600.0
2002-07-03 12:00:00	AAPL	Stock	0.3107	0.3114	0.3054	0.307	17455200.0
2002-07-03 13:00:00	AAPL	Stock	0.3071	0.3107	0.3043	0.3095	18037600.0
2002-07-03 14:00:00	AAPL	Stock	0.3095	0.3157	0.3086	0.3114	31746400.0
2002-07-03 15:00:00	AAPL	Stock	0.3116	0.3143	0.3075	0.3136	31068800.0
2002-07-03 16:00:00	AAPL	Stock	0.3136	0.3143	0.3076	0.3134	9441600.0
2002-07-03 17:00:00	AAPL	Stock	0.3134	0.3134	0.3134	0.3134	638400.0
2002-07-03 08:00:00	MSFT	Stock	25.7	25.84	25.565	25.755	87800.0
2002-07-03 09:00:00	MSFT	Stock	25.77	26.11	25.605	25.975	10076600.0
2002-07-03 10:00:00	MSFT	Stock	25.975	26.05	25.325	25.377	16819200.0
2002-07-03 11:00:00	MSFT	Stock	25.36	25.625	25.225	25.625	11839400.0
2002-07-03 12:00:00	MSFT	Stock	25.625	25.75	25.4	25.5705	9077600.0
2002-07-03 13:00:00	MSFT	Stock	25.5705	25.7	25.4	25.625	6325000.0
2002-07-03 14:00:00	MSFT	Stock	25.63	26.0	25.575	25.995	10829600.0
2002-07-03 15:00:00	MSFT	Stock	26.0	26.255	25.675	26.25	11410800.0
2002-07-03 16:00:00	MSFT	Stock	26.245	26.3	25.615	26.25	2094200.0
2002-07-03 17:00:00	MSFT	Stock	26.27	26.275	26.235	26.255	116600.0
2002-07-03 18:00:00	MSFT	Stock	26.26	26.26	26.26	26.26	800.0
2002-07-03 08:00:00	NVDA	Stock	0.1326	0.1342	0.1303	0.1321	2196000.0
2002-07-03 09:00:00	NVDA	Stock	0.1323	0.1424	0.1318	0.1398	226836000.0
2002-07-03 10:00:00	NVDA	Stock	0.1402	0.1409	0.1362	0.1373	179532000.0
2002-07-03 11:00:00	NVDA	Stock	0.1371	0.1417	0.1366	0.1414	91092000.0
2002-07-03 12:00:00	NVDA	Stock	0.1412	0.1417	0.1381	0.1395	123720000.0
2002-07-03 13:00:00	NVDA	Stock	0.1397	0.1414	0.1383	0.1407	84180000.0
2002-07-03 14:00:00	NVDA	Stock	0.1407	0.1445	0.1407	0.1434	146760000.0
2002-07-03 15:00:00	NVDA	Stock	0.1436	0.1457	0.1425	0.1454	181248000.0
2002-07-03 16:00:00	NVDA	Stock	0.1454	0.1456	0.1402	0.1454	17268000.0
2002-07-03 17:00:00	NVDA	Stock	0.1452	0.1454	0.1446	0.1454	1044000.0
2002-07-03 18:00:00	NVDA	Stock	0.1456	0.146	0.145	0.146	900000.0
2002-07-03 08:00:00	AMZN	Stock	0.6626	0.674	0.6625	0.665	46000.0
2002-07-03 09:00:00	AMZN	Stock	0.669	0.6951	0.666	0.691	17310000.0
2002-07-03 10:00:00	AMZN	Stock	0.6915	0.6935	0.651	0.651	18726000.0
2002-07-03 11:00:00	AMZN	Stock	0.651	0.7025	0.6445	0.702	27660000.0
2002-07-03 12:00:00	AMZN	Stock	0.7025	0.7075	0.6835	0.695	20492000.0
2002-07-03 13:00:00	AMZN	Stock	0.697	0.71	0.692	0.7021	20252000.0
2002-07-03 14:00:00	AMZN	Stock	0.704	0.723	0.702	0.7165	17262000.0
2002-07-03 15:00:00	AMZN	Stock	0.7165	0.7215	0.701	0.7125	22526000.0
2002-07-03 16:00:00	AMZN	Stock	0.713	0.7135	0.7075	0.7125	2836000.0
2002-07-03 17:00:00	AMZN	Stock	0.7125	0.7125	0.705	0.705	220000.0
2002-07-03 09:00:00	CL	Stock	25.25	25.43	25.215	25.37	307000.0
2002-07-03 10:00:00	CL	Stock	25.39	25.39	24.995	25.005	642000.0
2002-07-03 11:00:00	CL	Stock	25.025	25.025	24.885	24.98	744000.0
2002-07-03 12:00:00	CL	Stock	24.985	24.985	24.8	24.855	667000.0
2002-07-03 13:00:00	CL	Stock	24.855	24.855	24.77	24.82	506400.0
2002-07-03 14:00:00	CL	Stock	24.82	25.125	24.8	25.125	711600.0
2002-07-03 15:00:00	CL	Stock	25.13	25.25	25.045	25.07	770800.0
2002-07-03 16:00:00	CL	Stock	25.075	25.075	25.0	25.0	133400.0

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

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