PREVIEW / stock_30min / 2007-08-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-24.parquet
  size:    1.1 MB
  rows:    63,362
  symbols: 3,101

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-08-24 09:30:00	AAPL	Stock	4.6618	4.6989	4.6361	4.6893	84338352.0
2007-08-24 10:00:00	AAPL	Stock	4.6893	4.7475	4.6893	4.7304	125193656.0
2007-08-24 10:30:00	AAPL	Stock	4.7311	4.7707	4.7286	4.7629	75673724.0
2007-08-24 11:00:00	AAPL	Stock	4.7625	4.8054	4.7557	4.7818	110720988.0
2007-08-24 11:30:00	AAPL	Stock	4.7811	4.7986	4.7707	4.7932	58610524.0
2007-08-24 12:00:00	AAPL	Stock	4.7936	4.8143	4.7732	4.8032	58956688.0
2007-08-24 12:30:00	AAPL	Stock	4.8032	4.8107	4.7875	4.8071	44807280.0
2007-08-24 13:00:00	AAPL	Stock	4.8071	4.8125	4.7985	4.8046	36601264.0
2007-08-24 13:30:00	AAPL	Stock	4.804	4.8054	4.785	4.7882	35080528.0
2007-08-24 14:00:00	AAPL	Stock	4.7879	4.8011	4.7786	4.7975	48587252.0
2007-08-24 14:30:00	AAPL	Stock	4.7975	4.8179	4.7886	4.8171	54595128.0
2007-08-24 15:00:00	AAPL	Stock	4.8175	4.8175	4.7857	4.8014	55302380.0
2007-08-24 15:30:00	AAPL	Stock	4.8014	4.8346	4.8014	4.8319	90497792.0
2007-08-24 16:00:00	AAPL	Stock	4.8318	4.8321	4.8311	4.8321	12697496.0
2007-08-24 09:30:00	MSFT	Stock	28.21	28.26	28.07	28.095	3420456.0
2007-08-24 10:00:00	MSFT	Stock	28.092	28.2	28.09	28.13	3691579.0
2007-08-24 10:30:00	MSFT	Stock	28.13	28.23	28.11	28.23	2641256.0
2007-08-24 11:00:00	MSFT	Stock	28.23	28.32	28.2	28.32	2510610.0
2007-08-24 11:30:00	MSFT	Stock	28.32	28.42	28.29	28.42	2766844.0
2007-08-24 12:00:00	MSFT	Stock	28.41	28.65	28.39	28.57	4511930.0
2007-08-24 12:30:00	MSFT	Stock	28.58	28.65	28.53	28.59	2286630.0
2007-08-24 13:00:00	MSFT	Stock	28.582	28.64	28.58	28.612	1444907.0
2007-08-24 13:30:00	MSFT	Stock	28.62	28.68	28.56	28.6	2818685.0
2007-08-24 14:00:00	MSFT	Stock	28.61	28.65	28.59	28.62	1823141.0
2007-08-24 14:30:00	MSFT	Stock	28.62	28.73	28.6	28.72	2686929.0
2007-08-24 15:00:00	MSFT	Stock	28.715	28.72	28.66	28.72	3030077.0
2007-08-24 15:30:00	MSFT	Stock	28.72	28.84	28.72	28.8	6889511.0
2007-08-24 16:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	2155221.0
2007-08-24 08:30:00	NVDA	Stock	0.7978	0.798	0.7978	0.798	96000.0
2007-08-24 09:00:00	NVDA	Stock	0.796	0.7967	0.7955	0.7967	530580.0
2007-08-24 09:30:00	NVDA	Stock	0.7965	0.804	0.7918	0.798	32546580.0
2007-08-24 10:00:00	NVDA	Stock	0.7983	0.8055	0.7983	0.8035	32498160.0
2007-08-24 10:30:00	NVDA	Stock	0.8037	0.8055	0.8002	0.8033	19956660.0
2007-08-24 11:00:00	NVDA	Stock	0.8033	0.8057	0.8007	0.8023	18582240.0
2007-08-24 11:30:00	NVDA	Stock	0.8027	0.804	0.7979	0.8013	21922020.0
2007-08-24 12:00:00	NVDA	Stock	0.8015	0.802	0.7977	0.7993	26224620.0
2007-08-24 12:30:00	NVDA	Stock	0.799	0.8	0.7973	0.7992	18007980.0
2007-08-24 13:00:00	NVDA	Stock	0.7993	0.8013	0.7983	0.8003	24207120.0
2007-08-24 13:30:00	NVDA	Stock	0.8003	0.8012	0.7983	0.7997	25161360.0
2007-08-24 14:00:00	NVDA	Stock	0.7995	0.8043	0.7993	0.8013	27574980.0
2007-08-24 14:30:00	NVDA	Stock	0.8015	0.8055	0.8	0.8048	26531400.0
2007-08-24 15:00:00	NVDA	Stock	0.8047	0.8053	0.8013	0.8033	21617160.0
2007-08-24 15:30:00	NVDA	Stock	0.8033	0.8055	0.8032	0.8038	36522060.0
2007-08-24 16:00:00	NVDA	Stock	0.8042	0.8052	0.8042	0.8042	13680960.0
2007-08-24 16:30:00	NVDA	Stock	0.8025	0.8025	0.8025	0.8025	6000.0
2007-08-24 19:00:00	NVDA	Stock	0.805	0.8053	0.805	0.8053	18000.0
2007-08-24 06:00:00	AMZN	Stock	3.865	3.875	3.865	3.865	8000.0
2007-08-24 08:00:00	AMZN	Stock	3.86	3.8945	3.8455	3.8475	115120.0
2007-08-24 08:30:00	AMZN	Stock	3.85	3.8535	3.8475	3.8505	76000.0
2007-08-24 09:00:00	AMZN	Stock	3.85	3.857	3.85	3.85	70220.0

> showing 50 of 63,362 rows — these rows as CSV

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