PREVIEW / stock_30min / 2011-06-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-03.parquet
  size:    1.4 MB
  rows:    77,106
  symbols: 3,552

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-06-03 04:00:00	AAPL	Stock	12.3571	12.365	12.3571	12.365	11200.0
2011-06-03 04:30:00	AAPL	Stock	12.3629	12.3629	12.3575	12.3575	9100.0
2011-06-03 06:00:00	AAPL	Stock	12.3575	12.3575	12.3393	12.3554	70560.0
2011-06-03 07:30:00	AAPL	Stock	12.34	12.3554	12.3393	12.3393	73780.0
2011-06-03 08:00:00	AAPL	Stock	12.3375	12.3525	12.3107	12.3214	517832.0
2011-06-03 08:30:00	AAPL	Stock	12.3179	12.3214	12.25	12.2714	3444980.0
2011-06-03 09:00:00	AAPL	Stock	12.2689	12.2786	12.2507	12.2604	1554840.0
2011-06-03 09:30:00	AAPL	Stock	12.2571	12.3107	12.2382	12.2618	65209732.0
2011-06-03 10:00:00	AAPL	Stock	12.2664	12.3104	12.2643	12.3007	32888520.0
2011-06-03 10:30:00	AAPL	Stock	12.3029	12.3332	12.2868	12.3002	26788860.0
2011-06-03 11:00:00	AAPL	Stock	12.3004	12.3004	12.2643	12.2686	17059980.0
2011-06-03 11:30:00	AAPL	Stock	12.2679	12.3011	12.26	12.2821	14338436.0
2011-06-03 12:00:00	AAPL	Stock	12.2839	12.3079	12.275	12.3018	10088484.0
2011-06-03 12:30:00	AAPL	Stock	12.2993	12.3139	12.2914	12.3021	13367928.0
2011-06-03 13:00:00	AAPL	Stock	12.3021	12.3089	12.2868	12.2925	6836228.0
2011-06-03 13:30:00	AAPL	Stock	12.2933	12.2993	12.2829	12.2862	9037448.0
2011-06-03 14:00:00	AAPL	Stock	12.2854	12.2869	12.2679	12.2836	11802336.0
2011-06-03 14:30:00	AAPL	Stock	12.285	12.2871	12.2629	12.265	13325060.0
2011-06-03 15:00:00	AAPL	Stock	12.263	12.265	12.2146	12.2429	31483900.0
2011-06-03 15:30:00	AAPL	Stock	12.2439	12.2821	12.2385	12.2611	40375300.0
2011-06-03 16:00:00	AAPL	Stock	12.2648	12.2911	12.2596	12.2657	9637012.0
2011-06-03 16:30:00	AAPL	Stock	12.2661	12.2675	12.2446	12.2675	338184.0
2011-06-03 17:00:00	AAPL	Stock	12.2639	12.2639	12.2586	12.2632	56280.0
2011-06-03 17:30:00	AAPL	Stock	12.2611	12.2643	12.2607	12.2607	1315216.0
2011-06-03 18:00:00	AAPL	Stock	12.2636	12.2675	12.2629	12.2668	157052.0
2011-06-03 18:30:00	AAPL	Stock	12.2671	12.2671	12.2671	12.2671	6832.0
2011-06-03 19:00:00	AAPL	Stock	12.2671	12.2671	12.2657	12.2657	95788.0
2011-06-03 19:30:00	AAPL	Stock	12.2661	12.2671	12.2661	12.2661	61152.0
2011-06-03 07:00:00	MSFT	Stock	24.19	24.22	24.19	24.22	1948.0
2011-06-03 08:00:00	MSFT	Stock	24.2	24.22	24.16	24.18	8707.0
2011-06-03 08:30:00	MSFT	Stock	24.17	24.17	24.05	24.05	64530.0
2011-06-03 09:00:00	MSFT	Stock	24.06	24.11	24.03	24.07	64410.0
2011-06-03 09:30:00	MSFT	Stock	24.04	24.14	24.02	24.09	5232907.0
2011-06-03 10:00:00	MSFT	Stock	24.08	24.11	23.99	24.02	7447182.0
2011-06-03 10:30:00	MSFT	Stock	24.03	24.09	24.02	24.06	5166645.0
2011-06-03 11:00:00	MSFT	Stock	24.06	24.09	24.03	24.04	2643467.0
2011-06-03 11:30:00	MSFT	Stock	24.04	24.1	24.025	24.078	3163595.0
2011-06-03 12:00:00	MSFT	Stock	24.075	24.11	24.06	24.065	1570475.0
2011-06-03 12:30:00	MSFT	Stock	24.06	24.07	24.01	24.015	1886334.0
2011-06-03 13:00:00	MSFT	Stock	24.015	24.06	24.01	24.022	1529786.0
2011-06-03 13:30:00	MSFT	Stock	24.03	24.06	24.0	24.023	2622597.0
2011-06-03 14:00:00	MSFT	Stock	24.02	24.03	23.98	23.98	3086933.0
2011-06-03 14:30:00	MSFT	Stock	23.98	23.99	23.95	23.96	3130131.0
2011-06-03 15:00:00	MSFT	Stock	23.96	23.96	23.85	23.899	5949785.0
2011-06-03 15:30:00	MSFT	Stock	23.9	23.95	23.84	23.89	12295683.0
2011-06-03 16:00:00	MSFT	Stock	23.91	23.992	23.84	23.87	3503264.0
2011-06-03 16:30:00	MSFT	Stock	23.87	23.901	23.86	23.89	41835.0
2011-06-03 17:00:00	MSFT	Stock	23.87	23.87	23.86	23.86	4350.0
2011-06-03 17:30:00	MSFT	Stock	23.9	23.9	23.85	23.85	373440.0
2011-06-03 18:00:00	MSFT	Stock	23.87	23.91	23.83	23.87	42582.0

> showing 50 of 77,106 rows — these rows as CSV

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