PREVIEW / stock_1hour / 2001-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-01.parquet
  size:    367 KB
  rows:    17,522
  symbols: 1,303

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-06-01 08:00:00	AAPL	Stock	0.3586	0.3634	0.352	0.3607	207200.0
2001-06-01 09:00:00	AAPL	Stock	0.3589	0.367	0.3563	0.3661	64097600.0
2001-06-01 10:00:00	AAPL	Stock	0.3663	0.3702	0.3568	0.3691	64797600.0
2001-06-01 11:00:00	AAPL	Stock	0.3691	0.37	0.3643	0.3675	38617600.0
2001-06-01 12:00:00	AAPL	Stock	0.3679	0.3723	0.3661	0.37	33622400.0
2001-06-01 13:00:00	AAPL	Stock	0.3702	0.3713	0.3679	0.368	28190400.0
2001-06-01 14:00:00	AAPL	Stock	0.368	0.3748	0.3679	0.3696	38141600.0
2001-06-01 15:00:00	AAPL	Stock	0.37	0.3766	0.3636	0.373	99948800.0
2001-06-01 16:00:00	AAPL	Stock	0.3732	0.3757	0.368	0.368	60261600.0
2001-06-01 17:00:00	AAPL	Stock	0.373	0.3759	0.373	0.3759	700000.0
2001-06-01 08:00:00	MSFT	Stock	34.675	34.75	34.33	34.7	172800.0
2001-06-01 09:00:00	MSFT	Stock	34.7	34.9	34.635	34.815	6745600.0
2001-06-01 10:00:00	MSFT	Stock	34.815	34.925	34.35	34.745	11224000.0
2001-06-01 11:00:00	MSFT	Stock	34.735	35.12	34.65	34.985	9971800.0
2001-06-01 12:00:00	MSFT	Stock	34.985	35.23	34.9	35.095	6745400.0
2001-06-01 13:00:00	MSFT	Stock	35.095	35.11	34.95	34.98	3786400.0
2001-06-01 14:00:00	MSFT	Stock	34.975	35.23	34.95	35.165	3595800.0
2001-06-01 15:00:00	MSFT	Stock	35.165	35.35	34.98	35.17	10682800.0
2001-06-01 16:00:00	MSFT	Stock	35.17	35.245	34.915	35.19	1766400.0
2001-06-01 17:00:00	MSFT	Stock	35.17	35.2	35.16	35.2	109200.0
2001-06-01 08:00:00	NVDA	Stock	0.35	0.3616	0.35	0.3604	1464000.0
2001-06-01 09:00:00	NVDA	Stock	0.3592	0.3633	0.3571	0.3621	132576000.0
2001-06-01 10:00:00	NVDA	Stock	0.3621	0.3677	0.36	0.3663	199272000.0
2001-06-01 11:00:00	NVDA	Stock	0.3663	0.3703	0.3646	0.369	84696000.0
2001-06-01 12:00:00	NVDA	Stock	0.3695	0.3783	0.3681	0.3767	147360000.0
2001-06-01 13:00:00	NVDA	Stock	0.3767	0.377	0.3704	0.3712	159432000.0
2001-06-01 14:00:00	NVDA	Stock	0.3713	0.3795	0.3709	0.3734	101880000.0
2001-06-01 15:00:00	NVDA	Stock	0.3736	0.3769	0.3716	0.3765	131640000.0
2001-06-01 16:00:00	NVDA	Stock	0.3771	0.3791	0.3698	0.3765	13560000.0
2001-06-01 17:00:00	NVDA	Stock	0.3777	0.3785	0.3765	0.3785	672000.0
2001-06-01 08:00:00	AMZN	Stock	0.834	0.8525	0.8325	0.8525	558000.0
2001-06-01 09:00:00	AMZN	Stock	0.8495	0.87	0.8345	0.8495	25378000.0
2001-06-01 10:00:00	AMZN	Stock	0.85	0.8565	0.8195	0.843	21340000.0
2001-06-01 11:00:00	AMZN	Stock	0.8435	0.845	0.82	0.8275	8772000.0
2001-06-01 12:00:00	AMZN	Stock	0.8275	0.837	0.826	0.83	5450000.0
2001-06-01 13:00:00	AMZN	Stock	0.8305	0.8325	0.8235	0.8255	7380000.0
2001-06-01 14:00:00	AMZN	Stock	0.825	0.8375	0.825	0.835	12406000.0
2001-06-01 15:00:00	AMZN	Stock	0.8345	0.849	0.8325	0.8475	28608000.0
2001-06-01 16:00:00	AMZN	Stock	0.8465	0.8505	0.8315	0.841	9090000.0
2001-06-01 17:00:00	AMZN	Stock	0.8475	0.8495	0.8435	0.8495	154000.0
2001-06-01 09:00:00	CL	Stock	28.375	28.375	28.09	28.175	220400.0
2001-06-01 10:00:00	CL	Stock	28.175	28.36	28.095	28.28	244200.0
2001-06-01 11:00:00	CL	Stock	28.275	28.3	28.17	28.2	106200.0
2001-06-01 12:00:00	CL	Stock	28.2	28.4	28.175	28.19	144800.0
2001-06-01 13:00:00	CL	Stock	28.19	28.55	28.175	28.405	239800.0
2001-06-01 14:00:00	CL	Stock	28.405	28.69	28.405	28.69	253000.0
2001-06-01 15:00:00	CL	Stock	28.675	28.73	28.605	28.675	421000.0
2001-06-01 16:00:00	CL	Stock	28.675	28.675	28.625	28.625	38000.0
2001-06-01 17:00:00	CL	Stock	28.625	28.625	28.625	28.625	1600.0

> showing 49 of 17,522 rows — these rows as CSV

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