PREVIEW / stock_1hour / 2002-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-08.parquet
  size:    408 KB
  rows:    19,268
  symbols: 1,440

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-08 08:00:00	AAPL	Stock	0.3305	0.3305	0.3305	0.3305	28000.0
2002-07-08 09:00:00	AAPL	Stock	0.3273	0.3323	0.3217	0.322	29052800.0
2002-07-08 10:00:00	AAPL	Stock	0.3227	0.3273	0.3196	0.3216	34916000.0
2002-07-08 11:00:00	AAPL	Stock	0.3218	0.325	0.3196	0.322	20753600.0
2002-07-08 12:00:00	AAPL	Stock	0.322	0.3255	0.3214	0.3247	17382400.0
2002-07-08 13:00:00	AAPL	Stock	0.3248	0.327	0.3234	0.3264	17119200.0
2002-07-08 14:00:00	AAPL	Stock	0.3263	0.3268	0.3198	0.3216	20507200.0
2002-07-08 15:00:00	AAPL	Stock	0.3214	0.3236	0.3157	0.3211	46653600.0
2002-07-08 16:00:00	AAPL	Stock	0.3213	0.3233	0.3209	0.3233	20977600.0
2002-07-08 17:00:00	AAPL	Stock	0.3232	0.3232	0.3232	0.3232	44800.0
2002-07-08 08:00:00	MSFT	Stock	27.075	27.43	26.865	27.3	67600.0
2002-07-08 09:00:00	MSFT	Stock	27.3	27.465	26.625	27.155	9707600.0
2002-07-08 10:00:00	MSFT	Stock	27.17	27.18	26.77	26.875	11060000.0
2002-07-08 11:00:00	MSFT	Stock	26.865	26.975	26.613	26.72	5987200.0
2002-07-08 12:00:00	MSFT	Stock	26.72	26.831	26.615	26.795	4691000.0
2002-07-08 13:00:00	MSFT	Stock	26.795	26.95	26.575	26.815	6926400.0
2002-07-08 14:00:00	MSFT	Stock	26.815	26.995	26.505	26.535	7789600.0
2002-07-08 15:00:00	MSFT	Stock	26.535	26.63	26.2945	26.465	12675400.0
2002-07-08 16:00:00	MSFT	Stock	26.465	27.365	26.4	26.46	2831000.0
2002-07-08 17:00:00	MSFT	Stock	26.425	26.5	26.425	26.5	43800.0
2002-07-08 08:00:00	NVDA	Stock	0.1562	0.1587	0.1558	0.1565	732000.0
2002-07-08 09:00:00	NVDA	Stock	0.1565	0.1679	0.1532	0.1638	274236000.0
2002-07-08 10:00:00	NVDA	Stock	0.1638	0.1642	0.1567	0.1589	301008000.0
2002-07-08 11:00:00	NVDA	Stock	0.1588	0.1619	0.1587	0.1601	136872000.0
2002-07-08 12:00:00	NVDA	Stock	0.16	0.1625	0.1598	0.1612	102240000.0
2002-07-08 13:00:00	NVDA	Stock	0.1611	0.1667	0.1609	0.1661	194016000.0
2002-07-08 14:00:00	NVDA	Stock	0.166	0.1687	0.1657	0.1662	300816000.0
2002-07-08 15:00:00	NVDA	Stock	0.1662	0.1672	0.1624	0.163	208956000.0
2002-07-08 16:00:00	NVDA	Stock	0.163	0.1661	0.1625	0.163	14112000.0
2002-07-08 17:00:00	NVDA	Stock	0.1632	0.1632	0.1628	0.163	696000.0
2002-07-08 18:00:00	NVDA	Stock	0.1635	0.1637	0.1635	0.1637	588000.0
2002-07-08 08:00:00	AMZN	Stock	0.75	0.754	0.7425	0.745	266000.0
2002-07-08 09:00:00	AMZN	Stock	0.745	0.7925	0.7325	0.7565	17992000.0
2002-07-08 10:00:00	AMZN	Stock	0.7575	0.763	0.743	0.7556	20478000.0
2002-07-08 11:00:00	AMZN	Stock	0.7555	0.763	0.7385	0.7385	12082000.0
2002-07-08 12:00:00	AMZN	Stock	0.7385	0.75	0.734	0.7475	13116000.0
2002-07-08 13:00:00	AMZN	Stock	0.7455	0.758	0.744	0.7565	17136000.0
2002-07-08 14:00:00	AMZN	Stock	0.756	0.77	0.7549	0.7555	14808000.0
2002-07-08 15:00:00	AMZN	Stock	0.7555	0.7576	0.7445	0.7465	16948000.0
2002-07-08 16:00:00	AMZN	Stock	0.747	0.76	0.7405	0.75	2562000.0
2002-07-08 17:00:00	AMZN	Stock	0.747	0.747	0.747	0.747	48000.0
2002-07-08 18:00:00	AMZN	Stock	0.747	0.747	0.747	0.747	20000.0
2002-07-08 09:00:00	CL	Stock	25.8	25.99	25.785	25.885	213200.0
2002-07-08 10:00:00	CL	Stock	25.885	25.905	25.735	25.74	338200.0
2002-07-08 11:00:00	CL	Stock	25.735	25.805	25.595	25.615	241400.0
2002-07-08 12:00:00	CL	Stock	25.61	25.775	25.55	25.72	170600.0
2002-07-08 13:00:00	CL	Stock	25.675	25.765	25.585	25.705	217800.0
2002-07-08 14:00:00	CL	Stock	25.705	25.775	25.515	25.57	309000.0
2002-07-08 15:00:00	CL	Stock	25.58	25.67	25.535	25.635	410400.0
2002-07-08 16:00:00	CL	Stock	25.645	25.69	25.645	25.69	71800.0

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

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