PREVIEW / stock_1hour / 2006-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-31.parquet
  size:    619 KB
  rows:    29,271
  symbols: 2,226

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
2006-03-31 04:00:00	AAPL	Stock	2.2464	2.2464	2.2464	2.2464	8400.0
2006-03-31 06:00:00	AAPL	Stock	2.2411	2.2411	2.2411	2.2411	5600.0
2006-03-31 07:00:00	AAPL	Stock	2.2446	2.2571	2.2411	2.2571	53200.0
2006-03-31 08:00:00	AAPL	Stock	2.2507	2.2564	2.2443	2.25	2309384.0
2006-03-31 09:00:00	AAPL	Stock	2.2493	2.2718	2.2393	2.2504	151742108.0
2006-03-31 10:00:00	AAPL	Stock	2.2504	2.2586	2.2229	2.235	167412756.0
2006-03-31 11:00:00	AAPL	Stock	2.2346	2.2584	2.2304	2.255	121552900.0
2006-03-31 12:00:00	AAPL	Stock	2.255	2.2714	2.2418	2.2446	81762856.0
2006-03-31 13:00:00	AAPL	Stock	2.2446	2.25	2.2346	2.2414	56059220.0
2006-03-31 14:00:00	AAPL	Stock	2.2411	2.2582	2.2411	2.2546	84643076.0
2006-03-31 15:00:00	AAPL	Stock	2.2539	2.2593	2.24	2.2436	116948636.0
2006-03-31 16:00:00	AAPL	Stock	2.2418	2.2454	2.2361	2.2446	9277212.0
2006-03-31 17:00:00	AAPL	Stock	2.2446	2.2461	2.24	2.2432	613928.0
2006-03-31 18:00:00	AAPL	Stock	2.2429	2.2443	2.2418	2.2425	160160.0
2006-03-31 07:00:00	MSFT	Stock	27.14	27.22	27.14	27.17	3720.0
2006-03-31 08:00:00	MSFT	Stock	27.22	27.22	27.17	27.2	5020030.0
2006-03-31 09:00:00	MSFT	Stock	27.2	27.541	27.2	27.46	6796327.0
2006-03-31 10:00:00	MSFT	Stock	27.46	27.53	27.4	27.45	5427478.0
2006-03-31 11:00:00	MSFT	Stock	27.45	27.45	27.35	27.39	5139493.0
2006-03-31 12:00:00	MSFT	Stock	27.4	27.49	27.378	27.46	6043864.0
2006-03-31 13:00:00	MSFT	Stock	27.462	27.47	27.29	27.31	3702214.0
2006-03-31 14:00:00	MSFT	Stock	27.31	27.4	27.27	27.34	5202400.0
2006-03-31 15:00:00	MSFT	Stock	27.34	27.37	27.21	27.24	14765466.0
2006-03-31 16:00:00	MSFT	Stock	27.28	27.28	27.17	27.21	1855645.0
2006-03-31 17:00:00	MSFT	Stock	27.23	27.24	27.21	27.23	505274.0
2006-03-31 18:00:00	MSFT	Stock	27.22	27.22	27.22	27.22	100.0
2006-03-31 08:00:00	NVDA	Stock	0.4783	0.4783	0.4768	0.4775	192000.0
2006-03-31 09:00:00	NVDA	Stock	0.4771	0.4832	0.477	0.4829	116853360.0
2006-03-31 10:00:00	NVDA	Stock	0.4828	0.4852	0.4748	0.4794	188960040.0
2006-03-31 11:00:00	NVDA	Stock	0.4794	0.4823	0.4767	0.4815	82296600.0
2006-03-31 12:00:00	NVDA	Stock	0.4815	0.4832	0.4777	0.4778	63659040.0
2006-03-31 13:00:00	NVDA	Stock	0.478	0.4794	0.4742	0.4767	85993920.0
2006-03-31 14:00:00	NVDA	Stock	0.4767	0.4819	0.4767	0.4816	85212000.0
2006-03-31 15:00:00	NVDA	Stock	0.4816	0.482	0.4772	0.4772	140153400.0
2006-03-31 16:00:00	NVDA	Stock	0.4771	0.4783	0.4771	0.4772	13452240.0
2006-03-31 17:00:00	NVDA	Stock	0.4772	0.4783	0.4772	0.4782	447960.0
2006-03-31 18:00:00	NVDA	Stock	0.4782	0.4782	0.4782	0.4782	240000.0
2006-03-31 09:00:00	AMZN	Stock	1.841	1.841	1.8255	1.83	7434980.0
2006-03-31 10:00:00	AMZN	Stock	1.83	1.8362	1.8255	1.83	6824180.0
2006-03-31 11:00:00	AMZN	Stock	1.83	1.832	1.826	1.8285	4584940.0
2006-03-31 12:00:00	AMZN	Stock	1.829	1.833	1.8275	1.83	6829180.0
2006-03-31 13:00:00	AMZN	Stock	1.83	1.832	1.8255	1.8255	4384520.0
2006-03-31 14:00:00	AMZN	Stock	1.8255	1.8315	1.8245	1.8295	6641260.0
2006-03-31 15:00:00	AMZN	Stock	1.8295	1.8315	1.824	1.8265	10759280.0
2006-03-31 16:00:00	AMZN	Stock	1.8275	1.836	1.8255	1.8255	841700.0
2006-03-31 17:00:00	AMZN	Stock	1.8255	1.8255	1.8255	1.8255	78880.0
2006-03-31 08:00:00	CL	Stock	29.14	29.14	29.14	29.14	2600.0
2006-03-31 09:00:00	CL	Stock	29.01	29.1	28.89	28.965	505200.0
2006-03-31 10:00:00	CL	Stock	28.965	28.975	28.68	28.8	599600.0
2006-03-31 11:00:00	CL	Stock	28.795	28.795	28.66	28.75	522800.0

> showing 50 of 29,271 rows — these rows as CSV

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