PREVIEW / stock_30min / 2008-01-28

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-28.parquet
  size:    1.2 MB
  rows:    69,038
  symbols: 3,264

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
2008-01-28 06:30:00	AAPL	Stock	4.5714	4.5714	4.5714	4.5714	2800.0
2008-01-28 07:00:00	AAPL	Stock	4.5979	4.6021	4.5893	4.6	156520.0
2008-01-28 07:30:00	AAPL	Stock	4.5857	4.62	4.5736	4.6071	372204.0
2008-01-28 08:00:00	AAPL	Stock	4.6071	4.6161	4.5571	4.5714	4432764.0
2008-01-28 08:30:00	AAPL	Stock	4.5757	4.5857	4.5489	4.5725	3692528.0
2008-01-28 09:00:00	AAPL	Stock	4.5714	4.5946	4.5636	4.5771	4410756.0
2008-01-28 09:30:00	AAPL	Stock	4.5771	4.6368	4.5161	4.628	234032288.0
2008-01-28 10:00:00	AAPL	Stock	4.6282	4.6386	4.5575	4.6375	150358628.0
2008-01-28 10:30:00	AAPL	Stock	4.6386	4.7079	4.6204	4.6807	154005516.0
2008-01-28 11:00:00	AAPL	Stock	4.6811	4.7571	4.6714	4.6915	109615380.0
2008-01-28 11:30:00	AAPL	Stock	4.6911	4.7386	4.6657	4.6759	88601520.0
2008-01-28 12:00:00	AAPL	Stock	4.676	4.7007	4.6429	4.6682	59957996.0
2008-01-28 12:30:00	AAPL	Stock	4.6696	4.6864	4.6571	4.6778	48169436.0
2008-01-28 13:00:00	AAPL	Stock	4.6775	4.7036	4.6696	4.6829	68487916.0
2008-01-28 13:30:00	AAPL	Stock	4.6825	4.7004	4.6757	4.6854	55619760.0
2008-01-28 14:00:00	AAPL	Stock	4.6857	4.7121	4.6793	4.6802	63742532.0
2008-01-28 14:30:00	AAPL	Stock	4.6804	4.6939	4.6207	4.6279	115042676.0
2008-01-28 15:00:00	AAPL	Stock	4.6289	4.6411	4.5564	4.5868	138024264.0
2008-01-28 15:30:00	AAPL	Stock	4.5868	4.6429	4.5825	4.6429	127385804.0
2008-01-28 16:00:00	AAPL	Stock	4.6429	4.6755	4.6059	4.6375	45996132.0
2008-01-28 16:30:00	AAPL	Stock	4.6375	4.6639	4.6071	4.6214	2232748.0
2008-01-28 17:00:00	AAPL	Stock	4.6214	4.6357	4.6035	4.6179	342692.0
2008-01-28 17:30:00	AAPL	Stock	4.6246	4.625	4.6143	4.6196	375928.0
2008-01-28 18:00:00	AAPL	Stock	4.6179	4.6179	4.6071	4.6125	211988.0
2008-01-28 18:30:00	AAPL	Stock	4.6075	4.6089	4.6036	4.6043	427392.0
2008-01-28 19:00:00	AAPL	Stock	4.605	4.6175	4.605	4.6164	335496.0
2008-01-28 19:30:00	AAPL	Stock	4.6175	4.6225	4.6107	4.6175	184128.0
2008-01-28 07:00:00	MSFT	Stock	32.73	32.77	32.73	32.77	250.0
2008-01-28 07:30:00	MSFT	Stock	32.99	33.0	32.82	32.82	4750.0
2008-01-28 08:00:00	MSFT	Stock	32.89	32.92	32.69	32.85	55439.0
2008-01-28 08:30:00	MSFT	Stock	32.85	32.95	32.85	32.9	93444.0
2008-01-28 09:00:00	MSFT	Stock	32.91	33.04	32.9	32.97	268962.0
2008-01-28 09:30:00	MSFT	Stock	32.97	33.1	32.78	32.96	9778492.0
2008-01-28 10:00:00	MSFT	Stock	32.96	33.0	32.65	32.97	8645356.0
2008-01-28 10:30:00	MSFT	Stock	32.97	33.02	32.77	32.87	7406187.0
2008-01-28 11:00:00	MSFT	Stock	32.87	32.9	32.72	32.8	4938518.0
2008-01-28 11:30:00	MSFT	Stock	32.8	32.93	32.72	32.73	4666139.0
2008-01-28 12:00:00	MSFT	Stock	32.74	32.79	32.55	32.6	3946135.0
2008-01-28 12:30:00	MSFT	Stock	32.6	32.62	32.45	32.55	5420865.0
2008-01-28 13:00:00	MSFT	Stock	32.55	32.7	32.5	32.61	4444360.0
2008-01-28 13:30:00	MSFT	Stock	32.61	32.65	32.51	32.59	3006287.0
2008-01-28 14:00:00	MSFT	Stock	32.59	32.72	32.58	32.66	4348899.0
2008-01-28 14:30:00	MSFT	Stock	32.66	32.69	32.55	32.56	5333693.0
2008-01-28 15:00:00	MSFT	Stock	32.569	32.7	32.42	32.49	6056166.0
2008-01-28 15:30:00	MSFT	Stock	32.49	32.74	32.48	32.72	9253090.0
2008-01-28 16:00:00	MSFT	Stock	32.71	33.01	32.605	32.64	3256021.0
2008-01-28 16:30:00	MSFT	Stock	32.61	32.72	32.6	32.61	70811.0
2008-01-28 17:00:00	MSFT	Stock	32.61	32.72	32.61	32.72	8973.0
2008-01-28 17:30:00	MSFT	Stock	32.71	32.72	32.7	32.71	38500.0
2008-01-28 18:00:00	MSFT	Stock	32.7	32.71	32.7	32.7	7730.0

> showing 50 of 69,038 rows — these rows as CSV

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