PREVIEW / stock_30min / 2013-10-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-09.parquet
  size:    1.5 MB
  rows:    80,150
  symbols: 3,539

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-10-09 04:00:00	AAPL	Stock	17.2857	17.2857	17.2536	17.2679	33600.0
2013-10-09 04:30:00	AAPL	Stock	17.3036	17.3036	17.2721	17.2721	14000.0
2013-10-09 05:00:00	AAPL	Stock	17.2857	17.3	17.2857	17.3	32312.0
2013-10-09 05:30:00	AAPL	Stock	17.33	17.3346	17.33	17.3346	5600.0
2013-10-09 06:00:00	AAPL	Stock	17.34	17.34	17.34	17.34	13300.0
2013-10-09 06:30:00	AAPL	Stock	17.3475	17.3629	17.3393	17.3393	36400.0
2013-10-09 07:00:00	AAPL	Stock	17.3461	17.3543	17.3121	17.3282	85400.0
2013-10-09 07:30:00	AAPL	Stock	17.3193	17.3393	17.3071	17.3157	195328.0
2013-10-09 08:00:00	AAPL	Stock	17.3114	17.3571	17.1786	17.3393	1181516.0
2013-10-09 08:30:00	AAPL	Stock	17.3386	17.3421	17.2914	17.3046	607992.0
2013-10-09 09:00:00	AAPL	Stock	17.2982	17.3189	17.2971	17.3039	314860.0
2013-10-09 09:30:00	AAPL	Stock	17.3086	17.3118	17.1796	17.2696	41727644.0
2013-10-09 10:00:00	AAPL	Stock	17.2661	17.2975	17.2	17.2796	23149392.0
2013-10-09 10:30:00	AAPL	Stock	17.2761	17.2893	17.1893	17.1956	27361600.0
2013-10-09 11:00:00	AAPL	Stock	17.1921	17.2104	17.0814	17.1209	27958112.0
2013-10-09 11:30:00	AAPL	Stock	17.1186	17.1864	17.1036	17.1611	13011320.0
2013-10-09 12:00:00	AAPL	Stock	17.1614	17.2303	17.1466	17.2204	13034728.0
2013-10-09 12:30:00	AAPL	Stock	17.2157	17.2539	17.1821	17.2096	9314704.0
2013-10-09 13:00:00	AAPL	Stock	17.2079	17.2868	17.2079	17.2633	14800156.0
2013-10-09 13:30:00	AAPL	Stock	17.2643	17.2943	17.2404	17.265	10321920.0
2013-10-09 14:00:00	AAPL	Stock	17.265	17.3429	17.2446	17.3379	18342968.0
2013-10-09 14:30:00	AAPL	Stock	17.3407	17.4211	17.33	17.4121	24669932.0
2013-10-09 15:00:00	AAPL	Stock	17.4139	17.4179	17.3429	17.3554	15945048.0
2013-10-09 15:30:00	AAPL	Stock	17.3579	17.3961	17.3125	17.3682	28577724.0
2013-10-09 16:00:00	AAPL	Stock	17.3679	17.3781	17.1771	17.3781	13919808.0
2013-10-09 16:30:00	AAPL	Stock	17.3732	17.3796	17.192	17.3732	150584.0
2013-10-09 17:00:00	AAPL	Stock	17.3679	17.3679	17.3568	17.3661	150388.0
2013-10-09 17:30:00	AAPL	Stock	17.3671	17.3671	17.3614	17.3614	25480.0
2013-10-09 18:00:00	AAPL	Stock	17.3679	17.3886	17.3643	17.3886	82684.0
2013-10-09 18:30:00	AAPL	Stock	17.3879	17.3893	17.3736	17.3875	172368.0
2013-10-09 19:00:00	AAPL	Stock	17.3893	17.4089	17.3893	17.4089	115556.0
2013-10-09 19:30:00	AAPL	Stock	17.3982	17.4129	17.3982	17.4129	108304.0
2013-10-09 08:00:00	MSFT	Stock	33.05	33.08	33.01	33.01	2177.0
2013-10-09 08:30:00	MSFT	Stock	33.03	33.05	33.01	33.05	5834.0
2013-10-09 09:00:00	MSFT	Stock	33.05	33.09	33.05	33.05	2150.0
2013-10-09 09:30:00	MSFT	Stock	33.07	33.35	33.01	33.29	3749315.0
2013-10-09 10:00:00	MSFT	Stock	33.29	33.33	33.065	33.28	3496206.0
2013-10-09 10:30:00	MSFT	Stock	33.28	33.31	33.01	33.02	2042729.0
2013-10-09 11:00:00	MSFT	Stock	33.02	33.18	32.96	33.15	3538259.0
2013-10-09 11:30:00	MSFT	Stock	33.15	33.3	33.09	33.16	3155605.0
2013-10-09 12:00:00	MSFT	Stock	33.16	33.2	33.1	33.13	1664199.0
2013-10-09 12:30:00	MSFT	Stock	33.13	33.18	32.98	33.01	1707106.0
2013-10-09 13:00:00	MSFT	Stock	33.013	33.29	33.01	33.246	2037479.0
2013-10-09 13:30:00	MSFT	Stock	33.24	33.325	33.16	33.18	1348880.0
2013-10-09 14:00:00	MSFT	Stock	33.18	33.23	33.1	33.155	1843931.0
2013-10-09 14:30:00	MSFT	Stock	33.167	33.22	33.11	33.164	1397623.0
2013-10-09 15:00:00	MSFT	Stock	33.16	33.26	33.13	33.228	2123919.0
2013-10-09 15:30:00	MSFT	Stock	33.225	33.27	33.05	33.08	5356887.0
2013-10-09 16:00:00	MSFT	Stock	33.08	33.151	32.9	33.07	1630048.0
2013-10-09 16:30:00	MSFT	Stock	32.94	33.23	32.9	33.07	30446.0

> showing 50 of 80,150 rows — these rows as CSV

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