PREVIEW / stock_1hour / 2007-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-08.parquet
  size:    776 KB
  rows:    38,562
  symbols: 3,102

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-10-08 05:00:00	AAPL	Stock	5.8014	5.8014	5.7875	5.7875	81200.0
2007-10-08 07:00:00	AAPL	Stock	5.7796	5.8214	5.7782	5.8036	274400.0
2007-10-08 08:00:00	AAPL	Stock	5.8	5.8518	5.7661	5.8325	7000112.0
2007-10-08 09:00:00	AAPL	Stock	5.8314	5.8929	5.8143	5.868	181583220.0
2007-10-08 10:00:00	AAPL	Stock	5.8704	5.8857	5.8536	5.8549	120452052.0
2007-10-08 11:00:00	AAPL	Stock	5.8557	5.865	5.8421	5.8536	76106408.0
2007-10-08 12:00:00	AAPL	Stock	5.8536	5.8836	5.8486	5.8807	58145220.0
2007-10-08 13:00:00	AAPL	Stock	5.8811	5.9104	5.8725	5.8936	89426988.0
2007-10-08 14:00:00	AAPL	Stock	5.8929	5.9425	5.8893	5.9296	124934432.0
2007-10-08 15:00:00	AAPL	Stock	5.9296	5.9961	5.9161	5.9961	163990036.0
2007-10-08 16:00:00	AAPL	Stock	5.9964	5.9996	5.8703	5.9871	11591048.0
2007-10-08 17:00:00	AAPL	Stock	5.9857	5.9968	5.9682	5.9893	1050504.0
2007-10-08 18:00:00	AAPL	Stock	5.9825	5.9968	5.9821	5.9821	1004472.0
2007-10-08 19:00:00	AAPL	Stock	5.9821	5.9982	5.9821	5.9957	291816.0
2007-10-08 07:00:00	MSFT	Stock	29.66	29.8	29.66	29.8	3300.0
2007-10-08 08:00:00	MSFT	Stock	29.8	29.84	29.67	29.71	21550.0
2007-10-08 09:00:00	MSFT	Stock	29.77	29.84	29.61	29.73	3763970.0
2007-10-08 10:00:00	MSFT	Stock	29.73	29.85	29.7	29.85	4113211.0
2007-10-08 11:00:00	MSFT	Stock	29.84	29.85	29.78	29.82	4140208.0
2007-10-08 12:00:00	MSFT	Stock	29.82	29.83	29.67	29.68	2269729.0
2007-10-08 13:00:00	MSFT	Stock	29.68	29.69	29.6	29.64	3051904.0
2007-10-08 14:00:00	MSFT	Stock	29.64	29.78	29.61	29.695	4736935.0
2007-10-08 15:00:00	MSFT	Stock	29.695	29.84	29.68	29.84	6615805.0
2007-10-08 16:00:00	MSFT	Stock	29.83	29.9	29.731	29.87	1554254.0
2007-10-08 17:00:00	MSFT	Stock	29.84	29.84	29.8	29.84	3194.0
2007-10-08 18:00:00	MSFT	Stock	29.8	29.87	29.8	29.87	965.0
2007-10-08 08:00:00	NVDA	Stock	0.9275	0.9373	0.9232	0.936	425440.0
2007-10-08 09:00:00	NVDA	Stock	0.935	0.9388	0.9188	0.9373	37892880.0
2007-10-08 10:00:00	NVDA	Stock	0.9373	0.9374	0.93	0.9332	37466120.0
2007-10-08 11:00:00	NVDA	Stock	0.933	0.9368	0.9298	0.9363	30688920.0
2007-10-08 12:00:00	NVDA	Stock	0.9363	0.938	0.932	0.936	24520840.0
2007-10-08 13:00:00	NVDA	Stock	0.936	0.9363	0.9295	0.93	31171440.0
2007-10-08 14:00:00	NVDA	Stock	0.93	0.9373	0.929	0.9352	29218560.0
2007-10-08 15:00:00	NVDA	Stock	0.9352	0.9398	0.935	0.9382	49412960.0
2007-10-08 16:00:00	NVDA	Stock	0.9375	0.9408	0.9335	0.9352	7950120.0
2007-10-08 17:00:00	NVDA	Stock	0.9382	0.9408	0.9365	0.9368	64320.0
2007-10-08 07:00:00	AMZN	Stock	4.685	4.705	4.685	4.705	59800.0
2007-10-08 08:00:00	AMZN	Stock	4.7	4.7365	4.7	4.725	1736900.0
2007-10-08 09:00:00	AMZN	Stock	4.725	4.763	4.7	4.745	30351600.0
2007-10-08 10:00:00	AMZN	Stock	4.745	4.784	4.7285	4.744	34220020.0
2007-10-08 11:00:00	AMZN	Stock	4.744	4.7605	4.7045	4.7475	17531000.0
2007-10-08 12:00:00	AMZN	Stock	4.749	4.7625	4.7415	4.749	9073120.0
2007-10-08 13:00:00	AMZN	Stock	4.749	4.764	4.74	4.7455	11342280.0
2007-10-08 14:00:00	AMZN	Stock	4.7455	4.7735	4.737	4.7595	14449560.0
2007-10-08 15:00:00	AMZN	Stock	4.7605	4.7925	4.749	4.7925	27305600.0
2007-10-08 16:00:00	AMZN	Stock	4.792	4.795	4.7519	4.7915	724740.0
2007-10-08 17:00:00	AMZN	Stock	4.7875	4.7995	4.7865	4.7975	286400.0
2007-10-08 18:00:00	AMZN	Stock	4.797	4.799	4.794	4.7975	33020.0
2007-10-08 19:00:00	AMZN	Stock	4.7995	4.835	4.7995	4.83	60400.0
2007-10-08 09:00:00	TLT	Stock	87.77	88.5	87.77	88.18	45800.0

> showing 50 of 38,562 rows — these rows as CSV

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