PREVIEW / stock_30min / 2011-10-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-24.parquet
  size:    1.5 MB
  rows:    76,664
  symbols: 3,512

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-10-24 04:00:00	AAPL	Stock	14.125	14.125	14.125	14.125	5600.0
2011-10-24 04:30:00	AAPL	Stock	14.125	14.125	14.1061	14.1061	22400.0
2011-10-24 05:00:00	AAPL	Stock	14.0786	14.0786	14.0786	14.0786	8400.0
2011-10-24 05:30:00	AAPL	Stock	14.0964	14.0964	14.0964	14.0964	5600.0
2011-10-24 06:00:00	AAPL	Stock	14.1071	14.1071	14.1036	14.1036	17640.0
2011-10-24 06:30:00	AAPL	Stock	14.1036	14.1164	14.1	14.1164	22400.0
2011-10-24 07:00:00	AAPL	Stock	14.1064	14.1071	14.1021	14.1021	82796.0
2011-10-24 07:30:00	AAPL	Stock	14.0964	14.1214	14.09	14.1214	268380.0
2011-10-24 08:00:00	AAPL	Stock	14.1179	14.1657	14.1025	14.1571	976752.0
2011-10-24 08:30:00	AAPL	Stock	14.1536	14.1679	14.1407	14.1407	1369872.0
2011-10-24 09:00:00	AAPL	Stock	14.14	14.1607	14.1257	14.1464	1250928.0
2011-10-24 09:30:00	AAPL	Stock	14.1457	14.2721	14.1214	14.2532	75790652.0
2011-10-24 10:00:00	AAPL	Stock	14.255	14.3904	14.2354	14.3757	82704664.0
2011-10-24 10:30:00	AAPL	Stock	14.3754	14.4554	14.3626	14.4161	55552140.0
2011-10-24 11:00:00	AAPL	Stock	14.4168	14.49	14.4039	14.4864	40045460.0
2011-10-24 11:30:00	AAPL	Stock	14.485	14.4879	14.4089	14.4382	34874840.0
2011-10-24 12:00:00	AAPL	Stock	14.4368	14.4754	14.4311	14.4621	20103132.0
2011-10-24 12:30:00	AAPL	Stock	14.4621	14.4707	14.425	14.4651	16629648.0
2011-10-24 13:00:00	AAPL	Stock	14.4657	14.4682	14.4268	14.4446	12231408.0
2011-10-24 13:30:00	AAPL	Stock	14.4446	14.5179	14.4343	14.5043	27215356.0
2011-10-24 14:00:00	AAPL	Stock	14.5043	14.515	14.4471	14.4817	23056768.0
2011-10-24 14:30:00	AAPL	Stock	14.4814	14.4907	14.4561	14.4814	15387680.0
2011-10-24 15:00:00	AAPL	Stock	14.4814	14.4893	14.4339	14.4457	28496412.0
2011-10-24 15:30:00	AAPL	Stock	14.4457	14.4964	14.4446	14.4893	50040844.0
2011-10-24 16:00:00	AAPL	Stock	14.4918	14.4993	14.1521	14.1521	9191840.0
2011-10-24 16:30:00	AAPL	Stock	14.48	14.4918	14.2408	14.4525	1620052.0
2011-10-24 17:00:00	AAPL	Stock	14.4525	14.4768	14.45	14.4718	116648.0
2011-10-24 17:30:00	AAPL	Stock	14.4786	14.4893	14.4743	14.4882	238308.0
2011-10-24 18:00:00	AAPL	Stock	14.4825	14.4918	14.475	14.4821	147560.0
2011-10-24 18:30:00	AAPL	Stock	14.4746	14.4818	14.4746	14.4789	40208.0
2011-10-24 19:00:00	AAPL	Stock	14.475	14.4757	14.4729	14.4746	68460.0
2011-10-24 19:30:00	AAPL	Stock	14.4746	14.4754	14.4643	14.4643	109928.0
2011-10-24 06:00:00	MSFT	Stock	27.08	27.08	27.08	27.08	330.0
2011-10-24 06:30:00	MSFT	Stock	27.24	27.24	27.24	27.24	100.0
2011-10-24 07:00:00	MSFT	Stock	27.08	27.08	27.02	27.02	1000.0
2011-10-24 07:30:00	MSFT	Stock	27.02	27.12	27.02	27.1	2200.0
2011-10-24 08:00:00	MSFT	Stock	27.11	27.16	27.11	27.12	3302.0
2011-10-24 08:30:00	MSFT	Stock	27.08	27.13	27.08	27.13	1100.0
2011-10-24 09:00:00	MSFT	Stock	27.13	27.23	27.02	27.11	41388.0
2011-10-24 09:30:00	MSFT	Stock	27.12	27.24	27.04	27.2	4593417.0
2011-10-24 10:00:00	MSFT	Stock	27.194	27.35	27.17	27.2	7721930.0
2011-10-24 10:30:00	MSFT	Stock	27.2	27.3	27.14	27.275	3199759.0
2011-10-24 11:00:00	MSFT	Stock	27.28	27.4	27.275	27.32	2946658.0
2011-10-24 11:30:00	MSFT	Stock	27.32	27.34	27.22	27.275	2810259.0
2011-10-24 12:00:00	MSFT	Stock	27.275	27.36	27.25	27.31	2481097.0
2011-10-24 12:30:00	MSFT	Stock	27.3	27.31	27.24	27.279	1943162.0
2011-10-24 13:00:00	MSFT	Stock	27.28	27.31	27.24	27.27	1718351.0
2011-10-24 13:30:00	MSFT	Stock	27.275	27.35	27.27	27.3	1602700.0
2011-10-24 14:00:00	MSFT	Stock	27.305	27.36	27.25	27.28	2020815.0
2011-10-24 14:30:00	MSFT	Stock	27.29	27.34	27.28	27.301	2122044.0

> showing 50 of 76,664 rows — these rows as CSV

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