PREVIEW / stock_1hour / 2007-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-08.parquet
  size:    714 KB
  rows:    34,343
  symbols: 2,728

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-05-08 09:00:00	AAPL	Stock	3.6954	3.7421	3.6936	3.7229	168683172.0
2007-05-08 10:00:00	AAPL	Stock	3.7221	3.7371	3.5846	3.7057	180712168.0
2007-05-08 11:00:00	AAPL	Stock	3.7064	3.7196	3.695	3.7132	70597184.0
2007-05-08 12:00:00	AAPL	Stock	3.7132	3.7236	3.7082	3.7211	40451124.0
2007-05-08 13:00:00	AAPL	Stock	3.7207	3.7339	3.5889	3.7274	55955480.0
2007-05-08 14:00:00	AAPL	Stock	3.7271	3.7504	3.7236	3.7439	111506948.0
2007-05-08 15:00:00	AAPL	Stock	3.7443	3.7554	3.7343	3.7536	120778252.0
2007-05-08 16:00:00	AAPL	Stock	3.7536	3.7536	3.7521	3.7521	3336228.0
2007-05-08 09:00:00	MSFT	Stock	30.68	30.71	30.58	30.67	6245440.0
2007-05-08 10:00:00	MSFT	Stock	30.662	30.75	30.65	30.69	7594271.0
2007-05-08 11:00:00	MSFT	Stock	30.7	30.82	30.65	30.79	5286143.0
2007-05-08 12:00:00	MSFT	Stock	30.79	30.94	30.79	30.84	5836651.0
2007-05-08 13:00:00	MSFT	Stock	30.84	30.94	30.83	30.855	5013240.0
2007-05-08 14:00:00	MSFT	Stock	30.86	30.92	30.76	30.762	5498073.0
2007-05-08 15:00:00	MSFT	Stock	30.77	30.81	30.71	30.75	6733760.0
2007-05-08 16:00:00	MSFT	Stock	30.75	30.76	30.75	30.75	854090.0
2007-05-08 08:00:00	NVDA	Stock	0.5533	0.5533	0.55	0.55	246000.0
2007-05-08 09:00:00	NVDA	Stock	0.5492	0.5492	0.5367	0.543	98245500.0
2007-05-08 10:00:00	NVDA	Stock	0.543	0.5537	0.5417	0.5532	126505080.0
2007-05-08 11:00:00	NVDA	Stock	0.5532	0.5548	0.5495	0.5517	119422080.0
2007-05-08 12:00:00	NVDA	Stock	0.5517	0.5548	0.5507	0.5545	57183840.0
2007-05-08 13:00:00	NVDA	Stock	0.5545	0.5562	0.5523	0.5537	58410060.0
2007-05-08 14:00:00	NVDA	Stock	0.5538	0.555	0.5485	0.5502	73323840.0
2007-05-08 15:00:00	NVDA	Stock	0.5502	0.5548	0.548	0.5548	173570220.0
2007-05-08 16:00:00	NVDA	Stock	0.5548	0.5562	0.5375	0.5462	11178720.0
2007-05-08 17:00:00	NVDA	Stock	0.5462	0.5467	0.5462	0.5465	71280.0
2007-05-08 18:00:00	NVDA	Stock	0.5483	0.5483	0.5475	0.5475	24000.0
2007-05-08 05:00:00	AMZN	Stock	3.02	3.02	3.02	3.02	2000.0
2007-05-08 07:00:00	AMZN	Stock	3.0305	3.0305	3.0255	3.0255	109580.0
2007-05-08 08:00:00	AMZN	Stock	3.0255	3.0465	3.011	3.025	632740.0
2007-05-08 09:00:00	AMZN	Stock	3.0265	3.0625	2.985	3.0085	58385020.0
2007-05-08 10:00:00	AMZN	Stock	3.0085	3.0525	3.0	3.0465	62080320.0
2007-05-08 11:00:00	AMZN	Stock	3.0465	3.0615	3.0285	3.0525	32598140.0
2007-05-08 12:00:00	AMZN	Stock	3.0525	3.0775	3.0475	3.068	27129040.0
2007-05-08 13:00:00	AMZN	Stock	3.067	3.0785	3.0615	3.0725	19001720.0
2007-05-08 14:00:00	AMZN	Stock	3.0725	3.0795	3.068	3.0695	20355520.0
2007-05-08 15:00:00	AMZN	Stock	3.07	3.092	3.062	3.091	37742720.0
2007-05-08 16:00:00	AMZN	Stock	3.091	3.095	3.0815	3.082	5201520.0
2007-05-08 17:00:00	AMZN	Stock	3.082	3.0915	3.08	3.0825	922000.0
2007-05-08 18:00:00	AMZN	Stock	3.0855	3.0855	3.0825	3.085	94000.0
2007-05-08 19:00:00	AMZN	Stock	3.085	3.085	3.0815	3.0845	77280.0
2007-05-08 09:00:00	TLT	Stock	89.01	89.01	88.92	88.94	81300.0
2007-05-08 10:00:00	TLT	Stock	88.94	88.97	88.82	88.82	37700.0
2007-05-08 11:00:00	TLT	Stock	88.82	88.87	88.8	88.81	91000.0
2007-05-08 12:00:00	TLT	Stock	88.82	88.86	88.82	88.86	23400.0
2007-05-08 13:00:00	TLT	Stock	88.82	88.82	88.67	88.68	54200.0
2007-05-08 14:00:00	TLT	Stock	88.68	88.73	88.67	88.7	84962.0
2007-05-08 15:00:00	TLT	Stock	88.69	88.72	88.67	88.68	113560.0
2007-05-08 16:00:00	TLT	Stock	88.64	88.64	88.64	88.64	500.0
2007-05-08 09:00:00	CL	Stock	33.71	33.745	33.58	33.745	981200.0

> showing 50 of 34,343 rows — these rows as CSV

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