PREVIEW / stock_30min / 2011-10-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-04.parquet
  size:    1.5 MB
  rows:    79,132
  symbols: 3,517

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-04 04:00:00	AAPL	Stock	13.3504	13.3504	13.3504	13.3504	5600.0
2011-10-04 06:00:00	AAPL	Stock	13.3932	13.3932	13.3932	13.3932	2800.0
2011-10-04 06:30:00	AAPL	Stock	13.3929	13.3964	13.3793	13.3821	70000.0
2011-10-04 07:00:00	AAPL	Stock	13.3725	13.4214	13.3286	13.3857	537964.0
2011-10-04 07:30:00	AAPL	Stock	13.3843	13.3843	13.3429	13.3446	246820.0
2011-10-04 08:00:00	AAPL	Stock	13.3636	13.375	13.2943	13.3411	1136072.0
2011-10-04 08:30:00	AAPL	Stock	13.3407	13.4125	13.3407	13.4107	2519300.0
2011-10-04 09:00:00	AAPL	Stock	13.4146	13.4357	13.3564	13.3829	3313380.0
2011-10-04 09:30:00	AAPL	Stock	13.3889	13.5179	13.2689	13.3321	96167428.0
2011-10-04 10:00:00	AAPL	Stock	13.3254	13.3839	13.225	13.3143	62499108.0
2011-10-04 10:30:00	AAPL	Stock	13.3143	13.4532	13.2907	13.4311	54851580.0
2011-10-04 11:00:00	AAPL	Stock	13.431	13.5486	13.3929	13.4954	48311200.0
2011-10-04 11:30:00	AAPL	Stock	13.4943	13.5607	13.4357	13.5354	32484928.0
2011-10-04 12:00:00	AAPL	Stock	13.5357	13.6357	13.5311	13.5621	44042796.0
2011-10-04 12:30:00	AAPL	Stock	13.5589	13.6043	13.4446	13.4714	39857552.0
2011-10-04 13:00:00	AAPL	Stock	13.4686	13.5125	13.2857	13.3418	72074240.0
2011-10-04 13:30:00	AAPL	Stock	13.345	13.3746	13.1625	13.2118	98800576.0
2011-10-04 14:00:00	AAPL	Stock	13.2046	13.2457	12.825	13.0357	181832448.0
2011-10-04 14:30:00	AAPL	Stock	13.0314	13.1721	12.8307	12.8476	148026984.0
2011-10-04 15:00:00	AAPL	Stock	12.8414	12.9264	12.6514	12.8459	166220432.0
2011-10-04 15:30:00	AAPL	Stock	12.8471	13.3304	12.8454	13.3064	155011668.0
2011-10-04 16:00:00	AAPL	Stock	13.294	13.3786	13.1619	13.2921	13256740.0
2011-10-04 16:30:00	AAPL	Stock	13.2914	13.3036	12.8659	13.2804	5080740.0
2011-10-04 17:00:00	AAPL	Stock	13.28	13.3143	13.2693	13.2839	936712.0
2011-10-04 17:30:00	AAPL	Stock	13.2943	13.3093	13.2943	13.3054	297836.0
2011-10-04 18:00:00	AAPL	Stock	13.3036	13.3096	13.2864	13.2929	203336.0
2011-10-04 18:30:00	AAPL	Stock	13.2921	13.3114	13.2861	13.3114	266616.0
2011-10-04 19:00:00	AAPL	Stock	13.3107	13.325	13.3036	13.3218	188356.0
2011-10-04 19:30:00	AAPL	Stock	13.325	13.3357	13.3032	13.3118	298368.0
2011-10-04 04:00:00	MSFT	Stock	24.27	24.27	24.27	24.27	100.0
2011-10-04 06:00:00	MSFT	Stock	24.33	24.33	24.31	24.31	3500.0
2011-10-04 06:30:00	MSFT	Stock	24.28	24.28	24.26	24.26	5000.0
2011-10-04 07:00:00	MSFT	Stock	24.25	24.31	24.24	24.25	4948.0
2011-10-04 07:30:00	MSFT	Stock	24.25	24.26	24.22	24.22	20379.0
2011-10-04 08:00:00	MSFT	Stock	24.29	24.29	24.22	24.26	14149.0
2011-10-04 08:30:00	MSFT	Stock	24.28	24.35	24.26	24.31	30218.0
2011-10-04 09:00:00	MSFT	Stock	24.3	24.4	24.23	24.34	102108.0
2011-10-04 09:30:00	MSFT	Stock	24.34	24.61	24.26	24.54	8730891.0
2011-10-04 10:00:00	MSFT	Stock	24.54	24.81	24.44	24.554	9083019.0
2011-10-04 10:30:00	MSFT	Stock	24.56	24.79	24.49	24.69	5370156.0
2011-10-04 11:00:00	MSFT	Stock	24.69	24.8	24.62	24.71	4317526.0
2011-10-04 11:30:00	MSFT	Stock	24.701	24.88	24.56	24.83	4459191.0
2011-10-04 12:00:00	MSFT	Stock	24.83	25.02	24.81	24.814	4355926.0
2011-10-04 12:30:00	MSFT	Stock	24.81	24.92	24.73	24.85	3203431.0
2011-10-04 13:00:00	MSFT	Stock	24.85	24.89	24.7	24.72	2327482.0
2011-10-04 13:30:00	MSFT	Stock	24.72	24.76	24.565	24.6	2909721.0
2011-10-04 14:00:00	MSFT	Stock	24.595	24.69	24.48	24.64	5074922.0
2011-10-04 14:30:00	MSFT	Stock	24.64	24.76	24.48	24.501	4713905.0
2011-10-04 15:00:00	MSFT	Stock	24.51	24.87	24.46	24.86	5720669.0
2011-10-04 15:30:00	MSFT	Stock	24.86	25.39	24.86	25.34	14730541.0

> showing 50 of 79,132 rows — these rows as CSV

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