PREVIEW / stock_1hour / 2009-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-10.parquet
  size:    808 KB
  rows:    39,525
  symbols: 3,297

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-10 07:00:00	AAPL	Stock	4.8696	4.8696	4.8696	4.8696	11200.0
2009-07-10 08:00:00	AAPL	Stock	4.8579	4.8786	4.85	4.8664	1239560.0
2009-07-10 09:00:00	AAPL	Stock	4.8668	4.9589	4.8661	4.9514	104099800.0
2009-07-10 10:00:00	AAPL	Stock	4.95	4.9571	4.9225	4.9434	75850572.0
2009-07-10 11:00:00	AAPL	Stock	4.9429	4.9493	4.9007	4.9218	59096212.0
2009-07-10 12:00:00	AAPL	Stock	4.9218	4.9436	4.9186	4.9393	30368464.0
2009-07-10 13:00:00	AAPL	Stock	4.9393	4.9614	4.9371	4.9593	33468932.0
2009-07-10 14:00:00	AAPL	Stock	4.9585	4.9607	4.9321	4.9379	41950048.0
2009-07-10 15:00:00	AAPL	Stock	4.9379	4.9632	4.9357	4.9461	77545580.0
2009-07-10 16:00:00	AAPL	Stock	4.9461	4.9571	4.9221	4.9471	9665348.0
2009-07-10 17:00:00	AAPL	Stock	4.9507	4.9518	4.9429	4.9464	544460.0
2009-07-10 18:00:00	AAPL	Stock	4.9411	4.9482	4.9393	4.9393	788984.0
2009-07-10 19:00:00	AAPL	Stock	4.9393	4.9429	4.9393	4.9404	221788.0
2009-07-10 07:00:00	MSFT	Stock	22.2	22.2	22.2	22.2	400.0
2009-07-10 08:00:00	MSFT	Stock	22.29	22.3	22.2	22.25	10244.0
2009-07-10 09:00:00	MSFT	Stock	22.3	22.45	22.15	22.41	8371794.0
2009-07-10 10:00:00	MSFT	Stock	22.41	22.54	22.32	22.37	6226973.0
2009-07-10 11:00:00	MSFT	Stock	22.36	22.37	22.16	22.258	6682468.0
2009-07-10 12:00:00	MSFT	Stock	22.25	22.36	22.23	22.33	3594859.0
2009-07-10 13:00:00	MSFT	Stock	22.33	22.41	22.27	22.39	3618662.0
2009-07-10 14:00:00	MSFT	Stock	22.38	22.39	22.285	22.33	3836011.0
2009-07-10 15:00:00	MSFT	Stock	22.32	22.47	22.31	22.39	7289636.0
2009-07-10 16:00:00	MSFT	Stock	22.39	22.43	22.21	22.39	1964461.0
2009-07-10 17:00:00	MSFT	Stock	22.42	22.42	22.34	22.34	5100.0
2009-07-10 18:00:00	MSFT	Stock	22.39	22.39	22.32	22.32	1137.0
2009-07-10 19:00:00	MSFT	Stock	22.32	22.38	22.32	22.38	3729.0
2009-07-10 09:00:00	NVDA	Stock	0.2578	0.261	0.2545	0.2585	55917200.0
2009-07-10 10:00:00	NVDA	Stock	0.2585	0.2603	0.2563	0.2578	94676360.0
2009-07-10 11:00:00	NVDA	Stock	0.258	0.258	0.2527	0.2559	64513080.0
2009-07-10 12:00:00	NVDA	Stock	0.2559	0.2572	0.254	0.255	41042720.0
2009-07-10 13:00:00	NVDA	Stock	0.2551	0.2583	0.255	0.257	41564240.0
2009-07-10 14:00:00	NVDA	Stock	0.2572	0.2592	0.2565	0.2583	81368440.0
2009-07-10 15:00:00	NVDA	Stock	0.2584	0.2608	0.2582	0.2595	126184960.0
2009-07-10 16:00:00	NVDA	Stock	0.2595	0.2608	0.2578	0.2592	13001120.0
2009-07-10 08:00:00	AMZN	Stock	3.8785	3.8785	3.8675	3.875	46500.0
2009-07-10 09:00:00	AMZN	Stock	3.878	3.941	3.8578	3.881	17068920.0
2009-07-10 10:00:00	AMZN	Stock	3.8805	3.8995	3.852	3.861	20585680.0
2009-07-10 11:00:00	AMZN	Stock	3.86	3.86	3.8085	3.841	16001600.0
2009-07-10 12:00:00	AMZN	Stock	3.8403	3.879	3.837	3.8595	14049200.0
2009-07-10 13:00:00	AMZN	Stock	3.86	3.904	3.86	3.8945	12312060.0
2009-07-10 14:00:00	AMZN	Stock	3.8935	3.897	3.873	3.881	10766960.0
2009-07-10 15:00:00	AMZN	Stock	3.88	3.8955	3.875	3.8815	23642180.0
2009-07-10 16:00:00	AMZN	Stock	3.8795	3.8815	3.8742	3.8815	3505140.0
2009-07-10 17:00:00	AMZN	Stock	3.8895	3.8895	3.8895	3.8895	2000.0
2009-07-10 06:00:00	TLT	Stock	95.48	95.48	95.48	95.48	100.0
2009-07-10 07:00:00	TLT	Stock	96.19	96.19	95.67	95.82	3200.0
2009-07-10 08:00:00	TLT	Stock	95.5	96.02	95.5	95.7	29300.0
2009-07-10 09:00:00	TLT	Stock	95.69	95.71	95.43	95.63	317450.0
2009-07-10 10:00:00	TLT	Stock	95.62	96.1601	95.52	96.1	658213.0
2009-07-10 11:00:00	TLT	Stock	96.12	96.31	96.02	96.02	697115.0

> showing 50 of 39,525 rows — these rows as CSV

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