PREVIEW / stock_1hour / 2007-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-18.parquet
  size:    765 KB
  rows:    37,651
  symbols: 3,046

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-18 09:00:00	AAPL	Stock	4.4029	4.4379	4.3764	4.4107	170521484.0
2007-06-18 10:00:00	AAPL	Stock	4.4107	4.4411	4.4011	4.4279	162855504.0
2007-06-18 11:00:00	AAPL	Stock	4.4279	4.43	4.4036	4.4232	94386908.0
2007-06-18 12:00:00	AAPL	Stock	4.4232	4.4375	4.4139	4.4357	56273896.0
2007-06-18 13:00:00	AAPL	Stock	4.4357	4.4489	4.425	4.429	91136248.0
2007-06-18 14:00:00	AAPL	Stock	4.4296	4.4371	4.4268	4.4357	63732200.0
2007-06-18 15:00:00	AAPL	Stock	4.4357	4.4707	4.4332	4.4661	205249968.0
2007-06-18 16:00:00	AAPL	Stock	4.4657	4.4675	4.465	4.4675	4078564.0
2007-06-18 09:00:00	MSFT	Stock	30.69	30.72	30.59	30.71	4082389.0
2007-06-18 10:00:00	MSFT	Stock	30.71	30.71	30.42	30.482	11451649.0
2007-06-18 11:00:00	MSFT	Stock	30.49	30.57	30.47	30.57	3206320.0
2007-06-18 12:00:00	MSFT	Stock	30.56	30.65	30.52	30.63	4124331.0
2007-06-18 13:00:00	MSFT	Stock	30.64	30.64	30.51	30.58	4964123.0
2007-06-18 14:00:00	MSFT	Stock	30.59	30.59	30.49	30.52	3160423.0
2007-06-18 15:00:00	MSFT	Stock	30.52	30.58	30.48	30.51	11257288.0
2007-06-18 16:00:00	MSFT	Stock	30.51	30.51	30.51	30.51	812705.0
2007-06-18 08:00:00	NVDA	Stock	0.669	0.6807	0.6675	0.6747	3157560.0
2007-06-18 09:00:00	NVDA	Stock	0.6742	0.6742	0.6567	0.6597	129631020.0
2007-06-18 10:00:00	NVDA	Stock	0.6597	0.6615	0.6542	0.66	125163720.0
2007-06-18 11:00:00	NVDA	Stock	0.66	0.6658	0.6572	0.6655	85930620.0
2007-06-18 12:00:00	NVDA	Stock	0.6655	0.6682	0.6567	0.6663	92235360.0
2007-06-18 13:00:00	NVDA	Stock	0.6663	0.6678	0.6618	0.6638	72807960.0
2007-06-18 14:00:00	NVDA	Stock	0.664	0.6642	0.6613	0.662	43889700.0
2007-06-18 15:00:00	NVDA	Stock	0.6622	0.6628	0.6593	0.6595	71026920.0
2007-06-18 16:00:00	NVDA	Stock	0.6595	0.6612	0.656	0.656	28661280.0
2007-06-18 17:00:00	NVDA	Stock	0.656	0.6568	0.655	0.6568	79980.0
2007-06-18 18:00:00	NVDA	Stock	0.6558	0.6558	0.655	0.6557	61860.0
2007-06-18 19:00:00	NVDA	Stock	0.6595	0.6595	0.6582	0.6582	151920.0
2007-06-18 08:00:00	AMZN	Stock	3.6225	3.624	3.6025	3.6225	142960.0
2007-06-18 09:00:00	AMZN	Stock	3.6155	3.632	3.6035	3.616	24931820.0
2007-06-18 10:00:00	AMZN	Stock	3.615	3.6165	3.589	3.606	30719680.0
2007-06-18 11:00:00	AMZN	Stock	3.606	3.606	3.584	3.596	19180180.0
2007-06-18 12:00:00	AMZN	Stock	3.596	3.6	3.58	3.592	14517800.0
2007-06-18 13:00:00	AMZN	Stock	3.592	3.5985	3.58	3.5855	12623580.0
2007-06-18 14:00:00	AMZN	Stock	3.586	3.598	3.57	3.5975	16638200.0
2007-06-18 15:00:00	AMZN	Stock	3.598	3.6125	3.5905	3.591	27828060.0
2007-06-18 16:00:00	AMZN	Stock	3.592	3.595	3.591	3.5925	773980.0
2007-06-18 17:00:00	AMZN	Stock	3.593	3.595	3.5925	3.595	50000.0
2007-06-18 18:00:00	AMZN	Stock	3.5908	3.5908	3.5908	3.5908	12780.0
2007-06-18 19:00:00	AMZN	Stock	3.5908	3.5925	3.5908	3.5925	39580.0
2007-06-18 09:00:00	TLT	Stock	83.63	83.65	83.38	83.44	1743000.0
2007-06-18 10:00:00	TLT	Stock	83.44	83.5	82.24	83.33	4813200.0
2007-06-18 11:00:00	TLT	Stock	83.34	83.44	83.23	83.4	1442700.0
2007-06-18 12:00:00	TLT	Stock	83.4	83.54	83.36	83.43	3075000.0
2007-06-18 13:00:00	TLT	Stock	83.43	83.56	83.36	83.45	437700.0
2007-06-18 14:00:00	TLT	Stock	83.44	83.59	83.43	83.52	2569400.0
2007-06-18 15:00:00	TLT	Stock	83.53	83.65	83.49	83.53	3603300.0
2007-06-18 16:00:00	TLT	Stock	83.48	83.52	83.48	83.52	1800.0
2007-06-18 09:00:00	CL	Stock	33.36	33.395	33.24	33.275	267976.0
2007-06-18 10:00:00	CL	Stock	33.275	33.28	33.165	33.18	518484.0

> showing 50 of 37,651 rows — these rows as CSV

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