PREVIEW / stock_30min / 2012-02-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-02.parquet
  size:    1.4 MB
  rows:    76,211
  symbols: 3,525

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-02-02 05:00:00	AAPL	Stock	16.3286	16.3286	16.3214	16.3214	25200.0
2012-02-02 05:30:00	AAPL	Stock	16.3571	16.3571	16.3214	16.3214	81928.0
2012-02-02 06:30:00	AAPL	Stock	16.3036	16.3036	16.3036	16.3036	2800.0
2012-02-02 07:00:00	AAPL	Stock	16.3196	16.3196	16.2868	16.2868	22400.0
2012-02-02 08:00:00	AAPL	Stock	16.2925	16.3161	16.2821	16.2875	339864.0
2012-02-02 08:30:00	AAPL	Stock	16.3036	16.3107	16.2925	16.2946	232932.0
2012-02-02 09:00:00	AAPL	Stock	16.2964	16.3039	16.2693	16.2825	496720.0
2012-02-02 09:30:00	AAPL	Stock	16.2821	16.3275	16.255	16.2593	27401136.0
2012-02-02 10:00:00	AAPL	Stock	16.2618	16.295	16.2357	16.2643	21894152.0
2012-02-02 10:30:00	AAPL	Stock	16.2656	16.2779	16.2571	16.2639	11390848.0
2012-02-02 11:00:00	AAPL	Stock	16.267	16.2746	16.2464	16.2634	9615760.0
2012-02-02 11:30:00	AAPL	Stock	16.2664	16.2678	16.2496	16.2639	8785896.0
2012-02-02 12:00:00	AAPL	Stock	16.2636	16.2721	16.2375	16.2461	12597172.0
2012-02-02 12:30:00	AAPL	Stock	16.2464	16.2497	16.2161	16.2364	15849120.0
2012-02-02 13:00:00	AAPL	Stock	16.2379	16.2404	16.2136	16.2136	9121588.0
2012-02-02 13:30:00	AAPL	Stock	16.2139	16.2457	16.2137	16.2296	8999172.0
2012-02-02 14:00:00	AAPL	Stock	16.2293	16.2454	16.2268	16.2345	7045276.0
2012-02-02 14:30:00	AAPL	Stock	16.2346	16.2493	16.2289	16.2443	9859080.0
2012-02-02 15:00:00	AAPL	Stock	16.2429	16.2593	16.2329	16.2446	10744468.0
2012-02-02 15:30:00	AAPL	Stock	16.2439	16.2571	16.2432	16.2518	19646004.0
2012-02-02 16:00:00	AAPL	Stock	16.2543	16.2602	16.2429	16.2543	6474216.0
2012-02-02 16:30:00	AAPL	Stock	16.2546	16.2564	16.2462	16.2564	737548.0
2012-02-02 17:00:00	AAPL	Stock	16.2564	16.2925	16.2529	16.2554	42952.0
2012-02-02 17:30:00	AAPL	Stock	16.2554	16.2579	16.2554	16.2579	44156.0
2012-02-02 18:00:00	AAPL	Stock	16.2571	16.2579	16.2439	16.2461	111888.0
2012-02-02 18:30:00	AAPL	Stock	16.2554	16.2557	16.2493	16.25	80612.0
2012-02-02 19:00:00	AAPL	Stock	16.2504	16.2504	16.2475	16.2475	14000.0
2012-02-02 19:30:00	AAPL	Stock	16.2471	16.25	16.2436	16.2446	77140.0
2012-02-02 08:00:00	MSFT	Stock	29.93	29.95	29.84	29.9	9192.0
2012-02-02 08:30:00	MSFT	Stock	29.95	29.98	29.92	29.96	4500.0
2012-02-02 09:00:00	MSFT	Stock	29.96	29.98	29.85	29.9	76810.0
2012-02-02 09:30:00	MSFT	Stock	29.89	30.06	29.845	30.025	3634346.0
2012-02-02 10:00:00	MSFT	Stock	30.03	30.05	29.97	30.02	3017747.0
2012-02-02 10:30:00	MSFT	Stock	30.015	30.15	30.0	30.12	3933575.0
2012-02-02 11:00:00	MSFT	Stock	30.11	30.17	29.92	29.995	5501130.0
2012-02-02 11:30:00	MSFT	Stock	29.995	30.01	29.92	29.947	3118573.0
2012-02-02 12:00:00	MSFT	Stock	29.95	29.96	29.81	29.835	2822829.0
2012-02-02 12:30:00	MSFT	Stock	29.84	29.9	29.79	29.88	3755196.0
2012-02-02 13:00:00	MSFT	Stock	29.86	29.87	29.71	29.74	2561611.0
2012-02-02 13:30:00	MSFT	Stock	29.74	29.9	29.73	29.855	2868743.0
2012-02-02 14:00:00	MSFT	Stock	29.85	30.0	29.84	29.935	3836217.0
2012-02-02 14:30:00	MSFT	Stock	29.93	30.01	29.93	29.96	3141979.0
2012-02-02 15:00:00	MSFT	Stock	29.95	30.02	29.94	29.985	3508639.0
2012-02-02 15:30:00	MSFT	Stock	29.985	30.01	29.93	29.945	7088016.0
2012-02-02 16:00:00	MSFT	Stock	29.95	29.97	29.92	29.95	1535689.0
2012-02-02 16:30:00	MSFT	Stock	29.95	30.044	29.95	29.95	225958.0
2012-02-02 17:00:00	MSFT	Stock	29.95	30.01	29.89	30.01	12713.0
2012-02-02 17:30:00	MSFT	Stock	30.0	30.01	29.95	29.95	24685.0
2012-02-02 18:00:00	MSFT	Stock	29.94	29.95	29.94	29.94	1392.0
2012-02-02 19:30:00	MSFT	Stock	29.99	29.99	29.95	29.95	1615.0

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

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