PREVIEW / stock_30min / 2011-05-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-23.parquet
  size:    1.4 MB
  rows:    77,142
  symbols: 3,530

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
2011-05-23 04:00:00	AAPL	Stock	11.8736	11.875	11.8571	11.8571	8540.0
2011-05-23 04:30:00	AAPL	Stock	11.8575	11.8589	11.85	11.85	19600.0
2011-05-23 05:00:00	AAPL	Stock	11.85	11.8536	11.8393	11.8429	43400.0
2011-05-23 05:30:00	AAPL	Stock	11.85	11.8536	11.85	11.8536	14560.0
2011-05-23 06:00:00	AAPL	Stock	11.8539	11.8539	11.8539	11.8539	4760.0
2011-05-23 06:30:00	AAPL	Stock	11.8679	11.8679	11.8607	11.8607	33600.0
2011-05-23 07:00:00	AAPL	Stock	11.8679	11.8793	11.8571	11.8793	119812.0
2011-05-23 07:30:00	AAPL	Stock	11.8643	11.8743	11.85	11.8571	260540.0
2011-05-23 08:00:00	AAPL	Stock	11.8579	11.8686	11.8271	11.83	1063580.0
2011-05-23 08:30:00	AAPL	Stock	11.83	11.8393	11.8214	11.8346	815444.0
2011-05-23 09:00:00	AAPL	Stock	11.8329	11.8329	11.78	11.7839	2083732.0
2011-05-23 09:30:00	AAPL	Stock	11.7846	11.8679	11.765	11.8264	79677192.0
2011-05-23 10:00:00	AAPL	Stock	11.8282	11.8679	11.8036	11.8504	32318524.0
2011-05-23 10:30:00	AAPL	Stock	11.8504	11.8832	11.8339	11.8479	30682904.0
2011-05-23 11:00:00	AAPL	Stock	11.8504	11.8664	11.8346	11.8407	19405232.0
2011-05-23 11:30:00	AAPL	Stock	11.8411	11.9032	11.8289	11.87	24470740.0
2011-05-23 12:00:00	AAPL	Stock	11.8694	11.8914	11.8479	11.8914	18361028.0
2011-05-23 12:30:00	AAPL	Stock	11.8914	11.91	11.8696	11.9075	16678816.0
2011-05-23 13:00:00	AAPL	Stock	11.9071	11.9196	11.89	11.8996	14786856.0
2011-05-23 13:30:00	AAPL	Stock	11.8986	11.9049	11.875	11.9011	14055020.0
2011-05-23 14:00:00	AAPL	Stock	11.9007	11.9721	11.8964	11.965	27207852.0
2011-05-23 14:30:00	AAPL	Stock	11.9646	11.9929	11.9571	11.9696	27163724.0
2011-05-23 15:00:00	AAPL	Stock	11.9696	11.9993	11.9482	11.9575	27389712.0
2011-05-23 15:30:00	AAPL	Stock	11.9577	11.9632	11.9179	11.9429	33413856.0
2011-05-23 16:00:00	AAPL	Stock	11.9432	11.9721	11.8817	11.9429	6135920.0
2011-05-23 16:30:00	AAPL	Stock	11.9405	11.9588	11.8344	11.9518	853860.0
2011-05-23 17:00:00	AAPL	Stock	11.9464	11.9482	11.9464	11.9482	32200.0
2011-05-23 17:30:00	AAPL	Stock	11.9468	11.9468	11.9464	11.9464	19600.0
2011-05-23 18:00:00	AAPL	Stock	11.9468	11.9468	11.9429	11.9439	77728.0
2011-05-23 18:30:00	AAPL	Stock	11.9439	11.9464	11.9439	11.9464	13160.0
2011-05-23 19:00:00	AAPL	Stock	11.9446	11.9496	11.9446	11.9446	175476.0
2011-05-23 19:30:00	AAPL	Stock	11.9446	11.9464	11.9439	11.9464	58800.0
2011-05-23 05:30:00	MSFT	Stock	24.38	24.38	24.38	24.38	200.0
2011-05-23 06:30:00	MSFT	Stock	24.25	24.25	24.25	24.25	100.0
2011-05-23 07:30:00	MSFT	Stock	24.37	24.37	24.26	24.29	1100.0
2011-05-23 08:00:00	MSFT	Stock	24.35	24.36	24.26	24.26	8016.0
2011-05-23 08:30:00	MSFT	Stock	24.27	24.27	24.25	24.26	16713.0
2011-05-23 09:00:00	MSFT	Stock	24.25	24.3	24.17	24.18	52446.0
2011-05-23 09:30:00	MSFT	Stock	24.21	24.25	24.03	24.19	6452890.0
2011-05-23 10:00:00	MSFT	Stock	24.195	24.25	24.16	24.196	3676309.0
2011-05-23 10:30:00	MSFT	Stock	24.2	24.24	24.13	24.19	3736994.0
2011-05-23 11:00:00	MSFT	Stock	24.19	24.21	24.13	24.17	3533087.0
2011-05-23 11:30:00	MSFT	Stock	24.17	24.17	24.09	24.125	2446956.0
2011-05-23 12:00:00	MSFT	Stock	24.125	24.15	24.08	24.12	2343199.0
2011-05-23 12:30:00	MSFT	Stock	24.115	24.14	24.07	24.14	2159548.0
2011-05-23 13:00:00	MSFT	Stock	24.14	24.15	24.09	24.09	3004324.0
2011-05-23 13:30:00	MSFT	Stock	24.09	24.18	24.09	24.18	2739099.0
2011-05-23 14:00:00	MSFT	Stock	24.175	24.2	24.16	24.167	2681305.0
2011-05-23 14:30:00	MSFT	Stock	24.165	24.205	24.15	24.15	2560024.0
2011-05-23 15:00:00	MSFT	Stock	24.16	24.22	24.14	24.151	4639719.0

> showing 50 of 77,142 rows — these rows as CSV

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