PREVIEW / stock_1hour / 2009-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-13.parquet
  size:    886 KB
  rows:    44,456
  symbols: 3,339

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-07-13 07:00:00	AAPL	Stock	4.9475	4.9475	4.9375	4.9375	39200.0
2009-07-13 08:00:00	AAPL	Stock	4.9375	4.9857	4.9375	4.9821	1869308.0
2009-07-13 09:00:00	AAPL	Stock	4.9832	5.0014	4.9118	4.9457	88815748.0
2009-07-13 10:00:00	AAPL	Stock	4.9461	5.0221	4.9246	5.0196	101648652.0
2009-07-13 11:00:00	AAPL	Stock	5.02	5.0621	5.0111	5.0579	69763316.0
2009-07-13 12:00:00	AAPL	Stock	5.0579	5.0625	5.0411	5.0461	36969296.0
2009-07-13 13:00:00	AAPL	Stock	5.0467	5.0621	5.0407	5.0546	31410652.0
2009-07-13 14:00:00	AAPL	Stock	5.0543	5.0661	5.045	5.055	37777096.0
2009-07-13 15:00:00	AAPL	Stock	5.0543	5.0832	5.0518	5.0832	85910384.0
2009-07-13 16:00:00	AAPL	Stock	5.0832	5.0846	5.0182	5.0746	14745444.0
2009-07-13 17:00:00	AAPL	Stock	5.0761	5.0836	5.0732	5.0796	196476.0
2009-07-13 18:00:00	AAPL	Stock	5.0796	5.0836	5.075	5.0836	6107920.0
2009-07-13 19:00:00	AAPL	Stock	5.0821	5.0871	5.0757	5.0861	206164.0
2009-07-13 08:00:00	MSFT	Stock	22.45	22.5	22.4	22.4	9287.0
2009-07-13 09:00:00	MSFT	Stock	22.4	22.65	22.14	22.33	5159836.0
2009-07-13 10:00:00	MSFT	Stock	22.34	22.71	22.28	22.71	9309582.0
2009-07-13 11:00:00	MSFT	Stock	22.706	23.03	22.67	22.99	8962047.0
2009-07-13 12:00:00	MSFT	Stock	22.99	23.01	22.89	23.0	5583576.0
2009-07-13 13:00:00	MSFT	Stock	22.995	23.08	22.97	23.0	5186104.0
2009-07-13 14:00:00	MSFT	Stock	23.005	23.15	23.0	23.13	8946593.0
2009-07-13 15:00:00	MSFT	Stock	23.13	23.25	23.1	23.23	17551311.0
2009-07-13 16:00:00	MSFT	Stock	23.24	23.29	22.896	23.23	4806392.0
2009-07-13 17:00:00	MSFT	Stock	23.15	23.23	23.14	23.21	83270.0
2009-07-13 18:00:00	MSFT	Stock	23.15	23.23	23.15	23.16	805543.0
2009-07-13 19:00:00	MSFT	Stock	23.16	23.19	23.16	23.16	1100.0
2009-07-13 08:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	4000.0
2009-07-13 09:00:00	NVDA	Stock	0.2608	0.2645	0.2495	0.2515	108598560.0
2009-07-13 10:00:00	NVDA	Stock	0.2515	0.2583	0.2488	0.258	93247400.0
2009-07-13 11:00:00	NVDA	Stock	0.258	0.263	0.257	0.263	93232960.0
2009-07-13 12:00:00	NVDA	Stock	0.263	0.2635	0.2583	0.259	63490080.0
2009-07-13 13:00:00	NVDA	Stock	0.2592	0.2612	0.2582	0.2603	33231480.0
2009-07-13 14:00:00	NVDA	Stock	0.2603	0.2618	0.2598	0.2612	44714640.0
2009-07-13 15:00:00	NVDA	Stock	0.2612	0.2625	0.2607	0.2623	92242440.0
2009-07-13 16:00:00	NVDA	Stock	0.2628	0.2628	0.2488	0.2623	13467480.0
2009-07-13 17:00:00	NVDA	Stock	0.2623	0.2623	0.2615	0.2623	994520.0
2009-07-13 18:00:00	NVDA	Stock	0.2623	0.2628	0.2623	0.2628	3927760.0
2009-07-13 19:00:00	NVDA	Stock	0.262	0.2625	0.262	0.2625	60000.0
2009-07-13 08:00:00	AMZN	Stock	3.8895	3.92	3.8895	3.92	12660.0
2009-07-13 09:00:00	AMZN	Stock	3.9135	3.9685	3.9005	3.932	20888900.0
2009-07-13 10:00:00	AMZN	Stock	3.9312	4.0045	3.9195	4.002	28699760.0
2009-07-13 11:00:00	AMZN	Stock	4.003	4.0635	3.995	4.0425	27718940.0
2009-07-13 12:00:00	AMZN	Stock	4.042	4.06	4.0305	4.049	11880700.0
2009-07-13 13:00:00	AMZN	Stock	4.05	4.0825	4.046	4.0605	19648840.0
2009-07-13 14:00:00	AMZN	Stock	4.0605	4.0775	4.05	4.0585	14848640.0
2009-07-13 15:00:00	AMZN	Stock	4.0595	4.0805	4.059	4.0735	24784280.0
2009-07-13 16:00:00	AMZN	Stock	4.082	4.0825	3.9318	4.08	1602200.0
2009-07-13 17:00:00	AMZN	Stock	4.0815	4.0835	4.0735	4.0825	111580.0
2009-07-13 18:00:00	AMZN	Stock	4.0825	4.0845	4.0735	4.0735	1229700.0
2009-07-13 19:00:00	AMZN	Stock	4.0775	4.0845	4.074	4.074	20000.0
2009-07-13 08:00:00	TLT	Stock	95.89	96.02	95.72	96.0	6900.0

> showing 50 of 44,456 rows — these rows as CSV

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