PREVIEW / stock_1hour / 2007-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-12.parquet
  size:    778 KB
  rows:    38,544
  symbols: 3,140

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-12 05:00:00	AAPL	Stock	5.7857	5.7857	5.7857	5.7857	19600.0
2007-10-12 07:00:00	AAPL	Stock	5.7857	5.8357	5.7857	5.8161	620256.0
2007-10-12 08:00:00	AAPL	Stock	5.8146	5.8836	5.7929	5.8711	12317760.0
2007-10-12 09:00:00	AAPL	Stock	5.8714	5.8754	5.7786	5.8579	167810160.0
2007-10-12 10:00:00	AAPL	Stock	5.8586	5.9554	5.8414	5.9357	232135876.0
2007-10-12 11:00:00	AAPL	Stock	5.9357	5.9618	5.9164	5.9189	117006260.0
2007-10-12 12:00:00	AAPL	Stock	5.9196	5.9444	5.8946	5.9347	101369884.0
2007-10-12 13:00:00	AAPL	Stock	5.935	5.9361	5.885	5.9154	96830384.0
2007-10-12 14:00:00	AAPL	Stock	5.9157	5.9661	5.9129	5.9518	94462676.0
2007-10-12 15:00:00	AAPL	Stock	5.9518	5.9743	5.9168	5.9739	143620456.0
2007-10-12 16:00:00	AAPL	Stock	5.9721	5.9857	5.8252	5.9821	20211688.0
2007-10-12 17:00:00	AAPL	Stock	5.9804	5.9911	5.9804	5.9889	633164.0
2007-10-12 18:00:00	AAPL	Stock	5.9889	5.9986	5.9732	5.9982	771820.0
2007-10-12 19:00:00	AAPL	Stock	5.9982	6.0	5.9936	5.9964	414456.0
2007-10-12 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	200.0
2007-10-12 08:00:00	MSFT	Stock	29.71	30.02	29.71	30.0	21918.0
2007-10-12 09:00:00	MSFT	Stock	30.02	30.29	29.95	30.28	3381678.0
2007-10-12 10:00:00	MSFT	Stock	30.29	30.34	30.22	30.27	5024290.0
2007-10-12 11:00:00	MSFT	Stock	30.27	30.4	30.24	30.36	4064051.0
2007-10-12 12:00:00	MSFT	Stock	30.36	30.36	30.26	30.32	2665012.0
2007-10-12 13:00:00	MSFT	Stock	30.31	30.37	30.25	30.29	2864200.0
2007-10-12 14:00:00	MSFT	Stock	30.29	30.38	30.19	30.19	4270033.0
2007-10-12 15:00:00	MSFT	Stock	30.19	30.22	30.1	30.17	6449455.0
2007-10-12 16:00:00	MSFT	Stock	30.16	30.325	30.15	30.17	2352598.0
2007-10-12 17:00:00	MSFT	Stock	30.18	30.22	30.17	30.22	6700.0
2007-10-12 18:00:00	MSFT	Stock	30.22	30.22	30.17	30.19	23847.0
2007-10-12 19:00:00	MSFT	Stock	30.21	30.23	30.19	30.19	1718.0
2007-10-12 08:00:00	NVDA	Stock	0.8832	0.894	0.8832	0.8925	177720.0
2007-10-12 09:00:00	NVDA	Stock	0.89	0.8955	0.8812	0.887	50264960.0
2007-10-12 10:00:00	NVDA	Stock	0.8868	0.8895	0.8778	0.8838	104498680.0
2007-10-12 11:00:00	NVDA	Stock	0.8838	0.8908	0.8818	0.887	45501760.0
2007-10-12 12:00:00	NVDA	Stock	0.8875	0.8938	0.883	0.8935	36523640.0
2007-10-12 13:00:00	NVDA	Stock	0.8936	0.8945	0.888	0.8938	31917240.0
2007-10-12 14:00:00	NVDA	Stock	0.8938	0.9025	0.8932	0.9008	31281280.0
2007-10-12 15:00:00	NVDA	Stock	0.901	0.9033	0.8943	0.9033	74389080.0
2007-10-12 16:00:00	NVDA	Stock	0.9033	0.905	0.8818	0.9033	43301360.0
2007-10-12 17:00:00	NVDA	Stock	0.9033	0.905	0.9033	0.905	52680.0
2007-10-12 19:00:00	NVDA	Stock	0.905	0.905	0.905	0.905	42960.0
2007-10-12 07:00:00	AMZN	Stock	4.475	4.49	4.475	4.49	36000.0
2007-10-12 08:00:00	AMZN	Stock	4.475	4.5	4.475	4.5	527300.0
2007-10-12 09:00:00	AMZN	Stock	4.5	4.543	4.446	4.5339	23627980.0
2007-10-12 10:00:00	AMZN	Stock	4.534	4.593	4.51	4.5735	37963260.0
2007-10-12 11:00:00	AMZN	Stock	4.574	4.6195	4.572	4.589	31002500.0
2007-10-12 12:00:00	AMZN	Stock	4.5885	4.61	4.5685	4.6	16184260.0
2007-10-12 13:00:00	AMZN	Stock	4.6	4.602	4.5505	4.5795	16615280.0
2007-10-12 14:00:00	AMZN	Stock	4.5795	4.612	4.5795	4.5995	14640940.0
2007-10-12 15:00:00	AMZN	Stock	4.5985	4.619	4.558	4.6185	22761340.0
2007-10-12 16:00:00	AMZN	Stock	4.613	4.6265	4.5701	4.6185	1052700.0
2007-10-12 17:00:00	AMZN	Stock	4.6265	4.642	4.6265	4.642	9000.0
2007-10-12 18:00:00	AMZN	Stock	4.6375	4.6415	4.6375	4.64	23980.0

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

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