PREVIEW / stock_1hour / 2008-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-09.parquet
  size:    846 KB
  rows:    40,442
  symbols: 3,326

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
2008-06-09 06:00:00	AAPL	Stock	6.6782	6.6786	6.6482	6.6482	110068.0
2008-06-09 07:00:00	AAPL	Stock	6.6432	6.6554	6.6339	6.6425	684740.0
2008-06-09 08:00:00	AAPL	Stock	6.65	6.6904	6.5304	6.6011	15717212.0
2008-06-09 09:00:00	AAPL	Stock	6.6014	6.6071	6.4289	6.4964	203639212.0
2008-06-09 10:00:00	AAPL	Stock	6.4954	6.5736	6.4782	6.4944	167085156.0
2008-06-09 11:00:00	AAPL	Stock	6.4932	6.5675	6.4664	6.5304	99507212.0
2008-06-09 12:00:00	AAPL	Stock	6.5293	6.5629	6.5011	6.5568	77813988.0
2008-06-09 13:00:00	AAPL	Stock	6.5568	6.5643	6.2768	6.3704	317536492.0
2008-06-09 14:00:00	AAPL	Stock	6.3704	6.5821	6.3214	6.3711	557628848.0
2008-06-09 15:00:00	AAPL	Stock	6.3707	6.5018	6.3021	6.4886	386356180.0
2008-06-09 16:00:00	AAPL	Stock	6.4886	6.55	6.4341	6.5329	18669140.0
2008-06-09 17:00:00	AAPL	Stock	6.5304	6.5321	6.5068	6.5096	3615724.0
2008-06-09 18:00:00	AAPL	Stock	6.5107	6.5179	6.5	6.5089	529788.0
2008-06-09 19:00:00	AAPL	Stock	6.5104	6.5107	6.5	6.5029	436548.0
2008-06-09 04:00:00	MSFT	Stock	27.73	27.73	27.63	27.63	300.0
2008-06-09 08:00:00	MSFT	Stock	27.54	27.7	27.54	27.66	21236.0
2008-06-09 09:00:00	MSFT	Stock	27.68	27.71	27.41	27.45	6864050.0
2008-06-09 10:00:00	MSFT	Stock	27.45	27.62	27.41	27.43	7649283.0
2008-06-09 11:00:00	MSFT	Stock	27.43	27.53	27.4	27.4	3982098.0
2008-06-09 12:00:00	MSFT	Stock	27.41	27.54	27.33	27.5	3763064.0
2008-06-09 13:00:00	MSFT	Stock	27.51	27.51	27.32	27.428	8853885.0
2008-06-09 14:00:00	MSFT	Stock	27.43	27.63	27.3	27.508	11102689.0
2008-06-09 15:00:00	MSFT	Stock	27.51	27.91	27.34	27.75	18271786.0
2008-06-09 16:00:00	MSFT	Stock	27.73	27.8	27.45	27.76	4580560.0
2008-06-09 17:00:00	MSFT	Stock	27.76	27.76	27.72	27.72	7094.0
2008-06-09 18:00:00	MSFT	Stock	27.72	27.74	27.71	27.73	1387.0
2008-06-09 19:00:00	MSFT	Stock	27.71	27.71	27.65	27.67	11613.0
2008-06-09 08:00:00	NVDA	Stock	0.6063	0.6073	0.6058	0.6058	478360.0
2008-06-09 09:00:00	NVDA	Stock	0.6055	0.6063	0.5872	0.5978	64733600.0
2008-06-09 10:00:00	NVDA	Stock	0.5975	0.6025	0.5878	0.5883	110574880.0
2008-06-09 11:00:00	NVDA	Stock	0.5883	0.5943	0.5868	0.5933	53517760.0
2008-06-09 12:00:00	NVDA	Stock	0.5934	0.5935	0.5895	0.592	30587520.0
2008-06-09 13:00:00	NVDA	Stock	0.5918	0.592	0.5838	0.5855	76273000.0
2008-06-09 14:00:00	NVDA	Stock	0.5853	0.591	0.5802	0.5863	132555160.0
2008-06-09 15:00:00	NVDA	Stock	0.5863	0.5955	0.5843	0.595	143693280.0
2008-06-09 16:00:00	NVDA	Stock	0.5945	0.595	0.5884	0.5923	21479360.0
2008-06-09 17:00:00	NVDA	Stock	0.5923	0.5923	0.5923	0.5923	84840.0
2008-06-09 09:00:00	AMZN	Stock	4.055	4.0765	4.0005	4.0505	14224600.0
2008-06-09 10:00:00	AMZN	Stock	4.0505	4.0735	4.004	4.011	17228200.0
2008-06-09 11:00:00	AMZN	Stock	4.0115	4.0358	4.006	4.035	10053140.0
2008-06-09 12:00:00	AMZN	Stock	4.0345	4.035	4.0	4.008	6509320.0
2008-06-09 13:00:00	AMZN	Stock	4.0072	4.0072	3.936	3.9375	19023620.0
2008-06-09 14:00:00	AMZN	Stock	3.937	3.9615	3.914	3.921	22322200.0
2008-06-09 15:00:00	AMZN	Stock	3.923	3.982	3.906	3.9725	23597660.0
2008-06-09 16:00:00	AMZN	Stock	3.975	3.985	3.9715	3.9715	12012820.0
2008-06-09 19:00:00	AMZN	Stock	3.977	3.977	3.977	3.977	8260.0
2008-06-09 09:00:00	TLT	Stock	90.67	90.72	90.3	90.57	193154.0
2008-06-09 10:00:00	TLT	Stock	90.56	90.63	90.26	90.49	470033.0
2008-06-09 11:00:00	TLT	Stock	90.47	90.47	90.19	90.43	122059.0
2008-06-09 12:00:00	TLT	Stock	90.43	90.56	90.25	90.55	94282.0

> showing 50 of 40,442 rows — these rows as CSV

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