PREVIEW / stock_1hour / 2002-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-27.parquet
  size:    408 KB
  rows:    19,002
  symbols: 1,471

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-08-27 08:00:00	AAPL	Stock	0.2771	0.2771	0.2768	0.2768	11200.0
2002-08-27 09:00:00	AAPL	Stock	0.2779	0.2813	0.2739	0.2746	24933384.0
2002-08-27 10:00:00	AAPL	Stock	0.275	0.2757	0.2709	0.2723	36526336.0
2002-08-27 11:00:00	AAPL	Stock	0.2721	0.275	0.2716	0.2727	28260400.0
2002-08-27 12:00:00	AAPL	Stock	0.2723	0.2732	0.2696	0.2696	25564504.0
2002-08-27 13:00:00	AAPL	Stock	0.27	0.2704	0.2668	0.2677	33136600.0
2002-08-27 14:00:00	AAPL	Stock	0.2679	0.268	0.2634	0.2657	39538128.0
2002-08-27 15:00:00	AAPL	Stock	0.2657	0.2679	0.2627	0.2652	55726216.0
2002-08-27 16:00:00	AAPL	Stock	0.2655	0.2679	0.2643	0.2661	9038400.0
2002-08-27 17:00:00	AAPL	Stock	0.2652	0.2664	0.2639	0.2664	84000.0
2002-08-27 08:00:00	MSFT	Stock	25.725	26.125	25.725	26.075	192462.0
2002-08-27 09:00:00	MSFT	Stock	26.075	26.225	25.91	25.985	8316012.0
2002-08-27 10:00:00	MSFT	Stock	25.98	25.991	25.63	25.82	13513380.0
2002-08-27 11:00:00	MSFT	Stock	25.8205	25.955	25.78	25.815	6914928.0
2002-08-27 12:00:00	MSFT	Stock	25.805	25.92	25.725	25.8	5452720.0
2002-08-27 13:00:00	MSFT	Stock	25.795	25.805	25.555	25.595	6500408.0
2002-08-27 14:00:00	MSFT	Stock	25.6	25.685	25.45	25.485	7989116.0
2002-08-27 15:00:00	MSFT	Stock	25.485	25.57	25.325	25.395	10449270.0
2002-08-27 16:00:00	MSFT	Stock	25.405	25.48	25.355	25.385	4539496.0
2002-08-27 17:00:00	MSFT	Stock	25.42	25.4747	25.39	25.39	51800.0
2002-08-27 18:00:00	MSFT	Stock	25.375	25.375	25.35	25.35	4300.0
2002-08-27 08:00:00	NVDA	Stock	0.096	0.0971	0.0942	0.0964	3528000.0
2002-08-27 09:00:00	NVDA	Stock	0.0964	0.099	0.0946	0.0954	82264200.0
2002-08-27 10:00:00	NVDA	Stock	0.0955	0.0955	0.0933	0.0943	125286000.0
2002-08-27 11:00:00	NVDA	Stock	0.0942	0.0957	0.0942	0.0949	71031240.0
2002-08-27 12:00:00	NVDA	Stock	0.0949	0.095	0.0929	0.0932	50137320.0
2002-08-27 13:00:00	NVDA	Stock	0.0932	0.0936	0.0918	0.0923	84301320.0
2002-08-27 14:00:00	NVDA	Stock	0.0924	0.0936	0.0917	0.092	83873760.0
2002-08-27 15:00:00	NVDA	Stock	0.0919	0.0922	0.0904	0.0915	154529400.0
2002-08-27 16:00:00	NVDA	Stock	0.0911	0.092	0.091	0.092	13275360.0
2002-08-27 17:00:00	NVDA	Stock	0.091	0.0925	0.091	0.0922	2864160.0
2002-08-27 18:00:00	NVDA	Stock	0.0918	0.0922	0.0917	0.0921	1320000.0
2002-08-27 08:00:00	AMZN	Stock	0.745	0.75	0.745	0.7475	108000.0
2002-08-27 09:00:00	AMZN	Stock	0.754	0.7635	0.7425	0.7545	9510620.0
2002-08-27 10:00:00	AMZN	Stock	0.7535	0.754	0.738	0.744	14744700.0
2002-08-27 11:00:00	AMZN	Stock	0.7435	0.7492	0.7375	0.743	6461000.0
2002-08-27 12:00:00	AMZN	Stock	0.743	0.744	0.7335	0.7375	6300540.0
2002-08-27 13:00:00	AMZN	Stock	0.7375	0.7385	0.73	0.7325	6139340.0
2002-08-27 14:00:00	AMZN	Stock	0.7325	0.7375	0.7295	0.735	6557140.0
2002-08-27 15:00:00	AMZN	Stock	0.7345	0.7375	0.729	0.7305	12517000.0
2002-08-27 16:00:00	AMZN	Stock	0.7295	0.7345	0.725	0.7275	4351840.0
2002-08-27 17:00:00	AMZN	Stock	0.726	0.7323	0.726	0.727	328000.0
2002-08-27 18:00:00	AMZN	Stock	0.727	0.727	0.726	0.726	46000.0
2002-08-27 09:00:00	CL	Stock	26.75	27.0	26.74	26.925	582600.0
2002-08-27 10:00:00	CL	Stock	26.92	26.925	26.505	26.775	518400.0
2002-08-27 11:00:00	CL	Stock	26.775	27.025	26.755	26.915	344600.0
2002-08-27 12:00:00	CL	Stock	26.91	27.045	26.855	27.035	256200.0
2002-08-27 13:00:00	CL	Stock	27.03	27.05	26.89	26.895	237000.0
2002-08-27 14:00:00	CL	Stock	26.885	27.06	26.82	27.025	457000.0
2002-08-27 15:00:00	CL	Stock	27.015	27.12	27.01	27.025	553600.0

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

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