PREVIEW / stock_30min / 2008-05-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-06.parquet
  size:    1.3 MB
  rows:    73,388
  symbols: 3,326

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-05-06 06:00:00	AAPL	Stock	6.6161	6.6161	6.6161	6.6161	5600.0
2008-05-06 06:30:00	AAPL	Stock	6.6143	6.6275	6.6143	6.6275	53200.0
2008-05-06 07:00:00	AAPL	Stock	6.6254	6.6329	6.6132	6.625	654192.0
2008-05-06 07:30:00	AAPL	Stock	6.6214	6.6225	6.5857	6.5857	454720.0
2008-05-06 08:00:00	AAPL	Stock	6.5925	6.6179	6.5754	6.61	2570176.0
2008-05-06 08:30:00	AAPL	Stock	6.6079	6.6336	6.6071	6.6107	3264268.0
2008-05-06 09:00:00	AAPL	Stock	6.6093	6.6093	6.5775	6.5936	4701088.0
2008-05-06 09:30:00	AAPL	Stock	6.5936	6.6157	6.5064	6.535	141060696.0
2008-05-06 10:00:00	AAPL	Stock	6.5346	6.5711	6.5286	6.5404	85925252.0
2008-05-06 10:30:00	AAPL	Stock	6.5404	6.5811	6.5279	6.5804	72675792.0
2008-05-06 11:00:00	AAPL	Stock	6.5796	6.5986	6.56	6.5768	59289216.0
2008-05-06 11:30:00	AAPL	Stock	6.5771	6.5982	6.5579	6.5982	37619148.0
2008-05-06 12:00:00	AAPL	Stock	6.5982	6.6518	6.5975	6.6357	85136660.0
2008-05-06 12:30:00	AAPL	Stock	6.6357	6.6429	6.6147	6.6357	45778852.0
2008-05-06 13:00:00	AAPL	Stock	6.6364	6.6411	6.6232	6.6332	32573240.0
2008-05-06 13:30:00	AAPL	Stock	6.6336	6.6564	6.625	6.6446	56294280.0
2008-05-06 14:00:00	AAPL	Stock	6.6444	6.6493	6.6168	6.6339	50150240.0
2008-05-06 14:30:00	AAPL	Stock	6.6336	6.67	6.6289	6.6621	63517916.0
2008-05-06 15:00:00	AAPL	Stock	6.6621	6.6829	6.6514	6.6532	73257800.0
2008-05-06 15:30:00	AAPL	Stock	6.6529	6.6714	6.6486	6.6636	71574776.0
2008-05-06 16:00:00	AAPL	Stock	6.6621	6.6889	6.6056	6.6786	10383240.0
2008-05-06 16:30:00	AAPL	Stock	6.6789	6.6875	6.6429	6.6629	6802516.0
2008-05-06 17:00:00	AAPL	Stock	6.6629	6.6629	6.606	6.6518	1003968.0
2008-05-06 17:30:00	AAPL	Stock	6.6482	6.6571	6.5657	6.6571	567896.0
2008-05-06 18:00:00	AAPL	Stock	6.6571	6.6668	6.6521	6.6521	158480.0
2008-05-06 18:30:00	AAPL	Stock	6.6521	6.6571	6.6486	6.6571	157416.0
2008-05-06 19:00:00	AAPL	Stock	6.655	6.655	6.6471	6.6536	155540.0
2008-05-06 19:30:00	AAPL	Stock	6.6571	6.6632	6.6571	6.6629	106372.0
2008-05-06 06:30:00	MSFT	Stock	29.1	29.1	29.1	29.1	200.0
2008-05-06 07:00:00	MSFT	Stock	29.1	29.18	29.08	29.18	1675.0
2008-05-06 07:30:00	MSFT	Stock	29.09	29.09	28.9	28.92	11821.0
2008-05-06 08:00:00	MSFT	Stock	28.9	29.2	28.9	29.04	88277.0
2008-05-06 08:30:00	MSFT	Stock	29.03	29.1	28.98	28.98	48750.0
2008-05-06 09:00:00	MSFT	Stock	29.0	29.07	28.93	29.0	294225.0
2008-05-06 09:30:00	MSFT	Stock	29.04	29.34	28.93	29.28	11207813.0
2008-05-06 10:00:00	MSFT	Stock	29.28	29.58	29.28	29.492	12694776.0
2008-05-06 10:30:00	MSFT	Stock	29.49	29.69	29.41	29.6	8373101.0
2008-05-06 11:00:00	MSFT	Stock	29.6	29.64	29.4	29.52	5644124.0
2008-05-06 11:30:00	MSFT	Stock	29.52	29.53	29.35	29.45	4399609.0
2008-05-06 12:00:00	MSFT	Stock	29.45	29.58	29.43	29.46	5480479.0
2008-05-06 12:30:00	MSFT	Stock	29.46	29.57	29.46	29.5	3739248.0
2008-05-06 13:00:00	MSFT	Stock	29.49	29.54	29.48	29.49	3603491.0
2008-05-06 13:30:00	MSFT	Stock	29.5	29.61	29.48	29.58	3964595.0
2008-05-06 14:00:00	MSFT	Stock	29.58	29.62	29.51	29.582	3401734.0
2008-05-06 14:30:00	MSFT	Stock	29.59	29.7	29.56	29.66	5862678.0
2008-05-06 15:00:00	MSFT	Stock	29.66	29.84	29.6	29.78	7134223.0
2008-05-06 15:30:00	MSFT	Stock	29.782	29.86	29.7	29.72	10119505.0
2008-05-06 16:00:00	MSFT	Stock	29.7	29.8	29.516	29.73	4498879.0
2008-05-06 16:30:00	MSFT	Stock	29.681	29.74	29.68	29.68	1233548.0
2008-05-06 17:00:00	MSFT	Stock	29.7	29.7	29.5	29.6	166645.0

> showing 50 of 73,388 rows — these rows as CSV

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