PREVIEW / stock_30min / 2010-03-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-18.parquet
  size:    1.4 MB
  rows:    73,013
  symbols: 3,467

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
2010-03-18 05:00:00	AAPL	Stock	7.9671	7.9821	7.9632	7.9821	8400.0
2010-03-18 05:30:00	AAPL	Stock	7.9911	7.9911	7.9911	7.9911	2800.0
2010-03-18 07:00:00	AAPL	Stock	7.9911	7.9911	7.9911	7.9911	2800.0
2010-03-18 07:30:00	AAPL	Stock	8.0232	8.0232	8.0029	8.0029	37100.0
2010-03-18 08:00:00	AAPL	Stock	8.0054	8.0071	7.9911	7.9989	335020.0
2010-03-18 08:30:00	AAPL	Stock	8.0005	8.0293	8.0005	8.0207	1025304.0
2010-03-18 09:00:00	AAPL	Stock	8.02	8.0229	8.0071	8.0079	812672.0
2010-03-18 09:30:00	AAPL	Stock	8.0071	8.015	7.9568	7.9657	54155752.0
2010-03-18 10:00:00	AAPL	Stock	7.9657	7.9904	7.9504	7.9746	43308888.0
2010-03-18 10:30:00	AAPL	Stock	7.975	7.9971	7.9661	7.9947	21849100.0
2010-03-18 11:00:00	AAPL	Stock	7.9946	8.0132	7.9905	8.0018	26442584.0
2010-03-18 11:30:00	AAPL	Stock	8.0007	8.0082	7.9757	7.9779	20787760.0
2010-03-18 12:00:00	AAPL	Stock	7.9771	7.9889	7.9618	7.9829	16882488.0
2010-03-18 12:30:00	AAPL	Stock	7.9825	7.9882	7.9732	7.9807	8258880.0
2010-03-18 13:00:00	AAPL	Stock	7.9818	7.9993	7.9807	7.9886	11488988.0
2010-03-18 13:30:00	AAPL	Stock	7.9886	7.9993	7.9811	7.9873	9291184.0
2010-03-18 14:00:00	AAPL	Stock	7.9879	7.9939	7.9807	7.9882	7813204.0
2010-03-18 14:30:00	AAPL	Stock	7.9875	7.9978	7.9679	7.985	17492916.0
2010-03-18 15:00:00	AAPL	Stock	7.9846	8.0121	7.9757	8.0054	26429564.0
2010-03-18 15:30:00	AAPL	Stock	8.0061	8.0357	8.0011	8.0268	65544248.0
2010-03-18 16:00:00	AAPL	Stock	8.0257	8.0339	7.9893	8.0268	5267584.0
2010-03-18 16:30:00	AAPL	Stock	8.0068	8.0364	8.0068	8.0357	488600.0
2010-03-18 17:00:00	AAPL	Stock	8.0379	8.0414	8.0304	8.0304	445732.0
2010-03-18 17:30:00	AAPL	Stock	8.03	8.0329	8.0232	8.0232	150024.0
2010-03-18 18:00:00	AAPL	Stock	8.025	8.0268	7.9964	8.0	749868.0
2010-03-18 18:30:00	AAPL	Stock	8.0	8.0061	7.9946	8.0061	258300.0
2010-03-18 19:00:00	AAPL	Stock	8.0064	8.0064	7.9964	7.9964	51044.0
2010-03-18 19:30:00	AAPL	Stock	7.9954	8.0004	7.9896	7.9932	223188.0
2010-03-18 07:00:00	MSFT	Stock	29.48	29.48	29.48	29.48	169.0
2010-03-18 07:30:00	MSFT	Stock	29.51	29.59	29.51	29.59	366.0
2010-03-18 08:00:00	MSFT	Stock	29.55	29.58	29.52	29.52	4865.0
2010-03-18 08:30:00	MSFT	Stock	29.53	29.64	29.53	29.6	13843.0
2010-03-18 09:00:00	MSFT	Stock	29.61	29.62	29.61	29.62	568.0
2010-03-18 09:30:00	MSFT	Stock	29.62	29.72	29.51	29.64	4844330.0
2010-03-18 10:00:00	MSFT	Stock	29.64	29.662	29.55	29.6	2610653.0
2010-03-18 10:30:00	MSFT	Stock	29.59	29.62	29.56	29.61	2397982.0
2010-03-18 11:00:00	MSFT	Stock	29.61	29.7	29.595	29.666	2382626.0
2010-03-18 11:30:00	MSFT	Stock	29.66	29.68	29.57	29.595	3773388.0
2010-03-18 12:00:00	MSFT	Stock	29.592	29.64	29.53	29.624	2601154.0
2010-03-18 12:30:00	MSFT	Stock	29.63	29.69	29.6	29.625	2167360.0
2010-03-18 13:00:00	MSFT	Stock	29.63	29.68	29.56	29.56	2735804.0
2010-03-18 13:30:00	MSFT	Stock	29.57	29.68	29.56	29.62	2443849.0
2010-03-18 14:00:00	MSFT	Stock	29.62	29.63	29.53	29.54	2602910.0
2010-03-18 14:30:00	MSFT	Stock	29.543	29.59	29.5	29.565	2906048.0
2010-03-18 15:00:00	MSFT	Stock	29.563	29.59	29.51	29.55	2471047.0
2010-03-18 15:30:00	MSFT	Stock	29.55	29.63	29.53	29.61	6119650.0
2010-03-18 16:00:00	MSFT	Stock	29.59	29.62	29.507	29.61	1572542.0
2010-03-18 16:30:00	MSFT	Stock	29.62	29.62	29.6	29.62	21165.0
2010-03-18 17:00:00	MSFT	Stock	29.63	29.63	29.59	29.59	910.0
2010-03-18 17:30:00	MSFT	Stock	29.61	29.61	29.56	29.57	19225.0

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

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