PREVIEW / stock_30min / 2008-05-13

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-13.parquet
  size:    1.2 MB
  rows:    68,765
  symbols: 3,301

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-13 05:00:00	AAPL	Stock	6.6993	6.6993	6.6993	6.6993	4200.0
2008-05-13 06:30:00	AAPL	Stock	6.7354	6.7354	6.7354	6.7354	2800.0
2008-05-13 07:00:00	AAPL	Stock	6.715	6.715	6.7089	6.7143	103600.0
2008-05-13 07:30:00	AAPL	Stock	6.7071	6.7071	6.6964	6.7036	69132.0
2008-05-13 08:00:00	AAPL	Stock	6.7093	6.7196	6.6989	6.7164	545328.0
2008-05-13 08:30:00	AAPL	Stock	6.7143	6.7357	6.7136	6.7346	2022552.0
2008-05-13 09:00:00	AAPL	Stock	6.7346	6.7496	6.7325	6.7361	2010400.0
2008-05-13 09:30:00	AAPL	Stock	6.7361	6.7729	6.7093	6.77	126552636.0
2008-05-13 10:00:00	AAPL	Stock	6.7704	6.8175	6.7529	6.8066	123238136.0
2008-05-13 10:30:00	AAPL	Stock	6.8061	6.8375	6.7696	6.7786	117537560.0
2008-05-13 11:00:00	AAPL	Stock	6.7796	6.7925	6.7618	6.7757	66607436.0
2008-05-13 11:30:00	AAPL	Stock	6.7746	6.7925	6.7661	6.7779	41748392.0
2008-05-13 12:00:00	AAPL	Stock	6.7782	6.8029	6.7696	6.7932	41774068.0
2008-05-13 12:30:00	AAPL	Stock	6.7939	6.8014	6.7825	6.7893	28496468.0
2008-05-13 13:00:00	AAPL	Stock	6.7896	6.8	6.7714	6.7889	29453060.0
2008-05-13 13:30:00	AAPL	Stock	6.7882	6.8111	6.7821	6.7968	31723188.0
2008-05-13 14:00:00	AAPL	Stock	6.7968	6.8196	6.7957	6.8046	37045400.0
2008-05-13 14:30:00	AAPL	Stock	6.8046	6.8096	6.79	6.8068	33605936.0
2008-05-13 15:00:00	AAPL	Stock	6.8068	6.8207	6.7779	6.79	55795880.0
2008-05-13 15:30:00	AAPL	Stock	6.79	6.7964	6.7793	6.7836	60202464.0
2008-05-13 16:00:00	AAPL	Stock	6.7318	6.7898	6.7318	6.7736	7034132.0
2008-05-13 16:30:00	AAPL	Stock	6.7718	6.7928	6.77	6.7732	484764.0
2008-05-13 17:00:00	AAPL	Stock	6.7732	6.7821	6.7714	6.7821	298116.0
2008-05-13 17:30:00	AAPL	Stock	6.7807	6.7857	6.7804	6.7857	191856.0
2008-05-13 18:00:00	AAPL	Stock	6.7829	6.7832	6.7807	6.7821	30296.0
2008-05-13 18:30:00	AAPL	Stock	6.7818	6.7857	6.7818	6.7832	37884.0
2008-05-13 19:00:00	AAPL	Stock	6.7857	6.7857	6.7857	6.7857	32396.0
2008-05-13 19:30:00	AAPL	Stock	6.7854	6.7889	6.7832	6.7832	67900.0
2008-05-13 20:00:00	AAPL	Stock	6.8314	6.8314	6.7796	6.7796	1362592.0
2008-05-13 08:00:00	MSFT	Stock	29.76	29.89	29.76	29.89	200.0
2008-05-13 08:30:00	MSFT	Stock	29.88	29.97	29.81	29.97	3361.0
2008-05-13 09:00:00	MSFT	Stock	29.88	30.03	29.88	30.0	271390.0
2008-05-13 09:30:00	MSFT	Stock	30.0	30.13	29.93	29.98	6345798.0
2008-05-13 10:00:00	MSFT	Stock	29.97	30.03	29.77	29.96	5260238.0
2008-05-13 10:30:00	MSFT	Stock	29.97	29.98	29.71	29.75	5716615.0
2008-05-13 11:00:00	MSFT	Stock	29.75	29.9	29.53	29.62	5730128.0
2008-05-13 11:30:00	MSFT	Stock	29.62	29.71	29.55	29.56	3148139.0
2008-05-13 12:00:00	MSFT	Stock	29.56	29.88	29.56	29.79	6647273.0
2008-05-13 12:30:00	MSFT	Stock	29.79	29.84	29.73	29.75	3663990.0
2008-05-13 13:00:00	MSFT	Stock	29.75	29.79	29.69	29.695	3159697.0
2008-05-13 13:30:00	MSFT	Stock	29.69	29.808	29.69	29.72	3406065.0
2008-05-13 14:00:00	MSFT	Stock	29.72	29.78	29.68	29.78	3579971.0
2008-05-13 14:30:00	MSFT	Stock	29.78	29.8	29.65	29.78	7072752.0
2008-05-13 15:00:00	MSFT	Stock	29.78	29.91	29.74	29.82	6470721.0
2008-05-13 15:30:00	MSFT	Stock	29.823	29.88	29.71	29.78	7214731.0
2008-05-13 16:00:00	MSFT	Stock	29.78	29.807	29.734	29.786	1389401.0
2008-05-13 16:30:00	MSFT	Stock	29.75	29.78	29.72	29.72	47110.0
2008-05-13 17:00:00	MSFT	Stock	29.78	29.78	29.72	29.78	7975.0
2008-05-13 17:30:00	MSFT	Stock	29.72	29.74	29.72	29.73	1600.0
2008-05-13 18:00:00	MSFT	Stock	29.74	29.74	29.72	29.72	3080.0

> showing 50 of 68,765 rows — these rows as CSV

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