PREVIEW / stock_30min / 2007-12-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-17.parquet
  size:    1.2 MB
  rows:    70,111
  symbols: 3,232

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-12-17 05:00:00	AAPL	Stock	6.7589	6.7589	6.7589	6.7589	8400.0
2007-12-17 06:00:00	AAPL	Stock	6.7568	6.7568	6.7568	6.7568	2800.0
2007-12-17 07:00:00	AAPL	Stock	6.7518	6.7857	6.75	6.7504	284620.0
2007-12-17 07:30:00	AAPL	Stock	6.7786	6.7946	6.7589	6.7857	101388.0
2007-12-17 08:00:00	AAPL	Stock	6.7839	6.8282	6.7718	6.81	2114700.0
2007-12-17 08:30:00	AAPL	Stock	6.8125	6.8182	6.7996	6.8089	441196.0
2007-12-17 09:00:00	AAPL	Stock	6.8121	6.8386	6.8071	6.8111	2543268.0
2007-12-17 09:30:00	AAPL	Stock	6.8111	6.8804	6.8104	6.825	117765256.0
2007-12-17 10:00:00	AAPL	Stock	6.8239	6.8254	6.7286	6.7464	113074304.0
2007-12-17 10:30:00	AAPL	Stock	6.7454	6.8114	6.7354	6.7492	51627268.0
2007-12-17 11:00:00	AAPL	Stock	6.7486	6.7668	6.6632	6.6718	78475712.0
2007-12-17 11:30:00	AAPL	Stock	6.6714	6.6864	6.6468	6.675	66445680.0
2007-12-17 12:00:00	AAPL	Stock	6.675	6.7004	6.6671	6.6963	38967012.0
2007-12-17 12:30:00	AAPL	Stock	6.6964	6.7021	6.6643	6.6939	30774912.0
2007-12-17 13:00:00	AAPL	Stock	6.6939	6.6975	6.6268	6.6336	46186980.0
2007-12-17 13:30:00	AAPL	Stock	6.6336	6.6475	6.535	6.5464	100310924.0
2007-12-17 14:00:00	AAPL	Stock	6.5471	6.595	6.535	6.5821	75959296.0
2007-12-17 14:30:00	AAPL	Stock	6.5821	6.6311	6.5589	6.5768	75686044.0
2007-12-17 15:00:00	AAPL	Stock	6.5769	6.6196	6.5625	6.6018	87723216.0
2007-12-17 15:30:00	AAPL	Stock	6.6018	6.6429	6.5571	6.5886	110764416.0
2007-12-17 16:00:00	AAPL	Stock	6.5868	6.7996	6.5696	6.5729	22798552.0
2007-12-17 16:30:00	AAPL	Stock	6.5857	6.5857	6.5696	6.5732	440328.0
2007-12-17 17:00:00	AAPL	Stock	6.575	6.5768	6.5607	6.5625	291816.0
2007-12-17 17:30:00	AAPL	Stock	6.5686	6.6786	6.5554	6.5561	632240.0
2007-12-17 18:00:00	AAPL	Stock	6.5561	6.5857	6.5561	6.5714	627816.0
2007-12-17 18:30:00	AAPL	Stock	6.5679	6.5786	6.5679	6.5704	183092.0
2007-12-17 19:00:00	AAPL	Stock	6.5732	6.5804	6.5714	6.5757	209272.0
2007-12-17 19:30:00	AAPL	Stock	6.575	6.5857	6.5746	6.5843	254044.0
2007-12-17 08:00:00	MSFT	Stock	35.14	35.15	35.11	35.15	4000.0
2007-12-17 08:30:00	MSFT	Stock	35.31	35.31	35.13	35.15	8670.0
2007-12-17 09:00:00	MSFT	Stock	35.14	35.16	35.0	35.03	61111.0
2007-12-17 09:30:00	MSFT	Stock	35.05	35.13	34.84	34.96	5888228.0
2007-12-17 10:00:00	MSFT	Stock	34.96	35.05	34.81	34.81	4028706.0
2007-12-17 10:30:00	MSFT	Stock	34.81	35.03	34.78	35.0	3336825.0
2007-12-17 11:00:00	MSFT	Stock	35.0	35.05	34.96	35.0	4354819.0
2007-12-17 11:30:00	MSFT	Stock	35.01	35.1	34.95	34.98	3946825.0
2007-12-17 12:00:00	MSFT	Stock	34.98	34.98	34.83	34.88	2401093.0
2007-12-17 12:30:00	MSFT	Stock	34.88	35.05	34.84	35.0	1684404.0
2007-12-17 13:00:00	MSFT	Stock	35.0	35.0	34.74	34.8	2653264.0
2007-12-17 13:30:00	MSFT	Stock	34.81	34.82	34.61	34.68	3468209.0
2007-12-17 14:00:00	MSFT	Stock	34.68	34.77	34.56	34.68	3083306.0
2007-12-17 14:30:00	MSFT	Stock	34.68	35.05	34.47	34.53	3133051.0
2007-12-17 15:00:00	MSFT	Stock	34.53	34.6	34.48	34.5	4025355.0
2007-12-17 15:30:00	MSFT	Stock	34.5	34.66	34.36	34.39	10307080.0
2007-12-17 16:00:00	MSFT	Stock	34.39	35.31	34.39	34.42	3655822.0
2007-12-17 16:30:00	MSFT	Stock	34.42	34.743	34.39	34.47	27431.0
2007-12-17 17:00:00	MSFT	Stock	34.39	34.39	34.39	34.39	180.0
2007-12-17 17:30:00	MSFT	Stock	34.45	34.45	34.39	34.39	2177201.0
2007-12-17 18:00:00	MSFT	Stock	34.4	34.5	34.39	34.39	28696.0
2007-12-17 18:30:00	MSFT	Stock	34.43	34.45	34.43	34.45	500.0

> showing 50 of 70,111 rows — these rows as CSV

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