PREVIEW / stock_1hour / 2001-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-10.parquet
  size:    347 KB
  rows:    16,790
  symbols: 1,294

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
2001-04-10 08:00:00	AAPL	Stock	0.3732	0.3732	0.3732	0.3732	140000.0
2001-04-10 09:00:00	AAPL	Stock	0.3732	0.3779	0.3711	0.3759	62288800.0
2001-04-10 10:00:00	AAPL	Stock	0.3777	0.4054	0.3761	0.3907	126963200.0
2001-04-10 11:00:00	AAPL	Stock	0.3907	0.3934	0.385	0.3895	35660800.0
2001-04-10 12:00:00	AAPL	Stock	0.3893	0.4013	0.3893	0.3973	52914400.0
2001-04-10 13:00:00	AAPL	Stock	0.3971	0.3977	0.3918	0.392	35414400.0
2001-04-10 14:00:00	AAPL	Stock	0.3911	0.3995	0.3911	0.3948	38164000.0
2001-04-10 15:00:00	AAPL	Stock	0.3954	0.4036	0.3929	0.3929	71864800.0
2001-04-10 16:00:00	AAPL	Stock	0.3938	0.3945	0.3884	0.3936	18704000.0
2001-04-10 17:00:00	AAPL	Stock	0.3936	0.3936	0.3936	0.3936	39200.0
2001-04-10 08:00:00	MSFT	Stock	29.0	29.185	28.575	28.95	606612.0
2001-04-10 09:00:00	MSFT	Stock	28.975	29.28	28.83	29.23	11446600.0
2001-04-10 10:00:00	MSFT	Stock	29.26	29.785	29.21	29.66	22235000.0
2001-04-10 11:00:00	MSFT	Stock	29.66	29.78	29.5	29.75	13707800.0
2001-04-10 12:00:00	MSFT	Stock	29.75	30.015	29.745	29.98	13916200.0
2001-04-10 13:00:00	MSFT	Stock	29.98	30.02	29.865	29.93	6980600.0
2001-04-10 14:00:00	MSFT	Stock	29.93	29.995	29.665	29.8	10390200.0
2001-04-10 15:00:00	MSFT	Stock	29.8	30.04	29.76	29.84	20237400.0
2001-04-10 16:00:00	MSFT	Stock	29.84	30.03	28.915	29.85	3139400.0
2001-04-10 17:00:00	MSFT	Stock	29.55	29.995	29.55	29.87	26400.0
2001-04-10 18:00:00	MSFT	Stock	29.845	29.845	29.655	29.655	11800.0
2001-04-10 08:00:00	NVDA	Stock	0.251	0.2529	0.2488	0.2529	6072480.0
2001-04-10 09:00:00	NVDA	Stock	0.2542	0.2633	0.2521	0.2625	124584000.0
2001-04-10 10:00:00	NVDA	Stock	0.2623	0.2767	0.2618	0.2731	293784000.0
2001-04-10 11:00:00	NVDA	Stock	0.273	0.28	0.27	0.2772	185232000.0
2001-04-10 12:00:00	NVDA	Stock	0.2772	0.2794	0.2754	0.2757	102000000.0
2001-04-10 13:00:00	NVDA	Stock	0.2755	0.2767	0.2704	0.2718	113448000.0
2001-04-10 14:00:00	NVDA	Stock	0.2721	0.277	0.2713	0.2749	100536000.0
2001-04-10 15:00:00	NVDA	Stock	0.275	0.2758	0.2717	0.272	176760000.0
2001-04-10 16:00:00	NVDA	Stock	0.272	0.2724	0.2675	0.2711	52560000.0
2001-04-10 17:00:00	NVDA	Stock	0.2708	0.2713	0.2688	0.2706	840000.0
2001-04-10 18:00:00	NVDA	Stock	0.2704	0.2706	0.2667	0.2667	960000.0
2001-04-10 08:00:00	AMZN	Stock	0.561	0.585	0.559	0.5725	1676000.0
2001-04-10 09:00:00	AMZN	Stock	0.57	0.625	0.56	0.6135	51104000.0
2001-04-10 10:00:00	AMZN	Stock	0.615	0.675	0.6075	0.6605	98540000.0
2001-04-10 11:00:00	AMZN	Stock	0.6615	0.665	0.6525	0.6615	53526000.0
2001-04-10 12:00:00	AMZN	Stock	0.661	0.67	0.642	0.6425	36412000.0
2001-04-10 13:00:00	AMZN	Stock	0.6425	0.65	0.6195	0.6205	37254000.0
2001-04-10 14:00:00	AMZN	Stock	0.6205	0.625	0.5995	0.6005	34690000.0
2001-04-10 15:00:00	AMZN	Stock	0.6	0.6195	0.5975	0.6	38120000.0
2001-04-10 16:00:00	AMZN	Stock	0.6005	0.6175	0.594	0.6005	7022000.0
2001-04-10 17:00:00	AMZN	Stock	0.6025	0.613	0.592	0.606	300000.0
2001-04-10 18:00:00	AMZN	Stock	0.6	0.606	0.595	0.5995	156000.0
2001-04-10 09:00:00	CL	Stock	25.8	25.975	25.69	25.825	770600.0
2001-04-10 10:00:00	CL	Stock	25.825	25.92	25.725	25.75	1142600.0
2001-04-10 11:00:00	CL	Stock	25.75	25.8	25.68	25.745	609000.0
2001-04-10 12:00:00	CL	Stock	25.75	26.125	25.745	26.0	583200.0
2001-04-10 13:00:00	CL	Stock	26.005	26.05	25.825	25.83	332000.0
2001-04-10 14:00:00	CL	Stock	25.82	25.85	25.725	25.73	504000.0
2001-04-10 15:00:00	CL	Stock	25.75	25.94	25.75	25.81	783400.0

> showing 50 of 16,790 rows — these rows as CSV

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