PREVIEW / stock_1hour / 2007-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-06.parquet
  size:    764 KB
  rows:    37,426
  symbols: 3,002

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-06 09:00:00	AAPL	Stock	4.3679	4.4071	4.3554	4.3882	173147912.0
2007-06-06 10:00:00	AAPL	Stock	4.3882	4.3882	4.3593	4.3771	227155656.0
2007-06-06 11:00:00	AAPL	Stock	4.3773	4.4121	4.3732	4.3964	167583668.0
2007-06-06 12:00:00	AAPL	Stock	4.3964	4.4107	4.39	4.3936	92075256.0
2007-06-06 13:00:00	AAPL	Stock	4.3936	4.3996	4.3789	4.3975	116341176.0
2007-06-06 14:00:00	AAPL	Stock	4.3975	4.4182	4.3957	4.4121	115849328.0
2007-06-06 15:00:00	AAPL	Stock	4.4118	4.4304	4.4	4.4157	181634432.0
2007-06-06 16:00:00	AAPL	Stock	4.4154	4.4157	4.4154	4.4157	5565028.0
2007-06-06 09:00:00	MSFT	Stock	30.37	30.5	30.25	30.48	5382812.0
2007-06-06 10:00:00	MSFT	Stock	30.49	30.53	30.34	30.37	4632697.0
2007-06-06 11:00:00	MSFT	Stock	30.375	30.411	30.29	30.3	3818594.0
2007-06-06 12:00:00	MSFT	Stock	30.3	30.39	30.28	30.3	3161961.0
2007-06-06 13:00:00	MSFT	Stock	30.302	30.39	30.28	30.39	3541024.0
2007-06-06 14:00:00	MSFT	Stock	30.39	30.43	30.31	30.402	4390100.0
2007-06-06 15:00:00	MSFT	Stock	30.41	30.46	30.29	30.29	8067781.0
2007-06-06 16:00:00	MSFT	Stock	30.3	30.3	30.29	30.29	1158208.0
2007-06-06 09:00:00	NVDA	Stock	0.5992	0.6048	0.5952	0.601	93445920.0
2007-06-06 10:00:00	NVDA	Stock	0.601	0.616	0.5973	0.6115	266213040.0
2007-06-06 11:00:00	NVDA	Stock	0.6115	0.6152	0.609	0.6098	114352800.0
2007-06-06 12:00:00	NVDA	Stock	0.6098	0.6112	0.6062	0.6063	78771180.0
2007-06-06 13:00:00	NVDA	Stock	0.6062	0.6082	0.6052	0.6065	82086240.0
2007-06-06 14:00:00	NVDA	Stock	0.6067	0.6077	0.606	0.6067	74239620.0
2007-06-06 15:00:00	NVDA	Stock	0.6067	0.6108	0.606	0.6063	166180020.0
2007-06-06 16:00:00	NVDA	Stock	0.6072	0.6077	0.606	0.6062	1313520.0
2007-06-06 17:00:00	NVDA	Stock	0.6075	0.609	0.6057	0.6058	233820.0
2007-06-06 18:00:00	NVDA	Stock	0.6082	0.6082	0.6057	0.6057	132000.0
2007-06-06 05:00:00	AMZN	Stock	3.653	3.653	3.653	3.653	2000.0
2007-06-06 07:00:00	AMZN	Stock	3.647	3.647	3.647	3.647	2000.0
2007-06-06 08:00:00	AMZN	Stock	3.6525	3.6585	3.6455	3.65	722100.0
2007-06-06 09:00:00	AMZN	Stock	3.65	3.6875	3.641	3.656	61682560.0
2007-06-06 10:00:00	AMZN	Stock	3.6555	3.6565	3.593	3.6195	92151100.0
2007-06-06 11:00:00	AMZN	Stock	3.619	3.645	3.612	3.6175	37596000.0
2007-06-06 12:00:00	AMZN	Stock	3.6175	3.6325	3.6115	3.625	26047660.0
2007-06-06 13:00:00	AMZN	Stock	3.6265	3.633	3.601	3.613	27618180.0
2007-06-06 14:00:00	AMZN	Stock	3.613	3.619	3.6015	3.6155	18752200.0
2007-06-06 15:00:00	AMZN	Stock	3.6155	3.6375	3.6045	3.6145	39195060.0
2007-06-06 16:00:00	AMZN	Stock	3.615	3.6165	3.605	3.6075	6062140.0
2007-06-06 17:00:00	AMZN	Stock	3.607	3.6075	3.605	3.6075	56780.0
2007-06-06 18:00:00	AMZN	Stock	3.6075	3.6285	3.5975	3.622	2437080.0
2007-06-06 19:00:00	AMZN	Stock	3.627	3.6345	3.62	3.62	126500.0
2007-06-06 09:00:00	TLT	Stock	85.36	85.49	85.34	85.35	160700.0
2007-06-06 10:00:00	TLT	Stock	85.35	85.5	85.35	85.48	105500.0
2007-06-06 11:00:00	TLT	Stock	85.5	85.54	85.38	85.4	312000.0
2007-06-06 12:00:00	TLT	Stock	85.37	85.37	85.26	85.3	61747.0
2007-06-06 13:00:00	TLT	Stock	85.31	85.34	85.26	85.29	94400.0
2007-06-06 14:00:00	TLT	Stock	85.29	85.36	85.27	85.34	219605.0
2007-06-06 15:00:00	TLT	Stock	85.35	85.39	85.28	85.39	123900.0
2007-06-06 16:00:00	TLT	Stock	85.39	85.4	85.39	85.4	700.0
2007-06-06 08:00:00	CL	Stock	33.435	33.435	33.435	33.435	200.0
2007-06-06 09:00:00	CL	Stock	33.3	33.38	33.25	33.37	247600.0

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

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