PREVIEW / stock_1hour / 2007-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-03.parquet
  size:    697 KB
  rows:    32,597
  symbols: 2,509

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-01-03 04:00:00	AAPL	Stock	3.0832	3.0832	3.0718	3.0718	120400.0
2007-01-03 06:00:00	AAPL	Stock	3.0804	3.0804	3.0714	3.0729	144480.0
2007-01-03 07:00:00	AAPL	Stock	3.0786	3.0821	3.0686	3.0771	1283240.0
2007-01-03 08:00:00	AAPL	Stock	3.0786	3.0911	3.0679	3.0886	8941128.0
2007-01-03 09:00:00	AAPL	Stock	3.0889	3.0943	3.03	3.0678	210604268.0
2007-01-03 10:00:00	AAPL	Stock	3.0674	3.0857	3.0529	3.0711	193439204.0
2007-01-03 11:00:00	AAPL	Stock	3.0711	3.0776	3.0418	3.0643	151495680.0
2007-01-03 12:00:00	AAPL	Stock	3.0636	3.0675	3.0496	3.06	67638172.0
2007-01-03 13:00:00	AAPL	Stock	3.06	3.0639	3.015	3.0232	111281800.0
2007-01-03 14:00:00	AAPL	Stock	3.0229	3.0261	2.925	2.9411	258038172.0
2007-01-03 15:00:00	AAPL	Stock	2.9418	2.9979	2.9379	2.9929	205282840.0
2007-01-03 16:00:00	AAPL	Stock	2.9925	2.9968	2.9893	2.9918	8671376.0
2007-01-03 17:00:00	AAPL	Stock	2.9918	2.9929	2.9893	2.9911	530236.0
2007-01-03 18:00:00	AAPL	Stock	2.9918	2.9929	2.9286	2.9911	399252.0
2007-01-03 19:00:00	AAPL	Stock	2.9921	3.0	2.99	3.0	322336.0
2007-01-03 05:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	200.0
2007-01-03 07:00:00	MSFT	Stock	29.93	29.93	29.8	29.8	200.0
2007-01-03 08:00:00	MSFT	Stock	29.87	29.99	29.86	29.97	251591.0
2007-01-03 09:00:00	MSFT	Stock	29.98	30.01	29.85	29.85	9882906.0
2007-01-03 10:00:00	MSFT	Stock	29.84	30.05	29.83	29.95	14840394.0
2007-01-03 11:00:00	MSFT	Stock	29.95	30.13	29.93	30.08	7656717.0
2007-01-03 12:00:00	MSFT	Stock	30.085	30.25	29.88	30.18	6042246.0
2007-01-03 13:00:00	MSFT	Stock	30.19	30.21	30.1	30.16	6586635.0
2007-01-03 14:00:00	MSFT	Stock	30.16	30.2	29.4	29.49	14821209.0
2007-01-03 15:00:00	MSFT	Stock	29.49	29.88	29.48	29.88	11574563.0
2007-01-03 16:00:00	MSFT	Stock	29.88	29.89	29.81	29.86	261578.0
2007-01-03 17:00:00	MSFT	Stock	29.82	29.86	29.75	29.75	62985.0
2007-01-03 18:00:00	MSFT	Stock	29.8	29.85	29.477	29.81	5400.0
2007-01-03 19:00:00	MSFT	Stock	29.8	29.8	29.8	29.8	1162.0
2007-01-03 07:00:00	NVDA	Stock	0.6182	0.6182	0.6182	0.6182	24000.0
2007-01-03 08:00:00	NVDA	Stock	0.6182	0.6247	0.6168	0.6247	4922640.0
2007-01-03 09:00:00	NVDA	Stock	0.6245	0.6248	0.6142	0.619	66757020.0
2007-01-03 10:00:00	NVDA	Stock	0.6192	0.625	0.6188	0.6238	114417900.0
2007-01-03 11:00:00	NVDA	Stock	0.6238	0.6253	0.6215	0.6225	76857780.0
2007-01-03 12:00:00	NVDA	Stock	0.6225	0.6232	0.611	0.6123	170646900.0
2007-01-03 13:00:00	NVDA	Stock	0.6125	0.6127	0.5942	0.597	193233540.0
2007-01-03 14:00:00	NVDA	Stock	0.597	0.5983	0.5798	0.5822	249364680.0
2007-01-03 15:00:00	NVDA	Stock	0.5823	0.6028	0.5813	0.6013	226519680.0
2007-01-03 16:00:00	NVDA	Stock	0.601	0.6025	0.6002	0.6002	1219260.0
2007-01-03 17:00:00	NVDA	Stock	0.6013	0.6013	0.6013	0.6013	114000.0
2007-01-03 18:00:00	NVDA	Stock	0.6017	0.6023	0.5802	0.6023	117900.0
2007-01-03 19:00:00	NVDA	Stock	0.6023	0.6023	0.6023	0.6023	31500.0
2007-01-03 04:00:00	AMZN	Stock	1.965	1.965	1.938	1.938	24000.0
2007-01-03 07:00:00	AMZN	Stock	1.95	1.95	1.9425	1.9485	230000.0
2007-01-03 08:00:00	AMZN	Stock	1.954	1.973	1.945	1.95	2338700.0
2007-01-03 09:00:00	AMZN	Stock	1.9475	1.973	1.9195	1.9195	36265960.0
2007-01-03 10:00:00	AMZN	Stock	1.925	1.934	1.9025	1.932	51893080.0
2007-01-03 11:00:00	AMZN	Stock	1.9315	1.953	1.93	1.9425	40726460.0
2007-01-03 12:00:00	AMZN	Stock	1.9425	1.946	1.9325	1.944	15611740.0
2007-01-03 13:00:00	AMZN	Stock	1.945	1.9515	1.9345	1.9365	18332000.0

> showing 50 of 32,597 rows — these rows as CSV

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