PREVIEW / stock_1hour / 2002-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-06.parquet
  size:    403 KB
  rows:    18,931
  symbols: 1,408

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-05-06 09:00:00	AAPL	Stock	0.4205	0.4205	0.4118	0.4164	26163200.0
2002-05-06 10:00:00	AAPL	Stock	0.4161	0.4168	0.4125	0.4134	24617600.0
2002-05-06 11:00:00	AAPL	Stock	0.4134	0.4155	0.4089	0.4098	21280000.0
2002-05-06 12:00:00	AAPL	Stock	0.4095	0.4121	0.4088	0.41	17466400.0
2002-05-06 13:00:00	AAPL	Stock	0.4098	0.4121	0.4089	0.4096	15142400.0
2002-05-06 14:00:00	AAPL	Stock	0.4102	0.4113	0.4071	0.4098	45505600.0
2002-05-06 15:00:00	AAPL	Stock	0.4098	0.4104	0.4011	0.4046	81004000.0
2002-05-06 16:00:00	AAPL	Stock	0.4045	0.4064	0.4036	0.4045	12465600.0
2002-05-06 08:00:00	MSFT	Stock	24.845	24.925	24.75	24.8	85400.0
2002-05-06 09:00:00	MSFT	Stock	24.8	25.04	24.71	24.83	10841800.0
2002-05-06 10:00:00	MSFT	Stock	24.83	25.04	24.625	24.855	11465600.0
2002-05-06 11:00:00	MSFT	Stock	24.855	25.163	24.825	25.095	6643000.0
2002-05-06 12:00:00	MSFT	Stock	25.093	25.22	25.01	25.18	5236000.0
2002-05-06 13:00:00	MSFT	Stock	25.185	25.27	24.83	24.9	6804200.0
2002-05-06 14:00:00	MSFT	Stock	24.9	24.965	24.725	24.87	5564800.0
2002-05-06 15:00:00	MSFT	Stock	24.865	24.9	24.185	24.31	15752000.0
2002-05-06 16:00:00	MSFT	Stock	24.315	24.8314	24.155	24.22	2255400.0
2002-05-06 17:00:00	MSFT	Stock	24.245	24.31	24.2	24.235	77600.0
2002-05-06 18:00:00	MSFT	Stock	24.21	24.21	24.165	24.185	6600.0
2002-05-06 08:00:00	NVDA	Stock	0.275	0.275	0.27	0.2721	1032000.0
2002-05-06 09:00:00	NVDA	Stock	0.2721	0.2725	0.2604	0.2646	213480000.0
2002-05-06 10:00:00	NVDA	Stock	0.2646	0.267	0.2612	0.265	185376000.0
2002-05-06 11:00:00	NVDA	Stock	0.2653	0.2677	0.2639	0.2667	101616000.0
2002-05-06 12:00:00	NVDA	Stock	0.2668	0.2722	0.2663	0.2704	117396000.0
2002-05-06 13:00:00	NVDA	Stock	0.2704	0.2783	0.2701	0.2724	193224000.0
2002-05-06 14:00:00	NVDA	Stock	0.2724	0.2747	0.2696	0.2696	80388000.0
2002-05-06 15:00:00	NVDA	Stock	0.2697	0.27	0.2622	0.2625	178848000.0
2002-05-06 16:00:00	NVDA	Stock	0.263	0.2738	0.2624	0.2625	13464000.0
2002-05-06 17:00:00	NVDA	Stock	0.2627	0.2632	0.2625	0.2625	564000.0
2002-05-06 18:00:00	NVDA	Stock	0.2638	0.2638	0.2617	0.2617	312000.0
2002-05-06 08:00:00	AMZN	Stock	0.8018	0.8018	0.775	0.775	462000.0
2002-05-06 09:00:00	AMZN	Stock	0.7985	0.81	0.7875	0.8085	16922000.0
2002-05-06 10:00:00	AMZN	Stock	0.809	0.809	0.8	0.805	12990000.0
2002-05-06 11:00:00	AMZN	Stock	0.8055	0.811	0.805	0.8105	9904000.0
2002-05-06 12:00:00	AMZN	Stock	0.811	0.821	0.808	0.8195	8918000.0
2002-05-06 13:00:00	AMZN	Stock	0.8195	0.8245	0.813	0.8195	13538000.0
2002-05-06 14:00:00	AMZN	Stock	0.819	0.821	0.8145	0.819	13734000.0
2002-05-06 15:00:00	AMZN	Stock	0.8186	0.8195	0.805	0.806	25712000.0
2002-05-06 16:00:00	AMZN	Stock	0.806	0.8105	0.8	0.8105	4078000.0
2002-05-06 17:00:00	AMZN	Stock	0.8075	0.808	0.806	0.806	172000.0
2002-05-06 18:00:00	AMZN	Stock	0.81	0.81	0.81	0.81	2000.0
2002-05-06 09:00:00	CL	Stock	27.375	27.55	27.325	27.545	275400.0
2002-05-06 10:00:00	CL	Stock	27.545	27.675	27.52	27.665	539200.0
2002-05-06 11:00:00	CL	Stock	27.665	27.775	27.65	27.74	461200.0
2002-05-06 12:00:00	CL	Stock	27.75	27.84	27.68	27.7	438600.0
2002-05-06 13:00:00	CL	Stock	27.7	27.72	27.575	27.655	486000.0
2002-05-06 14:00:00	CL	Stock	27.65	27.655	27.555	27.64	627400.0
2002-05-06 15:00:00	CL	Stock	27.63	27.63	27.54	27.58	940200.0
2002-05-06 16:00:00	CL	Stock	27.585	27.6	27.58	27.585	87800.0
2002-05-06 17:00:00	CL	Stock	27.59	27.59	27.59	27.59	50000.0

> showing 50 of 18,931 rows — these rows as CSV

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