PREVIEW / stock_1hour / 2005-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-01.parquet
  size:    580 KB
  rows:    27,757
  symbols: 2,106

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
2005-11-01 07:00:00	AAPL	Stock	2.0464	2.0464	2.0464	2.0464	2800.0
2005-11-01 08:00:00	AAPL	Stock	2.0525	2.0568	2.0357	2.0568	1472968.0
2005-11-01 09:00:00	AAPL	Stock	2.0393	2.0764	2.0311	2.0589	150500532.0
2005-11-01 10:00:00	AAPL	Stock	2.0589	2.0714	2.0343	2.0493	136800076.0
2005-11-01 11:00:00	AAPL	Stock	2.0493	2.055	2.0457	2.0514	53822972.0
2005-11-01 12:00:00	AAPL	Stock	2.0514	2.0593	2.0446	2.0482	59488268.0
2005-11-01 13:00:00	AAPL	Stock	2.0486	2.0486	2.0407	2.0411	59884944.0
2005-11-01 14:00:00	AAPL	Stock	2.0411	2.07	2.0371	2.0479	177069200.0
2005-11-01 15:00:00	AAPL	Stock	2.0482	2.0568	2.0418	2.0536	100007908.0
2005-11-01 16:00:00	AAPL	Stock	2.0536	2.0579	2.0529	2.0546	1540280.0
2005-11-01 17:00:00	AAPL	Stock	2.0546	2.0568	2.045	2.0539	420168.0
2005-11-01 18:00:00	AAPL	Stock	2.045	2.045	2.045	2.045	36120.0
2005-11-01 08:00:00	MSFT	Stock	25.76	25.8	25.53	25.61	73171.0
2005-11-01 09:00:00	MSFT	Stock	25.61	25.87	25.59	25.83	8561592.0
2005-11-01 10:00:00	MSFT	Stock	25.84	25.91	25.82	25.91	12576555.0
2005-11-01 11:00:00	MSFT	Stock	25.9	25.93	25.82	25.879	9541631.0
2005-11-01 12:00:00	MSFT	Stock	25.88	25.89	25.82	25.86	5733042.0
2005-11-01 13:00:00	MSFT	Stock	25.85	25.98	25.84	25.97	7680734.0
2005-11-01 14:00:00	MSFT	Stock	25.97	26.06	25.94	25.97	13721662.0
2005-11-01 15:00:00	MSFT	Stock	25.98	26.1	25.95	25.96	11425955.0
2005-11-01 16:00:00	MSFT	Stock	25.96	26.01	25.89	25.96	396629.0
2005-11-01 17:00:00	MSFT	Stock	25.96	25.96	25.94	25.96	60600.0
2005-11-01 18:00:00	MSFT	Stock	25.63	25.63	25.63	25.63	5330.0
2005-11-01 08:00:00	NVDA	Stock	0.2777	0.2796	0.2772	0.2775	8811720.0
2005-11-01 09:00:00	NVDA	Stock	0.2765	0.2817	0.2762	0.2787	44226480.0
2005-11-01 10:00:00	NVDA	Stock	0.2787	0.2793	0.2762	0.2782	97747680.0
2005-11-01 11:00:00	NVDA	Stock	0.2783	0.2783	0.2767	0.277	36715800.0
2005-11-01 12:00:00	NVDA	Stock	0.2769	0.2777	0.2764	0.2768	18061440.0
2005-11-01 13:00:00	NVDA	Stock	0.2768	0.2772	0.276	0.2763	21484200.0
2005-11-01 14:00:00	NVDA	Stock	0.2764	0.2783	0.2752	0.2753	62205120.0
2005-11-01 15:00:00	NVDA	Stock	0.2754	0.2762	0.274	0.2762	101328000.0
2005-11-01 16:00:00	NVDA	Stock	0.2762	0.2762	0.276	0.2762	2690280.0
2005-11-01 17:00:00	NVDA	Stock	0.2765	0.2779	0.2762	0.2762	180000.0
2005-11-01 08:00:00	AMZN	Stock	2.0185	2.03	1.9885	1.993	238200.0
2005-11-01 09:00:00	AMZN	Stock	1.9925	2.009	1.9825	1.999	19156260.0
2005-11-01 10:00:00	AMZN	Stock	1.9995	2.026	1.999	2.0255	23067280.0
2005-11-01 11:00:00	AMZN	Stock	2.026	2.037	2.0111	2.0285	15429600.0
2005-11-01 12:00:00	AMZN	Stock	2.0285	2.032	2.0195	2.028	6239420.0
2005-11-01 13:00:00	AMZN	Stock	2.028	2.03	2.0095	2.012	8192040.0
2005-11-01 14:00:00	AMZN	Stock	2.013	2.027	2.007	2.007	14648040.0
2005-11-01 15:00:00	AMZN	Stock	2.0065	2.0185	2.005	2.0185	14615480.0
2005-11-01 16:00:00	AMZN	Stock	2.0185	2.04	2.0125	2.018	2794000.0
2005-11-01 17:00:00	AMZN	Stock	2.0245	2.0245	2.0245	2.0245	4000.0
2005-11-01 08:00:00	CL	Stock	26.875	26.875	26.875	26.875	10000.0
2005-11-01 09:00:00	CL	Stock	26.625	26.795	26.5	26.61	890400.0
2005-11-01 10:00:00	CL	Stock	26.6	26.61	26.205	26.385	878600.0
2005-11-01 11:00:00	CL	Stock	26.385	26.44	26.165	26.245	594200.0
2005-11-01 12:00:00	CL	Stock	26.245	26.245	26.16	26.18	613000.0
2005-11-01 13:00:00	CL	Stock	26.19	26.225	26.09	26.175	694000.0
2005-11-01 14:00:00	CL	Stock	26.175	26.18	26.055	26.105	842800.0

> showing 50 of 27,757 rows — these rows as CSV

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