PREVIEW / stock_30min / 2011-08-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-04.parquet
  size:    1.6 MB
  rows:    82,712
  symbols: 3,567

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-08-04 04:00:00	AAPL	Stock	13.9964	14.0089	13.9964	14.0089	11200.0
2011-08-04 04:30:00	AAPL	Stock	14.0211	14.0211	14.0204	14.0207	11200.0
2011-08-04 05:00:00	AAPL	Stock	13.9789	13.9789	13.9789	13.9789	2800.0
2011-08-04 06:00:00	AAPL	Stock	13.9761	13.9761	13.9079	13.9079	67200.0
2011-08-04 06:30:00	AAPL	Stock	13.9079	13.9375	13.9079	13.9375	16800.0
2011-08-04 07:00:00	AAPL	Stock	13.9375	13.9429	13.9214	13.9257	363328.0
2011-08-04 07:30:00	AAPL	Stock	13.9286	13.9579	13.9286	13.9432	55216.0
2011-08-04 08:00:00	AAPL	Stock	13.9543	13.9571	13.875	13.8925	1238748.0
2011-08-04 08:30:00	AAPL	Stock	13.8925	13.9368	13.8536	13.9054	2554020.0
2011-08-04 09:00:00	AAPL	Stock	13.9057	13.9404	13.8825	13.9136	2227708.0
2011-08-04 09:30:00	AAPL	Stock	13.9136	13.9757	13.8214	13.8771	87193876.0
2011-08-04 10:00:00	AAPL	Stock	13.8743	13.905	13.8096	13.8521	64194816.0
2011-08-04 10:30:00	AAPL	Stock	13.8521	13.8893	13.75	13.7546	71735860.0
2011-08-04 11:00:00	AAPL	Stock	13.7546	13.8096	13.7221	13.7279	64575644.0
2011-08-04 11:30:00	AAPL	Stock	13.7257	13.7857	13.6746	13.7121	68393220.0
2011-08-04 12:00:00	AAPL	Stock	13.7132	13.7843	13.6939	13.7789	49936180.0
2011-08-04 12:30:00	AAPL	Stock	13.7804	13.8293	13.7429	13.7443	44958760.0
2011-08-04 13:00:00	AAPL	Stock	13.7475	13.7804	13.7289	13.7611	23565444.0
2011-08-04 13:30:00	AAPL	Stock	13.7627	13.7882	13.7268	13.7543	34550740.0
2011-08-04 14:00:00	AAPL	Stock	13.7575	13.7668	13.6786	13.7171	50786680.0
2011-08-04 14:30:00	AAPL	Stock	13.7132	13.7925	13.6979	13.6986	55162772.0
2011-08-04 15:00:00	AAPL	Stock	13.7007	13.75	13.5732	13.5754	79344748.0
2011-08-04 15:30:00	AAPL	Stock	13.5754	13.6286	13.4768	13.4768	145276404.0
2011-08-04 16:00:00	AAPL	Stock	13.4814	13.7334	13.4748	13.4929	13078268.0
2011-08-04 16:30:00	AAPL	Stock	13.4946	13.5756	13.4775	13.4971	2272900.0
2011-08-04 17:00:00	AAPL	Stock	13.4971	13.5161	13.4775	13.5107	915124.0
2011-08-04 17:30:00	AAPL	Stock	13.5139	13.5179	13.4996	13.5036	440692.0
2011-08-04 18:00:00	AAPL	Stock	13.5036	13.5036	13.4775	13.4964	450604.0
2011-08-04 18:30:00	AAPL	Stock	13.4821	13.4821	13.4546	13.4571	285236.0
2011-08-04 19:00:00	AAPL	Stock	13.4589	13.4607	13.3943	13.4143	481880.0
2011-08-04 19:30:00	AAPL	Stock	13.4143	13.4286	13.4054	13.4286	300300.0
2011-08-04 05:30:00	MSFT	Stock	26.77	26.77	26.7	26.7	600.0
2011-08-04 06:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	200.0
2011-08-04 06:30:00	MSFT	Stock	26.63	26.63	26.63	26.63	400.0
2011-08-04 07:00:00	MSFT	Stock	26.59	26.65	26.52	26.65	7330.0
2011-08-04 07:30:00	MSFT	Stock	26.66	26.66	26.66	26.66	501.0
2011-08-04 08:00:00	MSFT	Stock	26.66	26.66	26.57	26.6	5810.0
2011-08-04 08:30:00	MSFT	Stock	26.6	26.66	26.5	26.6	23033.0
2011-08-04 09:00:00	MSFT	Stock	26.66	26.67	26.51	26.54	48309.0
2011-08-04 09:30:00	MSFT	Stock	26.53	26.81	26.4	26.77	7300246.0
2011-08-04 10:00:00	MSFT	Stock	26.77	26.87	26.49	26.595	6423468.0
2011-08-04 10:30:00	MSFT	Stock	26.59	26.73	26.48	26.516	6826222.0
2011-08-04 11:00:00	MSFT	Stock	26.515	26.6	26.36	26.36	7065684.0
2011-08-04 11:30:00	MSFT	Stock	26.37	26.48	26.23	26.421	8287566.0
2011-08-04 12:00:00	MSFT	Stock	26.43	26.515	26.39	26.47	5395727.0
2011-08-04 12:30:00	MSFT	Stock	26.48	26.58	26.44	26.451	3298606.0
2011-08-04 13:00:00	MSFT	Stock	26.46	26.57	26.43	26.553	3018903.0
2011-08-04 13:30:00	MSFT	Stock	26.554	26.56	26.39	26.465	3816017.0
2011-08-04 14:00:00	MSFT	Stock	26.47	26.48	26.21	26.28	5576141.0
2011-08-04 14:30:00	MSFT	Stock	26.27	26.47	26.25	26.32	5183949.0

> showing 50 of 82,712 rows — these rows as CSV

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