PREVIEW / stock_1hour / 2007-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-08.parquet
  size:    750 KB
  rows:    36,609
  symbols: 3,026

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
2007-06-08 09:00:00	AAPL	Stock	4.4937	4.4939	4.4007	4.4418	231923300.0
2007-06-08 10:00:00	AAPL	Stock	4.4418	4.46	4.4132	4.4182	229421304.0
2007-06-08 11:00:00	AAPL	Stock	4.4182	4.4193	4.3675	4.4096	235592420.0
2007-06-08 12:00:00	AAPL	Stock	4.4093	4.41	4.3846	4.3925	72540048.0
2007-06-08 13:00:00	AAPL	Stock	4.3921	4.4429	4.3839	4.4289	127001336.0
2007-06-08 14:00:00	AAPL	Stock	4.4291	4.4529	4.4168	4.4243	121455852.0
2007-06-08 15:00:00	AAPL	Stock	4.4246	4.45	4.4214	4.445	162973524.0
2007-06-08 16:00:00	AAPL	Stock	4.4454	4.4461	4.445	4.4461	12630884.0
2007-06-08 09:00:00	MSFT	Stock	29.58	29.671	29.45	29.56	7914568.0
2007-06-08 10:00:00	MSFT	Stock	29.56	29.9	29.52	29.82	10567957.0
2007-06-08 11:00:00	MSFT	Stock	29.82	29.85	29.69	29.74	5424698.0
2007-06-08 12:00:00	MSFT	Stock	29.74	29.82	29.65	29.8	3875649.0
2007-06-08 13:00:00	MSFT	Stock	29.8	29.93	29.75	29.9	4635680.0
2007-06-08 14:00:00	MSFT	Stock	29.91	30.02	29.9	30.0	5561361.0
2007-06-08 15:00:00	MSFT	Stock	30.01	30.06	29.41	30.04	15858699.0
2007-06-08 16:00:00	MSFT	Stock	30.05	30.05	30.03	30.05	2905662.0
2007-06-08 08:00:00	NVDA	Stock	0.5975	0.5975	0.5973	0.5973	18000.0
2007-06-08 09:00:00	NVDA	Stock	0.5985	0.5998	0.5875	0.5985	57081000.0
2007-06-08 10:00:00	NVDA	Stock	0.5987	0.6003	0.5958	0.5968	67717440.0
2007-06-08 11:00:00	NVDA	Stock	0.597	0.5972	0.5908	0.5932	74472000.0
2007-06-08 12:00:00	NVDA	Stock	0.5932	0.5967	0.5918	0.5962	40227900.0
2007-06-08 13:00:00	NVDA	Stock	0.5963	0.606	0.5938	0.6033	85835940.0
2007-06-08 14:00:00	NVDA	Stock	0.6032	0.607	0.6028	0.6055	68436840.0
2007-06-08 15:00:00	NVDA	Stock	0.6053	0.61	0.605	0.6092	124450560.0
2007-06-08 16:00:00	NVDA	Stock	0.6092	0.6093	0.6088	0.6088	489720.0
2007-06-08 17:00:00	NVDA	Stock	0.6092	0.6092	0.6092	0.6092	72000.0
2007-06-08 18:00:00	NVDA	Stock	0.609	0.609	0.609	0.609	60000.0
2007-06-08 05:00:00	AMZN	Stock	3.5955	3.5955	3.5955	3.5955	3000.0
2007-06-08 07:00:00	AMZN	Stock	3.6095	3.61	3.605	3.61	31280.0
2007-06-08 08:00:00	AMZN	Stock	3.61	3.6295	3.605	3.623	661660.0
2007-06-08 09:00:00	AMZN	Stock	3.625	3.6375	3.5525	3.6035	45974260.0
2007-06-08 10:00:00	AMZN	Stock	3.605	3.6235	3.57	3.5895	42012620.0
2007-06-08 11:00:00	AMZN	Stock	3.5905	3.6175	3.5775	3.606	25089120.0
2007-06-08 12:00:00	AMZN	Stock	3.606	3.61	3.58	3.5975	12469360.0
2007-06-08 13:00:00	AMZN	Stock	3.598	3.631	3.5815	3.6155	16635060.0
2007-06-08 14:00:00	AMZN	Stock	3.616	3.64	3.6145	3.6325	18125660.0
2007-06-08 15:00:00	AMZN	Stock	3.634	3.662	3.6285	3.662	37232140.0
2007-06-08 16:00:00	AMZN	Stock	3.66	3.667	3.656	3.667	2200500.0
2007-06-08 17:00:00	AMZN	Stock	3.667	3.6695	3.661	3.665	85740.0
2007-06-08 18:00:00	AMZN	Stock	3.665	3.665	3.6645	3.6645	12000.0
2007-06-08 19:00:00	AMZN	Stock	3.6645	3.6645	3.6605	3.6605	18000.0
2007-06-08 09:00:00	TLT	Stock	83.61	84.12	83.39	83.84	980000.0
2007-06-08 10:00:00	TLT	Stock	83.85	83.99	83.62	83.63	542224.0
2007-06-08 11:00:00	TLT	Stock	83.62	83.62	83.36	83.46	706150.0
2007-06-08 12:00:00	TLT	Stock	83.46	83.6	83.39	83.52	735700.0
2007-06-08 13:00:00	TLT	Stock	83.52	83.59	83.5	83.56	645200.0
2007-06-08 14:00:00	TLT	Stock	83.58	83.92	83.58	83.86	542300.0
2007-06-08 15:00:00	TLT	Stock	83.87	83.95	83.84	83.92	536025.0
2007-06-08 16:00:00	TLT	Stock	83.94	83.99	83.8	83.8	9600.0
2007-06-08 09:00:00	CL	Stock	33.11	33.155	33.005	33.07	461800.0

> showing 50 of 36,609 rows — these rows as CSV

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