PREVIEW / stock_30min / 2008-05-28

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-28.parquet
  size:    1.2 MB
  rows:    68,843
  symbols: 3,302

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-28 07:00:00	AAPL	Stock	6.675	6.6893	6.675	6.6786	21112.0
2008-05-28 07:30:00	AAPL	Stock	6.6786	6.6961	6.6786	6.6929	305480.0
2008-05-28 08:00:00	AAPL	Stock	6.6964	6.7	6.6761	6.6825	2937564.0
2008-05-28 08:30:00	AAPL	Stock	6.6829	6.7136	6.6825	6.7086	3606484.0
2008-05-28 09:00:00	AAPL	Stock	6.7064	6.7125	6.6857	6.6932	3717924.0
2008-05-28 09:30:00	AAPL	Stock	6.6932	6.7125	6.6386	6.6489	140286748.0
2008-05-28 10:00:00	AAPL	Stock	6.6493	6.6725	6.6275	6.6504	78200696.0
2008-05-28 10:30:00	AAPL	Stock	6.6504	6.6643	6.6161	6.6429	55381704.0
2008-05-28 11:00:00	AAPL	Stock	6.6421	6.6464	6.5826	6.5864	56255696.0
2008-05-28 11:30:00	AAPL	Stock	6.5875	6.6211	6.5796	6.5961	39856432.0
2008-05-28 12:00:00	AAPL	Stock	6.5954	6.6071	6.5614	6.6057	55634012.0
2008-05-28 12:30:00	AAPL	Stock	6.6061	6.62	6.5804	6.6146	27725208.0
2008-05-28 13:00:00	AAPL	Stock	6.6154	6.6518	6.6082	6.6482	41870724.0
2008-05-28 13:30:00	AAPL	Stock	6.6479	6.6511	6.6121	6.6193	37598960.0
2008-05-28 14:00:00	AAPL	Stock	6.6193	6.6339	6.6025	6.6089	30762088.0
2008-05-28 14:30:00	AAPL	Stock	6.6093	6.6582	6.6071	6.6339	43574636.0
2008-05-28 15:00:00	AAPL	Stock	6.6339	6.6518	6.6236	6.6493	39560696.0
2008-05-28 15:30:00	AAPL	Stock	6.6489	6.6807	6.6471	6.6786	70043204.0
2008-05-28 16:00:00	AAPL	Stock	6.6786	6.685	6.6394	6.6807	7000532.0
2008-05-28 16:30:00	AAPL	Stock	6.68	6.6804	6.6725	6.6732	260260.0
2008-05-28 17:00:00	AAPL	Stock	6.6732	6.6761	6.6661	6.6746	186312.0
2008-05-28 17:30:00	AAPL	Stock	6.6696	6.6804	6.6386	6.6796	184828.0
2008-05-28 18:00:00	AAPL	Stock	6.6786	6.6804	6.675	6.6786	109424.0
2008-05-28 18:30:00	AAPL	Stock	6.6786	6.68	6.6786	6.6789	66976.0
2008-05-28 19:00:00	AAPL	Stock	6.6804	6.6804	6.6789	6.6789	165200.0
2008-05-28 19:30:00	AAPL	Stock	6.6789	6.6804	6.6786	6.6789	134428.0
2008-05-28 08:00:00	MSFT	Stock	28.45	28.58	28.45	28.56	16480.0
2008-05-28 08:30:00	MSFT	Stock	28.55	28.61	28.55	28.58	23795.0
2008-05-28 09:00:00	MSFT	Stock	28.58	28.6	28.55	28.55	19465.0
2008-05-28 09:30:00	MSFT	Stock	28.55	28.57	28.27	28.39	4954111.0
2008-05-28 10:00:00	MSFT	Stock	28.388	28.4	28.09	28.19	4339620.0
2008-05-28 10:30:00	MSFT	Stock	28.19	28.32	28.18	28.28	2827638.0
2008-05-28 11:00:00	MSFT	Stock	28.29	28.33	28.17	28.19	2509523.0
2008-05-28 11:30:00	MSFT	Stock	28.2	28.24	28.14	28.14	2673247.0
2008-05-28 12:00:00	MSFT	Stock	28.144	28.144	28.05	28.07	3925094.0
2008-05-28 12:30:00	MSFT	Stock	28.07	28.14	28.04	28.08	3574095.0
2008-05-28 13:00:00	MSFT	Stock	28.08	28.15	28.07	28.12	2483410.0
2008-05-28 13:30:00	MSFT	Stock	28.13	28.16	28.04	28.09	2694173.0
2008-05-28 14:00:00	MSFT	Stock	28.08	28.16	28.05	28.082	3130610.0
2008-05-28 14:30:00	MSFT	Stock	28.08	28.15	28.06	28.07	2642252.0
2008-05-28 15:00:00	MSFT	Stock	28.08	28.14	28.07	28.1	4294468.0
2008-05-28 15:30:00	MSFT	Stock	28.1	28.22	28.08	28.21	7600826.0
2008-05-28 16:00:00	MSFT	Stock	28.18	28.23	28.086	28.18	1733108.0
2008-05-28 16:30:00	MSFT	Stock	28.22	28.23	28.14	28.2	31142.0
2008-05-28 17:00:00	MSFT	Stock	28.2	28.3	28.2	28.28	69950.0
2008-05-28 17:30:00	MSFT	Stock	28.27	28.27	28.084	28.25	10750.0
2008-05-28 18:00:00	MSFT	Stock	28.25	28.25	28.2	28.2	267352.0
2008-05-28 18:30:00	MSFT	Stock	28.2	28.25	28.2	28.25	1250.0
2008-05-28 19:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	400.0
2008-05-28 19:30:00	MSFT	Stock	28.2	28.24	28.2	28.24	500.0

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

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