PREVIEW / stock_30min / 2008-01-04

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-04.parquet
  size:    1.3 MB
  rows:    71,462
  symbols: 3,260

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-04 04:00:00	AAPL	Stock	6.9957	6.9993	6.9814	6.9993	42000.0
2008-01-04 05:00:00	AAPL	Stock	7.0211	7.0446	7.0211	7.0446	44800.0
2008-01-04 05:30:00	AAPL	Stock	7.0482	7.0482	7.0425	7.0471	22400.0
2008-01-04 06:00:00	AAPL	Stock	7.0375	7.0375	7.0357	7.0357	54292.0
2008-01-04 06:30:00	AAPL	Stock	7.0296	7.035	7.0268	7.035	8400.0
2008-01-04 07:00:00	AAPL	Stock	7.0179	7.0179	6.9957	7.0036	110320.0
2008-01-04 07:30:00	AAPL	Stock	6.9957	7.0	6.9946	6.9946	180320.0
2008-01-04 08:00:00	AAPL	Stock	6.9946	6.9996	6.9464	6.9643	3539676.0
2008-01-04 08:30:00	AAPL	Stock	6.9575	6.9646	6.8214	6.8321	10110436.0
2008-01-04 09:00:00	AAPL	Stock	6.8375	6.85	6.7971	6.8382	6137740.0
2008-01-04 09:30:00	AAPL	Stock	6.8371	6.8929	6.7629	6.8289	173095076.0
2008-01-04 10:00:00	AAPL	Stock	6.8291	6.8446	6.7714	6.7811	97188336.0
2008-01-04 10:30:00	AAPL	Stock	6.7818	6.7979	6.7357	6.7518	98172788.0
2008-01-04 11:00:00	AAPL	Stock	6.7507	6.7689	6.7143	6.7679	105672308.0
2008-01-04 11:30:00	AAPL	Stock	6.7675	6.7771	6.7329	6.7446	58061892.0
2008-01-04 12:00:00	AAPL	Stock	6.7446	6.7821	6.7343	6.7393	55838188.0
2008-01-04 12:30:00	AAPL	Stock	6.7396	6.755	6.7143	6.7211	47292140.0
2008-01-04 13:00:00	AAPL	Stock	6.7204	6.7214	6.6696	6.6836	71466416.0
2008-01-04 13:30:00	AAPL	Stock	6.6836	6.7121	6.6607	6.6961	67675524.0
2008-01-04 14:00:00	AAPL	Stock	6.6961	6.6996	6.6204	6.6257	87047688.0
2008-01-04 14:30:00	AAPL	Stock	6.6264	6.6354	6.5271	6.5793	153704236.0
2008-01-04 15:00:00	AAPL	Stock	6.5804	6.5814	6.5	6.5293	147561008.0
2008-01-04 15:30:00	AAPL	Stock	6.5293	6.5511	6.3889	6.4261	248725484.0
2008-01-04 16:00:00	AAPL	Stock	6.4257	6.8226	6.4204	6.6604	20266036.0
2008-01-04 16:30:00	AAPL	Stock	6.4329	6.6604	6.4236	6.4236	1183952.0
2008-01-04 17:00:00	AAPL	Stock	6.4261	6.4286	6.4125	6.4179	1150100.0
2008-01-04 17:30:00	AAPL	Stock	6.4207	6.4232	6.4143	6.4196	492380.0
2008-01-04 18:00:00	AAPL	Stock	6.4239	6.4261	6.4182	6.4261	293468.0
2008-01-04 18:30:00	AAPL	Stock	6.4282	6.4304	6.4239	6.4304	218792.0
2008-01-04 19:00:00	AAPL	Stock	6.4318	6.4321	6.425	6.4286	251104.0
2008-01-04 19:30:00	AAPL	Stock	6.4286	6.4321	6.4246	6.43	224812.0
2008-01-04 08:00:00	MSFT	Stock	35.5	35.5	35.37	35.47	260700.0
2008-01-04 08:30:00	MSFT	Stock	35.31	35.38	34.95	34.96	15069.0
2008-01-04 09:00:00	MSFT	Stock	34.96	35.22	34.9	35.22	133521.0
2008-01-04 09:30:00	MSFT	Stock	35.22	35.22	34.83	35.05	5807025.0
2008-01-04 10:00:00	MSFT	Stock	35.05	35.15	34.93	34.95	4639849.0
2008-01-04 10:30:00	MSFT	Stock	34.96	34.96	34.28	34.28	7404752.0
2008-01-04 11:00:00	MSFT	Stock	34.29	34.4	34.09	34.35	8115523.0
2008-01-04 11:30:00	MSFT	Stock	34.36	34.44	34.27	34.44	4561910.0
2008-01-04 12:00:00	MSFT	Stock	34.44	34.69	34.43	34.51	4327979.0
2008-01-04 12:30:00	MSFT	Stock	34.51	34.56	34.4	34.46	2579531.0
2008-01-04 13:00:00	MSFT	Stock	34.47	34.54	34.35	34.42	2682988.0
2008-01-04 13:30:00	MSFT	Stock	34.42	34.58	34.22	34.51	4096717.0
2008-01-04 14:00:00	MSFT	Stock	34.5	34.51	34.23	34.25	3165403.0
2008-01-04 14:30:00	MSFT	Stock	34.25	34.3	34.11	34.29	4667967.0
2008-01-04 15:00:00	MSFT	Stock	34.29	34.38	34.17	34.32	5538872.0
2008-01-04 15:30:00	MSFT	Stock	34.32	34.46	34.26	34.36	10190695.0
2008-01-04 16:00:00	MSFT	Stock	34.34	35.054	34.34	34.43	3577052.0
2008-01-04 16:30:00	MSFT	Stock	34.38	34.45	34.34	34.45	93068.0
2008-01-04 17:00:00	MSFT	Stock	34.48	34.48	34.34	34.35	27764.0

> showing 50 of 71,462 rows — these rows as CSV

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