PREVIEW / stock_30min / 2013-04-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-12.parquet
  size:    1.5 MB
  rows:    76,519
  symbols: 3,491

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
2013-04-12 04:30:00	AAPL	Stock	15.4821	15.4821	15.4821	15.4821	2800.0
2013-04-12 06:30:00	AAPL	Stock	15.4579	15.4579	15.4579	15.4579	11200.0
2013-04-12 07:00:00	AAPL	Stock	15.4568	15.4568	15.4107	15.4143	16800.0
2013-04-12 07:30:00	AAPL	Stock	15.4154	15.4607	15.4154	15.4464	41804.0
2013-04-12 08:00:00	AAPL	Stock	15.4421	15.5143	15.4286	15.4393	255108.0
2013-04-12 08:30:00	AAPL	Stock	15.4311	15.4314	15.3793	15.4143	1690640.0
2013-04-12 09:00:00	AAPL	Stock	15.4082	15.4982	15.3968	15.4979	1639120.0
2013-04-12 09:30:00	AAPL	Stock	15.4961	15.5054	15.4029	15.4173	38328248.0
2013-04-12 10:00:00	AAPL	Stock	15.4143	15.4786	15.4054	15.4571	20181140.0
2013-04-12 10:30:00	AAPL	Stock	15.4554	15.4636	15.3411	15.3661	32427024.0
2013-04-12 11:00:00	AAPL	Stock	15.3646	15.3711	15.3304	15.3686	19156984.0
2013-04-12 11:30:00	AAPL	Stock	15.364	15.3871	15.3346	15.3836	12805324.0
2013-04-12 12:00:00	AAPL	Stock	15.3814	15.3839	15.34	15.3457	8898316.0
2013-04-12 12:30:00	AAPL	Stock	15.3461	15.3854	15.3454	15.3686	7691824.0
2013-04-12 13:00:00	AAPL	Stock	15.3696	15.3807	15.3539	15.3625	8248268.0
2013-04-12 13:30:00	AAPL	Stock	15.3596	15.3753	15.3409	15.3591	10808952.0
2013-04-12 14:00:00	AAPL	Stock	15.3596	15.37	15.3411	15.3425	6166524.0
2013-04-12 14:30:00	AAPL	Stock	15.3432	15.3529	15.3246	15.3469	9917236.0
2013-04-12 15:00:00	AAPL	Stock	15.3457	15.3707	15.3354	15.357	10194184.0
2013-04-12 15:30:00	AAPL	Stock	15.3568	15.3671	15.3396	15.3489	25974928.0
2013-04-12 16:00:00	AAPL	Stock	15.35	15.4919	15.3371	15.35	13775216.0
2013-04-12 16:30:00	AAPL	Stock	15.3414	15.3581	15.3414	15.35	1807288.0
2013-04-12 17:00:00	AAPL	Stock	15.3414	15.4341	15.3396	15.3396	401548.0
2013-04-12 17:30:00	AAPL	Stock	15.3396	15.3443	15.3393	15.3443	67312.0
2013-04-12 18:00:00	AAPL	Stock	15.3446	15.3464	15.3443	15.3443	8400.0
2013-04-12 18:30:00	AAPL	Stock	15.3446	15.3446	15.3429	15.3429	5600.0
2013-04-12 19:00:00	AAPL	Stock	15.3414	15.3439	15.3396	15.3411	44744.0
2013-04-12 19:30:00	AAPL	Stock	15.3396	15.3429	15.3393	15.3393	62328.0
2013-04-12 04:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	100.0
2013-04-12 04:30:00	MSFT	Stock	28.77	28.77	28.77	28.77	650.0
2013-04-12 05:00:00	MSFT	Stock	28.76	28.76	28.76	28.76	100.0
2013-04-12 06:00:00	MSFT	Stock	28.71	28.71	28.5	28.59	6712.0
2013-04-12 07:00:00	MSFT	Stock	28.62	28.83	28.62	28.8	73812.0
2013-04-12 07:30:00	MSFT	Stock	28.77	28.79	28.74	28.79	3338.0
2013-04-12 08:00:00	MSFT	Stock	28.79	28.8	28.7	28.74	82957.0
2013-04-12 08:30:00	MSFT	Stock	28.74	28.75	28.67	28.71	153286.0
2013-04-12 09:00:00	MSFT	Stock	28.69	28.88	28.69	28.84	419213.0
2013-04-12 09:30:00	MSFT	Stock	28.83	29.02	28.73	28.94	9835926.0
2013-04-12 10:00:00	MSFT	Stock	28.95	29.0	28.85	28.86	12599370.0
2013-04-12 10:30:00	MSFT	Stock	28.86	28.87	28.66	28.785	5642664.0
2013-04-12 11:00:00	MSFT	Stock	28.785	28.84	28.76	28.835	2916398.0
2013-04-12 11:30:00	MSFT	Stock	28.834	28.85	28.77	28.83	2634036.0
2013-04-12 12:00:00	MSFT	Stock	28.835	28.89	28.784	28.785	1542140.0
2013-04-12 12:30:00	MSFT	Stock	28.78	28.83	28.78	28.81	1870891.0
2013-04-12 13:00:00	MSFT	Stock	28.82	28.86	28.76	28.8	1882351.0
2013-04-12 13:30:00	MSFT	Stock	28.81	28.81	28.77	28.78	994924.0
2013-04-12 14:00:00	MSFT	Stock	28.78	28.81	28.76	28.765	1498461.0
2013-04-12 14:30:00	MSFT	Stock	28.765	28.79	28.74	28.77	2588677.0
2013-04-12 15:00:00	MSFT	Stock	28.765	28.79	28.75	28.77	5471881.0
2013-04-12 15:30:00	MSFT	Stock	28.77	28.84	28.74	28.82	8403885.0

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

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