PREVIEW / stock_30min / 2007-12-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-18.parquet
  size:    1.2 MB
  rows:    70,432
  symbols: 3,255

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-18 04:00:00	AAPL	Stock	6.6321	6.6321	6.6321	6.6321	2800.0
2007-12-18 05:30:00	AAPL	Stock	6.6736	6.6786	6.6736	6.6786	16800.0
2007-12-18 06:30:00	AAPL	Stock	6.6786	6.6804	6.6621	6.6732	128660.0
2007-12-18 07:00:00	AAPL	Stock	6.6964	6.6964	6.6607	6.6625	258272.0
2007-12-18 07:30:00	AAPL	Stock	6.6607	6.6707	6.6454	6.6607	249312.0
2007-12-18 08:00:00	AAPL	Stock	6.6643	6.8114	6.6571	6.6796	5093452.0
2007-12-18 08:30:00	AAPL	Stock	6.6793	6.6882	6.6607	6.6689	1864464.0
2007-12-18 09:00:00	AAPL	Stock	6.6661	6.6779	6.6596	6.6654	1705032.0
2007-12-18 09:30:00	AAPL	Stock	6.6614	6.6904	6.5786	6.6182	128154404.0
2007-12-18 10:00:00	AAPL	Stock	6.6182	6.6275	6.5118	6.5693	129201212.0
2007-12-18 10:30:00	AAPL	Stock	6.5693	6.5836	6.4679	6.5389	83358268.0
2007-12-18 11:00:00	AAPL	Stock	6.5393	6.5686	6.4804	6.4901	63944916.0
2007-12-18 11:30:00	AAPL	Stock	6.49	6.5171	6.4118	6.4254	87183488.0
2007-12-18 12:00:00	AAPL	Stock	6.4268	6.4568	6.3786	6.4514	102637864.0
2007-12-18 12:30:00	AAPL	Stock	6.45	6.4786	6.4129	6.4736	62093892.0
2007-12-18 13:00:00	AAPL	Stock	6.4732	6.5604	6.4575	6.5479	73954748.0
2007-12-18 13:30:00	AAPL	Stock	6.5479	6.6046	6.5293	6.5818	107718604.0
2007-12-18 14:00:00	AAPL	Stock	6.5814	6.6307	6.5775	6.6086	89873392.0
2007-12-18 14:30:00	AAPL	Stock	6.6089	6.6196	6.5443	6.58	85266132.0
2007-12-18 15:00:00	AAPL	Stock	6.5796	6.5868	6.5371	6.5718	83028876.0
2007-12-18 15:30:00	AAPL	Stock	6.5714	6.6014	6.5096	6.5347	101214848.0
2007-12-18 16:00:00	AAPL	Stock	6.5343	6.5421	6.4732	6.535	12414948.0
2007-12-18 16:30:00	AAPL	Stock	6.5339	6.5857	6.5321	6.535	1487248.0
2007-12-18 17:00:00	AAPL	Stock	6.5486	6.55	6.535	6.5496	255836.0
2007-12-18 17:30:00	AAPL	Stock	6.6293	6.6293	6.5464	6.5464	858172.0
2007-12-18 18:00:00	AAPL	Stock	6.5482	6.5507	6.5464	6.5507	261800.0
2007-12-18 18:30:00	AAPL	Stock	6.5514	6.5536	6.55	6.5504	154280.0
2007-12-18 19:00:00	AAPL	Stock	6.5536	6.5554	6.55	6.5536	110880.0
2007-12-18 19:30:00	AAPL	Stock	6.55	6.5575	6.5457	6.5536	164920.0
2007-12-18 07:30:00	MSFT	Stock	34.64	34.64	34.64	34.64	800.0
2007-12-18 08:00:00	MSFT	Stock	34.7	34.78	34.63	34.77	11550.0
2007-12-18 08:30:00	MSFT	Stock	34.67	34.74	34.67	34.71	4300.0
2007-12-18 09:00:00	MSFT	Stock	34.71	34.71	34.51	34.57	324603.0
2007-12-18 09:30:00	MSFT	Stock	34.57	34.72	34.45	34.56	5693058.0
2007-12-18 10:00:00	MSFT	Stock	34.55	34.69	34.47	34.65	4106191.0
2007-12-18 10:30:00	MSFT	Stock	34.64	34.67	34.51	34.58	3624779.0
2007-12-18 11:00:00	MSFT	Stock	34.58	34.64	34.52	34.52	3918030.0
2007-12-18 11:30:00	MSFT	Stock	34.53	34.56	34.3	34.34	3566869.0
2007-12-18 12:00:00	MSFT	Stock	34.332	34.4	34.21	34.36	3163675.0
2007-12-18 12:30:00	MSFT	Stock	34.36	34.39	34.3	34.34	1704813.0
2007-12-18 13:00:00	MSFT	Stock	34.34	34.6	34.3	34.54	2398855.0
2007-12-18 13:30:00	MSFT	Stock	34.54	34.658	34.49	34.658	2596532.0
2007-12-18 14:00:00	MSFT	Stock	34.65	35.0	34.6	34.948	5236662.0
2007-12-18 14:30:00	MSFT	Stock	34.95	34.99	34.72	34.76	3695028.0
2007-12-18 15:00:00	MSFT	Stock	34.76	34.82	34.68	34.753	3029323.0
2007-12-18 15:30:00	MSFT	Stock	34.75	34.92	34.7	34.78	6000741.0
2007-12-18 16:00:00	MSFT	Stock	34.774	35.031	34.42	34.74	2620456.0
2007-12-18 16:30:00	MSFT	Stock	34.75	34.8	34.39	34.74	283929.0
2007-12-18 17:00:00	MSFT	Stock	34.74	34.74	34.74	34.74	463.0
2007-12-18 17:30:00	MSFT	Stock	34.76	35.02	34.76	35.02	3100.0

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

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