PREVIEW / stock_30min / 2012-01-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-31.parquet
  size:    1.4 MB
  rows:    76,738
  symbols: 3,527

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
2012-01-31 04:00:00	AAPL	Stock	16.3039	16.305	16.2857	16.305	10108.0
2012-01-31 04:30:00	AAPL	Stock	16.3036	16.3132	16.2857	16.2857	47460.0
2012-01-31 05:00:00	AAPL	Stock	16.2857	16.3036	16.2857	16.3036	39284.0
2012-01-31 05:30:00	AAPL	Stock	16.3032	16.3036	16.3014	16.3036	33236.0
2012-01-31 06:00:00	AAPL	Stock	16.3036	16.3175	16.3036	16.3175	26600.0
2012-01-31 06:30:00	AAPL	Stock	16.2857	16.2857	16.2718	16.285	60200.0
2012-01-31 07:00:00	AAPL	Stock	16.285	16.285	16.2429	16.285	270480.0
2012-01-31 07:30:00	AAPL	Stock	16.2846	16.2943	16.2536	16.2539	547512.0
2012-01-31 08:00:00	AAPL	Stock	16.2521	16.2771	16.2521	16.2714	883960.0
2012-01-31 08:30:00	AAPL	Stock	16.2729	16.2746	16.2589	16.2625	741888.0
2012-01-31 09:00:00	AAPL	Stock	16.2643	16.2811	16.2521	16.2746	1862280.0
2012-01-31 09:30:00	AAPL	Stock	16.2739	16.3429	16.2561	16.3336	79429756.0
2012-01-31 10:00:00	AAPL	Stock	16.3336	16.3657	16.3036	16.3593	49057680.0
2012-01-31 10:30:00	AAPL	Stock	16.3582	16.3596	16.2646	16.2796	36596532.0
2012-01-31 11:00:00	AAPL	Stock	16.2796	16.2982	16.2521	16.2743	22790208.0
2012-01-31 11:30:00	AAPL	Stock	16.2743	16.2782	16.1811	16.2169	30389688.0
2012-01-31 12:00:00	AAPL	Stock	16.2197	16.2379	16.185	16.1982	17754184.0
2012-01-31 12:30:00	AAPL	Stock	16.1971	16.2314	16.1964	16.2104	15142988.0
2012-01-31 13:00:00	AAPL	Stock	16.2114	16.2482	16.2093	16.2404	15595496.0
2012-01-31 13:30:00	AAPL	Stock	16.2406	16.2532	16.2075	16.2154	11014472.0
2012-01-31 14:00:00	AAPL	Stock	16.2173	16.2771	16.2157	16.2729	12990964.0
2012-01-31 14:30:00	AAPL	Stock	16.2729	16.2854	16.2479	16.2718	12949944.0
2012-01-31 15:00:00	AAPL	Stock	16.2746	16.3089	16.2643	16.3057	20283256.0
2012-01-31 15:30:00	AAPL	Stock	16.3068	16.3068	16.2686	16.3029	31494596.0
2012-01-31 16:00:00	AAPL	Stock	16.2959	16.3029	16.2504	16.3028	14242228.0
2012-01-31 16:30:00	AAPL	Stock	16.2864	16.3074	16.2725	16.2786	4032532.0
2012-01-31 17:00:00	AAPL	Stock	16.3029	16.3029	16.2625	16.2679	203532.0
2012-01-31 17:30:00	AAPL	Stock	16.2679	16.2771	16.2643	16.2757	90804.0
2012-01-31 18:00:00	AAPL	Stock	16.2768	16.2789	16.2732	16.2771	116564.0
2012-01-31 18:30:00	AAPL	Stock	16.2789	16.2793	16.2768	16.2768	161280.0
2012-01-31 19:00:00	AAPL	Stock	16.2768	16.2854	16.2679	16.2679	110796.0
2012-01-31 19:30:00	AAPL	Stock	16.2654	16.2739	16.2625	16.2625	274260.0
2012-01-31 07:00:00	MSFT	Stock	29.66	29.66	29.65	29.65	2000.0
2012-01-31 08:00:00	MSFT	Stock	29.7	29.7	29.61	29.65	6900.0
2012-01-31 08:30:00	MSFT	Stock	29.67	29.68	29.67	29.68	5600.0
2012-01-31 09:00:00	MSFT	Stock	29.68	29.69	29.63	29.65	17394.0
2012-01-31 09:30:00	MSFT	Stock	29.66	29.7	29.51	29.59	5084919.0
2012-01-31 10:00:00	MSFT	Stock	29.57	29.635	29.5	29.535	3644385.0
2012-01-31 10:30:00	MSFT	Stock	29.54	29.55	29.3	29.35	3514168.0
2012-01-31 11:00:00	MSFT	Stock	29.34	29.38	29.29	29.32	3969475.0
2012-01-31 11:30:00	MSFT	Stock	29.32	29.36	29.23	29.31	2313288.0
2012-01-31 12:00:00	MSFT	Stock	29.32	29.395	29.31	29.37	1824916.0
2012-01-31 12:30:00	MSFT	Stock	29.38	29.47	29.37	29.445	1491940.0
2012-01-31 13:00:00	MSFT	Stock	29.445	29.525	29.44	29.506	1407329.0
2012-01-31 13:30:00	MSFT	Stock	29.502	29.52	29.44	29.47	1463612.0
2012-01-31 14:00:00	MSFT	Stock	29.46	29.63	29.42	29.606	5182392.0
2012-01-31 14:30:00	MSFT	Stock	29.61	29.63	29.535	29.61	2479025.0
2012-01-31 15:00:00	MSFT	Stock	29.61	29.62	29.53	29.59	2138970.0
2012-01-31 15:30:00	MSFT	Stock	29.595	29.6	29.5	29.54	5335217.0
2012-01-31 16:00:00	MSFT	Stock	29.545	29.55	29.45	29.528	5405219.0

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

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