PREVIEW / stock_1hour / 2009-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-10.parquet
  size:    893 KB
  rows:    42,633
  symbols: 3,427

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-10 07:00:00	AAPL	Stock	7.0918	7.1429	7.0764	7.1189	1089340.0
2009-12-10 08:00:00	AAPL	Stock	7.1232	7.1375	7.1043	7.1196	5768952.0
2009-12-10 09:00:00	AAPL	Stock	7.1204	7.1321	7.0425	7.0618	118065108.0
2009-12-10 10:00:00	AAPL	Stock	7.0618	7.0946	7.0432	7.0539	87658172.0
2009-12-10 11:00:00	AAPL	Stock	7.0536	7.0821	7.0479	7.0696	41652688.0
2009-12-10 12:00:00	AAPL	Stock	7.0675	7.0757	7.0257	7.0593	54051200.0
2009-12-10 13:00:00	AAPL	Stock	7.0593	7.0639	7.0289	7.04	40259240.0
2009-12-10 14:00:00	AAPL	Stock	7.04	7.0464	7.0043	7.0186	54286204.0
2009-12-10 15:00:00	AAPL	Stock	7.0179	7.0418	7.0054	7.0214	65661344.0
2009-12-10 16:00:00	AAPL	Stock	7.0214	7.0575	7.0132	7.015	13752508.0
2009-12-10 17:00:00	AAPL	Stock	7.015	7.025	6.9337	7.0229	540484.0
2009-12-10 18:00:00	AAPL	Stock	7.0189	7.0257	7.0154	7.0225	362376.0
2009-12-10 19:00:00	AAPL	Stock	7.0225	7.0268	7.0225	7.0268	209692.0
2009-12-10 20:00:00	AAPL	Stock	7.0707	7.0707	7.0707	7.0707	2800.0
2009-12-10 07:00:00	MSFT	Stock	29.72	29.72	29.7	29.72	13725.0
2009-12-10 08:00:00	MSFT	Stock	29.72	29.83	29.72	29.74	20155.0
2009-12-10 09:00:00	MSFT	Stock	29.75	29.9	29.66	29.77	5427610.0
2009-12-10 10:00:00	MSFT	Stock	29.77	29.92	29.76	29.86	5863573.0
2009-12-10 11:00:00	MSFT	Stock	29.86	29.94	29.84	29.915	3848298.0
2009-12-10 12:00:00	MSFT	Stock	29.91	29.92	29.84	29.911	3330285.0
2009-12-10 13:00:00	MSFT	Stock	29.92	29.93	29.795	29.87	6116883.0
2009-12-10 14:00:00	MSFT	Stock	29.88	29.95	29.827	29.924	3502767.0
2009-12-10 15:00:00	MSFT	Stock	29.92	29.96	29.86	29.87	10492461.0
2009-12-10 16:00:00	MSFT	Stock	29.88	29.916	29.8	29.87	3756458.0
2009-12-10 17:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	379.0
2009-12-10 18:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	19406.0
2009-12-10 19:00:00	MSFT	Stock	29.89	29.89	29.87	29.89	600.0
2009-12-10 07:00:00	NVDA	Stock	0.3995	0.3995	0.3995	0.3995	4000.0
2009-12-10 08:00:00	NVDA	Stock	0.395	0.397	0.395	0.397	24000.0
2009-12-10 09:00:00	NVDA	Stock	0.3965	0.3988	0.388	0.3882	69879240.0
2009-12-10 10:00:00	NVDA	Stock	0.3882	0.39	0.3862	0.3898	76677920.0
2009-12-10 11:00:00	NVDA	Stock	0.3895	0.3908	0.3878	0.3882	55131840.0
2009-12-10 12:00:00	NVDA	Stock	0.388	0.389	0.3868	0.3873	32087240.0
2009-12-10 13:00:00	NVDA	Stock	0.3873	0.3875	0.3845	0.3862	51685000.0
2009-12-10 14:00:00	NVDA	Stock	0.3862	0.3881	0.386	0.3875	40474000.0
2009-12-10 15:00:00	NVDA	Stock	0.3875	0.3875	0.384	0.385	75915000.0
2009-12-10 16:00:00	NVDA	Stock	0.3848	0.3883	0.383	0.3853	16284760.0
2009-12-10 17:00:00	NVDA	Stock	0.3922	0.3922	0.3865	0.387	260000.0
2009-12-10 19:00:00	NVDA	Stock	0.3873	0.3873	0.3873	0.3873	32000.0
2009-12-10 06:00:00	AMZN	Stock	6.6245	6.6245	6.6245	6.6245	2000.0
2009-12-10 07:00:00	AMZN	Stock	6.6245	6.633	6.6245	6.629	21000.0
2009-12-10 08:00:00	AMZN	Stock	6.6425	6.66	6.627	6.645	1090220.0
2009-12-10 09:00:00	AMZN	Stock	6.645	6.7295	6.62	6.668	38757180.0
2009-12-10 10:00:00	AMZN	Stock	6.6685	6.7645	6.667	6.754	50898320.0
2009-12-10 11:00:00	AMZN	Stock	6.755	6.7775	6.7315	6.746	22652120.0
2009-12-10 12:00:00	AMZN	Stock	6.747	6.7665	6.719	6.7645	14290800.0
2009-12-10 13:00:00	AMZN	Stock	6.7653	6.7685	6.729	6.7625	18143020.0
2009-12-10 14:00:00	AMZN	Stock	6.762	6.8095	6.7585	6.795	24191500.0
2009-12-10 15:00:00	AMZN	Stock	6.7942	6.8055	6.7425	6.77	40410080.0
2009-12-10 16:00:00	AMZN	Stock	6.77	6.7735	6.7414	6.7735	2546040.0

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

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