PREVIEW / stock_30min / 2009-06-10

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-10.parquet
  size:    1.3 MB
  rows:    73,933
  symbols: 3,349

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
2009-06-10 04:00:00	AAPL	Stock	5.1304	5.1425	5.1304	5.1425	11956.0
2009-06-10 05:00:00	AAPL	Stock	5.1318	5.1318	5.1318	5.1318	2800.0
2009-06-10 05:30:00	AAPL	Stock	5.1421	5.1421	5.1421	5.1421	2800.0
2009-06-10 06:30:00	AAPL	Stock	5.1425	5.1425	5.1425	5.1425	2800.0
2009-06-10 07:00:00	AAPL	Stock	5.1425	5.1507	5.1357	5.1507	205380.0
2009-06-10 07:30:00	AAPL	Stock	5.1446	5.1446	5.1079	5.1086	151564.0
2009-06-10 08:00:00	AAPL	Stock	5.1196	5.12	5.0839	5.1179	1111712.0
2009-06-10 08:30:00	AAPL	Stock	5.1179	5.1189	5.0932	5.1064	923720.0
2009-06-10 09:00:00	AAPL	Stock	5.1039	5.1071	5.0714	5.0836	1975148.0
2009-06-10 09:30:00	AAPL	Stock	5.0843	5.0868	4.9964	5.0214	111316380.0
2009-06-10 10:00:00	AAPL	Stock	5.0212	5.0268	4.9689	4.98	83590360.0
2009-06-10 10:30:00	AAPL	Stock	4.98	4.9875	4.96	4.9625	55138664.0
2009-06-10 11:00:00	AAPL	Stock	4.9625	4.9768	4.9393	4.9648	66674384.0
2009-06-10 11:30:00	AAPL	Stock	4.9652	4.9836	4.9575	4.9594	30492504.0
2009-06-10 12:00:00	AAPL	Stock	4.9586	4.9854	4.9536	4.97	34937840.0
2009-06-10 12:30:00	AAPL	Stock	4.97	4.9732	4.9521	4.9557	28392840.0
2009-06-10 13:00:00	AAPL	Stock	4.9557	4.96	4.9446	4.9554	28268940.0
2009-06-10 13:30:00	AAPL	Stock	4.955	4.962	4.945	4.96	27262088.0
2009-06-10 14:00:00	AAPL	Stock	4.96	4.9604	4.945	4.9546	31625720.0
2009-06-10 14:30:00	AAPL	Stock	4.9546	4.9775	4.9479	4.9686	38168144.0
2009-06-10 15:00:00	AAPL	Stock	4.9682	4.9686	4.9482	4.9504	30637124.0
2009-06-10 15:30:00	AAPL	Stock	4.9507	5.0125	4.95	5.0071	81196416.0
2009-06-10 16:00:00	AAPL	Stock	5.0075	5.0143	4.9556	5.0089	20655152.0
2009-06-10 16:30:00	AAPL	Stock	5.0089	5.0089	4.986	5.0061	4358088.0
2009-06-10 17:00:00	AAPL	Stock	5.0043	5.0089	4.9982	4.9982	293468.0
2009-06-10 17:30:00	AAPL	Stock	4.9964	5.0032	4.9893	4.9968	181048.0
2009-06-10 18:00:00	AAPL	Stock	5.0	5.0089	5.0	5.0054	738444.0
2009-06-10 18:30:00	AAPL	Stock	5.0039	5.0068	5.0039	5.005	13664.0
2009-06-10 19:00:00	AAPL	Stock	5.0068	5.0086	5.0039	5.0039	73500.0
2009-06-10 19:30:00	AAPL	Stock	5.0036	5.0036	5.0021	5.0036	39564.0
2009-06-10 05:30:00	MSFT	Stock	22.32	22.32	22.32	22.32	200.0
2009-06-10 07:00:00	MSFT	Stock	22.33	22.33	22.3	22.3	200.0
2009-06-10 08:00:00	MSFT	Stock	22.25	22.29	22.18	22.25	20827.0
2009-06-10 08:30:00	MSFT	Stock	22.23	22.23	22.17	22.18	6546.0
2009-06-10 09:00:00	MSFT	Stock	22.17	22.2	22.14	22.14	10176.0
2009-06-10 09:30:00	MSFT	Stock	22.17	22.3	22.12	22.28	4945009.0
2009-06-10 10:00:00	MSFT	Stock	22.28	22.31	22.2	22.27	4629998.0
2009-06-10 10:30:00	MSFT	Stock	22.27	22.28	22.22	22.25	2964354.0
2009-06-10 11:00:00	MSFT	Stock	22.24	22.28	22.15	22.23	4844253.0
2009-06-10 11:30:00	MSFT	Stock	22.232	22.27	22.19	22.221	2009609.0
2009-06-10 12:00:00	MSFT	Stock	22.22	22.37	22.22	22.31	2593490.0
2009-06-10 12:30:00	MSFT	Stock	22.3	22.36	22.25	22.351	1802403.0
2009-06-10 13:00:00	MSFT	Stock	22.35	22.37	22.23	22.267	3847745.0
2009-06-10 13:30:00	MSFT	Stock	22.27	22.32	22.23	22.26	4760441.0
2009-06-10 14:00:00	MSFT	Stock	22.26	22.3	22.13	22.28	3955629.0
2009-06-10 14:30:00	MSFT	Stock	22.28	22.44	22.24	22.41	3125340.0
2009-06-10 15:00:00	MSFT	Stock	22.415	22.44	22.32	22.4	4494655.0
2009-06-10 15:30:00	MSFT	Stock	22.4	22.62	22.39	22.56	11433222.0
2009-06-10 16:00:00	MSFT	Stock	22.56	22.62	22.254	22.55	3007428.0
2009-06-10 16:30:00	MSFT	Stock	22.55	22.59	22.336	22.58	700541.0

> showing 50 of 73,933 rows — these rows as CSV

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