PREVIEW / stock_1hour / 2009-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-11.parquet
  size:    882 KB
  rows:    42,321
  symbols: 3,442

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
2009-12-11 06:00:00	AAPL	Stock	7.0614	7.0614	7.0571	7.0571	5600.0
2009-12-11 07:00:00	AAPL	Stock	7.0536	7.0896	7.0536	7.0754	346192.0
2009-12-11 08:00:00	AAPL	Stock	7.0761	7.0786	7.0154	7.0607	3349500.0
2009-12-11 09:00:00	AAPL	Stock	7.0604	7.0714	7.01	7.0467	63957068.0
2009-12-11 10:00:00	AAPL	Stock	7.0475	7.0482	6.9771	6.9943	73369212.0
2009-12-11 11:00:00	AAPL	Stock	6.9946	6.9957	6.9107	6.9293	86526804.0
2009-12-11 12:00:00	AAPL	Stock	6.9289	6.9607	6.9196	6.9607	42077868.0
2009-12-11 13:00:00	AAPL	Stock	6.9607	6.9632	6.9304	6.9357	30827720.0
2009-12-11 14:00:00	AAPL	Stock	6.9357	6.9564	6.9321	6.9443	33462800.0
2009-12-11 15:00:00	AAPL	Stock	6.9441	6.9743	6.9082	6.9536	69857564.0
2009-12-11 16:00:00	AAPL	Stock	6.9461	7.0154	6.9237	6.9525	11862116.0
2009-12-11 17:00:00	AAPL	Stock	6.9571	6.9589	6.9532	6.9571	120036.0
2009-12-11 18:00:00	AAPL	Stock	6.9525	7.0364	6.9525	6.9536	393008.0
2009-12-11 19:00:00	AAPL	Stock	6.9536	6.9643	6.9536	6.9607	364420.0
2009-12-11 08:00:00	MSFT	Stock	29.87	29.97	29.87	29.92	6749.0
2009-12-11 09:00:00	MSFT	Stock	29.92	30.0	29.87	29.965	5515561.0
2009-12-11 10:00:00	MSFT	Stock	29.968	30.0	29.87	29.94	7410133.0
2009-12-11 11:00:00	MSFT	Stock	29.94	29.956	29.79	29.872	6148136.0
2009-12-11 12:00:00	MSFT	Stock	29.88	29.89	29.8	29.86	4246228.0
2009-12-11 13:00:00	MSFT	Stock	29.87	29.9	29.84	29.851	2662810.0
2009-12-11 14:00:00	MSFT	Stock	29.85	29.9	29.82	29.84	6099182.0
2009-12-11 15:00:00	MSFT	Stock	29.84	29.9	29.81	29.85	8068831.0
2009-12-11 16:00:00	MSFT	Stock	29.86	29.9	29.849	29.85	2395202.0
2009-12-11 17:00:00	MSFT	Stock	29.87	29.87	29.85	29.85	1100.0
2009-12-11 19:00:00	MSFT	Stock	29.87	29.88	29.87	29.88	1418.0
2009-12-11 08:00:00	NVDA	Stock	0.388	0.3905	0.388	0.3905	116400.0
2009-12-11 09:00:00	NVDA	Stock	0.3905	0.3905	0.383	0.3865	65261360.0
2009-12-11 10:00:00	NVDA	Stock	0.3865	0.3875	0.3851	0.3859	80888400.0
2009-12-11 11:00:00	NVDA	Stock	0.3858	0.3865	0.3798	0.38	75988520.0
2009-12-11 12:00:00	NVDA	Stock	0.38	0.381	0.3793	0.3806	41456840.0
2009-12-11 13:00:00	NVDA	Stock	0.3808	0.381	0.3798	0.3799	27163960.0
2009-12-11 14:00:00	NVDA	Stock	0.38	0.3813	0.3795	0.38	45841480.0
2009-12-11 15:00:00	NVDA	Stock	0.3801	0.3818	0.3795	0.3805	60670320.0
2009-12-11 16:00:00	NVDA	Stock	0.3805	0.383	0.3802	0.3829	9580720.0
2009-12-11 17:00:00	NVDA	Stock	0.3853	0.3853	0.3793	0.3795	86000.0
2009-12-11 19:00:00	NVDA	Stock	0.3803	0.3803	0.3795	0.3795	149280.0
2009-12-11 04:00:00	AMZN	Stock	6.786	6.8065	6.786	6.8065	4000.0
2009-12-11 05:00:00	AMZN	Stock	6.836	6.838	6.815	6.838	6000.0
2009-12-11 06:00:00	AMZN	Stock	6.7825	6.8125	6.7825	6.8125	8000.0
2009-12-11 07:00:00	AMZN	Stock	6.852	6.852	6.8125	6.8345	62000.0
2009-12-11 08:00:00	AMZN	Stock	6.769	6.8375	6.7585	6.8155	1609720.0
2009-12-11 09:00:00	AMZN	Stock	6.815	6.8155	6.7255	6.7675	22627940.0
2009-12-11 10:00:00	AMZN	Stock	6.7635	6.7675	6.705	6.7325	19351620.0
2009-12-11 11:00:00	AMZN	Stock	6.732	6.7365	6.66	6.6715	21116220.0
2009-12-11 12:00:00	AMZN	Stock	6.6718	6.7445	6.663	6.7435	14648040.0
2009-12-11 13:00:00	AMZN	Stock	6.7435	6.755	6.698	6.7075	13547840.0
2009-12-11 14:00:00	AMZN	Stock	6.707	6.719	6.6915	6.7108	9969720.0
2009-12-11 15:00:00	AMZN	Stock	6.71	6.73	6.676	6.7075	27674480.0
2009-12-11 16:00:00	AMZN	Stock	6.706	6.769	6.706	6.7175	3408360.0
2009-12-11 17:00:00	AMZN	Stock	6.7175	6.7175	6.712	6.7165	28800.0

> showing 50 of 42,321 rows — these rows as CSV

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