PREVIEW / stock_1hour / 2009-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-01.parquet
  size:    880 KB
  rows:    42,643
  symbols: 3,378

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-09-01 04:00:00	AAPL	Stock	6.0282	6.0282	6.0282	6.0282	2800.0
2009-09-01 05:00:00	AAPL	Stock	5.9489	5.9489	5.9489	5.9489	2800.0
2009-09-01 06:00:00	AAPL	Stock	5.9143	5.9357	5.9143	5.9286	33600.0
2009-09-01 07:00:00	AAPL	Stock	5.9621	6.0	5.9571	5.9725	161196.0
2009-09-01 08:00:00	AAPL	Stock	5.9871	6.0214	5.9786	6.0139	1830052.0
2009-09-01 09:00:00	AAPL	Stock	6.0107	6.0689	5.9857	6.06	45053652.0
2009-09-01 10:00:00	AAPL	Stock	6.0593	6.0714	6.0221	6.0222	68686128.0
2009-09-01 11:00:00	AAPL	Stock	6.0225	6.0239	5.9343	5.9411	96042996.0
2009-09-01 12:00:00	AAPL	Stock	5.9414	5.9625	5.9204	5.9207	50131396.0
2009-09-01 13:00:00	AAPL	Stock	5.9221	5.93	5.8907	5.9261	60215904.0
2009-09-01 14:00:00	AAPL	Stock	5.9271	5.9554	5.9239	5.9329	45925180.0
2009-09-01 15:00:00	AAPL	Stock	5.9336	5.9443	5.8946	5.9036	76822032.0
2009-09-01 16:00:00	AAPL	Stock	5.9039	5.9733	5.8996	5.8996	13267100.0
2009-09-01 17:00:00	AAPL	Stock	5.9018	5.9036	5.8957	5.8982	383180.0
2009-09-01 18:00:00	AAPL	Stock	5.8964	5.9036	5.8964	5.9	325864.0
2009-09-01 19:00:00	AAPL	Stock	5.8968	5.9107	5.895	5.9071	247828.0
2009-09-01 06:00:00	MSFT	Stock	24.43	24.43	24.43	24.43	200.0
2009-09-01 07:00:00	MSFT	Stock	24.45	24.45	24.45	24.45	900.0
2009-09-01 08:00:00	MSFT	Stock	24.57	24.65	24.5	24.57	94513.0
2009-09-01 09:00:00	MSFT	Stock	24.55	24.74	24.34	24.59	4692697.0
2009-09-01 10:00:00	MSFT	Stock	24.59	24.73	24.46	24.46	7721212.0
2009-09-01 11:00:00	MSFT	Stock	24.46	24.49	24.04	24.06	13105669.0
2009-09-01 12:00:00	MSFT	Stock	24.07	24.1	23.95	23.96	6789404.0
2009-09-01 13:00:00	MSFT	Stock	23.97	24.06	23.9	24.02	6130105.0
2009-09-01 14:00:00	MSFT	Stock	24.02	24.06	23.93	23.98	5377443.0
2009-09-01 15:00:00	MSFT	Stock	23.99	24.13	23.97	23.98	11933146.0
2009-09-01 16:00:00	MSFT	Stock	23.98	24.22	23.96	23.99	4552242.0
2009-09-01 17:00:00	MSFT	Stock	23.99	24.0	23.99	23.99	24754.0
2009-09-01 18:00:00	MSFT	Stock	24.0	24.0	23.95	23.95	20408.0
2009-09-01 19:00:00	MSFT	Stock	23.95	23.99	23.92	23.92	2545.0
2009-09-01 08:00:00	NVDA	Stock	0.363	0.363	0.3612	0.3618	683640.0
2009-09-01 09:00:00	NVDA	Stock	0.3618	0.3708	0.3588	0.3688	103333200.0
2009-09-01 10:00:00	NVDA	Stock	0.3688	0.373	0.3668	0.3668	110177480.0
2009-09-01 11:00:00	NVDA	Stock	0.3668	0.3675	0.354	0.355	121103520.0
2009-09-01 12:00:00	NVDA	Stock	0.3548	0.3572	0.3528	0.3532	66951240.0
2009-09-01 13:00:00	NVDA	Stock	0.3532	0.3536	0.35	0.352	83927880.0
2009-09-01 14:00:00	NVDA	Stock	0.3522	0.354	0.3518	0.352	51078080.0
2009-09-01 15:00:00	NVDA	Stock	0.3522	0.3545	0.3488	0.35	170292400.0
2009-09-01 16:00:00	NVDA	Stock	0.351	0.3581	0.35	0.3508	10900520.0
2009-09-01 17:00:00	NVDA	Stock	0.363	0.363	0.3502	0.3508	219360.0
2009-09-01 18:00:00	NVDA	Stock	0.3502	0.3508	0.3502	0.3502	30800.0
2009-09-01 19:00:00	NVDA	Stock	0.3505	0.3508	0.3505	0.3508	60000.0
2009-09-01 08:00:00	AMZN	Stock	4.0595	4.077	4.025	4.026	772600.0
2009-09-01 09:00:00	AMZN	Stock	4.0275	4.121	4.026	4.098	10410600.0
2009-09-01 10:00:00	AMZN	Stock	4.097	4.1135	4.016	4.017	23601880.0
2009-09-01 11:00:00	AMZN	Stock	4.0175	4.028	3.954	3.969	25675620.0
2009-09-01 12:00:00	AMZN	Stock	3.969	3.987	3.961	3.9745	9868440.0
2009-09-01 13:00:00	AMZN	Stock	3.975	3.986	3.956	3.9856	12063940.0
2009-09-01 14:00:00	AMZN	Stock	3.986	3.9895	3.961	3.9655	11512760.0
2009-09-01 15:00:00	AMZN	Stock	3.9665	3.977	3.95	3.959	25922900.0

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

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