PREVIEW / stock_1hour / 2010-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-12.parquet
  size:    876 KB
  rows:    42,358
  symbols: 3,468

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
2010-07-12 04:00:00	AAPL	Stock	9.2507	9.2507	9.2286	9.2286	8036.0
2010-07-12 07:00:00	AAPL	Stock	9.245	9.2571	9.2429	9.2571	47040.0
2010-07-12 08:00:00	AAPL	Stock	9.2586	9.2818	9.245	9.2679	785876.0
2010-07-12 09:00:00	AAPL	Stock	9.2668	9.3486	9.2002	9.3268	75773936.0
2010-07-12 10:00:00	AAPL	Stock	9.3279	9.3518	9.2321	9.2704	92953812.0
2010-07-12 11:00:00	AAPL	Stock	9.2696	9.2697	9.1021	9.1144	116645536.0
2010-07-12 12:00:00	AAPL	Stock	9.115	9.2168	9.1149	9.1757	84066444.0
2010-07-12 13:00:00	AAPL	Stock	9.1764	9.2275	9.1679	9.2109	48744584.0
2010-07-12 14:00:00	AAPL	Stock	9.2123	9.2239	9.18	9.1968	41207012.0
2010-07-12 15:00:00	AAPL	Stock	9.1989	9.2136	9.1679	9.1892	94062416.0
2010-07-12 16:00:00	AAPL	Stock	9.1932	9.2406	9.1857	9.2104	5829964.0
2010-07-12 17:00:00	AAPL	Stock	9.2104	9.2196	9.2071	9.2179	642292.0
2010-07-12 18:00:00	AAPL	Stock	9.2179	9.2214	9.1889	9.2214	338576.0
2010-07-12 19:00:00	AAPL	Stock	9.2196	9.2375	9.2196	9.2336	477260.0
2010-07-12 06:00:00	MSFT	Stock	24.26	24.29	24.26	24.29	1000.0
2010-07-12 07:00:00	MSFT	Stock	24.32	24.41	24.31	24.37	15175.0
2010-07-12 08:00:00	MSFT	Stock	24.36	24.42	24.29	24.29	56409.0
2010-07-12 09:00:00	MSFT	Stock	24.28	24.84	24.28	24.69	6767813.0
2010-07-12 10:00:00	MSFT	Stock	24.69	24.8	24.65	24.682	8845071.0
2010-07-12 11:00:00	MSFT	Stock	24.685	24.71	24.57	24.68	5816378.0
2010-07-12 12:00:00	MSFT	Stock	24.67	24.74	24.66	24.68	3016273.0
2010-07-12 13:00:00	MSFT	Stock	24.66	24.88	24.65	24.86	4755829.0
2010-07-12 14:00:00	MSFT	Stock	24.857	24.89	24.73	24.84	5704328.0
2010-07-12 15:00:00	MSFT	Stock	24.845	24.88	24.74	24.83	11954128.0
2010-07-12 16:00:00	MSFT	Stock	24.83	24.88	24.746	24.87	2298261.0
2010-07-12 17:00:00	MSFT	Stock	24.9	24.99	24.735	24.92	22421.0
2010-07-12 18:00:00	MSFT	Stock	24.92	24.95	24.83	24.9	7504.0
2010-07-12 19:00:00	MSFT	Stock	24.92	24.95	24.9	24.94	9175.0
2010-07-12 08:00:00	NVDA	Stock	0.2592	0.26	0.2583	0.2595	320040.0
2010-07-12 09:00:00	NVDA	Stock	0.2588	0.2663	0.2575	0.2658	76466840.0
2010-07-12 10:00:00	NVDA	Stock	0.266	0.2668	0.259	0.261	86425240.0
2010-07-12 11:00:00	NVDA	Stock	0.261	0.2615	0.2594	0.2612	49972760.0
2010-07-12 12:00:00	NVDA	Stock	0.2612	0.2635	0.2612	0.262	39710360.0
2010-07-12 13:00:00	NVDA	Stock	0.262	0.2638	0.2615	0.2638	37721440.0
2010-07-12 14:00:00	NVDA	Stock	0.2636	0.264	0.2618	0.2632	92551280.0
2010-07-12 15:00:00	NVDA	Stock	0.2634	0.265	0.2625	0.2635	164405600.0
2010-07-12 16:00:00	NVDA	Stock	0.2635	0.265	0.262	0.265	16820880.0
2010-07-12 17:00:00	NVDA	Stock	0.264	0.265	0.264	0.265	428000.0
2010-07-12 18:00:00	NVDA	Stock	0.265	0.2652	0.265	0.2652	255600.0
2010-07-12 19:00:00	NVDA	Stock	0.2652	0.2672	0.2652	0.267	126720.0
2010-07-12 07:00:00	AMZN	Stock	5.871	5.8775	5.871	5.8775	26000.0
2010-07-12 08:00:00	AMZN	Stock	5.865	5.9175	5.8335	5.9	220220.0
2010-07-12 09:00:00	AMZN	Stock	5.8975	5.9695	5.8875	5.928	15201360.0
2010-07-12 10:00:00	AMZN	Stock	5.93	5.941	5.866	5.9139	14891220.0
2010-07-12 11:00:00	AMZN	Stock	5.912	5.9125	5.867	5.8925	9759360.0
2010-07-12 12:00:00	AMZN	Stock	5.892	5.9352	5.8905	5.9005	7822120.0
2010-07-12 13:00:00	AMZN	Stock	5.899	5.966	5.898	5.9625	11703820.0
2010-07-12 14:00:00	AMZN	Stock	5.9615	5.975	5.938	5.9565	9783360.0
2010-07-12 15:00:00	AMZN	Stock	5.957	5.985	5.9345	5.975	23931700.0
2010-07-12 16:00:00	AMZN	Stock	5.976	5.9865	5.863	5.976	1580120.0

> showing 50 of 42,358 rows — these rows as CSV

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