PREVIEW / stock_30min / 2008-03-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-25.parquet
  size:    1.2 MB
  rows:    69,133
  symbols: 3,262

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-03-25 07:00:00	AAPL	Stock	4.9961	5.0036	4.9961	5.0036	36400.0
2008-03-25 07:30:00	AAPL	Stock	5.0007	5.0011	4.9893	4.9989	286916.0
2008-03-25 08:00:00	AAPL	Stock	4.9964	5.0121	4.9936	5.0068	1887060.0
2008-03-25 08:30:00	AAPL	Stock	5.0054	5.0068	4.9814	4.9814	1620080.0
2008-03-25 09:00:00	AAPL	Stock	4.9821	5.0	4.9782	4.9996	1524432.0
2008-03-25 09:30:00	AAPL	Stock	4.9986	5.0061	4.9368	4.9464	124728128.0
2008-03-25 10:00:00	AAPL	Stock	4.9471	4.9804	4.9046	4.9643	111841604.0
2008-03-25 10:30:00	AAPL	Stock	4.9646	4.9932	4.9507	4.975	78017940.0
2008-03-25 11:00:00	AAPL	Stock	4.9746	5.0193	4.9696	5.0029	84371504.0
2008-03-25 11:30:00	AAPL	Stock	5.0021	5.0071	4.9889	4.995	43264256.0
2008-03-25 12:00:00	AAPL	Stock	4.9946	5.015	4.9857	5.012	40168016.0
2008-03-25 12:30:00	AAPL	Stock	5.0093	5.0118	4.9939	4.9982	36438276.0
2008-03-25 13:00:00	AAPL	Stock	4.9984	5.0421	4.9939	5.0407	52186680.0
2008-03-25 13:30:00	AAPL	Stock	5.0407	5.0821	5.0394	5.0732	95436040.0
2008-03-25 14:00:00	AAPL	Stock	5.0736	5.0918	5.0575	5.075	74744432.0
2008-03-25 14:30:00	AAPL	Stock	5.0757	5.0875	5.0507	5.0875	67764508.0
2008-03-25 15:00:00	AAPL	Stock	5.0857	5.1107	5.0829	5.0943	92139852.0
2008-03-25 15:30:00	AAPL	Stock	5.0943	5.0971	5.0271	5.0325	101832584.0
2008-03-25 16:00:00	AAPL	Stock	5.0346	5.0725	4.9625	5.0232	11276132.0
2008-03-25 16:30:00	AAPL	Stock	5.0179	5.035	5.0164	5.0286	2900352.0
2008-03-25 17:00:00	AAPL	Stock	5.0246	5.0293	5.0218	5.0268	286832.0
2008-03-25 17:30:00	AAPL	Stock	5.0268	5.0293	5.025	5.0275	87892.0
2008-03-25 18:00:00	AAPL	Stock	5.0221	5.0268	5.0196	5.0268	36568.0
2008-03-25 18:30:00	AAPL	Stock	5.0264	5.0268	5.0179	5.0179	123060.0
2008-03-25 19:00:00	AAPL	Stock	5.0179	5.0189	5.0168	5.0186	44380.0
2008-03-25 19:30:00	AAPL	Stock	5.0179	5.0268	5.0161	5.0161	112252.0
2008-03-25 07:30:00	MSFT	Stock	29.27	29.27	29.27	29.27	400.0
2008-03-25 08:00:00	MSFT	Stock	29.27	29.38	29.27	29.27	10149.0
2008-03-25 08:30:00	MSFT	Stock	29.26	29.3	29.25	29.25	20650.0
2008-03-25 09:00:00	MSFT	Stock	29.22	29.36	29.2	29.36	86731.0
2008-03-25 09:30:00	MSFT	Stock	29.36	29.37	29.0	29.02	5816321.0
2008-03-25 10:00:00	MSFT	Stock	29.01	29.1	28.94	29.01	4924785.0
2008-03-25 10:30:00	MSFT	Stock	29.01	29.2	28.95	29.13	3741207.0
2008-03-25 11:00:00	MSFT	Stock	29.12	29.22	29.1	29.18	2498212.0
2008-03-25 11:30:00	MSFT	Stock	29.17	29.21	29.05	29.07	2271125.0
2008-03-25 12:00:00	MSFT	Stock	29.07	29.16	29.03	29.15	2486004.0
2008-03-25 12:30:00	MSFT	Stock	29.14	29.27	29.1	29.2	1934870.0
2008-03-25 13:00:00	MSFT	Stock	29.19	29.22	29.11	29.18	1885720.0
2008-03-25 13:30:00	MSFT	Stock	29.17	29.23	29.119	29.21	2340371.0
2008-03-25 14:00:00	MSFT	Stock	29.2	29.21	29.04	29.1	2449972.0
2008-03-25 14:30:00	MSFT	Stock	29.09	29.16	29.05	29.135	1795750.0
2008-03-25 15:00:00	MSFT	Stock	29.14	29.25	29.07	29.189	3047228.0
2008-03-25 15:30:00	MSFT	Stock	29.18	29.21	29.02	29.14	8127569.0
2008-03-25 16:00:00	MSFT	Stock	29.141	29.2	28.98	29.13	4057188.0
2008-03-25 16:30:00	MSFT	Stock	29.13	29.14	29.06	29.08	8168.0
2008-03-25 17:00:00	MSFT	Stock	29.003	29.06	29.003	29.06	17600.0
2008-03-25 17:30:00	MSFT	Stock	29.05	29.163	29.01	29.05	4619.0
2008-03-25 18:00:00	MSFT	Stock	29.05	29.08	29.05	29.06	21600.0
2008-03-25 18:30:00	MSFT	Stock	29.06	29.07	29.06	29.07	2400.0
2008-03-25 19:00:00	MSFT	Stock	29.07	29.07	29.07	29.07	512.0

> showing 50 of 69,133 rows — these rows as CSV

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