PREVIEW / stock_30min / 2010-10-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-14.parquet
  size:    1.4 MB
  rows:    74,331
  symbols: 3,479

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-10-14 04:00:00	AAPL	Stock	10.7582	10.7582	10.7582	10.7582	14000.0
2010-10-14 05:00:00	AAPL	Stock	10.75	10.75	10.75	10.75	5600.0
2010-10-14 05:30:00	AAPL	Stock	10.7425	10.7425	10.7425	10.7425	2800.0
2010-10-14 06:30:00	AAPL	Stock	10.7286	10.7386	10.7286	10.7386	8400.0
2010-10-14 07:00:00	AAPL	Stock	10.75	10.7571	10.7421	10.7521	79436.0
2010-10-14 07:30:00	AAPL	Stock	10.7521	10.7632	10.7521	10.7586	203000.0
2010-10-14 08:00:00	AAPL	Stock	10.7536	10.7582	10.7357	10.7561	1129492.0
2010-10-14 08:30:00	AAPL	Stock	10.7561	10.8261	10.735	10.7968	10262952.0
2010-10-14 09:00:00	AAPL	Stock	10.7954	10.7968	10.75	10.7625	3231788.0
2010-10-14 09:30:00	AAPL	Stock	10.7636	10.79	10.7286	10.74	85596224.0
2010-10-14 10:00:00	AAPL	Stock	10.74	10.7932	10.7357	10.7806	44780736.0
2010-10-14 10:30:00	AAPL	Stock	10.7796	10.8025	10.775	10.7914	26800116.0
2010-10-14 11:00:00	AAPL	Stock	10.7918	10.7964	10.7661	10.7782	24803604.0
2010-10-14 11:30:00	AAPL	Stock	10.7786	10.7814	10.7625	10.775	27934228.0
2010-10-14 12:00:00	AAPL	Stock	10.7743	10.7857	10.7571	10.7632	18930184.0
2010-10-14 12:30:00	AAPL	Stock	10.7632	10.7718	10.7457	10.7629	20123712.0
2010-10-14 13:00:00	AAPL	Stock	10.7639	10.7643	10.7329	10.7561	27706756.0
2010-10-14 13:30:00	AAPL	Stock	10.7564	10.7743	10.7486	10.7707	18893140.0
2010-10-14 14:00:00	AAPL	Stock	10.7693	10.7707	10.7507	10.7518	12918304.0
2010-10-14 14:30:00	AAPL	Stock	10.7518	10.7589	10.7429	10.7479	19172160.0
2010-10-14 15:00:00	AAPL	Stock	10.7482	10.7714	10.7375	10.7629	23636788.0
2010-10-14 15:30:00	AAPL	Stock	10.7632	10.7964	10.7629	10.7954	41117300.0
2010-10-14 16:00:00	AAPL	Stock	10.7946	10.8836	10.7685	10.8825	16234512.0
2010-10-14 16:30:00	AAPL	Stock	10.8836	10.9071	10.7193	10.9014	3958108.0
2010-10-14 17:00:00	AAPL	Stock	10.7844	10.905	10.7653	10.8804	1360268.0
2010-10-14 17:30:00	AAPL	Stock	10.8807	10.8868	10.8786	10.8868	393036.0
2010-10-14 18:00:00	AAPL	Stock	10.885	10.885	10.7968	10.8821	715540.0
2010-10-14 18:30:00	AAPL	Stock	10.8829	10.8839	10.8664	10.8732	428736.0
2010-10-14 19:00:00	AAPL	Stock	10.8736	10.8811	10.8736	10.8811	137452.0
2010-10-14 19:30:00	AAPL	Stock	10.8814	10.8821	10.8707	10.8807	337568.0
2010-10-14 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	500.0
2010-10-14 05:30:00	MSFT	Stock	25.4	25.4	25.37	25.37	1000.0
2010-10-14 06:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	500.0
2010-10-14 07:00:00	MSFT	Stock	25.4	25.4	25.36	25.37	2800.0
2010-10-14 07:30:00	MSFT	Stock	25.39	25.4	25.35	25.35	5400.0
2010-10-14 08:00:00	MSFT	Stock	25.34	25.35	25.33	25.34	32440.0
2010-10-14 08:30:00	MSFT	Stock	25.34	25.38	25.13	25.14	46459.0
2010-10-14 09:00:00	MSFT	Stock	25.14	25.29	25.1	25.27	266043.0
2010-10-14 09:30:00	MSFT	Stock	25.27	25.34	25.08	25.086	7069034.0
2010-10-14 10:00:00	MSFT	Stock	25.09	25.22	25.05	25.202	4231594.0
2010-10-14 10:30:00	MSFT	Stock	25.21	25.23	25.17	25.21	2047872.0
2010-10-14 11:00:00	MSFT	Stock	25.21	25.22	25.13	25.17	2058753.0
2010-10-14 11:30:00	MSFT	Stock	25.18	25.21	25.13	25.141	2778518.0
2010-10-14 12:00:00	MSFT	Stock	25.142	25.18	25.07	25.085	1977641.0
2010-10-14 12:30:00	MSFT	Stock	25.09	25.13	25.06	25.123	2257355.0
2010-10-14 13:00:00	MSFT	Stock	25.125	25.13	25.0	25.095	3178171.0
2010-10-14 13:30:00	MSFT	Stock	25.1	25.23	25.09	25.215	3571463.0
2010-10-14 14:00:00	MSFT	Stock	25.22	25.22	25.11	25.122	3644934.0
2010-10-14 14:30:00	MSFT	Stock	25.12	25.16	25.03	25.05	3406744.0
2010-10-14 15:00:00	MSFT	Stock	25.04	25.16	25.02	25.13	2678483.0

> showing 50 of 74,331 rows — these rows as CSV

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