PREVIEW / stock_30min / 2010-06-30

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-30.parquet
  size:    1.4 MB
  rows:    76,408
  symbols: 3,483

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-06-30 04:00:00	AAPL	Stock	9.2139	9.2139	9.2139	9.2139	2800.0
2010-06-30 05:00:00	AAPL	Stock	9.1782	9.2493	9.1782	9.2493	38948.0
2010-06-30 05:30:00	AAPL	Stock	9.2493	9.2493	9.2493	9.2493	11592.0
2010-06-30 06:00:00	AAPL	Stock	9.2489	9.2493	9.2489	9.2493	18956.0
2010-06-30 06:30:00	AAPL	Stock	9.2286	9.2286	9.2264	9.2264	28000.0
2010-06-30 07:00:00	AAPL	Stock	9.2264	9.2661	9.2189	9.25	478716.0
2010-06-30 07:30:00	AAPL	Stock	9.2493	9.25	9.2093	9.2093	229488.0
2010-06-30 08:00:00	AAPL	Stock	9.2143	9.2286	9.1839	9.2071	3195948.0
2010-06-30 08:30:00	AAPL	Stock	9.205	9.2071	9.1518	9.1589	2152640.0
2010-06-30 09:00:00	AAPL	Stock	9.1589	9.1768	9.1225	9.1657	1885884.0
2010-06-30 09:30:00	AAPL	Stock	9.1682	9.1921	9.0825	9.1264	142632336.0
2010-06-30 10:00:00	AAPL	Stock	9.1264	9.2132	9.11	9.1407	84301560.0
2010-06-30 10:30:00	AAPL	Stock	9.14	9.1836	9.1036	9.1093	53157272.0
2010-06-30 11:00:00	AAPL	Stock	9.1093	9.1911	9.1048	9.1686	43362256.0
2010-06-30 11:30:00	AAPL	Stock	9.1696	9.1964	9.1646	9.1714	28938756.0
2010-06-30 12:00:00	AAPL	Stock	9.1711	9.2025	9.165	9.187	20364568.0
2010-06-30 12:30:00	AAPL	Stock	9.1889	9.1939	9.1439	9.1629	24549476.0
2010-06-30 13:00:00	AAPL	Stock	9.1626	9.1786	9.1393	9.1475	22581636.0
2010-06-30 13:30:00	AAPL	Stock	9.1471	9.1607	9.13	9.1379	19689348.0
2010-06-30 14:00:00	AAPL	Stock	9.1379	9.1539	9.1082	9.1179	32489268.0
2010-06-30 14:30:00	AAPL	Stock	9.1171	9.1357	9.0996	9.1143	30743580.0
2010-06-30 15:00:00	AAPL	Stock	9.1143	9.1261	9.0861	9.09	41003060.0
2010-06-30 15:30:00	AAPL	Stock	9.0901	9.1775	8.9289	8.9836	146286812.0
2010-06-30 16:00:00	AAPL	Stock	8.9818	9.1777	8.9614	8.9825	27591816.0
2010-06-30 16:30:00	AAPL	Stock	8.9821	9.0877	8.9743	8.9807	1403836.0
2010-06-30 17:00:00	AAPL	Stock	9.1342	9.1342	8.9696	8.98	1350664.0
2010-06-30 17:30:00	AAPL	Stock	8.9796	8.98	8.9714	8.9796	252224.0
2010-06-30 18:00:00	AAPL	Stock	8.9764	8.9804	8.9714	8.9714	185892.0
2010-06-30 18:30:00	AAPL	Stock	8.9714	8.9807	8.9714	8.975	197596.0
2010-06-30 19:00:00	AAPL	Stock	8.98	8.9832	8.9736	8.9786	227920.0
2010-06-30 19:30:00	AAPL	Stock	8.9807	8.9911	8.9754	8.9893	414148.0
2010-06-30 20:00:00	AAPL	Stock	9.175	9.175	9.175	9.175	2800.0
2010-06-30 04:30:00	MSFT	Stock	23.5	23.5	23.5	23.5	450.0
2010-06-30 05:30:00	MSFT	Stock	23.58	23.58	23.57	23.57	865.0
2010-06-30 06:00:00	MSFT	Stock	23.58	23.61	23.58	23.61	1205.0
2010-06-30 06:30:00	MSFT	Stock	23.55	23.6	23.55	23.6	300.0
2010-06-30 07:00:00	MSFT	Stock	23.47	23.55	23.47	23.54	4877.0
2010-06-30 07:30:00	MSFT	Stock	23.5	23.54	23.49	23.49	3975.0
2010-06-30 08:00:00	MSFT	Stock	23.46	23.52	23.4	23.42	70193.0
2010-06-30 08:30:00	MSFT	Stock	23.4	23.53	23.4	23.43	38108.0
2010-06-30 09:00:00	MSFT	Stock	23.41	23.42	23.24	23.24	87668.0
2010-06-30 09:30:00	MSFT	Stock	23.24	23.49	23.22	23.351	8759661.0
2010-06-30 10:00:00	MSFT	Stock	23.36	23.5	23.34	23.42	5230574.0
2010-06-30 10:30:00	MSFT	Stock	23.41	23.49	23.4	23.44	6501777.0
2010-06-30 11:00:00	MSFT	Stock	23.46	23.62	23.44	23.57	4733605.0
2010-06-30 11:30:00	MSFT	Stock	23.571	23.65	23.57	23.6	3325097.0
2010-06-30 12:00:00	MSFT	Stock	23.61	23.68	23.59	23.62	2009448.0
2010-06-30 12:30:00	MSFT	Stock	23.615	23.62	23.49	23.54	2960457.0
2010-06-30 13:00:00	MSFT	Stock	23.55	23.63	23.46	23.556	3196186.0
2010-06-30 13:30:00	MSFT	Stock	23.56	23.579	23.44	23.515	3334335.0

> showing 50 of 76,408 rows — these rows as CSV

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