PREVIEW / stock_1hour / 2009-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-08.parquet
  size:    842 KB
  rows:    41,106
  symbols: 3,313

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
2009-07-08 07:00:00	AAPL	Stock	4.85	4.8661	4.8475	4.8571	100828.0
2009-07-08 08:00:00	AAPL	Stock	4.8489	4.8571	4.8286	4.8329	564340.0
2009-07-08 09:00:00	AAPL	Stock	4.8375	4.8868	4.8111	4.8461	72102352.0
2009-07-08 10:00:00	AAPL	Stock	4.845	4.8857	4.8414	4.8432	77482916.0
2009-07-08 11:00:00	AAPL	Stock	4.8432	4.8568	4.8007	4.8414	81188884.0
2009-07-08 12:00:00	AAPL	Stock	4.8411	4.8464	4.8089	4.8386	52315508.0
2009-07-08 13:00:00	AAPL	Stock	4.8386	4.8807	4.8357	4.8554	58962904.0
2009-07-08 14:00:00	AAPL	Stock	4.8561	4.8661	4.8168	4.8593	69764520.0
2009-07-08 15:00:00	AAPL	Stock	4.8593	4.93	4.8464	4.9014	138912676.0
2009-07-08 16:00:00	AAPL	Stock	4.9011	4.9157	4.8548	4.9157	14796488.0
2009-07-08 17:00:00	AAPL	Stock	4.9107	4.9179	4.9007	4.9157	113764.0
2009-07-08 18:00:00	AAPL	Stock	4.9082	4.9125	4.9007	4.9121	719068.0
2009-07-08 19:00:00	AAPL	Stock	4.9143	4.9143	4.9071	4.9071	320600.0
2009-07-08 20:00:00	AAPL	Stock	4.82	4.82	4.82	4.82	8400.0
2009-07-08 07:00:00	MSFT	Stock	22.56	22.57	22.47	22.57	2448.0
2009-07-08 08:00:00	MSFT	Stock	22.55	22.55	22.28	22.34	97477.0
2009-07-08 09:00:00	MSFT	Stock	22.34	22.39	22.1	22.19	9077225.0
2009-07-08 10:00:00	MSFT	Stock	22.18	22.46	22.17	22.24	11768022.0
2009-07-08 11:00:00	MSFT	Stock	22.23	22.24	22.07	22.1	9141313.0
2009-07-08 12:00:00	MSFT	Stock	22.093	22.2	22.0	22.17	6618658.0
2009-07-08 13:00:00	MSFT	Stock	22.17	22.4	22.16	22.37	7414464.0
2009-07-08 14:00:00	MSFT	Stock	22.38	22.49	22.28	22.462	6482328.0
2009-07-08 15:00:00	MSFT	Stock	22.47	22.69	22.42	22.58	16663984.0
2009-07-08 16:00:00	MSFT	Stock	22.56	22.64	22.232	22.58	3761320.0
2009-07-08 17:00:00	MSFT	Stock	22.56	22.65	22.56	22.65	14913.0
2009-07-08 18:00:00	MSFT	Stock	22.65	22.65	22.58	22.58	1300.0
2009-07-08 19:00:00	MSFT	Stock	22.6	22.72	22.59	22.72	1311.0
2009-07-08 20:00:00	MSFT	Stock	22.04	22.04	22.04	22.04	8400.0
2009-07-08 09:00:00	NVDA	Stock	0.2543	0.255	0.2428	0.245	199780600.0
2009-07-08 10:00:00	NVDA	Stock	0.2448	0.252	0.2448	0.2504	180474120.0
2009-07-08 11:00:00	NVDA	Stock	0.2503	0.2543	0.2485	0.2535	158294880.0
2009-07-08 12:00:00	NVDA	Stock	0.2535	0.2543	0.252	0.252	86200280.0
2009-07-08 13:00:00	NVDA	Stock	0.252	0.2539	0.251	0.2527	127638440.0
2009-07-08 14:00:00	NVDA	Stock	0.2525	0.2527	0.25	0.2507	127971560.0
2009-07-08 15:00:00	NVDA	Stock	0.251	0.254	0.2503	0.2527	304501080.0
2009-07-08 16:00:00	NVDA	Stock	0.2527	0.2535	0.2508	0.2527	16828280.0
2009-07-08 17:00:00	NVDA	Stock	0.2535	0.2535	0.2527	0.253	131360.0
2009-07-08 18:00:00	NVDA	Stock	0.2535	0.2535	0.2533	0.2535	54400.0
2009-07-08 19:00:00	NVDA	Stock	0.2535	0.2535	0.2535	0.2535	16000.0
2009-07-08 07:00:00	AMZN	Stock	3.8	3.8495	3.8	3.8495	8000.0
2009-07-08 08:00:00	AMZN	Stock	3.8445	3.8445	3.808	3.8185	201300.0
2009-07-08 09:00:00	AMZN	Stock	3.8255	3.8965	3.819	3.8725	22962720.0
2009-07-08 10:00:00	AMZN	Stock	3.872	3.8865	3.822	3.822	28254180.0
2009-07-08 11:00:00	AMZN	Stock	3.822	3.834	3.785	3.8225	21843320.0
2009-07-08 12:00:00	AMZN	Stock	3.8225	3.8555	3.804	3.8405	16570380.0
2009-07-08 13:00:00	AMZN	Stock	3.8405	3.8825	3.84	3.8545	15431380.0
2009-07-08 14:00:00	AMZN	Stock	3.8535	3.8605	3.8265	3.844	20542400.0
2009-07-08 15:00:00	AMZN	Stock	3.8445	3.876	3.8345	3.8685	40293880.0
2009-07-08 16:00:00	AMZN	Stock	3.8625	3.8705	3.8412	3.868	1625100.0
2009-07-08 17:00:00	AMZN	Stock	3.868	3.8825	3.868	3.8775	11280.0

> showing 50 of 41,106 rows — these rows as CSV

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