PREVIEW / stock_1hour / 2002-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-07.parquet
  size:    417 KB
  rows:    19,678
  symbols: 1,497

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-10-07 08:00:00	AAPL	Stock	0.2496	0.2496	0.2489	0.2489	101920.0
2002-10-07 09:00:00	AAPL	Stock	0.2502	0.2534	0.2459	0.2482	33343520.0
2002-10-07 10:00:00	AAPL	Stock	0.248	0.2516	0.2473	0.2496	37613240.0
2002-10-07 11:00:00	AAPL	Stock	0.2496	0.2507	0.2482	0.2496	20334888.0
2002-10-07 12:00:00	AAPL	Stock	0.2496	0.2538	0.2495	0.2525	25054232.0
2002-10-07 13:00:00	AAPL	Stock	0.2523	0.2532	0.2518	0.2529	12637408.0
2002-10-07 14:00:00	AAPL	Stock	0.253	0.253	0.2489	0.25	18746784.0
2002-10-07 15:00:00	AAPL	Stock	0.25	0.2509	0.2457	0.2463	73845856.0
2002-10-07 16:00:00	AAPL	Stock	0.2459	0.2493	0.2459	0.2463	13249600.0
2002-10-07 17:00:00	AAPL	Stock	0.2466	0.2473	0.2459	0.2473	1708000.0
2002-10-07 18:00:00	AAPL	Stock	0.2459	0.2459	0.2459	0.2459	134400.0
2002-10-07 08:00:00	MSFT	Stock	22.0	22.0	21.75	21.9695	360100.0
2002-10-07 09:00:00	MSFT	Stock	21.9595	22.325	21.872	22.155	14132964.0
2002-10-07 10:00:00	MSFT	Stock	22.145	22.355	22.035	22.115	14868934.0
2002-10-07 11:00:00	MSFT	Stock	22.125	22.335	22.015	22.265	11249948.0
2002-10-07 12:00:00	MSFT	Stock	22.26	22.53	22.225	22.34	11597372.0
2002-10-07 13:00:00	MSFT	Stock	22.34	22.386	22.18	22.3245	7456894.0
2002-10-07 14:00:00	MSFT	Stock	22.32	22.355	22.075	22.155	9057138.0
2002-10-07 15:00:00	MSFT	Stock	22.155	22.175	21.845	22.03	15735644.0
2002-10-07 16:00:00	MSFT	Stock	22.025	22.12	21.85	22.075	3604226.0
2002-10-07 17:00:00	MSFT	Stock	22.025	22.1	21.99	22.04	1006964.0
2002-10-07 18:00:00	MSFT	Stock	22.065	22.125	22.06	22.06	139610.0
2002-10-07 08:00:00	NVDA	Stock	0.0678	0.0678	0.0666	0.0675	534000.0
2002-10-07 09:00:00	NVDA	Stock	0.0668	0.0682	0.065	0.0662	86297400.0
2002-10-07 10:00:00	NVDA	Stock	0.0662	0.0664	0.0647	0.0655	109607520.0
2002-10-07 11:00:00	NVDA	Stock	0.0655	0.0661	0.0642	0.0657	64935240.0
2002-10-07 12:00:00	NVDA	Stock	0.0657	0.0667	0.0653	0.0658	50092440.0
2002-10-07 13:00:00	NVDA	Stock	0.0659	0.0664	0.0654	0.0661	31703640.0
2002-10-07 14:00:00	NVDA	Stock	0.0662	0.0662	0.0647	0.0649	35433720.0
2002-10-07 15:00:00	NVDA	Stock	0.0649	0.065	0.064	0.0646	83920680.0
2002-10-07 16:00:00	NVDA	Stock	0.0646	0.065	0.0642	0.0646	17580000.0
2002-10-07 17:00:00	NVDA	Stock	0.0644	0.0647	0.0644	0.0647	2003280.0
2002-10-07 18:00:00	NVDA	Stock	0.0645	0.0645	0.0645	0.0645	516000.0
2002-10-07 08:00:00	AMZN	Stock	0.8225	0.8275	0.8225	0.8275	32000.0
2002-10-07 09:00:00	AMZN	Stock	0.8275	0.828	0.8185	0.827	9134820.0
2002-10-07 10:00:00	AMZN	Stock	0.826	0.8475	0.8235	0.8475	20749620.0
2002-10-07 11:00:00	AMZN	Stock	0.8475	0.848	0.8248	0.8415	22179900.0
2002-10-07 12:00:00	AMZN	Stock	0.8405	0.845	0.8355	0.8375	13259300.0
2002-10-07 13:00:00	AMZN	Stock	0.8375	0.8425	0.8325	0.838	17750400.0
2002-10-07 14:00:00	AMZN	Stock	0.8385	0.8395	0.831	0.832	8069980.0
2002-10-07 15:00:00	AMZN	Stock	0.831	0.8365	0.8255	0.832	16443260.0
2002-10-07 16:00:00	AMZN	Stock	0.832	0.835	0.8275	0.832	2476000.0
2002-10-07 17:00:00	AMZN	Stock	0.832	0.833	0.832	0.833	388000.0
2002-10-07 18:00:00	AMZN	Stock	0.834	0.84	0.832	0.84	376000.0
2002-10-07 09:00:00	CL	Stock	27.05	27.25	27.05	27.18	334400.0
2002-10-07 10:00:00	CL	Stock	27.175	27.625	27.175	27.505	843400.0
2002-10-07 11:00:00	CL	Stock	27.505	27.65	27.405	27.625	1037200.0
2002-10-07 12:00:00	CL	Stock	27.625	27.825	27.475	27.5	544400.0
2002-10-07 13:00:00	CL	Stock	27.5	27.675	27.44	27.66	611200.0
2002-10-07 14:00:00	CL	Stock	27.66	27.68	27.375	27.55	768400.0

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

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